CODEWITHSUNDEEP
magento
Christina Rule
Christina Rule

Reputation: 473

Issue with importing products in magento

I always have issues importing csv (products) into Magneto. No matter what I do I always get errors that don't make any sense and I can never import anything. I am on a mac and I've read that this can cause issues so I've been updating everything in google docs and then downloading it as a CSV. The current error I have is:

"Can not find required columns: sku"

Which is a column in my CSV file.

Upvotes: 0

Views: 1793

Answers (2)

pguardiario
pguardiario

Reputation: 54984

I resolved this same issue today by saving as UTF-8 without BOM. By default I believe Excel will save with a BOM. Magento should really be smart enough to recognize the BOM imho.

Upvotes: 0

magentoassistance
magentoassistance

Reputation: 121

If you're using a Mac, you need to ensure that you are saving your CSV:

  • In UTF-8 encoding
  • as CSV (Windows) file type

If you want to deal with it manually, what you'll need to do is find and replace the line breaks in the file. From the command line:

tr '\r' '\n' < file_excel_munged.csv >| fixed_file.csv

But just saving it was a Windows CSV/Excel file should do the trick.

Upvotes: 5

Related Questions