Skip to main content

How to import products in Magento

J
Written by Juul v Kessel
Updated this week

Export your optimized content to Magento 2 using the built-in CSV import feature.

Exporting from Valuna

  • Go to Products

  • Select the products to export

  • Click "Export"

  • Choose "CSV Standard"

  • Download the file

CSV File Requirements

  • UTF-8 encoding required

  • Comma as field separator

  • SKU field is required for matching products

  • Column headers must match Magento attribute codes

Importing to Magento 2

  • In Magento Admin, go to System > Data Transfer > Import

  • Select "Products" as the Entity Type

  • Set Import Behavior to "Add/Update"

  • Upload your CSV file

  • Click "Check Data" to validate

  • If validation passes, click "Import"

Required Field Mapping

Valuna Field

Magento Field

name

name

sku

sku

description

description

price

price

Import Behavior Options

  • Add/Update: Creates new products or updates existing ones by SKU

  • Replace: Completely replaces existing product data

  • Delete: Removes products matching the SKUs in your file

Validation Errors

If validation fails, Magento shows specific error messages. Common issues:

  • Invalid SKU format

  • Missing required attributes

  • Invalid attribute values (check dropdown options)

  • Category paths not found

Multi-Store Updates

To update store-specific content, include the store_view_code column in your CSV. Leave it empty for default store view or specify the store view code for targeted updates.

Tip: Always use "Check Data" before importing to catch errors. Download a sample export from Magento first to see the exact format expected for your store's attributes.

Did this answer your question?