Importing Data

Importing Products

Getting an import template

Using the Admin UI

  1. Log in to the Admin
  2. Navigate to Products > Products
  3. Click Import Products
  4. Click Export Template

Importing product data

Using the Admin UI:

  1. Log in to the Admin
  2. Navigate to Products > Products
  3. Click Import Products
  4. Select your CSV file
  5. Choose either Validate or Import File
  6. Check progress at System > Jobs.
    • You'll see the new Job, but it'll be "New" at 0% until all the chunks are created
    • Click the job to see the list of chunks. Once the list stops growing, processing should commence
    • Products will appear in Products > Products as the import progresses.

Using the command line:

1
2
3
4
5
6
7
php bin/console oro:import:file
    --jobName entity_import_from_csv
    --processor oro_product_product.add_or_replace
    --email info@domain.com
    [--validate]
    "/path/to/file.csv"
    [--env prod|dev]

Then check progress at System > Jobs

Importing Customers

The customer import CSV is pretty sparse, holding only the following data fields:

  • Name
  • Parent Id
  • Group Name
  • Owner Id
  • Tax code
  • Account Id
  • Internal rating Id
  • Payment term Label