Problem with Uploading XLS to the price platform
could see the unloading of XLS on the price platform. I have them formed on 3 sites, and there is some problem with this upload
https://vmk.crm-onebox.com/admin/shop/priceplaces/?id=2
on the site Prom beats an error on it and does not load. and when download and open it says that the file has an error
https://prnt.sc/105007a
I tried to restart it but no result. Now I have to open the file confirming the error, then save it and upload it to Prom manually
Original question is available on version: ru
https://vmk.crm-onebox.com/admin/shop/priceplaces/?id=2
on the site Prom beats an error on it and does not load. and when download and open it says that the file has an error
https://prnt.sc/105007a
I tried to restart it but no result. Now I have to open the file confirming the error, then save it and upload it to Prom manually
Answers:
Most likely in the contents of the file in some cells there are special characters that both prom and excel swear at
you can't catch it automatically
only by removing some columns it will be possible to understand where and what
you can't catch it automatically
only by removing some columns it will be possible to understand where and what
24.02.2021, 15:04
Original comment available on version: ru
in the unload file, only the most necessary columns, no extra is unloaded there
24.02.2021, 17:05
Original comment available on version: ru
and for example today unloaded 1 time. https://prnt.sc/105qoyw and earlier https://prnt.sc/105qpm5
I thought that maybe an error crept in and renamed the upload file, as if recreating it, but it didn’t help, and then one upload went through
I thought that maybe an error crept in and renamed the upload file, as if recreating it, but it didn’t help, and then one upload went through
24.02.2021, 17:09
Original comment available on version: ru
Tarovik Dmitry Nikolaevich
Client wrote:
and for example today unloaded 1 time. https://prnt.sc/105qoyw and earlier https://prnt.sc/105qpm5
I thought that maybe an error crept in and renamed the upload file, as if recreating it, but it didn’t help, and then one upload went through
most likely there is a product with special symbols
you can find it like this:
1. Remove the column by the 1st and check the opening in excel - if there is no error, then the matter is in this column and dem to step 2
2. In step 2, we try to remove products (reduce categories and nonsense for unloading) and thereby find a list of products with a problem
25.02.2021, 14:25
Original comment available on version: ru
it was some kind of general file creation bug, since it disappeared. and he previously appeared in another Unloading and disappeared, only he quickly disappeared there, but here it was for a couple of days. Perhaps forced file generation helped, but I have encountered the problem several times already.
on Price sites it is advised to switch to XLSX uploads, they already write less of this kind of problems with them
on Price sites it is advised to switch to XLSX uploads, they already write less of this kind of problems with them
25.02.2021, 15:29
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
