Import product data into magentogo online store
I tried to import product data into my online store. I got the following errors.
Category does not exist on lines: 3, 4, 6, 9, 10, 12, 14, 15, 17, 18, 19, 21, 23, 24, 27, 28, 31, 35, 36, 39, 43, 51, 52, 59, 60, 63, 64, 66, 71, 72
Invalid value for column Set Attribute Set (does the set exist?) On lines: 3, 9, 14, 18, 23, 27, 31, 35, 39, 43, 47, 48, 49, 50, 51, 55, 56, 57, 58, 59, 63, 67, 68, 69, 70, 71
Orphan lines to be skipped due to default line errors on lines: 4, 5, 6, 7, 8, 10, 11, 12, 13, 15, 16, 17, 19, 20, 21, 22, 24, 25, 26, 28, 29, 30, 32, 33, 34, 36, 37, 38, 40, 41, 42, 44, 45, 46, 52, 53, 54, 60, 61, 62, 66, 72
Error limit reached (100). Correct errors and re-upload the file
Lines checked: 72, objects checked: 27, invalid lines: 70, total errors: 100
Could you tell me what is causing this?
source to share
I faced the same problems, but I fixed them with the following steps.
Error-1 . Category does not exist on lines: 3, 4, 6, 9, 10, 12, 14, 15, 17, 18, 19, 21, 23, 24, 27, 28, 31, 35, 36, 39, 43, 51, 52, 59, 60, 63, 64, 66, 71, 72
Solution . The problem is the categories the affiliate products are not present in the backend, so create those categories. After that, the error will disappear
Error-2 . Invalid value for column Set Attribute Set (set doesn't exist?) On lines: 3, 9, 14, 18, 23, 27, 31, 35, 39, 43, 47, 48, 49, 50, 51, 55, 56, 57, 58, 59, 63, 67, 68, 69, 70, 71
Solution : _attribute_set
column is a required field, it must be there with a value when loading products.
Error-3 Orphan lines that will be skipped due to line errors by default on lines: 4, 5, 6, 7, 8, 10, 11, 12, 13, 15, 16, 17, 19, 20, 21, 22 , 24, 25, 26, 28, 29, 30, 32, 33, 34, 36, 37, 38, 40, 41, 42, 44, 45, 46, 52, 53, 54, 60, 61, 62, 64 , 65, 66, 72 Error limit (100) reached. Errors fixed and file reloading Checked lines: 72, checked objects: 27, invalid lines: 70, total errors: 100
Solution . This error disappears as soon as the two above are fixed.
Thank.
Happy coding.
source to share