1b.app
Link copied -

Updating and posting goods with the number of records in the task from 10,000 or more

Please respond to the task of OneBox developers.
How to solve the problem described below and get the desired result.
PURPOSE: Before posting, update the prices and values of the system and additional fields of the process products.
In the invoice from the manufacturer and in the task of updating/receiving at the same time, there can be from 10,000 goods or more at the same time.
Updating and posting should occur in one task.
How did you decide:
We created a business process and brought to the stage Update products - a package of actions that update the values of the required fields, now there are 16 of them, maybe more:
https://onebox.constantagro.com.ua:44553/admin/shop/workflowstatus/419/action/ne...
Here is a test task in which we performed actions on 500 products:
https://onebox.constantagro.com.ua:44553/admin/customorder/issue/2580/edit/
Everything went perfectly.
Here is an example of two products from the task, the data in which was completely updated correctly.
- first
https://
Original question is available on version: ru Вячеслав Легеза

Answers:

And what is the purpose of this thread?
23.07.2021, 16:06
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

Ustimenko Igor
OneBox production wrote:
And what is the purpose of this thread?

so there is a technical specification in which he analyzed the problem in detail
what exactly is not clear from the description to help with the decision?
23.07.2021, 17:41
Вячеслав Легеза Original comment available on version: ru


Ustimenko Igor
OneBox production wrote:
And what is the purpose of this thread?

Boxing does not digest the list of goods for more than 1000 items when importing through the BP. And you need to download more at once.
24.07.2021, 00:15
Original comment available on version: ru


Lisenko Oleksandr wrote:

Ustimenko Igor
OneBox production wrote:
And what is the purpose of this thread?

Boxing does not digest the list of goods for more than 1000 items when importing through the BP. And you need to download more at once.

1. if you go to the stage - then for what purpose is the checkbox "Diya spratsovuє after saving the process" - you perform these copies in the 2nd circle, the total time is multiplied by 2
2. I think you should make the setting not to recalculate the process after each action is completed. For example :
16 copy actions.
in total, you will recalculate the process 16 times, and in fact the recalculation is either not needed at all in your case, or only in the last action.
make this setting 1h
3. I think you can think about optimizing the action itself - there seems to be an idea. I can try to implement in 2 hours
26.07.2021, 09:59
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

Ustimenko Igor
OneBox production wrote:

Lisenko Oleksandr wrote:

Ustimenko Igor
OneBox production wrote:
And what is the purpose of this thread?

Boxing does not digest the list of goods for more than 1000 items when importing through the BP. And you need to download more at once.

1. if you go to the stage - then for what purpose is the checkbox "Diya spratsovuє after saving the process" - you perform these copies in the 2nd circle, the total time is multiplied by 2
2. I think you should make the setting not to recalculate the process after each action is completed. For example :
16 copy actions.
in total, you will recalculate the process 16 times, and in fact the recalculation is either not needed at all in your case, or only in the last action.
make this setting 1h
3. I think you can think about optimizing the action itself - there seems to be an idea. I can try to implement in 2 hours

1. it turns out that now the action package does not work optimally
2. unchecked to avoid unnecessary triggers when saving the task
3. Does this action pack work optimally on OneBox OS?
that is, will our task be solved after the transition to a new system without the cost of revision?
as an option, perhaps it makes sense to modify the actions so that it is possible to select an unlimited number of fields for updating in it?
26.07.2021, 10:15
Вячеслав Легеза Original comment available on version: ru

3. Yes, it works faster there + if you transfer, we are ready to redo it at our own expense

Legeza Vyacheslav Valerianovich
iCOLOR OneBox (FOP LEGEZA VYACHESLAV VALERIANOVICH) wrote:
as an option, perhaps it makes sense to modify the actions so that it is possible to select an unlimited number of fields for updating in it?

maybe but not sure until we try
26.07.2021, 10:23
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