Attributes

[Guest]

Hi I am new to Oscommerce and had a site recently built for my business of selling DJ equipment. I have been researching on how to add attributes to products so that I can advertise a new product as well as a used or open box product. I don't seem to have the ability to add any attributes however. I tried to add it in the attributes section of my catalog but i kept getting an error message :

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values ('', '499', '1', '3', '', '+')

 

[TEP STOP]

 

Can somebody please advise on this thank you.

 

Victor

[♥geoffreywalton]

Looks like you are trying to add an attribute to a product that has a blank id.

 

Shown below are the fields in that file.

 

products_attributes_id,

products_id,

options_id,

options_values_id ,

options_values_price

price_prefix

 

Have you added the options and the option values?

 

One tip is to add the values in the sequence you want them to appear to your customers in the drop downs.