Godiva Posted December 16, 2008 Share Posted December 16, 2008 I sell candles of different sizes, prices, and fragrances. I want to categorize by fragrance group, which is easy enough, but then I would like to have the different fragrances with a drop down box so the customer can choose the size/price. Can someone point me to a module that would accomplish this? Thanks. Quote Link to comment Share on other sites More sharing options...
voided Posted December 16, 2008 Share Posted December 16, 2008 http://addons.oscommerce.com/info/160 Quote Designrfix.com | Graphic Design Inspiration & Web Design Resources - @designrfix Link to comment Share on other sites More sharing options...
Godiva Posted December 16, 2008 Author Share Posted December 16, 2008 http://addons.oscommerce.com/info/160 Thanks! Quote Link to comment Share on other sites More sharing options...
Godiva Posted December 17, 2008 Author Share Posted December 17, 2008 I downloaded the add-on, since I'm adding onto a clean version of osCommerce, was easy to upload php and css files. Last instruction I am completely lost on. I have tried figuring it out, but to no avail. It's updating the databases. Here's the instructions, can anyone point me in the right direction? Thanks Update the database with these sql commands ## ALTER TABLE products_options ADD products_options_type INT( 5 ) NOT NULL , ADD products_options_length SMALLINT( 2 ) DEFAULT '32' NOT NULL , ADD products_options_comment VARCHAR( 32 ) ; ALTER TABLE customers_basket_attributes ADD products_options_value_text text ; ## ## INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT'); INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 2, 'TEXT'); INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 3, 'TEXT'); ## or via some other method. (For info, these are the instructions) Add new fields to db Add the following fields to table products_options NAME: products_options_type TYPE: int(5) NULL: No DEFAULT: 0 NAME: products_options_length TYPE: smallint(2) NULL: No DEFAULT: 32 NAME: products_options_comment TYPE: varchar(32) NULL: Yes DEFAULT: NULL Add the following field to table customer_basket_attributes NAME: products_options_value_text TYPE: text NULL: Yes DEFAULT: Null Quote Link to comment Share on other sites More sharing options...
Godiva Posted December 17, 2008 Author Share Posted December 17, 2008 I figured it out - how to update the database. Took a few, but finally success. Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.