When to Use a Custom Product Additional Costs Import
Conjura Retail Analytics automatically retrieves Cost of Goods Sold (COGS) data from your integrated eCommerce and ERP systems. However, many businesses incur additional costs beyond basic COGS that are essential for accurate contribution margin calculations.
Product Additional Costs allows you to import supplementary costs that sit on top of your existing COGS data, whether pulled from Shopify, your ERP/OMS (like Brightpearl, Linnworks, or Cin7), or manually imported via Product Costs.
Why Import Product Additional Costs?
Many ERP and eCommerce systems don't capture the full spectrum of costs associated with fulfilling orders. Product Additional Costs ensures you have a complete picture of your true cost structure by accounting for expenses such as:
Pick & Pack fees
Fulfillment center costs
Import duties and tariffs
Freight and shipping costs to your warehouse
Storage and warehousing fees
Quality control and inspection costs
Packaging materials
Third-party logistics (3PL) fees
Without these additional costs, your contribution margin calculations may be overstated, leading to inaccurate profitability analysis and poor business decisions.
How Product Additional Costs Work
Product Additional Costs are additive to your existing COGS data:
If you have COGS from Shopify → Additional Costs are added on top
If you have COGS from ERP/OMS (Brightpearl, Linnworks, Cin7) → Additional Costs are added on top
If you have manually imported Product Costs → Additional Costs are added on top
Example:
Base COGS from Shopify: $10.00
Pick & Pack cost: $2.50
Import duties: $1.25
Total Cost for margin calculation: $13.75
How to Use a Custom Product Additional Costs Import
There are two methods for adding product additional costs: via CSV upload or by manual entry into the app.
For large uploads, the CSV method is typically faster. Here's how to do it:
CSV Upload Method
Navigate to the Custom Data Import tab under 'Connectors' on the left-hand side navigation bar.
Select 'Product Additional Costs'.
Click on 'Download CSV Template File'.
Fill out the spreadsheet offline with the following details:
Start Date (optional, yyyy-mm-dd): When these additional costs should start applying
End Date (optional, yyyy-mm-dd): When these additional costs should stop applying
Product Key (pre-populated): Internal product identifier
Product SKU (pre-populated): Your product SKU
Product Name (pre-populated): Product name for reference
Country (optional): Specify if costs vary by country/market
Label: Descriptive name for the cost type (e.g., "Pick & Pack", "Import Duties", "3PL Fees")
Currency: Currency for the cost amount
Cost Amount: The additional cost value per unit
Repeat for all desired SKUs and cost types, then save the file.
Navigate back to the Product Additional Costs import in Retail Analytics.
Before uploading your file, delete all existing 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 reports with updated contribution margins.
Manual Entry Method
Alternatively, you can manually input data directly into the app:
Navigate to the Custom Data Import tab under 'Connectors'.
Select 'Product Additional Costs'.
Follow the on-screen prompts for manual data entry.
Select 'Submit Data'.
Your data will sync overnight and appear in your reports.
Managing Your Product Additional Costs
Updating Costs
To update existing additional costs, simply upload a new file or manually enter new data. The system will replace costs for the specified time periods and SKUs.
Removing Costs
To remove additional costs, locate the file under 'My Imported Data' in the Custom Data Import tab and select the delete button.
Troubleshooting
If invalid entries are appearing, double-check that you removed all existing rows prior to uploading your new file.
Ensure date formats follow yyyy-mm-dd structure
Verify that SKUs match exactly with those in your connected systems
Check that currency codes are valid (USD, GBP, EUR, etc.)
Best Practices
Use descriptive labels for different cost types. Currently these will be grouped together as a single cost in the dashboards.
Set appropriate date ranges if costs change over time (e.g., seasonal freight rates)
Review contribution margins after import to ensure calculations look accurate
Keep costs up-to-date as your fulfillment costs change
Use country-specific costs if you have different cost structures by market
Impact on Reporting
Once imported, Product Additional Costs will be automatically included in:
Contribution Margin calculations
Product Contribution Margin
SKU-level financial performance metrics
This ensures you have the most accurate view of your true product profitability and can make informed decisions about pricing, product mix, and operational efficiency.