Overview
Although Shopify's Order API does not pass through direct markdown data, Toolio is able to back into markdown values at the line item level by referencing a variant's compare at price. Please see below for an overview of the logic Toolio follows at the time of import, along with a few examples.
Walkthrough
Since Shopify does not provide the Sales Ticket (MSRP) value of the sales line, Toolio calculates this first by multiplying the number of Sales Units against the Shopify Compare at Price (if available). If the Compare at Price is null (as shown in Sale Id 003), this means that no Compare at Price has been set, and the item has not been markdown. In examples 001 and 002, the Sales Ticket values are evaluated as $50, and $100, respectively.
Please note that while Sales Retail and Discount values from Shopify already account for the number of units sold, the Compare at Price is always at the single unit level.
Toolio then calculates Markdown = Sales Ticket - Discount - Sales Retail
Please see below for a few examples of Shopify Sales Data and Toolio's transformation:
Shopify Sales Data:
Sale Id | Sales Units | Sales Retail | Discount | Compare at Price |
001 | 1 | $30 | $10 | $50 |
002 | 2 | $60 | $20 | $50 |
003 | 1 | $50 | $10 |
|
Toolio Transformation:
Sale Id | Sales Units | Sales Retail | Discount | Markdown |
001 | 1 | $30 | $10 | $10 |
002 | 2 | $60 | $20 | $20 |
003 | 1 | $50 | $10 | $0 |
Please also note that Shopify only passes through the Compare at Price at the time of data import. This means that historic sales will be captured with current Compare at Prices but future Markdown calculations will be accurate even if the Compare at Prices change.
If you have any questions regarding this workflow or validating your sales data in Toolio, please reach out to your Customer Success Manager.
Related Articles