In preparation for Shopify Multi-Location Inventory, the Excelify app has implemented all the required changes to support that for all the types of items.
Shopify Admin Settings
When your store has Multi-Location Inventory enabled, your Shopify Admin will have the new section in Settings, called “Locations“. It will look like this:
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:
In the Excelify app you will see an additional checkbox for Product details export “Multi-Location Inventory Levels“:
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:
Notice that each of those columns have the location name in it (like Office) – that is important because this is how you will tell the app, which quantity you want to change for which 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 Excelify 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.
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.
The same with the import – 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.
When you issue the Order Refund with restocking, in the Admin you are offered to choose the location to which to restock:
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.