Jump to content
Sign in to follow this  
Godiva

Drop down sizes & prices

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×