Overview
Understanding your Cost of Goods Sold (COGs) is essential for tracking profitability and making informed business decisions. In Polar Analytics, you can view and manage your Cost of Products data sourced from Shopify and Amazon. This article explains how to import and view your COGs in Polar, how updates are handled over time, and how to ensure your metrics remain accurate.
Importing and Viewing Shopify COGs
If your product costs are already tracked in Shopify, they will automatically sync to Polar under the Cost of Products (COGs) and Total Costs metric—no extra steps needed.
However, if your costs aren’t in Shopify, you can manually add them by SKU using our Cost of Products Google Sheet template. Once uploaded, your data will automatically appear in Polar and roll into the Cost of Products (Gsheet Only) and Total Costs metric.
Steps to Add Shopify COGs:
Download and fill out the Cost of Products Google Sheet template.
Enter your product costs by SKU.
Import the completed sheet into Polar.
Review your “Cost of Products” metric in your reports or dashboards.
This article provides more detail on how you can add data to Polar with a Google Sheet.
If you’d prefer, you can also add COGs directly into Shopify—Shopify’s Help Center article explains how to do this. Once entered, the data will automatically flow into Polar.
💡 Tip: In Polar, you can break down your Total Costs by Cost Type (for example: COGs, fulfillment, opex) to analyze profitability more accurately.
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 imports.
This makes it easy to see how your operational and product costs contribute to overall profitability across channels.
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 sell on Amazon, you can track your Cost of Products in Polar using the same Google Sheet import method.
To import Amazon COGs:
Download the Cost of Products Google Sheet template.
In the “Store” column (Column B), enter your Amazon Merchant ID instead of your Shopify store name.
Upload the completed sheet to Polar.
Your data will appear in the "Cost of Products (COGs)" Amazon metric.
This allows you to consolidate product cost data from both Shopify and Amazon, ensuring that all costs contribute to your total profitability metrics in Polar.
If you'd like to use the data to calculate your profitability in Polar, this article details how you can do so.
Understanding How Historical COGs Are Treated
By default, Polar does not retroactively update historical COGs. This design choice ensures that your historical reports remain accurate to the data as it existed at that time.
If you’d like to apply updated COGs across all historical data, our team can perform a full historical refresh on your account upon request. Simply reach out through the in-app live chat, and we’ll handle it for you.