How to fix an error when importing products from Excel?

Technical Q&A
1

Hi support team!

I am trying to import products from Excel and this error occurs:

There was an error importing your CSV file. After you fix the error, try importing the CSV file again.

  • Invalid CSV Header: Missing headers: Title.

I am attaching the import file.

Can you please help me solve this issue, just couldn’t figure this out on my own…

2

@spodnje-perilo

CSV files can be sensitive in that, if there is more than one issue with the CSV, then the error presented may not provide the full situation.

In your case, you do have the Title column, but the CSV is missing values in required columns that will result in the CSV failing to import. You need data in

  • Option 1/2 Value & Name - You’re missing values in each parent row for each product. You need to include a value and name for each variant (ie. Type and Size).
  • Published - This needs to be filled in for every row.
  • Variant Inventory Tracker - This needs to be filled in for every row.
  • Variant Inventory Policy - This needs to be filled in for every row.
  • Variant Price - Needs to be filled in if applicable
  • Variant Requires Shipping - This needs to be filled in for every row.
  • Variant Taxable - This needs to be filled in for every row.
  • Image Position - Only fill this in if you fill in all other rows in sequence (ie 1, 2, 3) otherwise leave blank
  • Status - This needs to be filled in for every row.

In addition to missing values, the image URL’s you included go to a 404 error page, so the system is unable to download the images. More information on what fields are required and the values that go into these columns can be found here.

Once you’ve filled in all the required columns/rows and updated your image URL’s then you should be able to import successfully.