Import Issues

Troubleshooting CSV import problems

Last updated: 17th January 2025

Import Issues

Having trouble importing cost data? Here are solutions to common problems.

Import Fails Completely

Problem: The CSV import fails with an error.

Solutions:

  1. File format - Ensure it's a valid CSV file (not Excel .xlsx)
  2. Encoding - Save as UTF-8 encoding
  3. File size - Files larger than 10MB may timeout
  4. Column headers - Required headers must be present

Required Columns Missing

Problem: Error says required columns are missing.

Required columns:

  • sku or product_id - To identify the product
  • cost - The cost value to import

Optional columns:

  • shipping_cost
  • handling_cost
  • supplier

Products Not Matching

Problem: Import completes but products don't update.

Solutions:

  1. SKU matching - SKUs must match exactly (case-sensitive)
  2. Variant SKUs - Use variant SKUs for products with variants
  3. Check for spaces - Extra spaces in SKUs prevent matching
  4. Review import report - Check which rows failed

Wrong Values Imported

Problem: Imported costs don't match the CSV values.

Solutions:

  1. Number format - Use plain numbers (no currency symbols)
  2. Decimal separator - Use period (.) not comma (,)
  3. Thousands separator - Don't use commas in numbers
  4. Quotes - Values with commas need to be quoted

Correct Format Examples

sku,cost
ABC123,25.99
DEF456,100.50

Incorrect Format Examples

sku,cost
ABC123,$25.99     ← No currency symbols
DEF456,"100,50"   ← Use . for decimals
GHI789,1,000.00   ← No thousands separators

Partial Import

Problem: Some rows import, others fail.

Solutions:

  1. Download the error report after import
  2. Review failed rows for common issues
  3. Fix the problematic rows
  4. Re-import only the fixed rows

Duplicate SKUs

Problem: Multiple rows have the same SKU.

Solutions:

  1. Only the last row for each SKU will be used
  2. Remove duplicates before importing
  3. Use variant-level SKUs if updating variants

Timeout on Large Files

Problem: Import times out with large CSV files.

Solutions:

  1. Split large files into smaller batches (1000 rows each)
  2. Import during off-peak hours
  3. Remove unnecessary columns to reduce file size

Template Download

For best results, use our import template:

  1. Go to Products > Import
  2. Click Download Template
  3. Fill in your data
  4. Import the completed file

Still Having Issues?

Contact support with:

  • Your CSV file (or a sample)
  • Error messages received
  • Screenshot of import results