Product Attribute/Add To Cart Problem

[Guest]

http://www.poconographics.com/catalog/index.php

 

I have a product with a base price of 6.99 for a 6" sticker. I have attributes for a 12, 24, & 32" stickers. When I add the base sticker to a cart it is showing the attribute for the 12" sticker with the 12" price and adding that to the cart. Can anyone explain to me how to fix this problem. Thank you.

[Guest]

I really need some help on this, anyone? Thanks!

[Guest]

I figured out that I need another attribute for the 6" sticker with no price. Does anyone know how I can do that without having to manually add each new one and make it show as the default?

[khime]

You have to add 6" as an attribute and set the price to zero unfortunately.

 

This Ajax attribute manager will help

 

http://www.oscommerce.com/community/contributions,4063

 

This can store common sets attributes so you can load them direct in the add product page saving you the need to add options manually

 

Also you need to sort the options in price ascending order, this way the default 6" appears as the first option. Oscommerce doesnt do this so you need to modify the code.

 

This thread will show you how

 

http://www.oscommerce.com/forums/index.php?showtopic=123629

[Guest]

thank you very much!!! Im will try that now.

[Guest]

After I installed it I got:

 

1054 - Unknown column 'products_options_sort_order' in 'order clause'

 

select * from products_options where language_id='1' order by products_options_sort_order

 

[TEP STOP]

[Guest]

the default to use sort order was true. I changed it to false.

[Guest]

It works really good. The only question I have is can I have this change all my products at once or will I still have to go into each product?