Crooked work "import products EXCEL"
Good afternoon, quite often we work with the export and import of goods through EXCEL.
Over the past couple of weeks, we have been seeing failures, previously partially, now the import reports have completely stopped coming - now there is no way to find out what was successfully updated and what was not.
Settings screenshots:
https://prnt.sc/wormbp
https://prnt.sc/worqh5
An example file to download is attached.
Original question is available on version: ru
Over the past couple of weeks, we have been seeing failures, previously partially, now the import reports have completely stopped coming - now there is no way to find out what was successfully updated and what was not.
Settings screenshots:
https://prnt.sc/wormbp
https://prnt.sc/worqh5
An example file to download is attached.
Answers:
Andrey wrote:
Over the past couple of weeks, we have been seeing failures, previously partially, now the import reports have completely stopped coming - now there is no way to find out what was successfully updated and what was not.
Checked in the system - crowns work out stably?
Is SMTP integration with the system mailbox configured correctly for sending?
15.01.2021, 18:30
Original comment available on version: ru
Everything is fine with SMTP, because all other notifications come, including the file with the export, which is attached to the subject of the ticket.
It’s hard to say from the crown, everything works out from the visible - can someone see if everything is in order with us? because import is very important to us.
https://owwa.crm-onebox.com/admin/shop/statistic/
It’s hard to say from the crown, everything works out from the visible - can someone see if everything is in order with us? because import is very important to us.
https://owwa.crm-onebox.com/admin/shop/statistic/
15.01.2021, 20:00
Original comment available on version: ru
Good evening.
The history of sent emails can be viewed here
https://owwa.crm-onebox.com/admin/report/massemailsend/
The history shows that there is no addressee in the "To" column, so no one received this letter.
In reports -> logging, in the sendmail-2021-01-15.log log, you can see that the to field is empty
[2021-01-15 13:08:26]
[0] => from: info@owwa.com.ua
[1] => to:
[2] => cc:
[3] => subject: Supplier import products.
...
)
The history of sent emails can be viewed here
https://owwa.crm-onebox.com/admin/report/massemailsend/
The history shows that there is no addressee in the "To" column, so no one received this letter.
In reports -> logging, in the sendmail-2021-01-15.log log, you can see that the to field is empty
[2021-01-15 13:08:26]
[0] => from: info@owwa.com.ua
[1] => to:
[2] => cc:
[3] => subject: Supplier import products.
...
)
15.01.2021, 23:53
Original comment available on version: ru
Sergey, we use import quite often, in this functionality there is no field indicating the recipient's email.
Please check why this field is empty - the email of the user who makes the import is not substituted.
Please check why this field is empty - the email of the user who makes the import is not substituted.
16.01.2021, 16:26
Original comment available on version: ru
Andrey wrote:
Please check why this field is empty - the email of the user who makes the import is not substituted.
Because the setting "Email for technical notifications" is not filled
18.01.2021, 14:50
Original comment available on version: ru
Unfortunately, this setting did not solve the problem, notifications after import do not come - but other technical notifications began to fall in the mail.
I ask you to help me deal with the import, because. we have work for more than a week, we are ready to pay for your allocated time, but the problem needs to be solved.
Here is a simple example, you can try to import it yourself, unloaded goods from the Pushers with filters category (file attached). Then I just want to import the same file without making any changes, but when importing, I check the box to remove filters and overwrite.
After loading, nothing happens, although a couple of weeks ago, information about the status of importing goods came to the mail.
Settings screen: https://prnt.sc/x6zu0t
In mail statuses there is a letter with an export, but no import: https://prnt.sc/x70f5b
I ask you to help me deal with the import, because. we have work for more than a week, we are ready to pay for your allocated time, but the problem needs to be solved.
Here is a simple example, you can try to import it yourself, unloaded goods from the Pushers with filters category (file attached). Then I just want to import the same file without making any changes, but when importing, I check the box to remove filters and overwrite.
After loading, nothing happens, although a couple of weeks ago, information about the status of importing goods came to the mail.
Settings screen: https://prnt.sc/x6zu0t
In mail statuses there is a letter with an export, but no import: https://prnt.sc/x70f5b
19.01.2021, 09:47
Original comment available on version: ru
You made this setting on 2021-01-18 18:18:31
https://i.imgur.com/dax29OC.png
And the last "Supplier import products." you had at 2021-01-18 15:13:16
https://i.imgur.com/n2AaGVh.png
https://i.imgur.com/dax29OC.png
And the last "Supplier import products." you had at 2021-01-18 15:13:16
https://i.imgur.com/n2AaGVh.png
19.01.2021, 11:15
Original comment available on version: ru
Sergey,
Supplier import products - supplier price list import.
In the topic, I indicated that we are talking about importing goods from EXCEL.
Such emails have a subject: Import№... done
https://prnt.sc/x7b12k
But you correctly indicated that I made the import today, but there is still no information about its status (I also did the import yesterday, but also to no avail).
I repeat, we use this tool often, according to the last letter it is clear that this is 223 import, therefore we assert that something has changed and now the import does not work correctly.
Please, import the attached file with the specified settings https://prnt.sc/x6zu0t - and look at the result.
Supplier import products - supplier price list import.
In the topic, I indicated that we are talking about importing goods from EXCEL.
Such emails have a subject: Import№... done
https://prnt.sc/x7b12k
But you correctly indicated that I made the import today, but there is still no information about its status (I also did the import yesterday, but also to no avail).
I repeat, we use this tool often, according to the last letter it is clear that this is 223 import, therefore we assert that something has changed and now the import does not work correctly.
Please, import the attached file with the specified settings https://prnt.sc/x6zu0t - and look at the result.
19.01.2021, 11:55
Original comment available on version: ru
We tested the import of values, downloaded this file
and there is data in the sending history
Right here
https://owwa.crm-onebox.com/admin/report/massemailsend/
and there is data in the sending history
Right here
https://owwa.crm-onebox.com/admin/report/massemailsend/
19.01.2021, 12:20
Original comment available on version: ru
Alexander, in your file there is only id and price. There were filters in my file, and it is more likely that the import bug is associated with them.
For example, if you remove the "Product Type" filter from the import, then the import will pass. And together with this field there will be no result.
Please download the entire file with my settings https://prnt.sc/x6zu0t
For example, if you remove the "Product Type" filter from the import, then the import will pass. And together with this field there will be no result.
Please download the entire file with my settings https://prnt.sc/x6zu0t
19.01.2021, 12:43
Original comment available on version: ru
Colleagues, please test the functionality, because. worth the work because of this situation. I repeat, we are ready to pay for the work - just test and solve this problem.
20.01.2021, 12:10
Original comment available on version: ru
Alexander, Sergey, Maxim, can you give feedback?
21.01.2021, 09:05
Original comment available on version: ru
Andrey wrote:
Alexander, Sergey, Maxim, can you give feedback?
Yes, I have had time to look at your appeal.
Specify - the file is relevant in the description or provide a more "fresh" one?
25.01.2021, 17:55
Original comment available on version: ru
Alexander, the problem was solved, but for this I had to unload all products with filters, remove the "Product type" filter, import products with the "remove filters" checkbox enabled, and then import from the uploaded file. At the same time, a new filter "Product type" was created, and at the moment the system works correctly for importing products with this field.
25.01.2021, 18:00
Original comment available on version: ru
At the moment, the problem has been solved, we exported all products with filters, then removed all filters from the products and separately the "Product Type" filter itself, then imported products with filters. Thus, a new filter "Product Type" was created and now the import works correctly. That is, there was a problem with this field.
26.01.2021, 10:17
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
