Top Menu

Excel Like Product Manager Importing partially

15 Apr 2020 22:56 #5919 by Newemage
My client is having some problems with their import, just updated to recent version  but when submitting a 4,000  product CSV (with variations) it says it has processed 1999 items and redirects to the product list.

Is there any configuration or constant flag we are missing?

Please Log in or Create an account to join the conversation.

16 Apr 2020 09:04 #5920 by Super User
Replied by Super User on topic Excel Like Product Manager Importing partially
It may be that other records in file have id defined and that that id does not exists in system. If record is to be added as new product id should be empty.
If id exists update will be done, but if id does not exist that record will be omitted..

Please Log in or Create an account to join the conversation.

16 Apr 2020 15:48 #5921 by Newemage
Replied by Newemage on topic Excel Like Product Manager Importing partially
As attached you may see the IDs in the CSV do exist and are not being updated (in this case im trying to update the SKUs)


We need to manually slice the CSV in files with less than 1900 items so they import correctly

And it used to work fine

No timeouts or error,  we have tried to update 70 items per loop but still just updates up to 1900 items

Please Log in or Create an account to join the conversation.

16 Apr 2020 15:52 #5922 by Super User
Replied by Super User on topic Excel Like Product Manager Importing partially
Hi,

does is stops on certain record in sequence or there is no rule which is accepted and which not ?

Please Log in or Create an account to join the conversation.

16 Apr 2020 18:11 - 17 Apr 2020 14:10 #5923 by Newemage
Replied by Newemage on topic Excel Like Product Manager Importing partially
Yeah just stops after 1900 on different files nothing weird in the files.

Here is a validation result
csvlint.io/validation/5e989f38a1df500004000023
says  encoding ASCII-8BIT, but final one is uploaded in UTF8

Version 2.0.62 worked perfectly, should we rollback?

Please Log in or Create an account to join the conversation.

18 Apr 2020 15:19 #5924 by Super User
Replied by Super User on topic Excel Like Product Manager Importing partially
Hi,

there is no difference in reading CSV file from 2.1.62 and current version.

Can you try to remove row at line 1901 (first one that is not imported) and try.

Thanks

Please Log in or Create an account to join the conversation.

20 Apr 2020 14:35 #5925 by Newemage
Replied by Newemage on topic Excel Like Product Manager Importing partially
I rolled back to Version 2.0.62 (like 3 years old code, not 2.1.62)

The contents of the line 1901 are not the issue, I have to break large files in files below 1900 lines then it imports fine, but of course it's not convenient for the client so rolling back the version was the best option

Please Log in or Create an account to join the conversation.

Time to create page: 0.081 seconds