Import Order Data

[chirag_0110]

Hi,

 

Can someone help me to import customer order data from custom platform(.NET) to prestashop store.

 

I have e-commerce store developed in .NET. Now i want to move store to prestashop. I can import Product,customer,categories,... data from back office (Advanced Parameters =>CSV Import) but what about order  data.

 

How can i import order data from old store to prestashop store.

 

Is there any module of any custom method to do so.

 

Thanks in advance.

 

[NemoPS]

Interesting, there are plenty of modules for exporting them, but non for importing. I guess the main reason is that prestashop references products with current ids.
So the only thing you can do is having a 1:1 copy of the products and attributes tables, then a 1:1 copy of all the ones related to _order

Basically, clean db dump of all those tables, or make sure you can keep products ids when you import

[chirag_0110]

Interesting, there are plenty of modules for exporting them, but non for importing. I guess the main reason is that prestashop references products with current ids.

So the only thing you can do is having a 1:1 copy of the products and attributes tables, then a 1:1 copy of all the ones related to _order

 

Basically, clean db dump of all those tables, or make sure you can keep products ids when you import

 

Hi NemoPS,

 

I can not copy tables as old store made in .NET platform with custom table. It has different Table structure then prestashop.

[NemoPS]

Ah, sorry I didn't read it well. Then no, there is no way, apart from a manual conversion or creating a custom export plugin for your store, then a custom import for prestashop. You need a custom import as product ids and references must be matched

[chirag_0110]

Hi NemoPS,

 

Thanks for your time.

 

I did it by import from csv of back office functionality. It's time consuming but we did it.

 

thanks again.