Sale Model
sale_id
What are common values to use for sale_id?
sale_id, needs to be unique identifier that you can reproduce deterministically.
Below are are few approaches:
If you're sending Sales data on a transaction granularity
line_item_id(e.g. on Shopify), which would be unique to every transaction variant combination{order_id}_{variant_id}, i.e. concatenation of order_id and variant_id
If you're sending Sales data on a day level granularity
{date}_{location}_{variant_id}, i.e. concatenation of date, location and variant_id. Example could be: 2020-10-01_1234_999999
returns_retail
Should returns_retail include the markdowns and discounts?
Returns retail will be the exact amount given to the customer - so it will be net of the discounts and markdowns that they might have had during the sales.
For example:
Sales Ticket: $100
Markdown: $10
Discount: $20
Sales Retail: $70
Return happens:
Returns Retail: $70
location
Should location be a human readable name, or an identifier?
It's important that the value for the location attribute doesn't change over time. To that end, identifiers are preferable to human readable names, as the latter tends to change. As needed, Toolio can map the location identifiers to human readable names as needed.