CSV Import Troubleshooting

Resolve issues importing table rate CSV files.

Common Issues

Import Fails

Symptoms:

• Error message on upload
• Rates not appearing

Solutions:

1. Check CSV format (UTF-8, no BOM)
2. Verify column headers match exactly
3. Check for empty rows
4. Remove special characters

Bulkgood Column Ignored

Symptoms:

• CSV imports but bulkgood not working

Solutions:

1. Column must be named exactly "Bulkgood"
2. Values must be 0 or 1 (not Yes/No)
3. No spaces in column name

Wrong Rates Applied

Symptoms:

• Rates don't match CSV values

Solutions:

1. Clear config cache after import
2. Check store view scope
3. Verify condition column values
4. Check for duplicate rows

CSV Format Requirements

Country,Region,Zip,Condition,Price,Bulkgood

Validation

Before import:

1. Open in text editor (not Excel)
2. Check encoding is UTF-8
3. Verify no hidden characters
4. Test with small file first

Related

• Table Rate Setup
• Common Issues