To search for a metric, use the Table of Contents dropdown above. 👆
(If you are on our Help Center webpage, click the metric titles on the right 👉)

Any variance between Stock Units (Stock on Hand), PO Received, Sales Units and Returns within the week. Usually shrinkage/system processing delays

Stock Units + Sales Units After Returns, which is how you would calculate Opening Stock on Hand (OSOH) manually, however, ATS and OSOH have few differences.

ATS differs from OSOH in the following ways:

If there are no transfers or Intake ATS will equal OSOH

Current Week's Stock Units / Average Sales Units (after returns) of the last 4 weeks

Sales revenue before returns ex-tax, divided by sales units before returns

Based on the average weekly closing stock over the time period you have selected.

Calculated by taking the Sum of Closing Stock U / Number of weeks in the selected timeframe

Calculated by taking Average Stock on Hand x Cost Price

Mapped directly from the source system, or calculated by taking cost price x sales units after returns or before returns

Sales $ Before Returns / Page views

Sales $ After Returns / Page views

Product List Clicks / Impressions

the value difference between the RRP or sell price (if the product is marked down) and the sales generated from the order.
Calculation = Total markdown $ - markdown $

Average units sold in the first 4 weeks of Sales (after returns)

((RRP/1.1) - Cost Price)/(RRP/1.1)

Shows the size that sold out first

Shows the week that the first size went out of stock

Sales Units After Returns Full Price/ ATS (Available to sell)

Sales units when the product’s price = RRP

This metric shows the sum of all units that are currently on order, to be delivered at a future date for a product

The in transit units that have not yet arrived at the intended store/warehouse

Style Arcade determines whether units as in transit or received by reading the due date of the movement

Used to analyse the profitability of inventory purchases. The calculation measures the cost of the average inventory compared to the gross margin you receive from selling it.

Calculated by taking Gross Profit After Returns / Average Stock @ Cost

Calculated by taking Sales $ Before Returns - Cost of Goods Sold Before Returns

Calculated by taking Sales $ After Returns - Cost of Goods Sold After Returns

Calculated by taking a percentage of Gross Profit Before Returns $ / Sales Before Returns $

Calculated by taking a percentage of Gross Profit After Returns $ / Sales After Returns $

The number of times the user sees either a product image or thumbnail

The date/week/month on which you last received stock in the selected store/location in the selected time period

The date/week/month a product was launched in any given store or online. For more info on how the launch date is calculated please check out this article

Average units sold in the last 4 weeks of Sales (after returns)

This is your red pen discount revenue. Essentially showing the value difference between the RRP and the sell price (exc tax).
Calculation = ((RRP ex tax)-(sell price ex tax)) x markdown sales units

This is the & difference between your RRP and the current selling price.

Calculation = 1 - (Selling Price / RRP) all ex tax

Sales units when the product’s price > RRP

The number of times a page has been viewed on a website

Price Status is dependent on the time you selected
Full Price = Selling at full price or at RRP
Markdown = Item has a red pen discount applied
Unknown = When the sell price is at 0 or unavailable

The number of times the users clicked the product when it appeared in the product list

How many individual styles within the time selected based on product code
​

Count of products that made sales or held stock within the time frame selected

To calculate the projected return, we consider the expected number of returns based on the current return rate (RR%) of the product and the remaining stock.

For instance, if the RR% is 10% and there are 100 units remaining, the projected returns would be estimated at 10 units.

PO Received Unit x RRP (ex tax)

Returns are attributed to the week they are returned/processed

Returned Units % of Sales Before Returns

Inclusive of tax. Please check out this article for current tax rates

Retail Sales $'s after returns and discounts

Retail Sales $'s before returns and after discounts

The net sales units, calculated by taking Sales U BR - Returned Units

The gross sold units

Sales units after returns of the selected week in your date range

Sales units after returns 2 weeks before your selected week

Sales units after returns 3 weeks before your selected week

Current price at which the product is selling or sold if in the past (markdown price)

Count of Sizes in Stock / Count of Total Sizes Bought

Shows how many more weeks the current stock will last based on the last full week's sales.

Sales Units After Returns (Sales U AR)/Available to Sell (ATS) of the selected period

Average Weekly Sell Through of the product in the first or last X weeks (customer dependent)

Stock on Hand Units or Closing Stock Units (when looking at historical sales data)

Stock at original cost price. Calculated by Cost price x Stock Units

Stock at original retail ex GST. Calculated by (RRP ex tax rounded) x Stock Units

The difference between (sales units after returns X RRP ex tax) and (sales after returns). This includes both markdowns & discounts.

Calculation is 1 - [Sales Revenue / (Sales U AR x RRP (ex tax))]. This metric is time-sliceable.

The to-date sell-through % since the product's gone live.

The units that were transferred in from another store/warehouse

Average weekly sales for a product, calculated using average sales only from the in-stock weeks. Essentially showing what you could have sold if you were always in stock of all sizes.

All variance % metrics are a comparison of this year vs last year.

E.g. Sales Units After Returns Variance % = Sales Units After Returns / Sales Units After Returns - 1

Units Bought in Sizes Still Available / Total Units Bought

How many weeks a product was in stock and able to make sales after the launch date

If a product sells out and comes back into stock it will calculate from the original launch date. This also takes into account if a time filter is applied

How many weeks has the product been in the business since its 1st date of launch

Not affected by time filters