Bulk product upload lets you instantly upload as many products as your premium plans allow in one shot. Instead of adding products one by one, you can prepare a CSV file and upload hundreds of products with their images, variants, and descriptions all at once.

Step 1: Prerequisites

Before You Start

Have pictures of all your products & variants in a folder
All pictures must be in 1:1 aspect ratio (recommended size 1080x1080) for perfect fit on website
Name picture files clearly to track which image belongs to which product & variant

Step 2: Uploading Pictures to Blanxer

2.1 Create a Folder

Go to Media Management, click on + Folder and create a folder (e.g., Nov_30)

2.2 Upload Images

Click on the created folder and Drag and Drop all images from your local folder

2.3 Download CSV

On the top right, click the CSV button to download the CSV format of that folder

CSV File Structure

The CSV file will contain:

file_name, file_url

This CSV is required for the bulk upload process.

Step 3: Understanding Bulk Upload Parameters

Go to Products → Add Product → Bulk Upload and click on Download Sample CSV

CSV Field Reference

product_name

Name of the product

variant

Variant details (Color, Type, Brand...)

size

Size options if available

group

Groups rows belonging to same product

product_description

HTML formatted description

channel

All: 1, WEB: 2, POS: 3

price

Selling price of the product

crossed_price

Marked/original price

your_buying_cost

Actual cost for profit calculation

quantity

Products in inventory

sku

Unique identifier for product

sell_after_out_of_stock

Y or N (default: Y)

product_category

Categories separated by /

status

Active or Draft (default: Active)

image_1 ... image_5

Image URLs for product

Required Fields

• product_name — Required
• price — Required
• image_1 — Required
• product_description — Must contain at least 20 characters
• If group is non-empty, either variant or size is also required

Step 4: Creating Product Descriptions

Using the Description Generator

1Visit description.blanxer.com
2Write down the description for individual product
3Click on Show HTML Value and copy that HTML
4Add this HTML value to the product_description field in CSV

Step 5: Creating Categories

Go to Categories and add required categories for your products.

Important: Remember the exact category names as they need to be added to the product_category field in your CSV file.

Step 6: Preparing the CSV File

Combining CSV Files

1Open both CSV files: upload sample and folder CSV
2Add file_name from folder CSV to product_name field
3Add file_url to image_1 field
4Fill up other fields: price, category, description, etc.

Handling Products with Variants

For products with multiple colors and sizes:

• Add separate rows for each variant/size combination
• Use the same group value for all rows of the same product
• Fill in variant (e.g., "Red", "Blue") and size (e.g., "S", "M", "L") accordingly

Example:

Premium Sofa with 2 colors × 2 sizes = 4 rows in CSV, all with same group value

Uploading Your CSV

1Save your prepared CSV file
2Go to Products → Add Product → Bulk Upload
3Drag and drop your CSV file to the bulk uploader
4Review the upload results

Handling Rejected Uploads

If any products fail to upload, the system will:

• Show how many products were added successfully vs rejected
• Generate a separate CSV with rejected products and rejection reasons
• Allow you to fix errors and re-upload the rejected file

Important Note

If your product needs custom fields like custom image or custom text, you need to manually add that property to the required products after bulk upload.

Ready to Upload Your Products?

Start selling faster with bulk product upload. Add hundreds of products in minutes instead of hours.

Bulk Product Upload: Add Hundreds of Products in One Shot