Search code examples
magentoakeneopim

Akeneo - Import Product CSV - Import error - Field "sku" is expected, provided fields are


I'm trying to create a csv product import example for Akeneo project.

I have created some products, with some data and exported them as a .csv file. Export is done correctly. I did some changes on product values(from downloaded .csv) like change of sku, product name and now i want to import them.

When i run the import of product there is displayed the following error:

FIELD "SKU" IS EXPECTED, PROVIDED FIELDS ARE "SKU   CATEGORIES  ENABLED FAMILY  GROUPS  DESCRIPTION NAME    PACK-GROUPS PACK-PRODUCTS   PACK-PRODUCT_MODELS PRICE-EUR   PRICE-USD   SUBSTITUTION-GROUPS SUBSTITUTION-PRODUCTS   SUBSTITUTION-PRODUCT_MODELS UPSELL-GROUPS   UPSELL-PRODUCTS UPSELL-PRODUCT_MODELS   X_SELL-GROUPS   X_SELL-PRODUCTS X_SELL-PRODUCT_MODELS"

Why it shows that error when in fact i am importing the csv format dhe was exported before?


[Edit]

The problem was that .csv generated was not saved on the right format(using ';' between fields). After fixed it, import is still not working because of the following error: image of error

Thanks in advance


Solution

  • It seems that your import file has no separator ";" between each field like that: sku categories enabled family groups[...]

    When you save you csv file, take attention to select the separator ";" between data.

    The first line of your import will look like :

    sku;categories;enabled;family;groups[...]