Update Shopify Multi-Location inventory in bulk

Import shopify multi location levels

If your store uses multiple locations then updating inventory levels in bulk can be challenging. With Excelify you can set and adjust Shopify Multi-Location inventory levels for your Locations in bulk.

In Short

  1. Export your Products with checkboxes:
    • Inventory / Variants
    • Multi-Location Inventory Levels
  2. Delete unnecessary columns from the exported file. You only need the following columns:
    • ID
    • Handle
    • Variant ID
    • Variant SKU or Variant Barcode
    • Inventory Available: ….
    • Inventory Available Adjust: ….
  3. Update Multi-Location columns.
    • Inventory Available: …. – if you wish to set inventory level.
    • Inventory Available Adjust: … – if you wish to adjust inventory level
  4. Save & Import.
  5. Enjoy your updated Inventory levels.

Each step in details

1. Export your Products using Excelify

You do not require all the information about the products so you only need to select following checkboxes in Excelify export section

  • Inventory / Variants
  • Multi-Location Inventory Levels

Once selected you can press the “Export” button to start the export. Export Shopify Multi location

2. Delete unnecessary columns from the exported file

When export has been finished you can press the “Download Exported File” button to download the file and start editing.

The first thing that you would need to edit would be deleting all irrelevant information from the file. So delete all columns except:

  • ID
  • Handle
  • Variant ID
  • Variant SKU or Variant Barcode – These are both optional, but preferred so you can more easily see what item you are updating by the SKU.
  • Inventory Available: …. – Leave only columns for the location you are updating. If you wish to adjust your Inventory levels at this location, then you do not need these columns.
  • Inventory Available Adjust: …. – Leave only columns for the location you are updating. If you wish to set your Inventory levels at this location, then you do not need these columns.

You can also delete the rows of Products or Variants that you do not wish to update.

So in my example file, I will only wish to add a specific amount of items to one location named “RW Warehouse” and set specific inventory level at the location “Jonathan Ball”, so I only need columns “Inventory Available Adjust: RW Warehouse” and “Inventory Available: Jonathan Ball2.1 - Import Shopify multi location level

3. Update Multi-Location columns

Now you can fill your Location columns with the values that you wish to be set or adjusted. Update multi-loc columns

4. Save & Import

Now you can save the file. Go back to the Excelify app and import the file in the Import section. The app will analyze the file and count how many Products you are importing.

Press the Import button to start the import.

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why the particular Product has failed. Then you can fix that issue and re-import just those failed and fixed rows again. Import Multi location update in Shopify

5. Enjoy your updated Inventory levelsShopify imported multi location level

What to do next?