1b.app
Link copied -

Same article and description. Improvement "Search for a process product by article and brand at the same time"

Test order: https://psauto.crm-onebox.com/admin/customorder/order/31562/edit/.
We came across cases when a product has the same article and description (example https://prnt.sc/xuzwio) started testing, realized that we couldn’t do without help, we couldn’t set it up on our own so that Box would accept all positions from the site, regardless on which fields are identical.
Previously, we had a revision: Import orders from our site psauto.com.ua. Automation is set up: https://prnt.sc/xv0ab4, in which there is an item "Search for process products simultaneously by article and name". You need to make a similar item for selection, which will search for process products simultaneously by Article and Brand.
How many hours will it take?
And additionally a question regarding the logic of work in general in the system with such a case. In some BPs, there is a need to find products that have already been previously downloaded. For example, there is an arrival of goods at the warehouse, a
Original question is available on version: ru

Answers:

Hello, the prom in the order import method does not return the Product Brand. Here are the fields that the prom returns:
"products": [
{
"id": 0
"external_id": "string",
"image": "string",
quantity: 0
"price": "string",
"url": "string",
"name": "string",
"total_price": "string",
"measure_unit": "string",
"sku": "string"
}
],
2.

Krylov Gleb
Client wrote:
For example, there is an arrival of goods at the warehouse, and Box starts looking for an already created card, but it looks for either the Article field or the Name field. Posting Example https://prnt.sc/xv14yh . Is it possible to set up a similar operation "Search for a product simultaneously by Article and Brand" for all PSUs within the system?

When you make an entry, you are given one field to search for products. I don’t quite understand how you are going to search for values by article + brand by filling in one field?
01.02.2021, 14:30
Original comment available on version: ru

Thanks for the answer!

Bodyako Dmitry
dev wrote:
Hello, the prom in the order import method does not return the Product Brand. Here are the fields that the prom returns:
"products": [
{
"id": 0
"external_id": "string",
"image": "string",
quantity: 0
"price": "string",
"url": "string",
"name": "string",
"total_price": "string",
"measure_unit": "string",
"sku": "string"
}
],

This is not about the Prom.ua site, but about our main site psauto.com.ua, Automation: "Import orders from psauto.com.ua", it was a revision https://prnt.sc/y0311b

When you make an entry, you are given one field to search for products. I don’t quite understand how you are going to search for values by article + brand by filling in one field?

The question is precisely this, is it possible to add another additional field for searching products in the Posting section, so that the system would look for a match in two fields at the same time?
In our field, the uniqueness of the product is characterized by the Brand-Article link, this approach is used by original catalogs, non-original by the TecDoc type, all suppliers, so we are looking for an option in which we can set up a mapping of these fields inside OneBox to search for matches, using an example of how it works with the setting "Search for process products simultaneously by article and name".
Thanks for the help!
02.02.2021, 09:56
Original comment available on version: ru

1. Judging by the docks, your site conveys the product brand https://prnt.sc/y07ul7 , i.e. you can do a search by a bunch of brand + article. It will take 1 hour to finish
2. In theory, you will be able to search by brand and article without modification https://prnt.sc/y07wdo https://prnt.sc/y07x3e , try to find some product
02.02.2021, 12:39
Original comment available on version: ru

1. Great, it fits, you don’t need to delete anything in the settings, just add the ability to search for the brand + article link https://prnt.sc/zuyl0x. Please send an invoice for payment
2. Purely search - yes, we can. But when it comes to any operations, for example, posting or reserving in a warehouse, it is necessary for the system to search for a brand + article in a bunch, and not just an Article or Name that are available for comparison. Example: we are using the standard "Product Import Block", there you can select the appropriate column and match it with the criteria in OneBox https://prnt.sc/zuz9fh . But this list does not contain the Brand field, which is stored by the Directory https://psauto.crm-onebox.com/admin/shop/brands/ . How do we add the brandname system field to the selection in this menu?
As an option, of course, you can create an additional field for the product card using this https://psauto.crm-onebox.com/admin/shop/orderproductfield/ , as we did, but I don’t want to use this mechanism through crutches, because all the tools in system are available, we just need to configure them.
3. Can you check 2 items in the automation settings? https://prnt.sc/zv15zh :
PSauto.com.ua/Update status of process products
PSauto.com.ua/Remove deleted process products from an order on the website
This was a revision, it seems to us that in it the data is also sent to the site using only one "Article" key. If yes, it will be possible to do, as for point No. 1 - send a bunch of Brand + Article in order to change the status of products or delete them. Those. there are no questions about the automation itself - it works properly, just to eliminate problems in the future, we want to play it safe.
Thanks in advance, we will wait for your answer!
17.02.2021, 16:19
Original comment available on version: ru

1. accepted
2. But you add a specific product to the posting through the search. You also reserve a specific product by its id and not by article
3. We match the products of the process with the products of the process in your system by their article numbers, I highly doubt that there will be several products with the same article in one process. If this is still the case, then I think it is possible to check for the article + brand name. In order to make such a refinement, you need to find out on your part whether the Basket_GetList/id api method returns the name of the product brand
17.02.2021, 16:27
Original comment available on version: ru

Thanks for the answer!
2. We add through the import of the xls, csv file. The client and the supplier send their orders / shipments in the same format: a file with columns "Brand" - "Article" - "Quantity" . For example, the file contains Article 0001, but in the system it is available both under brand A and under brand B. The file does not contain the product ID, so it remains to match only by the "Article", and in this case, the reservation of the product in the warehouse may occur incorrectly, because. the system will book just the first item in the list with the same number. The same with cells: the system may display a cell of the wrong product, which is needed, because. will only search by "Article" . To eliminate such scenarios, we want to find a way to compare products across several fields, in particular, now we are talking about the Brand + Article link. Can this functionality be improved? Let's start with the same standard "Product Import Block" that we wrote about above. How many hours does it take to add a brandname (the "Brand" column in the table https://psauto.crm-onebox.com/admin/shop/brands/) to match when importing a file, so that the system would then search in its own bundle "Brand" + "Article" ? More clearly in the screenshot: https://prnt.sc/zyab0g
3. I agree, this is unlikely, but sometimes it occurs, although very rarely. The Basket_GetList/id api method returns the brand name of the product. How many hours will it take to finish?
Thank you for your time on our issue.
18.02.2021, 10:03
Original comment available on version: ru

2. I understand you, thanks for the detailed description. We can modify the Brand Name field into the "Product Import Block" block and the setting to search first by matching Article + Brand and if not found, then as before, only by Article, for example. This item will take 3 hours to complete.
3. It will take about an hour and a half for one action. Those. if you need to finalize 2 actions, it will take 3h
18.02.2021, 11:00
Original comment available on version: ru

2. Great, we will do it, then we are waiting for the bill for this revision!
3. The information is accepted, we will do this item, but a little later, when we finish with other more critical ones, thank you.
18.02.2021, 12:39
Original comment available on version: ru

Initiated the procedure for sending an invoice
19.02.2021, 15:29
Original comment available on version: ru


Krylov Gleb
Client wrote:
2. We add through the import of the xls, csv file. The client and the supplier send their orders / shipments in the same format: a file with columns "Brand" - "Article" - "Quantity" . For example, the file contains Article 0001, but in the system it is available both under brand A and under brand B. The file does not contain the product ID, so it remains to match only by the "Article", and in this case, the reservation of the product in the warehouse may occur incorrectly, because. the system will book just the first item in the list with the same number. The same with cells: the system may display a cell of the wrong product, which is needed, because. will only search by "Article" . To eliminate such scenarios, we want to find a way to compare products across several fields, in particular, now we are talking about the Brand + Article link. Can this functionality be improved? Let's start with the same standard "Product Import Block" that we wrote about above. How many hours does it take to add a brandname (the "Brand" column in the table https://psauto.crm-onebox.com/admin/shop/brands/) to match when importing a file, so that the system would then search in its own bundle "Brand" + "Article" ? More clearly in the screenshot: https://prnt.sc/zyab0g


Gimli son of Gloin
dwarf wrote:
2. I understand you, thanks for the detailed description. We can modify the Brand Name field into the "Product Import Block" block and the setting to search first by matching Article + Brand and if not found, then as before, only by Article, for example. This item will take 3 hours to complete.
3. It will take about an hour and a half for one action. Those. if you need to finalize 2 actions, it will take 3h

Good afternoon! Paid invoice. Please start from point #2 ("Product Import Block"). Thank you!
01.03.2021, 16:28
Original comment available on version: ru

Good afternoon. Item 2 is uploaded to your box. In the import block on its very first "page" an additional item was added to the drop-down list of product search options. Also added the ability to select a column with the name of the brand in the file preview.
04.03.2021, 14:53
Original comment available on version: ru


Gimli son of Gloin
dwarf wrote:
Good afternoon. Item 2 is uploaded to your box. In the import block on its very first "page" an additional item was added to the drop-down list of product search options. Also added the ability to select a column with the name of the brand in the file preview.

Super, thank you very much for the promptness, tomorrow we will test, we will write the result!
04.03.2021, 17:44
Original comment available on version: ru


Krylov Gleb
Client wrote:

Gimli son of Gloin
dwarf wrote:
Good afternoon. Item 2 is uploaded to your box. In the import block on its very first "page" an additional item was added to the drop-down list of product search options. Also added the ability to select a column with the name of the brand in the file preview.

Super, thank you very much for the promptness, tomorrow we will test, we will write the result!

Everything works, thank you very much! Let's think about which item we will finalize next, write to get an invoice! Thank you
05.03.2021, 17:19
Original comment available on version: ru

Please contact me - I'll be happy to help.
05.03.2021, 17:31
Original comment available on version: ru


Gimli son of Gloin
dwarf wrote:
1. Judging by the docks, your site conveys the product brand https://prnt.sc/y07ul7 , i.e. you can do a search by a bunch of brand + article. It will take 1 hour to finish

Please submit an invoice for revision. We will pay for this item. Thank you!
09.03.2021, 15:26
Original comment available on version: ru


Treebeard
the oldest of the Ents wrote:
1. Judging by the docs, your site conveys the product brand , i.e. you can do a search by a bunch of brand + article. It will take 1 hour to finish

Good evening! This item was paid, we are waiting for its implementation, and after that we will proceed to the revision of item No. 3. Thank you!
18.03.2021, 17:38
Original comment available on version: ru

Good afternoon. Added the setting "Search for a product by SKU+brand" to the process import action
15.04.2021, 17:30
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