Importing Data

[Guest]

Hi,

 

This is all very new to me so please excuse me if the answer to this is an obvious one.

 

I am thinking of using OS Commerce for the first time but already have my product list in a csv file which now contains 13,000 lines.

 

Is it possible to import this list directly into OS Commerce to save manually re-entering all the data.

 

Any help would be appreciated.

[wizardsandwars]

With some reorganization, and possibly breaking out some of the data into other tables, this can be done.

 

You'd have to look at the table structure for the product tables in OSCommerce, and re-organize your data to match it.

[steve***]

There is a contribution for this exact purpose. search in the contrib section for Easy Populate

 

It works a treat ;-)

[maxxgraphix]

:D yep. Can be done. I looked at EasyPopulate. Didn't get it. :blink: Required too much details.

 

So anyway, here's what I did.

1. authorize Mysql access from a winders box.

2. Install ODBC drivers in win for MySql

3. Install MS Acess create a blank database and link your tables.

4. Import your product data

5. Create a temporary table for your products with a unique ID and fields that match OSCommerce

6. Write a Query to append the product data to Mysql

7. Write a Query to Append the Product Category data

 

Done.

 

I did extra steps since each product has 17 attributes. That's another mess.

 

I can add 1000 products in about 15 minutes. My goal is to have 50,000 products.

The real hard part is getting product data ready to import.

 

I just started this project last week 11/25/03. I mean just started! The server hardware wasn't even assembled yet.

 

What can I say? LINUX RULES! :D

[Guest]

:D yep. Can be done. I looked at EasyPopulate. Didn't get it. :blink: Required too much details.

 

So anyway, here's what I did.

1. authorize Mysql access from a winders box.

2. Install ODBC drivers in win for MySql

3. Install MS Acess create a blank database and link your tables.

4. Import your product data

5. Create a temporary table for your products with a unique ID and fields that match OSCommerce

6. Write a Query to append the product data to Mysql

7. Write a Query to Append the Product Category data

 

Done.

 

I did extra steps since each product has 17 attributes. That's another mess.

 

I can add 1000 products in about 15 minutes. My goal is to have 50,000 products.

The real hard part is getting product data ready to import.

 

I just started this project last week 11/25/03. I mean just started! The server hardware wasn't even assembled yet.

 

What can I say? LINUX RULES! :D

:) First part I under stand LOL have used Acess little but can import my data from an excel data base or csv one but found lines missing in it :( but it up loaded to my shop no problem but the attribs dont show for the item and with 10,000 i dont want to do it manaully when i was told Easy would do it i have entered it all in a excel sheet, now to find it uploads all fine but shown no options like size or colours :( so hoow do i " Write a Query to append the product data to Mysql

7. Write a Query to Append the Product Category data" Please and help would be appreciated..

Laine non blonde fdrom down under