PS 8.0.5 multilingual import of products with multiple categories/subcategories from XLS

[ReyWebDev]

 

1. Import in the first language is fine. All products and categories are imported correctly.
2. Problem when importing a second language: I only import names and descriptions (category IDs are not included in the import). Translations are saved, but for some reason all products after that have only one category, all other categories disappear.

[AddWeb Solution]

Hi,

• Check that you've mapped the correct columns in your XLS file to the corresponding fields in Prestashop during the import process. Make sure that both the product names and descriptions in the second language are correctly mapped.
• If the category IDs are not included in the import, Prestashop might be defaulting to a single category. To avoid this issue, make sure that you also include the category mapping in your XLS file for the second language.
• Sometimes, the order in which you import data can affect the results. Try importing the categories and then the products for the second language separately to see if that resolves the issue.
• If possible, create a small test dataset with a few products and categories in both languages to see if you can reproduce the issue on a smaller scale.
• Consider using a CSV (Comma-Separated Values) file for the import instead of XLS. CSV files are often more straightforward for data imports and exports.

Take backup of your website and database before making significant changes like this to ensure you can recover your site in case anything goes wrong.

Thanks!

[ReyWebDev]

@AddWeb Solution thanks for your answer. My configuration:

First Import Options

• Language of the file: lang 1
• Use product reference as key: Yes
• Force all ID numbers: Yes

Data structure in the first import file

• ID;
• Reference#;
• Categories id1, id2, id3, id4;
• Name lang 1;
• Description lang 1;
• Price tax excluded;
• Tax rule ID;
• Quantity;
• Image URL;

The first import goes through, all the data is in place, the products are in their categories.

 

Second Import Options

• Language of the file: lang 2
• Use product reference as key: Yes
• Force all ID numbers: Yes

Data structure in the second import file

• ID;
• Reference#;
• Name lang 2;
• Description lang 2;

All data and translations is in place, but all products have only the id1 category. Categories id2, id3, id4 - disappear.

 

From your answer, I see that if category IDs are not included in the import, Prestashop uses one category by default. So now I understand my problem with the second import 🙂

 

 

 

 

3 hours ago, AddWeb Solution said:

Hi,

• Check that you've mapped the correct columns in your XLS file to the corresponding fields in Prestashop during the import process. Make sure that both the product names and descriptions in the second language are correctly mapped.
• If the category IDs are not included in the import, Prestashop might be defaulting to a single category. To avoid this issue, make sure that you also include the category mapping in your XLS file for the second language.
• Sometimes, the order in which you import data can affect the results. Try importing the categories and then the products for the second language separately to see if that resolves the issue.
• If possible, create a small test dataset with a few products and categories in both languages to see if you can reproduce the issue on a smaller scale.
• Consider using a CSV (Comma-Separated Values) file for the import instead of XLS. CSV files are often more straightforward for data imports and exports.

Take backup of your website and database before making significant changes like this to ensure you can recover your site in case anything goes wrong.

Thanks!