You can perform a manual stock take for your entire inventory or specific sections by following this guide. To perform a stock take in segments such as locations or categories, use the inventory filters to arrange and export your inventory as required.
Use our barcode sticker and scanner system to assist you in identifying physical items and updating them on the CSV file via their barcode. For more information about barcode stickers, see our Stickers for Listings guide.
Keep in mind that a barcode scanner functions the same way as a keyboard input device.
How it works
1. Export your current inventory
Go to your inventory page. Apply the In stock filter to export only stocked items.
Click Export > Export listings to export your inventory as a Listings export CSV file.
Download the Listings export CSV from the Jobs page.
It’s a good idea to keep a backup of your exported inventory before uploading changes, so you can revert if needed.
2. Organize your spreadsheet
Open the Listings export CSV in your preferred spreadsheet editor and sort. For example if you use Location, you can sort your listings by the listing_location column.
To make things easier to read, you can delete any column that isn't required for your stock take.
For example, in this tutorial you can keep these columns to easily identify your items:
listing_idlisting_stock_quantityitem_descriptionlisting_location
The listing_id column is required for the Listings Update tool to function
3. Perform your stock take
Go through your physical inventory and update the listing_stock_quantity column in your spreadsheet to match your actual stock counts.
Once complete, save and export your updated CSV file.
4. Update listings
Go to the Listings Update tool here: Inventory > Import > Listings: Update.
Upload the updated CSV file containing your current inventory.
Review the detected quantity changes in the uploader tool. If there are changes that need to be made, return to the CSV file and make them now.
When you are ready select Submit Upload to apply the updates.
It’s a good idea to keep a backup of your exported inventory before uploading changes, so you can revert if needed.
See here for more information about Listing updates.