Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Drop down sizes & prices


Godiva

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.

Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...