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: [file]7954[/file]
Screen of field settings during import, update the field quantity and price of the supplier: [file]7955[/file]
[file]7953[/file]
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:
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.
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.
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"
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"
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.
[quote]
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.
[/quote]
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.
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
Donate
You don't have enough funds in your account Top up