Bulk Import Products

Bulk import lets you create or update many products from a CSV file. Use a ZIP file when product images are stored locally and should be uploaded with the import.

CSV Only

1. Open Catalog → Products → Import.
2. Download the CSV template.
3. Fill required columns: name and price.
4. Use full URLs in image_url and additional_images if images are already hosted.
5. Select catalogs in Assign to catalogs if all imported products should be assigned to them.
6. Keep Update existing products if SKU matches enabled to update products with matching SKU or retailer ID.

ZIP with Images

1. Create a CSV named products.csv. If the ZIP has another CSV name, Socialone uses the first CSV it finds.
2. Place image files anywhere in the ZIP. Matching is by filename, not folder path.
3. Set image_url to the primary image filename, such as shirt-blue.jpg.
4. Set additional_images to comma-separated filenames, such as shirt-detail-1.jpg,shirt-detail-2.jpg.
5. Upload the ZIP. Socialone validates image type and size, uploads valid images, and replaces filenames with hosted URLs.
6. If an image is missing, too large, or invalid, the product can still import but that image is skipped.

Image Rules

• Supported formats: JPG, JPEG, PNG, GIF, WebP, and AVIF.
• Maximum size: 8 MB per image.
• Primary image: use image_url.
• Additional images: use additional_images, comma-separated, up to 20 images.

CSV Columns

• Required: name, price.
• Identity: sku, description, brand, gtin, mpn.
• Pricing: currency, compare_at_price, sale_price.
• Inventory: availability, stock_quantity, product_type, condition, requires_shipping.
• Images: image_url, additional_images.
• Variants: item_group_id, color, size, material, pattern, gender, age_group.
• Targeting: custom_label_0 through custom_label_4, tags.

Accepted Values and Defaults

• availability: in_stock, out_of_stock, preorder, discontinued. Invalid values default to in_stock.
• product_type: physical, digital, service, subscription. Invalid values default to physical.
• condition: new, refurbished, used. Invalid values default to new.
• currency: defaults to INR.
• requires_shipping: defaults to true unless value is false, 0, or no.

Import Results

• Created: rows that created new products.
• Updated: rows that updated existing products through SKU or retailer ID matching.
• Failed: rows that could not import. The error viewer shows row number, SKU when present, and the error.
• Background processing: the import continues if you close the modal.

Related Docs

• Create & Edit Products
• Product Variants
• Meta Sync