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.
NOTE: The END date is Before (Until) - Example: If the cost change takes effect on 9/1/2022 - The END date of the OLD cost should be 9/1/2022 and the START Date of the NEW Cost should ALSO be 9/1/2022. This will ensure the OLD Cost is used UNTIL/BEFORE 9/1. See Screenshot At Bottom of Page.
SKU (Column B)
- Input SKU
$ Cost (Column C)
- Input SKU cost
Currency (Column D)
- The currency used for this cost data. If nothing is entered it will default to USD.
Start Date (Column E)
- 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 F)
- 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 E are required if a SKU exists. F is only required if you need to list the SKU twice.