Skip to main content

How to import multiple products

Import multiple products at once into Magento using Elovate for quick catalog creation and bulk updates.

Updated over a month ago

Overview

With Elovate, you can import multiple products in one go, making it ideal for:

  • Initial catalog uploads.

  • Seasonal collection launches.

  • Regular supplier feed updates.


Step 1 – Prepare your file

Elovate supports CSV, Excel, and Google Sheets formats.
Your file should contain at least:

sku

name

price

description

qty

stock_status

PRODUCT-001

Product Name 1

19.95

Description here

100

1

PRODUCT-002

Product Name 2

29.95

Description here

50

1

Notes:

  • sku must be unique.

  • stock_status: 1 = in stock, 0 = out of stock.

  • You can add more Magento attributes as columns.


Step 2 – Create an import job

  1. Navigate to Apps → Import.

  2. Click Add Import Job.

  3. Upload your file or connect a Google Sheet/Feed URL.

  4. Select your Import Profile (default is Global).

  5. Map your file headers to Magento attributes.


Step 3 – Optional settings

Before running the import, you can:

  • Create New Products on Missing SKUs (choose Attribute Set, Status, Website).

  • Adjust Multi-select delimiter, Thousand separator, Decimal separator.

  • Prepend SKU to product names or other attributes if needed.


Step 4 – Validate and import

  1. Click Validate Import to check for formatting or data errors.

  2. Review the validation results.

  3. Click Import when ready.


Step 5 – Verify in Magento

After completion:

  • New products appear in Magento.

  • Updated products reflect the latest changes.

  • Check the Logs in Elovate for job details and any warnings.


Example use case – seasonal product launch

A fashion store launches its Spring Collection with 250 new items.

  • Supplier provides a CSV with SKU, name, price, description, size, and color.

  • Store uploads the file to Elovate, maps the headers, enables Create New Products on Missing SKUs, and assigns them to the "Spring 2025" website.

  • After validation, the products are imported in minutes and appear in Magento, ready for sale.

Did this answer your question?