Refresh

This website matrixify.app/tutorials/shopify-multi-location-inventory/?category=orders is currently offline. Cloudflare's Always Online™ shows a snapshot of this web page from the Internet Archive's Wayback Machine. To check for the live version, click Refresh.

Start Free Trial
Start Free Trial

Multi-Location Inventory

Shopify Multi-Locations|Export Shopify Multi-Location Inventory Levels columns|Exported Shopify Multi-Location Inventlry Levels|Shopify Admin - Settings Locations|Shopify Admin - Product Variant Locations|Shopify Admin - Orders Fulfillment Location|Shopify Orders Excel Export - Fulfillment Location|Shopify Admin - Orders Refund with Restock|Exported Shopify Multi-Location Inventory Levels

The Matrixify app fully supports Shopify Multi-Location Inventory and has implemented all the required changes for all types of items.

Shopify Admin Settings

When your store has a Multi-Location Inventory, your Shopify Admin will have the section in Settings, called “Locations“. It will looks like this:

multi-location inventory in Shopify settingsProducts

From that point, you will see for your variants the following table of the available quantities by each location which is attached to that variant:

Multi-location inventory in Shopify Admin

In the Matrixify app you will see an additional checkbox for Product details export “Multi-Location Inventory Levels“:

Multi-location inventory levels on Export set up page

Checking this checkbox in your export file will include additional columns Inventory Available: ...– for each of your locations.

Since each variant can have the quantity available in each location, you will see the quantity column for each location.

Those columns will look like this:

Multi-location Inventory in Exported Excel

Notice that each of those columns have the location name in it (like Paris Warehouse) – that is important because this is how you will tell the app to change the quantity for that specific location.

Also, there are additional columns Inventory Available Adjust: .... In the export, the values for those columns will always be 0. But when importing, you can import these columns to adjust the inventory for each location. To import adjustments, you need to delete the columns Inventory Available: ... – because those set your inventory to a specific value. While the adjustment columns adjust your inventory quantity – adds or subtracts the number that you specify. To subtract the inventory, import a negative value.

Be aware that exporting those columns will make your export run longer, as the Matrixify app has to ask Shopify the inventory levels for each of your products separately.

The Variant Inventory Qty column will be still there and will show the total of your inventory across all your locations. Also, if you import this column and no other Inventory Available: ... columns are in your import file, then the app will assume that you want to change the quantity of your first location.

Importing Inventory Quantity

If your store has just one location, you can continue importing the Variant Inventory Qty column, or the Inventory Available: ... column, or the Inventory Available Adjust: ... column.

If you import any number different from 0 in the Inventory Available Adjust: ... column, then you need to remove the Inventory Available: ... column. Otherwise, it doesn’t make sense to set and adjust the quantity at the same time, right?

If you have many locations but all of those don’t show up in the export, that means that there are no variants which are attached to those locations. You can attach those variants to those locations in bulk, by just adding that respective column of Inventory Available: ... and put there your location name. You should make sure that you have such a location defined in your Shopify Admin: Settings -> Locations section.

You can read about all the Products columns in the Products documentation.

Deleting Inventory On Location

To delete the inventory at specific location, import the empty value for that location column.

We also offer a great tutorial to update Multi-Location Inventory for your Products.

Orders

Fulfillments

When you fulfill your Orders, you will see in the Admin new field for the Fulfillment where you can change the Location of that fulfillment.

Change Location for Order in Shopify AdminWhen you export your Orders using the Matrixify app, you will see this location name in the column Fulfillment: Location but only if the Order is fulfilled. This value cannot be Exported for an unfulfilled Order.

Exports with fulfillment locations

If you need your Order to be fulfilled from the specific location, you need to provide that location name.

If you don’t provide any name, the app will automatically assume that you are fulfilling from the first of your locations.

We offer a great tutorial on how you can fulfil your Orders in bulk.

Refunds

When you issue the Order Refund with restocking, in the Admin you are offered to choose the location to which to restock:

Refund Restock Location in Shopify AdminThat same value appears in the Matrixify app Orders Export for Refunds, in the column Refund: Restock Location:

Refund Restock Location in Excel

Also, when importing Orders, you can specify the Location name in that column. If you will import it empty, the app will always assume the first of your Locations.

You can read about all the Products columns in the Orders documentation  and also check out our tutorial on how to refund Orders in bulk.