System updates

We’re experiencing issues that may affect your Square services. We’ll continue to update our status page with more information.

Back to Home

Sell-through Report with Square for Retail

The Square for Retail Inventory Sell-through Report provides you with an organised daily snapshot of all of the information you need to effectively manage your inventory – making purchasing decisions, price adjustments and identifying any dead stock easier.

Calculate Sell-Through

Sell-through is a percentage that compares the amount of inventory you receive from a vendor against what’s actually sold over a given period of time. The percentage is calculated by dividing the number of items sold in the selected time period by the quantity of items on hand at the start of the period plus the quantity received or adjusted during the period. Then multiply that number by 100 to find your percentage.

Although sell-through rates vary by industry and item type, a general rule of thumb is that any item at or above 80% is excellent and any item below 40% is concerning. A sell-through rate over 100% means the item or variation has been oversold and inventory has gone negative.

View and Adjust your Sell-through Report

To view your sell-through report:

  1. Go to your online Square Dashboard.

  2. Select Reports > Inventory Reports > Inventory Sell-through.

Within the report, you can search by name, SKU or GTIN and filter by location, category and time frame. To expand or collapse variations, click the blue arrow by the left of the Item column header. To change how the table is sorted, click the column headers that have up or down arrows next to them. To change which columns are visible in the table, click the plus sign. Visible columns may include Sell-through, On hand, Sold, Sales velocity and more. For variations that have multiple sell-by options, the sell-through report will only display the stock by unit.

Note: Inventory tracking must be turned on under Items > Settings > Inventory and the item or variation must have either been sold or had an inventory adjustment in the last 365 days for a sell-through report to be generated.

Understand and Use your Sell-through Rate

Restock items with a high sell-through rate

A high sell-through rate is a good indication of popular items that sell well and may be understocked. Monitor Quantity on Hand, Sales Velocity and Out of Stock to determine when you should be restocking

Promote and discount overstocked items

A low sell-through rate can indicate an item is overstocked or not selling well. You may want to promote this item, move it around in-store or offer a discount to reduce your supply and raise your sell-through rate.

Discontinue items with a low sell-through rate

Items that constantly have a low sell-through rate may be items you want to consider discontinuing or replacing.

Sell-through Report Glossary

  • Sell-through: the percentage that compares the amount of inventory received against what’s actually sold in the selected time period.

  • Quantity on hand: the number of items or variations sold in the selected time period.

  • Sales velocity: the average number of items sold per week over the last 30 days.

  • Last sold: the date the item or variation was last sold.

  • Last received: the date you last received stock for an item or variation.

  • Out of stock: a prediction that an item is no longer available in your inventory based on your sales and inventory history.

  • On order: the number of items or variations on order as documented in a purchase order.

FAQs

Will the sell-through report update live throughout the day as I add, sell or transfer items in my inventory?

No, the sell-through report is a snapshot of your inventory activity and will not reflect live changes. The report will update and refresh nightly every 24 hours and will have a timestamp stating the last time it was updated.

How will transferring items between my location affect my sell-through report?

Stock transfers will be treated as if the stock was already at the destination location at the start of the period.

For example, suppose you have two locations and the following actions happen in a seven-day period:

  1. Location A has 10 shirts, and
  2. Location B has 3 shirts.
  3. Location A sells four shirts and
  4. Location B sells three shirts.
  5. Seller transfers five shirts from location A to Location B.
  6. Location B sells 5 shirts.

In this case, sell-through at Location A would be (4 sold) / (10 initial - 5 transferred) = 4/5 = 80%.

Sell-through at Location B would be (5 sold + 3 sold) / (3 initial + 5 transferred) = 8/8 = 100%.

How does seasonality affect my sell-through rates?

Sell-through rate does not account for seasonlity so keep in mind the time of year when monitoring performance of certain items – for example, pumpkin spice sells better in October than it does in March.

Can't find what you need?