Wednesday, March 14, 2012

Magento import - misleading error - sku not defined

I got this error while doing an import into Magento:
Skipping import row, required field "sku" is not defined.

When I checked, all the rows did have a valid value for the SKU.

But, I had a few column names which contained special characters like this - text_with_specialÂcharacter.

When I changed the column names to something like text_with_special_character, and removed the special characters, the error went away and the import was successful.

Tuesday, March 13, 2012

Magento Import successful, but no imported products seen

I successfully ran an import of a CSV file into Magento, and it said
  • Processed 100% 2/2 records
  • Imported 2 records
But when I logged into the magento admin panel, I could not see the two new records.

To fix this, I had to change the value of the status column to 'Disabled' or 'Enabled' for all records in the CSV file.