Optimizing the operation of the "Update availability in opencart" action

Good afternoon. Just a few seconds, probably not (boxing and opencart are commonplace on different servers and each request to the database goes back and forth, i.e. a lot of time is spent purely on sending requests and receiving responses and not on the execution itself), but most likely it can be done in a couple of times faster. Will it take 3 hours to complete, will I issue an invoice?

Yes, post it. Is it possible to additionally make the setting “Update availability only for products whose availability has changed in the last N minutes”? And tell me, is it possible to somehow implement instant sending of availability after it has been changed to opencart via webhooks?

[quote] Rodion wrote: Yes, post it. Is it possible to additionally make the setting “Update availability only for products whose availability has changed in the last N minutes”? [/quote] yes, +1h. It will just look not at availability, but in general at changes in the product card (udate field). If you do this and you don’t have a lot of products updated every hour, then you don’t have to do optimizations; much fewer products will be sent. If there is some kind of price recalculation once an hour, then this will not change the situation in any way, all products will be updated and everything will be sent too. [quote] Rodion wrote: And tell me, is it possible to somehow implement instant sending of availability after it has been changed to opencart via webhooks? [/quote] Yes, in product update automation you can make an action that will update the availability of the product in the background after updating the card. It will take about 4 hours.

[quote] [file]21823[/file] Care Department [file]21823[/file] OneBox production wrote: [file]21823[/file] yes, +1h. It will just look not at availability, but in general at changes in the product card (udate field). If you do this and you don’t have a lot of products updated every hour, then you don’t have to do optimizations; much fewer products will be sent. If there is some kind of price recalculation once an hour, then this will not change the situation in any way, all products will be updated and everything will be sent too. [file]21823[/file] [/quote] [file]21823[/file] Yes, we run price recalculation once an hour, but if, for example, we make the setting “Update availability only for products whose availability has changed since the last time the action was launched,” then it will work for us. The action will run every minute and unload balances only for goods that were updated between unloadings and once an hour for all. Will it work the same? [file]21823[/file] [quote] [file]21823[/file] Care Department [file]21823[/file] OneBox production wrote: [file]21823[/file] It will just look not at availability, but in general at changes in the product card (udate field) [file]21823[/file] [/quote] [file]21823[/file] can it be done by analogy with the action “Upload products/categories/filters/characteristics into opencart (via database)”? In it you can select the availability and quantity fields, when changed, the product will be unloaded. [file]21823[/file] [file]21823[/file]

[quote] Rodion wrote: can it be done by analogy with the action “Upload products/categories/filters/characteristics into opencart (via database)”? In it you can select the availability and quantity fields, when changed, the product will be unloaded. [/quote] it is possible, but not all changes in these fields are in history. The same price recalculation can change availability without recording it in history

I tested it, it seems that all the processes that occur with us change the product update date, and there are entries in the logs: [file]21829[/file] storaged - when the quantity of goods in warehouses changes, [file]21829[/file] availtext - when recalculating, [file]21829[/file] avail - if neither we nor the supplier have the product, or vice versa, it has appeared. [file]21829[/file] Let's then make a setting so that only products are unloaded that have had changes in these 3 fields since the last time the action was launched (storaged, availtext, avail). [file]21829[/file] We still need 2 related improvements, should we create a new topic or can we do everything together? [file]21829[/file] 1. When updating the price list, for goods of the downloaded supplier that are not in the price list (availability is turned off for them, but that’s what we need), prices are not recalculated. It needs some configuration to get it running. [file]21829[/file] 2. When you manually change the supplier’s availability for an item in the product card, it also changes - as I understand it, the availability is recalculated. But if the supplier’s price and ppc change, the recalculation does not occur. A setting is needed to start recalculating prices and availability for a product while saving supplier information for this product. [file]21829[/file] [file]21829[/file]

Good afternoon Please confirm the modifications, and we are waiting for the invoice

[quote] Rodion wrote: I tested it, it seems that all the processes that occur with us change the product update date, and there are entries in the logs: storaged - when the quantity of goods in warehouses changes, availtext - when recalculating, avail - if neither we nor the supplier have the product, or vice versa, it has appeared. Let's then make a setting so that only products are unloaded that have had changes in these 3 fields since the last time the action was launched (storaged, availtext, avail). [/quote] ok, 4h [quote] Rodion wrote: We still need 2 related improvements, should we create a new topic or can we do everything together? 1. When updating the price list, for goods of the downloaded supplier that are not in the price list (availability is turned off for them, but that’s what we need), prices are not recalculated. You need to configure it for it to run. [/quote] 2h [quote] Rodion wrote: 2. When you manually change the supplier’s availability for an item in the product card, it also changes - as I understand it, the availability is recalculated. But if the supplier’s price and ppc change, the recalculation does not occur. A setting is needed to start recalculating prices and availability for a product while saving supplier information for this product. [/quote] 2h Bill?

