magento2: Exporting and reimporting products out of the box creates massive CSV bugs
Hi there,
we tried to export products from one store to another. This caused errors on ALL rows in the respective CSV.
We are using Magento 2.0.2
Validation Results
Data validation is failed. Please fix errors and re-upload the file..
Following Error(s) has been occurred during importing process:
Only first 100 errors are displayed here. Download full report
1. Value for 'visibility' attribute contains incorrect value, see acceptable values on settings specified for Admin in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49
2. Value for 'msrp_display_actual_price_type' attribute contains incorrect value, see acceptable values on settings specified for Admin in rows: 1, 2, 3, 4, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49
3. Value for 'country_of_manufacture' attribute contains incorrect value, see acceptable values on settings specified for Admin in rows: 1
4. Value for '%s' attribute contains incorrect value in rows: 1
Checked rows: 49, checked entities: 49, invalid rows: 49, total errors: 97
We did not modify the file nor did we have opened it. This problem should be reproduceable by exporting products without any further configuration and reimporting the very same file into another different Magento2 store.
Only thing is that there are custom fields, which are exported, too.
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Reactions: 1
- Comments: 30 (7 by maintainers)
How many years and this is still an issue? Really? Yes I can confirm this is still an issues with 2.2.5
Still an issue in 2.4.3. Please fix this.
Still an issue in 2.4.1. Please fix this.
OK, so I just figured out you need to translate the labels in your import file.
I’m using spanish, so with ‘No es visible individualmente’ instead of ‘Not Visible Individually’, the validation works fine.