Product Attributes Help

[cegeland]

I am using osCommerce v2.2 Release Candidate 2a as the install and I have a couple of questions. The store I am setting up will have several products that have over 2000 product attributes with each product having a different set of product attributes.

 

1. Will osCommerce be able to handle that many product attributes on each product?

2. Is there an easy way to import that many product attributes into osCommerce without having to type them in individually?

3. After the attributes are in what is the easiest way to associate all the attributes to the specific product?

 

Thanks for any help.

[satish]

I am using osCommerce v2.2 Release Candidate 2a as the install and I have a couple of questions. The store I am setting up will have several products that have over 2000 product attributes with each product having a different set of product attributes.

 

1. Will osCommerce be able to handle that many product attributes on each product?

2. Is there an easy way to import that many product attributes into osCommerce without having to type them in individually?

3. After the attributes are in what is the easiest way to associate all the attributes to the specific product?

 

Thanks for any help.

 

 

use easy populate.

 

some version suports attributes.

 

Satish

[emmwood]

I downloaded the MySQL ODBC 5.1 driver (appears in the administrative tools in control panel in vista under Data Sources post-install). After setting up the connection info, I used it to link the OS Commerce tables to Microsoft Access. It was very easy to import all of my products without attributes into OS Commerce. After copying the products table from Access into excel, I used vlookup to assign the OSCommerce-assigned product_id to my model number. I did the same for the options_id from the products_options table (i.e., size) and option_values_id from the products_options_values table (i.e., 12" x 24"). Once that was done, I create a column for the price prefix and the price value. The final spreadsheet layout looked like this:

 

 

product_attributes_id products_id options_id options_values_id options_values_price price_prefix PRICE_SORT

1234 1 2 25 - -25

 

Once the spreadsheet was in this format, I used the price_sort field to sort the prices (i chose low to high so the the prices appeared from lowest to highest). After that, I simply copied all columns except price_sort directly into the the linked products_attributes table in MS Access and presto, all done! The product_attributes_id field is automatically populated when you paste the data, so there isn't a need to populate it with values. NOTE: Before you paste, make sure that you enter + as the price_prefix and 0 as the options_values_price if your option price is zero. If you make a mistake, you can simply delete the contents of the products_attributes table and try again!