How to Stock or Unstock Products at Locations
Shopify allows you to set up multiple locations in your store data to track inventory and fulfill orders from various locations. You have to manually connect products or variants to locations in order for Shopify to track your inventory.
Locations can be configured in the Shopify admin settings. Note that Shopify only tracks inventory in each location if you configure it.
- First make sure the location is created in the Shopify Admin
- Second, connect your products to the location using Ablestar Bulk Product Editor
Our app allows you to filter or modify all products and variants that are connected or not connected.
- If you disconnect a product from a location, the inventory quantity for that location, prior to disconnecting, will be lost. If you reconnect that location, the inventory quantity will be 0.
- When you connect a product to a new location, the inventory quantity will be 0 by default. You will need to run a new edit to modify the level of inventory.
📹 Prefer a video walkthrough?
Choose if you prefer the 'In-App Edit' or 'Spreadsheet' method:
1. In-App Edits
From the Ablestar Bulk Product Editor dashboard, click the 'Products' menu:
- Click on the Filters button
- Search and select 'Stocked at location' from the picklist (you can also type 'connect')
- Choose whether the products are stocked or not stocked at the location
- Click on the name of your location and modal should close and apply filter
Once you have confirmed your filter from the preview, click the Edit products button
-
Configure your edit with the following parameters:
-
Field to Edit: select 'Stocked at location' (formerly called 'Connect Inventory Locations')
- How to Edit: select 'Stock at this location' or 'Unstock from this location'
-
Location: select the name of the specific location
-
Click the Run Edit button to process changes
Remember, you can click the Undo button any time after processing finishes to revert changes but your inventory may get reset back to zero. Learn how to bulk edit inventory if you need to make revisions.
2. Spreadsheet Edits
If you have a number of products you want to connect to different locations it might be quicker to use a spreadsheet edit.
Your spreadsheet needs to have two columns: a product-level identifier in the first column and the ID of the location you want to connect or disconnect in the second column:
💡Two ways to find your Inventory item (location) ID:
- Export your products using our app and format the spreadsheet to include 'Inventory quantities' on the report. There will be a column on the spreadsheet that indicates the 'Inventory Item ID' which is the same as the Location ID.
- Shopify settings: From the Settings icon → Locations menu: click any location and the last digits on the URL (ie 1234567890) are the location ID
https://admin.shopify.com/store/my-store/settings/locations/1234567890
✅ Tips and Troubleshooting
- Exporting products is easy and allows you to export inventory quantities and detail
- Click the Undo button if you need to start over and learn how to find a History of bulk edits
(07.163)