← Back to Resources
Bulk Upload Troubleshooting Guide
Core principle: Use official platform templates without modifications. All errors stem from data format issues or missing required fields.
Most Common Errors (& Quick Fixes)
1. Category Not Found
Problem: Category name doesn't match platform taxonomy exactly (including capitalization and punctuation).
Solution:
- Go to platform Seller Center → Add Product
- Navigate category tree and copy exact name
- For Lazada: Copy numeric category ID from URL (
catId=12345)
- Paste exact value into your template
2. Image URL Not Accessible
Problem: Platform can't load your images. Common causes: password-protected sites, Dropbox/Google Drive links, HTTP instead of HTTPS.
Solution: Test URLs in private browser. If you can't see them without login, neither can the platform. Use HTTPS, avoid spaces in filenames.
3. Price Format Invalid
Problem: Currency symbols, commas, or text in price field.
Solution: Use numeric values only: 29.99 not $29.99 or 29,99 or 29
4. Product Name Too Long
Problem: Exceeds character limits.
Solution: Limits are Shopee: 120 chars, Lazada: 255 chars, TikTok Shop: 120 chars. Use Excel formula =LEN(A2) to check length.
5. Missing Required Field
Problem: Weight, dimensions, or brand fields empty.
Solution: TikTok Shop requires weight/dimensions (mandatory). Lazada requires brand field. Fill in WooCommerce before export.
Platform-Specific Requirements
| Platform |
Columns |
Special Requirements |
| Shopee |
37 |
Square images (1:1), white background preferred |
| Lazada |
28 |
Numeric category IDs, mandatory Brand field, white background required |
| TikTok Shop |
28 |
Mandatory weight/dimensions in grams, lifestyle images work well |
Image Requirements
- Shopee: Min 500×500px (rec: 1000×1000px), max 2MB, square format
- Lazada: Min 800×800px (rec: 1200×1200px), max 1MB, white background mandatory for main image
- TikTok Shop: Min 800×800px, max 5MB, text overlays allowed
- All platforms: Use HTTPS URLs, no spaces in filenames, host on reliable server
Product Variations
Variations require multi-row entries with parent-child linking:
- Row 1: Parent product with basic info, stock field EMPTY
- Row 2+: Each variation with same Parent SKU, unique Variation ID, and stock quantity
- All variation fields must be filled if any variation exists
Pro Tip: Start with 10-20 products as test batch. Fix errors, then scale to full catalog. This catches systematic issues early (wrong categories, image problems) before bulk corrections needed.
Pre-Upload Checklist
Data validation:
- Product names under character limits
- Prices are numbers only (no $ symbols)
- Categories match platform taxonomy exactly
- All image URLs work (test in private browser)
- Weight/dimensions filled (especially TikTok)
- Brand field populated (Lazada)
Template validation:
- Using latest template from platform
- No deleted columns or modified headers
- Data starts at correct row
Time Savings
Manual process: 6-10 hours for 100 products across 3 platforms
Cirvie Product Exporter: 5-10 minutes
Plugin handles template formatting, field mapping, and variation conversion automatically. Source data quality in WooCommerce still determines success - automation can't fix incomplete or incorrect data.