Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Quick start: your first import
Getting started

Quick start: your first import

Run a real import end to end in about five minutes, using a ten-row test file so nothing can go wrong.
  • The fastest way to understand Migrato is to import a small product file and look at the result in your admin. This page walks through exactly that. Use the Free plan - twenty-five items is more than enough.

★
Always start with ten rows

This is not just for your first job. Every experienced Migrato user tests a ten-row slice before running a full file. It costs two minutes and catches nearly every mistake worth catching.

1. Get a template

In Migrato, go to Import → Templates and download the Products template. It is an .xlsx file containing every supported column with two example rows filled in.

Open the file, delete the example rows, and paste your own data underneath the header row. Delete any columns you do not need – Migrato only touches the columns you include.

  • Keep the header row exactly as it is
  • Only Handle and Title are required to create a product
  • Variant Price is required when creating, optional when updating

You do not have to use the template at all. Upload a file with your own column names and map them in step three. This is usually faster if you already export from another system.

i

Mapping is saved

Once you map your own columns, save the mapping. Next month’s file with the same headers maps itself.

The neatest option for updates: export the products you want to change, edit the values in Excel, and import the same file back. The columns are already correct, and the handles already match, so nothing can duplicate.

  • 2. Prepare a ten-row file

    Take your real file and keep the header row plus ten data rows. Save it as test_import.xlsx. A minimal valid product file looks like this:

Handle Title Variant SKU Variant Price Variant Inventory Qty
blue-cotton-tshirt Blue Cotton T-Shirt TS-BLU-M 24.00 30
blue-cotton-tshirt TS-BLU-L 24.00 18
oak-side-table Oak Side Table FUR-OAK-01 149.00 6
i
Two rows, one product

The first two rows share a handle, so they become one product with two variants. Only the first row of a product needs Title - the rest carry variant columns only.

  • 3. Upload and choose the operation

    1. Go to Import → New import and drop your file in.
    2. Choose Products as the data type. Migrato usually detects this correctly from your columns.
    3. Choose the operation for this job: add new records, update existing ones, do both, or delete the records listed in the sheet.
    4. Press Start import.

4. Read the preview carefully

This is the screen that matters. Migrato has applied your sheet and is telling you exactly what happened, row by row.

!
Check the created versus updated split

A preview that says 0 created, 10 updated is an update. One that says 10 created when you expected an update means your match key is wrong - usually a SKU or handle that does not exist in the store. Stop and fix the file rather than running it.

5. Run it and check the result

Press Run import. For ten rows the job finishes in a few seconds. Then do the part most people skip:

  1. Open one of the imported products in your Shopify admin and look at it with your own eyes
  2. Confirm the price, the variant count and the inventory quantity are what you expected
  3. Download the result file from the Jobs page and check the status column
  4. Only then run the full file
Importing dataMatching rules, validation levels, images and partial updates in depth.
Exporting dataFilters, column presets and the export-edit-import loop.
Scheduled jobsAutomate the job you just ran so it happens without you.
TroubleshootingWhat each error message means and how to clear it.

Ready to run this on your own store?

Migrato's free plan handles 25 items per job - enough to follow any page in these docs end to end before you pay anything.

Free plan forever No credit card 2-minute setup Uninstall anytime