Managing the inventory for all products at different locations

How to Export/Import the inventory list?

Operating a store across multiple locations introduces unique challenges, and managing inventory for all products is one of them. Recognizing this need, we've introduced a new Inventory feature designed to simplify this task. With multiple locations set up, tracking all products across every location becomes an essential aspect of smooth operations. This guide will walk you through how to leverage this new feature to manage inventory for all products at different locations. By following these guidelines, you'll maintain accurate stock levels, avoid potential problems, and have a clear understanding of when to reorder or produce more of your items.

1. Navigate to Shoplazza Admin > Products > Inventory. You can use the dropdown menu to switch between locations and view or edit product inventory accordingly.

2. By clicking the Export button, you can create an xlsx file to export the stock quantities for each location.

  • Please select the Export range in the pop-up window, including All variants, Selected variants, and All filtered results.

  • Please select the Export location at the same time. You can select a certain location or All locations.

  • Click Export to generate the document, and then you can download it.

Note

If you haven't checked "Inventory tracking" on the product details page, the inventory information of the product will not be exported.

3. You can use the exported inventory file as a template to update inventory quantities for each location, and then Import the list.

  • From your Shoplazza admin, go to Products > Inventory and click Import to upload the inventory list.

Note

  • The imported inventory quantity will replace your current inventory data. To prevent any confusion or errors, we suggest updating the inventory only when you have made no other changes to the inventory.
  • If you haven't checked "Inventory tracking" on the product details page and the product is included in the inventory list, the import will fail.
  • Before you import an inventory list, please make sure that you have filled in the Variant ID. The other two fields, Title and Variant, are not required.
  • If the exported inventory list includes columns for locations whose inventory requires no changes, you can delete the whole columns including their heads.
  • You must input the inventory quantity of the rest locations. The quantity can be positive, negative or zero.

How to view inventory history?

To easily track and trace detailed records of inventory history, please kindly refer to: Viewing inventory history

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Live chat
Reset