The sales and inventory history page displays historic information for a variant to provide more context around the forecast. On this page, you can view the data that was synced from Shopify and see how Inventory Planner used the data to determine whether the variant was available to be sold on a specific day.
The figures on this page cannot be changed – they are displayed for your reference.
Key dates
The dates to be aware of are:
Available sales and inventory data (range, “from”-“to”)
From: The “from” date is:
either 2 years ago (not including today’s date),
or the “Created at” date if the product was created within the last 2 years.
To: The “to” date is the date of the last nightly sales and inventory sync. It represents the last sync that ran before today’s date.
Created at: The date the variant was created in Shopify. It may be before or after the “Published at” date:
Before: Variants created before publishing, a product without variants
After: A variant added after the parent product was published
Published at: The date the product was published in Shopify. It’s set at the product level, not the variant level, and may be blank if the variant isn’t yet published.
Sales and inventory history data
The data available in the sales and inventory history screen is as follows:
Field | Description |
Date | The date the data in this row is from. |
Inventory | The inventory level at the time of the sync on the date.
If the date is before the first sync with Inventory Planner, this field will be left blank.
This data is taken from Shopify. |
Sales | The net sales made on the date. Net sales is calculated by subtracting returns from gross sales.
The sales data is taken from Shopify. |
Returns | The returns made on the date.
Note that returns correspond to the date a variant was returned into stock, not the date it originally sold. |
Gross sales | The gross sales made on the date. |
Sell when stockout | The state of the “Continue selling when out of stock” setting in Shopify at the time of the sync on the date. If checked, a checkmark will appear in this column. If left blank, an "x" will appear.
If the setting was changed after syncing, it won’t update.
If the date is before the first sync with Inventory Planner, you'll see a question mark. |
Available to sell | Inventory Planner calculates whether the variant could be sold on the date, and so whether the date should be included when counting the total number of sellable days, which is then used in calculating the forecast. Learn more about the forecast calculations here.
To be considered available to sell on a particular date, the variant must:
Because Shopify does not sync historical inventory setting data, the calculation uses different rules for dates before the first sync.
For those dates, a variant will be considered available to sell if its “Created” date and “Published at” date both fall outside the last two years. If one or both dates were within the last 2 years, the behavior is as follows:
This treatment of the data produces a slightly more conservative forecast, which will be more noticeable the longer your forecast period.
Note that the available to sell figure is calculated at the time of the nightly sync. It will not update during the day, but will be recalculated at the next nightly sync. |