importing products

Hi
I want to import products in 4.3   emporium.   But import fails because he gives a error by not seeing the categorie
Database doesn't contain the ARCHERY>>Recurve>>Risers Recurve>>Hoyt Archery'category
    

although the category exist  

what can i do

regards jac


https://archery.dasroggel.com/Admin/Category/List

Do you have any special characters (e.g. diacritics) in your category names?

Hi

No I Have none in my categories

regards
jac

Sorry

because i have 4 languages  i check them  and yest  indeed  in the german and france language there were some,
I am going to check them all and see if i find more.
Than i will try again  en let you know

Thanks

Hello

I have tried it again  but i am getting an other error
×Categories with the following names and/or IDs don't exist: Categories

so he can not find the categories   ID is not on  because there are new ones

i work with the import or export on product in nopcommerce

please  whatt to do

regards
jac

Hi,
it's a shame that the documentation doesn't write in a simple way that if you want to do a bulk import from excel:
- load the CATEGORY table from the database
- or download excel with all the categories
- link each category to each product
- put only the category Id in the column and separate them with semicolon (;)

This method was in old versions. I have been using it this way since NOP 2.30.
With the advent of version 3.90, it changed from "Category ID" to "Category Name".
I typed out the import, and in that time I've imported about 10,000 items over time.

It's my fault that I switched to the new version (4.40.3) only now and didn't follow the development and changes.
This has caused me to tear my hair out for the last 7 days now that the previous setting (from version 3.90) didn't work.

Only the last attempt worked. :-)
I tried what was great years ago - format 1;2;3;4;

And it works. :-)

Translated with www.DeepL.com/Translator (free version)