Estimated time to Update: <5 Minutes
If products in Shopify include the cost, you do not have to fill out this sheet.
If Shopify does not have your product costs, then fill in this sheet, your SKU cost is used to calculate Gross Margin.
What You'll Need:
- List of products by SKU
- Associated cost by SKU
- Dates costs may have had meaningful changes (optional)
The start date and end date are used to specify SKU costs at different points in time, as highlighted in the example below. This data will be used to integrate your order and revenue information to provide you with a daily gross margin figure.
Please note that "days" are defined as 12:00:00AM to 11:59:59PM in the timezone that your Shopify store is set to.
SKU (Column B)
- Input SKU
$ Cost (Column C)
- Input SKU cost
Start Date (Column D)
- The date the SKU started being sold at a specific cost. This tab was designed to account for SKU cost changes. This is a required field.
End Date (Column E)
- The Date an SKU stopped being sold at that cost. The end date is only required if the SKU cost changed. In the example below, you'll notice only 2 SKUs have End Dates (highlighted). This is not a required field.
Columns B, C, and D are required if an SKU exists. E is only required if you need to list the SKU twice.