You can use received inventory reports and sell-through percentages to improve your inventory management. Keep track of your inventory and how your products are selling.
Viewing received and remaining items
How to access the received items report, to review how much stock you've received and how much is still left for sale.
- Login to your account and select Reports.
- Select Received under Inventory Reports.
- Set the date range for the report.
- Click Search to generate the report.
Analyzing sell-through percentages
Follow these steps to add and analyze sell-through percentages, a key metric for effective inventory tracking.
- Click export at the top right of the received report.
- Open the exported report with a spreadsheet program such as Google Sheets or Excel.
-
Merge duplicate rows for accuracy.
- Select the data range in Google Sheets that include any duplicates.
- Go to Data > Data cleanup > Remove duplicates.
- In the pop-up, ensure 'Data has header row' is checked if applicable, and select the columns to check for duplicates.
- Click Remove duplicates. Google Sheets will merge duplicate rows and sum their quantities.
- Add a new column titled "Sell-Through %".
- Ensure column "B" contains received quantities and "C" contains remaining quantities. Or adjust the formula in the next step according to which column they are in.
- In the first cell under this new column, enter the formula
=100%-(C2/B2)
and press Enter to save it. - Drag the fill handle down from the corner of the cell to replicate the formula for all items in your list.
- Select the "Sell-Through %" column, right-click, choose 'Format Cells', and then select 'Percentage'.