CSV Import / Multiple warehouse IDs

[ViViD]

Hello,

I'm importing a CSV data file to products catalog, it seems the last field (warehouse) needs the ID number of a warehouse. When I enter one just number I succeed to work and products will be imported. But in interface I can choose multiple warehouses, in CSV when I enter multiple ID numbers of warehouses e.g. 1,2,3 , it shows a php exception error :

 

 

 

[PrestaShopException]

Property WarehouseProductLocation->id_warehouse is not valid
at line 881 in file classes/ObjectModel.php

876.
877.             $message = $this->validateField($field, $this->$field);
878.             if ($message !== true)
879.             {
880.                 if ($die)
881.                     throw new PrestaShopException($message);
882.                 return $error_return ? $message : false;
883.             }
884.         }
885.
886.         return true;

• ObjectModelCore->validateFields - [line 245 - classes/ObjectModel.php]
• ObjectModelCore->getFields - [line 469 - classes/ObjectModel.php]
• ObjectModelCore->add - [line 431 - classes/ObjectModel.php] - [2 Arguments]
• ObjectModelCore->save - [line 1868 - controllers/admin/AdminImportController.php]
• AdminImportControllerCore->productImport - [line 3461 - controllers/admin/AdminImportController.php]
• AdminImportControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

 

So how should I select warehouses in CSV?

Edited August 16, 2015 by ViViD (see edit history)

[Due_92]

Hi,

 

I have exactly the same problem like ViViD!

 

Does anybody has a solution?

 

 

Thank you.

[RogueWaveLimited]

Is it possible to enter a row for each product for each warehouse?

[ViViD]

Is it possible to enter a row for each product for each warehouse?

 

No,

The second row ID should be same and that will become duplicated and will cause errors. 

BTW if it was probable to use REF# as ID this will overwrite the old value and does not add anything.

Edited August 19, 2015 by ViViD (see edit history)

[RogueWaveLimited]

We have a daily update service that will take your inventory source (vendor, file, etc.) and update your store. It can update inventory for any number of warehouses. I know you are probably looking for a module to do this (or a built in) but I wanted to let you know it is available. If you are interested, you can contact me at the email below. Or we can discuss it here on the forum if you prefer.

[newcomer]

You can't do multiple warehouses and suppliers in csv product import. I have tried all kinds of formats in the csv file it just wouldn't work. In the end I had to create a new csv file and import it from SQL at cpanel>phpmyadmin.

 

Take note CSV import at SQL requires individual fields to have open and closed quotes. Excel alone can't do this so you will have to run some custom macro in VB for excel to export the correct format in CSV. For exporting excel to CSV with quotes by running a macro see link below:

https://support.microsoft.com/en-us/kb/291296

[Max Infocomercio]

It is real, don't have solution to import multiples warehouses into the prestashop. ??? Someone know a module that make this ?

[navid68]

Anyone knows a solution? Any module?

 

The developper of PrestaPricing confirmed that he is working on the Advanced Warehouse Management and will release a new version of the module with this update.

 

Other suggestions?

Navid