<aside>
💡 Link to Locations Tab: https://pos.shoptiques.com/variants
</aside>
How to export your variant list
Please follow these 3 easy steps to calculate how much Inventory on Hand you currently have in your store(s):
- Please go to your POS Web App and select "Variants" under "Products" tab or simply click here.
- On the top right of the screen, please select the small arrow to the side of the Export Button to expose a dropdown. Under that dropdown, select "Export Variants"
- Once all of your Products are exported into Excel, multiply columns L ("Stock") by column O ("Wholesale Price"). The result is your Inventory Cost on Hand for that particular variant. Copy the cell and Paste into the rest of the cells in that column. At the bottom of that column, select "=Sum" and select all of the cells in that column.
Please note: If you have a negative inventory of certain stock, it will subtract from your total inventory, unless you make that total inventory to be 0.
https://s3-us-west-2.amazonaws.com/secure.notion-static.com/c0e0d0d1-fae4-474d-8c8c-34f1611634fd/Screen_Recording_2020-12-30_at_3.44.52_PM.mov
Multiple Stores? No problem!
- Please click "Sort & Filter" option at the top right corner and select the location for which you are calculating the Inventory on Hand in column I ("Location)".
- Please watch the video below for visual instructions:
- If you need help navigating excel or calculating this metric, please don't hesitate to reach out to us at [email protected]
https://youtu.be/GN7NNa4hJo4