Import products from a CSV file
Prepare a CSV, review the import, and check products and images before retrying.
Reviewed by Closku documentation team ·
Before you start
You need:
- Product-management access
- A CSV export or prepared file
- Enough remaining product capacity
Start with a small sample. One request accepts at most 500 parsed products, which is not necessarily 500 CSV rows.
Prepare a generic CSV
Use a name for each product.
The generic importer recognizes:
name,title,product_name, orproductskuorvariant_skucolororcoloursizeimage_src,images,image_url, orimage
SKU, color, size, image, and status columns are optional for parsing, but check the resulting variants and image before use.
name,sku,color,size,image_url,status
Cotton Tee,TEE-001,Blue,M,https://closku.com/images/demo/blue-tee-product-transparent.webp,active
Cotton Tee,TEE-001,Blue,L,https://closku.com/images/demo/blue-tee-product-transparent.webp,activeDownload the example CSV for a small test import.
Replace the example image URL with your publicly accessible HTTPS image when preparing your catalog.
- Rows with the same name and SKU are grouped, with distinct color and size pairs.
- Products default to draft unless a grouped row has status
active,publish, ortrue. - Separate multiple image URLs with commas or semicolons; quote a CSV field containing commas.
- At most four image URLs per product are retained.
- Remote images have a separate 15 MiB download limit.
Import and check products
- Open Products and select Import CSV.
- Choose your file and inspect the detected format and product preview.
- Start the import and review the reported product counts.
- Open the resulting products and check names, statuses, variants, and images before mapping them to your storefront.
The following formats are detected automatically:
- Shopify
- WooCommerce
- BigCommerce
- Generic
For Shopify, inspect every resulting variant combination: observed colors and sizes can be combined even when a particular combination was not present in the export.
Correct an import
Images can fail independently after a product record is created. The summary does not provide a complete image-by-image report, so inspect products even when the product count looks successful. Correct inaccessible or rejected HTTPS URLs and update affected records.
Import creates new records rather than updating existing ones. Repeating a file can create duplicates; check what already exists before retrying. Repair already-created records in Products. If some products were not created, prepare a new CSV containing only those missing products before retrying. Changes in your store are not synchronized automatically. For persistent problems, contact support without sending credentials.
Next steps
Review and correct the imported records.