1b.app
Link copied -

Updating prices and availability in the "Generic Product Import (xml/json)" automatic action

Good afternoon. Where do you need to check the box so that new supplier products are not added, but only the availability and prices of existing ones are updated? https://prnt.sc/uobg5q
Original question is available on version: ru

Answers:

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
if you are looking for matches by article, then you can use this checkbox https://prnt.sc/uocqj2
26.09.2020, 19:09
Original comment available on version: ru


Sukhanitsky Andrey Vladimirovich Employee wrote:
if you are looking for matches by article, then you can use this checkbox https://prnt.sc/uocqj2

Thanks for the reply, Andrey.
But the product does not have an article, it suits me more according to these parameters https://prnt.sc/uocx3q
26.09.2020, 19:21
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
You can use this setting https://prnt.sc/uodbmd
26.09.2020, 19:47
Original comment available on version: ru

Create additional fields? Why don't these fields "Update availability only", "Update supplier prices only" work as specified, or is the logic different?
26.09.2020, 20:09
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Kachanovsky Andrey Vladimirovich
Client wrote:
Create additional fields? Why don't these fields "Update availability only", "Update supplier prices only" work as specified, or is the logic different?

they will only update the availability, but whether they will create new products - you need to check
26.09.2020, 20:11
Original comment available on version: ru

Checked, new ones are still being created
26.09.2020, 20:15
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
This action was originally conceived as importing products, not updating prices, so the emphasis on logic is to update only these fields, and if a new product, then load it with all the data
26.09.2020, 20:17
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
If you do not specify, for example, the name, then most likely the products will not be created, because the name is a required field
26.09.2020, 20:18
Original comment available on version: ru

Now I'm experimenting.
thanks for the help
26.09.2020, 20:23
Original comment available on version: ru

failed to update without adding a new product
27.09.2020, 10:56
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license
then either do additional work - it's 2 hours, or fill in an additional field - you can use the action when saving the product, or change the logic by the article or external id
27.09.2020, 13:03
Original comment available on version: ru

It seems to me that new products will be added anyway.
Well, if there is all the goods from the file, then only then it will only be updated.
27.09.2020, 14:14
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Kachanovsky Andrey Vladimirovich
Client wrote:
It seems to me that new products will be added anyway. Well, if there is all the product from the file, then only then it will only be updated.

No, not in any, in the same place in the settings it is written that new goods will not be created.
Here you need to see the price, what the file looks like, at least for several products, then you can talk about how to set it up, otherwise I just give you assumptions
27.09.2020, 14:55
Original comment available on version: ru


Sukhanitsky Andrey Vladimirovich Employee wrote:
No, not in any, in the same place in the settings it is written that new goods will not be created.

Can you tell me where it is in the settings?
The link to the price is in the settings.
27.09.2020, 15:07
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Kachanovsky Andrey Vladimirovich
Client wrote:
Sukhanitsky Andrey Vladimirovich The employee wrote / a: No, not in any, in the same place in the settings it is written that new goods will not be created. Can you tell me where it is in the settings? The link to the price is in the settings.

http://i.imgur.com/upTx1zQ.png
http://i.imgur.com/TBEZ8Yo.png
In general, in this action, option 2:
1) this setting http://i.imgur.com/DHRZNRr.png
2) this http://i.imgur.com/0g8A6sT.png
You can put the action in automation - calculate by the formula and write there http://i.imgur.com/9fogGw3.png http://i.imgur.com/x4I7TNs.png
27.09.2020, 16:22
Original comment available on version: ru


Sukhanitsky Andrey Vladimirovich Employee wrote:
2) this http://i.imgur.com/0g8A6sT.png You can put the action in automation - calculate by the formula and write there http://i.imgur.com/9fogGw3.png http://i.imgur.com/ x4I7TNs.png

Made according to the second option, added to the add. field provider code https://prnt.sc/uoth3n in the import settings made https://prnt.sc/uothka at the bottom of the report it is clear that nothing was successful :( Thanks for the help
27.09.2020, 19:38
Original comment available on version: ru

Суханіцький Андрій OneBox CORP
OneBox Corp - Інтегратор
Personal license

Kachanovsky Andrey Vladimirovich
Client wrote:
Sukhanitsky Andrey Vladimirovich Employee wrote: 2) this http://i.imgur.com/0g8A6sT.png You can put the action in automation - calculate by the formula and write there http://i.imgur.com/9fogGw3.png http: //i.imgur.com/x4I7TNs.png Made according to the second option, added to the add. field provider code https://prnt.sc/uoth3n in the import settings made https://prnt.sc/uothka at the bottom of the report it is clear that nothing was successful :( Thanks for the help

This setting only searches for products by SKU or external id. So that doesn't work either.
Is it possible to generate a price list in Google spreadsheet or Excel?
28.09.2020, 17:41
Original comment available on version: ru

I save xml xls mostly, but this price list is not suitable for this. It crookedly displays lines, not as it should
28.09.2020, 17:46
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