Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / Adding an additional hidden field in the attributes table

Adding an additional hidden field in the attributes table

Locked

Views: 2,206

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
13 Aug 2007, 8:22 AM
#1
quantum avatar

quantum

Zen Follower

Join Date:
May 2005
Posts:
134
Plugin Contributions:
0

Adding an additional hidden field in the attributes table

Hello,

I need to create a new field in the cart_products_attributes table called item_code. I tried doing this through the SQL interface, but when I tried adding an attribute it came up with the following error:

1136 Column count doesn't match value count at row 1
in:
[insert into cart_products_attributes values ('', '2', '1', '45', '250', '', '+', '', '0', '', '+', '0', '0', '1', '', '1', '', '', '', '', '', '', '', '', '', '', '', '0')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

So I take it that I am going about it the wrong way. Can anyone help?

The purpose of this is that my client prices their product by attribute, and having a hidden item code only for back end purposes allows them to use a v look up in excel to quickly adjust any pricing that has changed.