1b.app
Link copied -

Updating product fields in the table when importing through the process products loading block

Good afternoon, you need to add a checkmark in the "Process Products Loading Block" settings "If the product is already in the process, then update its fields in the product table.
Description of the problem: We send an order invoice to the supplier, the supplier processes and returns his invoice, which usually has changes in price or quantity.
Purpose: to update the fields of goods that are already in the table through the process products import block, if the products are not in the table, then add them in a new line (this is now working out).
Test Process: https://owwa.crm-onebox.com/admin/customorder/order/43026/edit/
The file for the import test is in the attachment (the file contains a different quantity of goods, price and 1 more product)
Block settings screen:
Screen of field settings during import, update the field quantity and price of the supplier:
Original question is available on version: ru

Answers:

This feature needs to be improved.
I can offer a setting in the form of a checkmark in the settings of the interface block, when enabled and the goods are loaded - if there is a match by product.id in the process products - the data of the process product will be updated. This revision will take approximately 2 hours.
09.07.2021, 17:20
Original comment available on version: ru

Андрій
CEO, owwa.com.ua
Maxim, the option with product.id is not suitable, because the supplier does not have our id - they have their own "supplier code". When uploading a file, you can choose which field to search for a product match, whether you can bind to this choice and what is selected and make a match. And in the block settings, add a checkbox "If the product is already in the process, then update its fields in the product table"
12.07.2021, 14:49
Original comment available on version: ru


Andrey wrote:
When uploading a file, you can choose which field to search for a product match, whether you can bind to this choice and what is selected and make a match.

This match is for searching the product in the system. But the found product, which is added as an item to the order, will already be added or updated.
12.07.2021, 15:40
Original comment available on version: ru

Андрій
CEO, owwa.com.ua
Maxim, please issue an invoice, we agree to revision.
18.07.2021, 21:01
Original comment available on version: ru

improved setting "Update found process products"
20.07.2021, 14:58
Original comment available on version: ru

Андрій
CEO, owwa.com.ua
Thanks, it works!
27.07.2021, 11:51
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