importing huge products from MS Access database to oscommerce store

[chinn]

Hi,

 

I want to import the products( more than 3000 products & 100 categories) from the MS access database to oscommerce. how to import the products easily & i saw oscommerce database tables & ms access tables, the field names are mismatch.

 

For example, In ms access "products" table have a field name called "item_id"(data type : varchar) & oscommerce table have a field name called "product_id" (data type :int)

 

How can i match this fields name & to import successfully.

 

Please help me, this is very urgent task for me.

 

Regards

Chinna

[Guest]

you can use navicat, http://www.navicat.com it's the easiest way to import products database from access to sql.i'm using it for my osc (more than 6000 products)

[chinn]

Thank you osclearner, but the given site is not opening (http://www.navicat.com), please verify it & reply it to me.

 

Thank you

 

Regards

Chinna

[Guest]

the link isn't broken.plz recheck it !

[Guest]

Hi,

 

I want to import the products( more than 3000 products & 100 categories) from the MS access database to oscommerce. how to import the products easily & i saw oscommerce database tables & ms access tables, the field names are mismatch.

 

For example, In ms access "products" table have a field name called "item_id"(data type : varchar) & oscommerce table have a field name called "product_id" (data type :int)

 

How can i match this fields name & to import successfully.

 

Please help me, this is very urgent task for me.

 

Regards

Chinna

 

Export them to csv or txt modify the EP module/script to do the importing.