if without optimization and just send those products whose selected fields have changed, then 1 hour

[quote] Care Department OneBox production wrote: if without optimization and just send those products whose selected fields have changed, then 1 hour [/quote] Yes, let's go without optimization for now, we will only send products for which these fields have changed. And since the last time this action was launched.

Total: 1. In the action of exporting the availability of products to opencart, we send only those products for which the selected fields have changed in the specified X minutes (you will set the number of minutes yourself and select the fields, among the available ones there will be a couple of fields like storaged availtext avail). 1h Points 2 and 3 are described in detail above. Only 5 hours, I'll issue an invoice.

Yes that's right! Just in case, let me clarify: [quote] Care Department OneBox production wrote: 1. In the action of exporting the availability of products to opencart, we send only those products for which the selected fields have changed in the specified X minutes (you will set the number of minutes yourself and select the fields, among the available ones there will be a couple of fields like storaged availtext avail). 1h [/quote] Action Update availability in opencart in the Automation section once per minute [quote] Rodion wrote: 1. When updating the price list, for goods of the downloaded supplier that are not in the price list (availability is turned off for them, but that’s what we need), prices are not recalculated. You need to configure it for it to run. [/quote] You need to launch Price and AVAILABILITY calculation [quote] Rodion wrote: 2. When you manually change the supplier’s availability for an item in the product card, it also changes - as I understand it, the availability is recalculated. But if the supplier’s price and ppc change, the recalculation does not occur. A setting is needed to start recalculating prices and availability for a product while saving supplier information for this product. [/quote] Start recalculation of prices and availability when saving any changes in the Suppliers by product section I'm waiting for the invoice, thank you!

Good afternoon Please advise on the timing of the implementation of improvements, thank you.

When should I expect it to be ready?

It's been 22 days, please give me some kind of answer. When will the improvements be implemented?

Good afternoon, usually improvements are made within a month from the date of payment, the maximum I have seen is about 6-7 weeks.

[quote] Care Department OneBox production wrote: Good afternoon, usually improvements are made within a month from the date of payment, the maximum I have seen is about 6-7 weeks. [/quote] Ok, please tell me when to expect this?

around this week

Thanks, we're waiting. Just in case, I’ll repeat the clarifications: [quote] Rodion wrote: Yes that's right! Just in case, let me clarify: [quote] Care Department OneBox production wrote: 1. In the action of exporting the availability of products to opencart, we send only those products for which the selected fields have changed in the specified X minutes (you will set the number of minutes yourself and select the fields, among the available ones there will be a couple of fields like storaged availtext avail). 1h [/quote] Action Update availability in opencart in the Automation section once per minute [quote] Rodion wrote: 1. When updating the price list, for goods of the downloaded supplier that are not in the price list (availability is turned off for them, but that’s what we need), prices are not recalculated. You need to configure it for it to run. [/quote] You need to launch Price and AVAILABILITY calculation [quote] Rodion wrote: 2. When you manually change the supplier’s availability for an item in the product card, it also changes - as I understand it, the availability is recalculated. But if the supplier’s price and ppc change, the recalculation does not occur. A setting is needed to start recalculating prices and availability for a product while saving supplier information for this product. [/quote] Start recalculation of prices and availability when saving any changes in the Suppliers by product section I'm waiting for the invoice, thank you! [/quote]

[quote] [file]22002[/file] Care Department [file]22002[/file] OneBox production wrote: [file]22002[/file] 3. In the “Suppliers” product block, select the “Run recalculation of prices and availability after saving this block (recalculation of prices and product availability will be launched in the background)” [file]22002[/file] [/quote] [file]22002[/file] As I understand it, the settings were made in the wrong place. [file]22002[/file] [quote] [file]22002[/file] Rodion wrote: [file]22002[/file] 2. When you manually change the supplier’s availability for an item in the product card, it also changes - as I understand it, the availability is recalculated. But if the supplier’s price and ppc change, the recalculation does not occur. A setting is needed to start recalculating prices and availability for a product while saving supplier information for this product. [file]22002[/file] Screenshot_86.png [file]22002[/file] [/quote] [file]22002[/file] I sent a screenshot to the technical specifications - this is the Suppliers and Prices application, not a block in the product interface (I didn’t even know about its existence). [file]22002[/file] [file]22002[/file]

Good afternoon, please correct us, we cannot use the improvement - we wanted to disable the automation of every hour Recalculation of prices and leave the recalculation only after editing.

Okay, let's use this block