Import Product And Quantity From Multiple Warehouses

[MrMgr]

Hi,

 

Introduction:

I have to link my old ERP system based on Oracle DB with prestashop.

I have 8 storage locations in 8 cities across the country.

All customers have its own default Warehouse - the closest one.

I can write sql query in Oracle and generate CSV's, and import them to prestashop but only for one warehouse.

 

Question:

When i generate one CSV's with state of product form multiple warehouse ony the first line per product is imported.

When i generate multiple CSV's one per warehouse then the quantity of product is imported only once (the fist time).

 

How to import it at once?

 

I have to import 9000 products and they quantity in 8 different locations, its almost 12000 lines in one CSV?

 

Please help.

Edited December 7, 2015 by MrMgr (see edit history)

[RogueWaveLimited]

Please clarify:

 

IN THE FIRST CASE:

 

What do you mean by "state of product"?

 

Is it correct to say that in the first case, you are importing a product with the same reference from multiple warehouses, one row per warehouse?

 

Is this just a quantity update?

 

Is the warehouse id one of the CSV fields?

 

IN THE SECOND CASE:

 

Do you have the warehouse id as one of the CSV fields?

 

 

 

 

[MrMgr]

Thank for your response, I will clarify my question tomorrow morning and add impot files.