Functionality - Order variables

[glengall1]

Hi there,

 

I am new to OSCommerce.

 

I have some products that have up to 700 variables. For instance a scarf I sell has 700 different colours (tartans). Will this be a monumental job to set it up using OSCommerce?

 

Steve

[glengall1]

I apologise for asking this question but it appers that I would have to write every different variable into the interface which is obviously alot.

[♥Monika in Germany]

with extensive options like you have, it would be

 

1) wise to group them, as 700 item dropdown list can be discouraging for users

 

2) use a script for adding option info to the database

[glengall1]

with extensive options like you have, it would be

 

1) wise to group them, as 700 item dropdown list can be discouraging for users

 

2) use a script for adding option info to the database

 

 

Thanks Monika,

 

With regards your second option. I am new to this could you please expand a bit in what that means and how it would work?

 

Is there script available in the community or would I have to get it written?

 

Thanks again

[♥Monika in Germany]

download osCommerce from this site. In the install folder, you will find a file called osCommerce.sql. You will see there in the product related tables (start with products...) how products can be added via a script. Check how attributes are handled. If you are a complete database newbie, you may need for help for adding your products options list via script once. If all your products use the same tartan sets, you can make use of the attributes sets contribution. The data for that could be added via a script also (a good coder allows you to add all your options in a column in excel and created the script for that ... too big a task though for a forum post).

[glengall1]

download osCommerce from this site. In the install folder, you will find a file called osCommerce.sql. You will see there in the product related tables (start with products...) how products can be added via a script. Check how attributes are handled. If you are a complete database newbie, you may need for help for adding your products options list via script once. If all your products use the same tartan sets, you can make use of the attributes sets contribution. The data for that could be added via a script also (a good coder allows you to add all your options in a column in excel and created the script for that ... too big a task though for a forum post).

 

 

Monika,

 

Thanks for your help I will give it a try. Unfortunately there is about 30 different tartan sets but I will have a good look at what you are saying and see if I can make sense of it.

 

Thanks again

 

Steve