Bulk CSV Import

Bulk CSV Import

Got a large inventory? CSV import is your best friend!

Navigate to: Create Listings to access CSV import and all bulk creation tools

When to Use CSV Import:

• Migrating from another platform
• Importing wholesale inventory
• Creating 100+ listings at once
• When you already have product data in spreadsheets

Import Methods

1. CSV File Upload

Upload a CSV file directly from your computer.

2. Google Sheets Import

Import directly from a public Google Sheets URL - no file download needed!

1. Open your Google Sheet
2. Click Share → Anyone with the link → Viewer
3. Copy the sheet URL
4. Paste in the Google Sheets input field
5. Click Import

Note: The sheet must be publicly viewable. Private sheets are not supported.

3. ZIP Folder Upload (Bulk Images)

Upload a ZIP file with images organized in folders that match your CSV data.

Folder Structure:

products.zip
├── SKU-001/
│   ├── front.jpg
│   ├── back.jpg
│   └── detail.jpg
├── SKU-002/
│   ├── img1.png
│   └── img2.png
└── "Blue Vintage Jacket"/
    ├── photo1.jpg
    └── photo2.jpg

How to Use:

1. Upload your CSV first
2. In the mapping interface, click Upload ZIP
3. Choose how to match folders:

• By SKU: Folder names match SKU values in your CSV
• By Title: Folder names match product titles

1. Images are automatically attached to matching products

4. Images-Only ZIP Upload (No CSV Required)

Don't have a CSV? Just organize your product photos into folders and let AI do the rest.

Folder Structure:

my-products.zip
├── Nike Air Max 90/
│   ├── front.jpg
│   ├── back.jpg
│   └── sole.jpg
├── Vintage Levi's 501/
│   ├── photo1.png
│   └── photo2.png
└── Adidas Hoodie/
    ├── img1.jpg
    ├── img2.jpg
    └── img3.jpg

How to Use:

1. Drag your ZIP onto the Create Listings page (or click to browse)
2. In the modal, select Images only (no CSV)
3. Review the mapping interface — each folder becomes one product row
4. Click Process — AI generates titles, prices, descriptions from your photos

Notes:

• Each folder = one product listing
• Folder names are used as initial title hints for AI
• Root-level images (not in any folder) are skipped
• Empty folders are ignored
• Maximum 5,000 folders per ZIP
• Nested subfolders group images under their immediate parent folder

CSV Format Requirements

• Encoding: UTF-8 (BOM-free preferred)
• Delimiter: Comma-separated
• Headers: First row must be column headers
• Max Rows: 5,000 rows per file

Required Columns:

Optional But Recommended:

• sku - Your product code
• description - Product description
• brand - Brand name
• category - Product category
• condition - new, like-new, good, fair, poor
• size - Size information
• color / colours - Color(s)
• department - womens, mens, kids, unisex
• material - Fabric/material type
• quantity - Inventory count (default: 1)

Image URL Support

FLUF automatically downloads images from URLs in your CSV. Supported sources:

• Depop - Full support for Depop CDN URLs
• eBay - eBay image hosting URLs
• Vinted - Vinted image URLs
• Any public URL - Imgur, Cloudinary, AWS S3, etc.

Multiple Images: Separate with pipe |, comma ,, or semicolon ;:

https://example.com/img1.jpg|https://example.com/img2.jpg|https://example.com/img3.jpg

Automatic Retry: Failed downloads are automatically retried up to 3 times with increasing delays.

AI Fix CSV Mode

Having issues with your CSV? Let AI fix it automatically!

What It Fixes:

• Encoding issues - Windows-1252, ISO-8859-1 → UTF-8
• Wrong delimiters - Semicolons, tabs → commas
• Unquoted fields - Fields containing commas
• Missing headers - Adds generic headers
• Merged cells - Fixes Excel export issues
• Inconsistent formatting - Standardizes data

How to Use:

1. Upload your problematic CSV
2. If issues are detected, click Fix with AI
3. Review the suggested fixes
4. Download the corrected CSV

Step-by-Step Import

1. Upload Your CSV

• Go to Listings → Create
• Drag & drop your CSV file or click to browse
• First 10 rows are shown as a preview

2. Map Columns

• FLUF AI suggests column mappings automatically
• Review and adjust as needed
• Use — to skip a field (AI will generate it)
• Multi-value fields (images, colors) support multiple column selection

Pro Tip: Channel-specific columns use prefixes like depop_description, ebay_title.

3. Add Images via ZIP (Optional)

• Click Upload ZIP in the mapping interface
• Choose matching method (SKU or Title)
• Images are attached to matching rows

4. Configure Settings

• Email Notification: Get notified when import completes (default: on)
• AI Processing: Toggle to disable AI generation
• Per-Marketplace Descriptions: Use different descriptions per channel

5. Start Processing

• Click Process CSV
• Processing runs in the background
• You can navigate away - import continues
• Check the results table for status

Email Notifications

For large imports (100+ items), you'll receive an email when processing completes with:

• Total items created
• Success/error counts
• Link to review your listings

Toggle this in Settings (on by default).

Undo Last Import

Made a mistake? You can undo your last import within 24 hours.

1. Look for the Undo Last Import button in the header
2. Click to see how many products will be affected
3. Confirm to move products to trash
4. Products can be recovered from WooCommerce trash for 30 days

Share Your Progress

Celebrate your bulk import! Share your progress with a shareable link.

1. After processing, click Share Progress
2. See your stats: items created, time saved
3. Copy the shareable link or share directly to X (Twitter)

Best Practices

• Test first: Try with 10-20 rows before full import
• Consistent formatting: Use the same format throughout
• Clean data: Remove special characters, fix encoding issues
• Backup: Keep a copy of your original CSV
• Use SKUs: Helps avoid duplicates and enables future updates

Processing Time

Monitoring Progress

• Results Table: Shows status of each row (pending, success, error)
• Row Count Badge: See total items being processed
• Error Details: Click on errors to see specific issues
• Email: Receive notification when complete

Common Issues

Troubleshooting

CSV won't upload:

• Check file size (max 10MB)
• Ensure UTF-8 encoding
• Try the AI Fix feature

Images not downloading:

• Verify URLs are publicly accessible
• Check for authentication requirements
• Try opening URLs in an incognito browser window

Google Sheets import fails:

• Ensure sheet is set to "Anyone with the link can view"
• Check the URL format is correct
• Try exporting as CSV instead

ZIP images not matching:

• Folder names must exactly match SKU or title values
• Check for extra spaces or special characters
• Try the title matching option if SKU isn't working