When uploading your product file, you may encounter errors that prevent your products from successfully importing. Below is a list of common errors, what they mean, and how to correct them.
File Type Validation
Error: "This file type is not supported: {file_type}"
Cause: Uploading non-CSV files (e.g., .xls, .xlsx, .txt)
Solution: Ensure file is .csv
File Size Limit
Error: "Processing Failed. Please limit your CSV to 1000 lines or less. Nothing has been saved."
Cause: CSV contains more than 1000 rows
Solution: Split large files into multiple files of 1000 rows or less
File Encoding Issues
Error: "Error decoding file content" or "Error parsing CSV data"
Cause: Invalid file encoding or malformed CSV structure
Solution: Save CSV as UTF-8 encoding with proper CSV formatting
Empty File
Error: "No processable rows in uploaded file. No new products have been saved."
Cause: CSV file contains only headers or empty data rows
Solution: Ensure CSV contains at least one valid data row
Header/Column Validation Errors
Missing Required Columns
Error: "column {column_name} column missing"
Cause: Required columns are missing from CSV header
Solution: Complete required columns
Product Title
Product Type
Description
Retail Price ({currency}) (for each currency in user's turf)
Invalid Location Inventory Columns
Error: "The label(s) for the following column(s) is not recognized: location_name} Inventory. Please edit the label(s) or remove the column(s)."
Cause: Location name in inventory column doesn't exist in the system
Solution: Use exact location names that exist in your system
Permission-Based Location Errors
Error: "You do not have permission to set inventory at the following location(s): {location_name}. Please remove the column(s)."
Cause: User doesn't have access to specified locations
Solution: Remove inventory columns for locations you don't have access to
Missing Currency in Pricing Columns
Error: "The column {column_name} is missing a currency code. Please add it."
Cause: Pricing columns don't specify currency (e.g., "Retail Price" instead of "Retail Price (USD)")
Solution: Format pricing columns as "Retail Price* (USD)", "Unit Cost (USD)", etc.
Unauthorized Currency Pricing
Error: "You do not have permission to set pricing at {column_name}."
Cause: Trying to set pricing for currencies not in user's location turf
Solution: Only include pricing columns for currencies in your assigned locations
Missing Required Pricing
Error: "Missing Retail Price for {currency} locations."
Cause: Required retail price column is missing for a currency in user's turf
Solution: Include retail price column for all currencies in your location turf
Row-Level Data Validation Errors
Missing Required Field Values
Error: "Value in column {column_name} is missing."
Cause: Required fields are empty in data rows
Solution: Complete required fields:
Product Title
Product Type
Description
Retail Price
Invalid Product Type
Error: "Value '{product_type}' is not allowed for column Product Type"
Cause: Product Type value is not in allowed list
Solution: Use allowed values:
Water, accessories, foodandbeverage, rentals, default, clothing, custom, equipment (case-sensitive)
Invalid Currency Amount Format
Error: "Currency amount {value} is invalid"
Cause: Price values are not in valid currency format
Solution: Use proper currency symbols and decimal formatting
Valid Formats: $1000.00, £500, €300, CA$100.00, ¥1000
Missing Price Data
Error: "Price is required." or "Price for {currency} required."
Cause: No pricing information provided for required currencies
Solution: Ensure all required currency pricing columns have values
Invalid Boolean Values
Error: Various validation errors for boolean fields
Cause: Invalid values for yes/no fields
Solution: Ensure valid values are used for yes/no fields
Valid Values: True/False, Yes/No, Y/N (case-insensitive)
Inventory Validation Errors
Invalid Inventory Quantity
Error: "Initial inventory for {location_name} is set to {value} but must be a positive integer value."
Cause: Non-numeric or non-integer inventory values
Solution: Use only positive integers for inventory quantities
Negative Inventory
Error: "You cannot set initial inventory to a negative value."
Cause: Negative inventory values provided
Solution: Use zero or positive integers only
Inventory on Non-Inventoriable Products
Error: "The stock record for {product_title} at {location_name} is not set to be inventoriable."
Cause: Trying to set inventory for products marked as non-inventoriable
Solution: Set "Track inventory? (False by default)" to "True" for products that need inventory
Serializer Validation Errors
Product Serializer Errors
Error: Various field-specific validation errors from the product serializer
Causes: Invalid SKU format, duplicate barcodes, invalid attribute values
Solution: Ensure all product data follows the expected format and doesn't conflict with existing products
Currency Code Validation
Error: "'{currency_code}' is not a supported currency."
Cause: Invalid currency code in pricing data
Solution: Use valid 3-letter currency codes (USD, EUR, CAD, etc.)
Price Required for Active Products
Error: "Price is required to make product active in the following locations: {locations}."
Cause: Product marked as active but missing price for some locations
Solution: Provide pricing for all locations where product is active
General Processing Errors
Database Transaction Errors
Error: Various database-related errors during product creation
Common Causes: Constraint violations, foreign key issues, duplicate entries
Solution: Check for duplicate SKUs, barcodes, or other unique constraints
Memory/Resource Errors
Error: Errors related to processing large files or system resource limitations
Solution: Use smaller file sizes, ensure adequate system resources