Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Functionality - Order variables


glengall1

Recommended Posts

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

Link to comment
Share on other sites

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

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...