Import Products

Import Products — Bulk import via CSV / Excel

Simple, non-technical guide for claimed shop owners and managers.

Use this tool to add many products at once instead of creating them one-by-one. You upload a properly formatted CSV file and the system creates the products in your shop.

Quick summary

  • Upload a CSV file (the import form accepts .csv files).

  • Use the Download Sample CSV link to get the exact template.

  • Required fields: name, sku, category, unit_price, unit_of_measurement, currency (see details below).

  • For Excel users: edit in Excel/Google Sheets and export as CSV (UTF-8) before uploading.

  • Max file size: 10 MB. Recommended: test with a small batch first.

Where to find it

Dashboard → Operations → Products → Import Products

(There’s a “Download Sample CSV” button and a help section on the import page.)

Step-by-step — import workflow

  1. Download the sample CSV from the import page.

  2. Open it in Excel or Google Sheets.

  3. Fill the rows — one product per row. Keep the column names intact.

  4. Save / export as CSV (Comma-separated) with UTF-8 encoding.

    • Google Sheets: File → Download → Comma-separated values (.csv).

    • Excel: File → Save As → CSV UTF-8 (Comma delimited) (.csv).

  5. Upload the CSV on the Import Products page and click Import Products.

  6. Review the product list after import to confirm everything looks right.

CSV column reference (what each column means)

Column
Required
What to put
Example

name

Yes*

Product or service name (max 255 chars)

Cotton T-Shirt

sku

Yes*

Unique SKU — must be unique across your shop

TSHIRT-001

stock_quantity

No

Integer stock count (0 for services)

50

category

Yes*

product or services

product

country_of_origin

No

Country name

India

description

No

Short description (up to a few thousand chars)

100% cotton, unisex

unit_price

Yes*

Price per unit (numeric, min 0.01)

9.99

unit_of_measurement

Yes*

How the item is sold (e.g., piece, kg, hour)

piece

moq

No

Minimum order quantity (integer)

1

specifications

No

Name:Value pairs separated by semicolons — e.g. Color:Red;Size:M

Color:Red;Size:M

tax_rate

No

Numeric percent 0–100

18

tax_type

No

gst, vat, sales_tax, or none

gst

tax_inclusive

No

true or false

true

hsn_sac_code

No

HSN / SAC code

123456

weight

No

Numeric (kg) — leave blank for services

0.5

dimensions

No

LxWxH — leave blank for services

20x10x3

currency

Yes*

Currency code — e.g. USD, INR

USD

* Required fields must be filled or the row will produce an import error.

Formatting rules & tips

  • Use the sample CSV as your template — column order and names must match.

  • sku must be unique. Duplicate SKUs will cause that row to fail.

  • specifications format: Name:Value;Name2:Value2 (no extra commas). System reads these and stores them as key/value specs.

  • For services: leave stock_quantity, weight, and dimensions blank or set them to 0.

  • Numeric fields (price, tax, weight) should not contain currency symbols or commas. Use 99.99, not $99.99 or 9,999.00.

  • Dates/encoding: Save CSV as UTF-8 to avoid broken characters.

  • Maximum file size: 10 MB. If you have more products, split into multiple files.

  • No images in CSV: Product images cannot be uploaded via CSV. Add images later from the product edit page.

  • Allowed values: Use values the system expects (e.g., product or services, valid currency codes). If you use unsupported values the import will either set defaults or throw validation errors.

Recommended workflow for first time

  1. Prepare 5–10 sample rows and import.

  2. Verify the products appear correctly (names, SKU, price, category, specs).

  3. Fix any issues in your master spreadsheet.

  4. Import the full file in batches (e.g., 250 rows at a time) to make troubleshooting easier.

Common errors & fixes

  • “SKU already exists” — Remove or fix duplicate SKUs in your CSV. If you want to update existing product, use the product edit UI (import only creates new products).

  • “Missing required field” — Check required columns (name, sku, category, unit_price, unit_of_measurement, currency) are present and not empty.

  • “Invalid numeric value” — Remove currency symbols and commas; use dot . for decimals.

  • “File too large” — Split CSV into smaller files (<10 MB).

  • Broken characters — Re-save as CSV UTF-8 encoding.

  • No images after import — Images must be uploaded later manually.

If an import fails, check the error message shown on the import page — it usually points to the problematic row and problem type.

Troubleshooting checklist

  • Did you use the sample CSV and keep column names unchanged?

  • Are required fields filled for every row?

  • Are all SKUs unique?

  • Did you export/save the file as CSV UTF-8?

  • Is the file under 10MB?

  • For numeric fields: no dollar signs or commas.

  • If errors persist, import a tiny file (1–3 rows) to isolate problem rows.

Safety & backup advice

  • Backup: Download or keep a copy of your CSV before importing.

  • Small batches reduce risk — it’s faster to fix 20 rows than 2000.

  • If the import touches many products, consider exporting your current product list first (if you have that option) so you can restore or compare.

Short UI tips you can show staff

  • “Use the sample CSV — don’t rename columns.”

  • “Save Excel as CSV UTF-8 before uploading.”

  • “SKUs must be unique — import will fail for duplicate SKUs.”

  • “Images are not imported — upload them later on the product page.”

PreviousRFQ ManagementNextInventory

Last updated