How-To: Add new Properties to your Products

The step by step guide by the OP is very clear. There must be something you may have done wrong without realising.
Best thing to do is double check you have entered everything properly. for example...

The OP wrote

Quote:

---

db manipulation
open the table "products" in your zencart-database and insert new rows at the end of the table called "products_guarantee" and "products_color"
ALTER TABLE `zencart_products` ADD `products_guarantee` INT NOT NULL , ADD `products_color` VARCHAR( 32 ) NOT NULL;

---

did you change the table names to suit your database, ie: ALTER TABLE `zen_products`............

Did you do as I said in my previous post.. adding the comma ","

In collect_info.php and preview_info.php, when you add the lines p.products_guarantee, p.products_color (or what ever you called them for your database) you need to make sure to add a comma at the end of the last line before you add the above lines.

I know, very simple things, but easy to miss too.

Im not great at explaining things, but hope it helps

DB

is there anyone who did this whole thing and worked for them???

because what i'm trying to do is to

1-add extra fields in my products table (which i was able to do)

2-add them to the admin section (which i was able to do)

3-show them on the product details page (worked too)

4-show them on the product listing page, that's when you click on a category name and lists all the products (can't do it yet) (HELP NEEDED!!!)

if anyone can find a solution for this or find a solution already please post it here, i'll be thankful.

thanks a lot.

Hi hovsepations,

I could actually do with something similar so I am going to have a go at it tonight, if I get it to work I will post here for you.

regards

DB

Could not figure it out, sorry.

Ok, so I finally managed to display my new field 'products_botanical' that I added with the routine of crasy_chris. Thanks by the way!

But in order to show it in products_listing, I had to replace 'PRODUCT_LIST_BOTANICAL' by 8 in $define_list in main_template_vars. If I echo the size of column_list it returns only the 4 that are supposed to be displayed set in the admin section.
1- How can I change/add a column to column_list?

2- Where is 'PRODUCT_LIST_BOTANICAL' defined?

3- How can I change where that column would display?

Also, the sort through that column doesn't work, and now I am really lost...:frusty:

you can see my site at
practitioners.springwind.com

Thanks for any input on how to fix the issues.
Fred

Quote:

---

Originally Posted by yakbuttertea

Ok, so I finally managed to display my new field 'products_botanical' that I added with the routine of crasy_chris. Thanks by the way!

But in order to show it in products_listing, I had to replace 'PRODUCT_LIST_BOTANICAL' by 8 in $define_list in main_template_vars. If I echo the size of column_list it returns only the 4 that are supposed to be displayed set in the admin section.
1- How can I change/add a column to column_list?

2- Where is 'PRODUCT_LIST_BOTANICAL' defined?

3- How can I change where that column would display?

Also, the sort through that column doesn't work, and now I am really lost...:frusty:

you can see my site at
practitioners.springwind.com

Thanks for any input on how to fix the issues.
Fred

---

Ok, so maybe that will help someone like me that was having issues displaying their new fields:
- If you follw the step describe around page 6-7-8 (don't remember sorrywhich page exactly) everything will be in place but not displaying. Don't panic, you have to define the constant PRODUCT_LIST_BOTANICAL somewhere and that is defined in the admin section. It tells the program that that column is the number 'x' to be displayed at the 'x' position. So once you define it it will magically appear... Well the way I did it is define it on /includes/module/pages/index/main_template_vars.php instead of putting 'PRODUCT_LIST_BOTANICAL' => PRODUCT_LIST_BOTANICAL, I did 'PRODUCT_LIST_BOTANICAL' => 8 and it worked. :happy:

- Now I have an other question, how can we have the alpha filter working on the new field?

Thanks!

Quote:

---

Originally Posted by hovsepations

is there anyone who did this whole thing and worked for them???

because what i'm trying to do is to

1-add extra fields in my products table (which i was able to do)

2-add them to the admin section (which i was able to do)

3-show them on the product details page (worked too)

4-show them on the product listing page, that's when you click on a category name and lists all the products (can't do it yet) (HELP NEEDED!!!)

if anyone can find a solution for this or find a solution already please post it here, i'll be thankful.

thanks a lot.

---

Look at my posting maybe that is your answer...

thanks yakbuttertea,
i'm gonna try it and see how it works for me.

i'll let you know:clap:

I'm selling computer equipment, which has very many different properties (for instance size, how much ram, cpu etc.), so I almost need to add 50 different ones that only show when filled in admin console.

But before I begin I wondered if it’s smart to do it this way, if not what do you advice?

Does someone know how to work with alpha filter?I am trying to have my new field sorted by the alpha filter. So far, the filter sort only by the Item column.How can we add an other filter or choose which column the filter will work on?