When to Use a Custom Product Costs Import
Conjura Retail Analytics automatically retrieves Cost of Goods Sold (COGS) data from your integrated eCommerce and ERP systems. This COGS information is essential for calculating key performance indicators (KPIs) like Contribution Margin and Gross Profit Margin displayed on your dashboards.
If your Shopify account already has COGS data, our system will automatically pull it—no manual import needed.
However, please note that at this time we are unable to pull Amazon COGS. You’ll need to import COGS data unless your Amazon SKUs exactly match your Shopify SKUs.
Why Import Product Costs?
Accurate COGS data is crucial for insightful financial analysis. If your eCommerce or ERP system lacks precise COGS tracking, using a Custom Product Costs Import ensures reliable data for informed decision-making in Retail Analytics.
How to Use a Custom Product Costs Import
There are two methods for manually adding product costs: via CSV or by manual entry into the app.
Important: Importing COGS for Shopify SKUs manually will replace any existing COGS in Shopify for the specified time period.
For large COGS uploads, the CSV method is typically faster. Here's how to do it:
Navigate to the Custom Data Import tab under ‘Connectors’ on the left-hand side navigation bar.
Select ‘Product Costs’.
Click on ‘Download CSV Template File’.
Fill out the spreadsheet offline with the following details:
Start Date (optional, yyyy-mm-dd)
End Date (optional, yyyy-mm-dd)
Product Key (pre-populated)
Product SKU (pre-populated)
Cost Amount: For fixed COGS
Currency
Perc of Revenue Cost Amount: For variable COGS (decimal format, e.g., 0.2 = 20%)
Repeat for desired SKUs and save.
Navigate back to the product costs import in Retail Analytics.
Before uploading your file, delete all rows in the table. You can see an example by hovering over "How to do it."
Either drag and drop your file or click 'Upload File'
Click 'Continue' to ensure all columns are correctly mapped.
Select ‘Submit Data’.
Your data will sync overnight and appear in your report.
To remove costs, locate the file under ‘My Imported Data’ in the custom data import tab and select the delete button.
Note - if invalid entries are appearing, double check you removed all existing rows prior to uploading your file.
Alternatively, you can manually input data directly into the app:
Navigate to the Custom Data Import tab under ‘Connectors’.
Select ‘Product Costs’.
Follow the steps for data entry.
Select ‘Submit Data’.
Your data will sync overnight and appear in your report.