Merchandise Analysis Report

The Merchandise Analysis report gives you a product-level view of sales and inventory performance across all of your locations. For each product, you can see total quantity sold, quantity on hand, sell-through, and profitability — both overall and broken out by location — without having to add up individual size or item rows yourself.

Use this report to quickly spot fast- and slow-moving products, see where inventory is sitting, and make buying and replenishment decisions with confidence.

The report is available under Reports → Custom Reports and generates a CSV file that can be emailed to one or more recipients.

How the report is organized

The report groups everything under the Product ID:

• One row per product shows the product's details — Product ID, Description, Vendor #, Department, Category, Subcategory, Average Selling Price, and MU %.
• Location rows underneath show that location's numbers, combined across all sizes of the product.
• An ALL row gives you the product's total across every location.

How to read the report

Each product appears as a group of rows. Here's an example:

Product ID	Description	Location	Qty on Hand	Sales	Qty Sold	Sellthru %
PID-8452	Home Team Fleece Hoodie	ALL	302	9,950	199	39.7
PID-8452	Home Team Fleece Hoodie	TS	64	5,850	117	64.6
PID-8452	Home Team Fleece Hoodie	WEB	28	4,100	82	74.5
PID-8452	Home Team Fleece Hoodie	WH	210	0	0	0

• The ALL row is the product's total across every location — your quickest read on overall performance.
• Each location row (e.g., TS, WEB, WH) shows that location's activity across all sizes of the product, so you can see where inventory is sitting and where it's selling.

In this example, the hoodie is selling well at the team store (64.6% sell-through) and even faster online (74.5%), but 210 units are still sitting in the warehouse — which is why the overall sell-through on the ALL row is a lower 39.7%. That's a signal to move warehouse stock out to the locations where it's selling.

Columns in the report

Product details (shown once per product):

Column	What it shows
Product ID	The product (style) identifier the report is grouped by
Description	Product name
Vendor #	The product's vendor
Department / Category / Subcategory	The product's merchandise hierarchy
Average Selling Price	The product's price. If sizes carry different prices, this displays as a range (low–high)
MU %	Markup percentage

Location details (one row per location, plus the ALL total):

Column	What it shows
Location	The store, web, or warehouse location (ALL = product total)
Qty on Hand	Units currently on hand at that location, across all sizes
Extended Retail Price on Hand	Retail value of on-hand inventory
Sales	Sales dollars for the selected period
Qty Sold	Units sold for the selected period
Sellthru %	Sell-through, calculated from that row's own totals
Profit %	Profit margin, calculated from that row's own totals
Qty on PO	Units on open purchase orders
Last Recv Date	The most recent receipt date. On the ALL row, this is the most recent date across all locations

If you have questions about the report, please reach out to our support team.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more