Mass Assign PrestaShop Products to Warehouses, Specifying Storage Location
*Can be applied to orders starting from $199

Mass Assign PrestaShop Products to Warehouses, Specifying Storage Location

If you are using Advanced Stock Management with a few storage places, you need to go through every product to assign PrestaShop products to warehouses and define the locations.

Store Manager for PrestaShop allows to manage warehouse associations for your products in bulk. This way you don’t need spend hours browsing between each product to manage alliances with storage places and can save a lot of time!

In this tutorial we will guide you how to massively associate a nearest warehouse for each product and its combinations, easily add multiple warehouse associations in bulk and indicate product location in warehouse. All of these operations can be performed using import via Store Manager for PrestaShop.

Prepare File for Warehouse Association and Item Location

In case you need to associate one product per warehouse and specify its location, for that you need to list the following fields:

  • Warehouse – in this field put your warehouse name. It should be exactly the same as you indicated configuring warehouse settings.
  • Location – type in there some meaningful info for you, like on which shelf you keep your product, so you easily could find it when packing your orders.
  • Advanced Stock Management – this field with value ‘1’ should be included if you want to use ASM for this product.
  • Reference (or ID for update) – include identifier field that will be used to check if the products are new ones. You can also use other unique identifiers as Name+Reference, UPC, EAN, supplier reference.

To assign product to a few warehouses, you need to include them in another line (each warehouse in new line) under the same product.

If you have product with combinations that come from different warehouses, you also need to include in your file related fields, like:

  • Combination Reference – that will serve as identifier for combinations.

This way you will be able to specify warehouse per variation. Each one is listed as a separate row.

Assign PrestaShop Products to Warehouses via Import

Now when the file is ready and warehouses relations are indicated for necessary goods, you can upload them in a few simple clicks.

  1. Run Product Import/Export Wizard -> Import.

  2. Select the file you have prepared previously.

  3. Make sure that on preview columns and info in them look properly. Otherwise, change delimiter symbol.

  4. Link CSV columns to database fields. Use auto mapping function if your headings are identical to DB names.

  5. Configure import method and proceed with upload.

After the process ends, you will see logs and then can check the results.

If you are also interested in synchronization of warehouse quantities with the advanced stock management system of Prestashop, check our related articles.

Related Articles:

Card image
How to Enable Advanced Stock Management

Find out how to bulk add products to Advanced Stock Management system and what this system involves. Read More…

Card image
How to Set Up PrestaShop Advanced Stock Management

Activate PrestaShop Advanced Stock Management option, add warehouses and assign products to them manually or in bulk. Read More…

Card image
Update PrestaShop Warehouse Stock Via Import

Get step-by-step instructions of executing PrestaShop warehouse update by import. Read More…

Card image
How to Transfer Stock Between PrestaShop Warehouses

Get detailed guides on how to smoothly transfer inventory to another PrestaShop store. Read More…

Be the first to comment.