Importing Shopify COGs:
If your costs are currently going through Shopify, they're also already in Polar as the "Cost of Products" metric (and there's no need to re-import them). If your costs are not currently going through Shopify, you can add them by SKU to Polar using our Cost of Products Google Sheet template. This article provides more detail on how you can add data to Polar with a Google Sheet. Once you've added them with a Google Sheet (or Shopify, or both) they'll be automatically added to Total Costs in Polar.
Similarly, if your Cost of Goods Sold (COGs) are not currently in Shopify, we recommend adding them to Shopify so that so that they can pull automatically to Polar. This article from Shopify's Help Center details how you can do that.
Once the data is flowing through either from Shopify or Google Sheets to Polar, you'll be able to pull the Total Cost metric into a Custom Report (or your Key Indicators) and break down by Cost Type to differentiate between your various costs.
This visual shows what the data might look like when you have the "Entire Range" date range set.
This visual shows what the data might look like when broken down "By Day" in the date range.
Importing Amazon COGs:
If you'd like to track your Amazon Cost of Products (COGs) in Polar, you'll need to import them using our Cost of Products Google Sheet template. In the "Store" column in Column B, enter your Amazon Merchant ID. This article provides more detail on how you can add data to Polar with a Google Sheet. Once you've added them with a Google Sheet, you'll see them populate in Polar within the Cost of Products (COGs) Amazon metric.
If you'd like to use the data to calculate your profitability in Polar, this article details how you can do so.
Things to Note:
When you're using a Custom Report to break down your cost types, "cogs" comes from Shopify, and "ops cogs", "fulfillment", and "opex" come from your Google Sheet.
If you make an update to your COGs or Cost of Products on Shopify and notice that the data on Polar is outdated, please reach out to our Support Team via the in-app live chat and we'll be happy to do a full historical data refresh on your account.