Start Free Trial
Start Free Trial

Update Shopify Multi-Location inventory in bulk

Import shopify multi location levels||Shopify imported multi location level||Update multi-loc columns|2.1 - Import Shopify multi location level|Export Shopify Multi location

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

In Short

  1. Export your Products with checkboxes:
    • Basic Columns
    • 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 quantity.
    • Inventory Available Adjust: … – if you wish to adjust inventory quantity.
  4. Save & Import.
  5. Enjoy your updated Inventory levels.

Let’s look into each step in detail:

1. Export your Products

You do not require all the information about the products so you only need to select following checkboxes in Matrixify export section once you have checked “Products” from the “Select Sheets” drop-down:

  • Basic Columns
  • Inventory / Variants
  • Multi-Location Inventory Levels

Once selected you can press the “Export” button to start the export. Exporting Multi-Location Inventory

2. Delete unnecessary columns

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

Set items to be stocked at a location when not tracking inventory

Shopify also allows you to specify at what locations you are stocking the inventory even when you do not have an inventory tracker turned on.

In that case, you can use the same “Inventory Available: …” column and set the value “Stocked“.

1 - bulk stock products in Shopify multi location inventory Matrixify Excel CSV sheet

4. Save & Import

Now you can save the file. Go back to the Matrixify 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.

Uploaded file to update multi-location inventory

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.Completed multi-location inventory update Import

5. Enjoy your updated Inventory levelsShopify imported multi location level

What to do next?