When uploading products via CSV, Programa runs a dry run check to identify any issues before syncing the product data. Here's a breakdown of common errors and warnings you may encounter, what they mean, and how to fix them.
❌ Errors (Must Fix)
These issues will block your upload. You'll need to correct them before proceeding.
1. MissingIdentifierError
What it means: A row is missing both product_id (for base products) and variant_of (for variants), so Programa can't tell what it is.
Fix: Add a unique product_id if it’s a base product, or use variant_of to link it to an existing product.
2. UnknownVariantError
What it means: A variant is referencing a base product (variant_of) that doesn’t exist in the CSV.
Fix: Ensure the corresponding base product row is included in your CSV and uses the exact same product_id.
3. DuplicateIdentifierError
What it means: Two or more products share the same product_id.
Fix: Make sure each base product has a unique product_id.
4. UnnamedProductError
What it means: A base product is missing a product_name.
Fix: Add a product name in the product_name column.
5. MissingBrandError
What it means: A product doesn't list a brand_name.
Fix: Include a valid brand name that matches your assigned brand(s).
6. MissingCategoryError
What it means: A product doesn’t have a category_key.
Fix: Use a valid category key from Programa’s [accepted list]
7. BrandNotFoundError
What it means: The brand_name listed doesn't exist or isn’t linked to your account.
Fix: Double-check spelling or add the brand to your company profile.
8. CategoryNotFoundError
What it means: The category listed isn't a valid option.
Fix: Use one of Programa’s supported category keys exactly as listed.
⚠️ Warnings (Optional Fix)
These issues won’t block your upload, but fixing them improves product quality and searchability.
Formatting or Missing Data Warnings
UnrecognizedColumnWarning
→ Extra columns will be ignored.
→ Fix: Remove unused or misspelled columns.
MissingBaseImageWarning
→ Product will show a placeholder image.
→ Fix: Add a valid primary_image URL or filename.
FileNotFoundWarning
→ The referenced image or file wasn’t found.
→ Fix: Check the filename in the CSV matches the filename of the image or document provided.
Numeric Field Issues
NonNumericWidth/Height/Length/Depth/WeightWarning
→ These dimensions must be numeric.
→ Fix: Remove text or symbols and use numbers only.
NonNumericProductRrpWarning
→ RRP should be a numeric value only (no $ signs or text).
→ Fix: Use a clean number (e.g. 199.95)
Value Option Warnings
ColourValueNotFoundWarning
→ Colour values don’t match Programa’s accepted values.
→ Fix: Use standard colour names
PerUnitNotFoundWarning
→ per_unit must be: Item, Set, Meter, SMeter, or LMeter.
PricedFromNotFoundWarning
→ Use only yes or no.
Lead Time Warnings
LeadTimeWarning
→ Must be a whole number between 1–52 weeks.
→ Fix: Remove any text or unrealistic values.
Contact Information Warning
EmailNotFoundWarning
→ Email doesn’t match a user in your account. The default company contact will be used.
Duplicate or Incomplete Variant Warnings
DuplicateVariantWarning
→ A variant row is identical to another.
→ Fix: Remove duplicates or update unique attributes like colour, size, etc.
EmptyVariantWarning
→ Variant is missing data and doesn't differ from the base product.
→ Fix: Include at least one unique variant field (e.g., colour, finish).
💡 Tip
Download the latest [CSV template] and view accepted fields and values to ensure a clean upload.
📬 Need Help?
Reach out to our team at brands@programa.com.au with any questions.