Hi,

I have a problem when trying to import products from .csv

I have a column named Category where I store the category ID. When I am trying to import the products, an error is displayed for each product and the products are not imported.

System error. Invalid value CategoryCode ('119')

Is there something wrong I am doing? Is this a bug?

 

Many thanks

Hi,
it seems that you try to attach product to category using CategoryId (int). You should use CategoryCode (nvarchar(50)) instead.

Hope this helps.

I have tried using the name of the category (Beletristica in my case), the generated name (CAT70652209). Still no luck.
Any ideea?

Send us please on support@mediachase.com yours map-file which should be on the following way:
C:\WINDOWS\Temp\eCFImport\Data\{StoreUID}\{mapping_name}.xml
or
C:\Documents and Settings \{COMPNAME}\ASPNET\Local
Settings\Temp\eCFImport\Rule\{StoreUID}\{mapping_name}.xml

Alexey,
Mediachase

No matter what i put for Category Code, it displays: "System error. Invalid value CategoryCode"

Such error occurs when the category is not found by code. Check up existence of the category with such code more carefully.

The code I gave as example (CAT70652209) was taken from "Edit Category" section. Therefore the code exists.

What version of ECF do you have?

Mediachase eCommerce Framework 4.1 (4.1.2.16751)

Hi,
we have successfully tested import in version 4.1.2.16751. Connecting product and category is working fine. New and already existing products are connected to selected custom category successfully. If we try to connect product to category which does not exist the following error occurs: System error. Invalid value CategoryCode ('CAT39230278~')". Everything is OK.
What was the first ECF release you used? Did you change/update your database?

I have checked directly the database now. The problem is that some of my categories (although they exist in the database) do not have a value for the field "Code". Probably they were imported and the system does not generate a default value for them. I have added a value to "Code" field and the import was successfull. Maybe you should think of a way to avoid insertion of categories without having a value for "Code".
For now i will check before importing, but there might be other users facing this problem in the future.

Many thanks for your support. I'll let you know if there are any other issues.