Good morning.
Problem with writing off an item, in the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1394850/edit/, item https://crm.ohrana.ua/admin/shop/products/620/storage / not written off from the warehouse - gives an error about the negative balance http://joxi.ru/zAN3beVc8zVEWr, although apparently it is enough in stock and the position is reserved
Please help
The problem is that in one second two api requests arrived in the box to create a process for moving goods between warehouses https://crm.ohrana.ua/admin/customorder/order/1396416/edit/ and https://crm.ohrana. ua/admin/customorder/order/1396415/edit/ , and both processes completed and moved the goods to another warehouse, in fact the transfer was not completed, since there was no availability for both transfers. For the product https://crm.ohrana.ua/admin/shop/products/620/storage/ deleted one transfer operation, and the problem on the above order is gone, the rest of the products are still left for you to check. But deleting warehouse operations is not a solution, how to avoid such situations?
The problem is that in one second two api requests arrived in the box to create a process for moving goods between warehouses https://crm.ohrana.ua/admin/customorder/order/1396416/edit/ and https://crm.ohrana. ua/admin/customorder/order/1396415/edit/ , and both processes completed and moved the goods to another warehouse, in fact the transfer was not completed, since there was no availability for both transfers.
For the product https://crm.ohrana.ua/admin/shop/products/620/storage/ deleted one transfer operation, and the problem on the above order is gone, the rest of the products are still left for you to check.
But deleting warehouse operations is not a solution, how to avoid such situations?
I will add that at the stage to which Box tried to go, the action of sending a message to the client was set, and Box sent the specified messages to the client with each attempt to go to the stage, as a result, the client was spammed by sending him 40 messages How to solve the above problem?
I will add that at the stage to which Box tried to go, the action of sending a message to the client was set, and Box sent the specified messages to the client with each attempt to go to the stage, as a result, the client was spammed by sending him 40 messages
How to solve the above problem?
Yes, you are right - the cant is that you duplicate requests in the api. To fix this, you need not to duplicate requests in the api, then you will not have such situations. If you avoid this at the software level in boxing, this will slow down the system tenfold
Yes, you are right - the cant is that you duplicate requests in the api. To fix this, you need not to duplicate requests in the api, then you will not have such situations. If you avoid this at the software level in boxing, this will slow down the system tenfold
while there is no possibility not to duplicate (the second system gives orders this way) maybe there is an opportunity from the side of boxing to bypass the settings somehow? is it a movement between warehouses, if we create two processes in one second, and then we will transfer to the second warehouse having previously reserved the goods? or maybe you can use the Change process step action if there are enough products in stock and the settings to ensure that only one process goes to the step where the move action is set, and the second one does not have enough left
while there is no possibility not to duplicate (the second system gives orders this way)
maybe there is an opportunity from the side of boxing to bypass the settings somehow?
is it a movement between warehouses, if we create two processes in one second, and then we will transfer to the second warehouse having previously reserved the goods? or maybe you can use the Change process step action if there are enough products in stock and the [file]9112[/file] settings to ensure that only one process goes to the step where the move action is set, and the second one does not have enough left
with parallel queries, you will not do anything at the code level without locks in the database. If blocking is washed down at the time of the request, it will hurt you a lot in terms of performance, believe me.
with parallel queries, you will not do anything at the code level without locks in the database. If blocking is washed down at the time of the request, it will hurt you a lot in terms of performance, believe me.
Good afternoon. Thank you. Let's try to fix it on the other side. But it’s not even the fact of doubling that is worse, but the fact that I see 8 pieces with my eyes, but in fact there are zero of them. Because of this, there is a lack of confidence in boxing. It is not duplicates that need to be corrected, but the fact that there is one value in the system, but another is shown. If the wiring is doubled, then I should see a negative value. Anything, but corresponding to the internal value. Can this be fixed somehow?
Good afternoon. Thank you.
Let's try to fix it on the other side.
But it’s not even the fact of doubling that is worse, but the fact that I see 8 pieces with my eyes, but in fact there are zero of them. Because of this, there is a lack of confidence in boxing. It is not duplicates that need to be corrected, but the fact that there is one value in the system, but another is shown. If the wiring is doubled, then I should see a negative value. Anything, but corresponding to the internal value.
Can this be fixed somehow?
This can be fixed by not sending the same requests to the system at the same time or by programmatically lowering the speed of your database by a factor of ten by placing read locks. Those. while someone is reading information about balances, you will wait until his reading is over.
This can be fixed by not sending the same requests to the system at the same time or by programmatically lowering the speed of your database by a factor of ten by placing read locks. Those. while someone is reading information about balances, you will wait until his reading is over.
Can't delete move operation
https://crm.ohrana.ua/admin/shop/products/617/storage/
I choose operations to delete [file]9175[/file] and save, and still everything is in place
[quote]
.
OneBox production wrote:
1. Try to delete one by one
2. Look, maybe you did something later with the products in this warehouse
[/quote]
I delete one by one, but they are still in place.
Try to remove the operation https://crm.ohrana.ua/admin/shop/storage/motion/106991/?productid=617
OneBox production wrote: This can be fixed by not sending the same requests to the system at the same time or by programmatically lowering the speed of your database by a factor of ten by placing read locks. Those. while someone is reading information about balances, you will wait until his reading is over.
I realized that if three requests are sent to the box at the same time, then it will work them out and we won’t solve this on the side of the box. I agree with this and have no questions. But the question is different. In the example above, there were three operations, they are in the warehouse operations. As a result of the posting, there should have been a negative balance. So why not show it? Yes, we will understand. that this is a mistake, and that there are doubled wiring that led to this. But you are different. With my eyes I see one remnant, but boxing sees something else. Can you imagine that there are 5 products in 1C, but in fact there are 10? Here is my thought. that in Boxing this should not be. I see the problem that the numbers that boxing shows cannot be trusted. The product seems to be there, but it is not. There should be a transparent connection between the result and the transactions that led to this. If for some reason there was a doubling of the operation - boxing reflected this in warehouse operations. There are three movements. But they affected only the visual part, but not some inner rest.
https://crm.ohrana.ua/admin/shop/products/617/storage/
Three operations 4.08.2021 at 13:20
[quote]
OneBox production wrote:
This can be fixed by not sending the same requests to the system at the same time or by programmatically lowering the speed of your database by a factor of ten by placing read locks. Those. while someone is reading information about balances, you will wait until his reading is over.
[/quote]
I realized that if three requests are sent to the box at the same time, then it will work them out and we won’t solve this on the side of the box. I agree with this and have no questions.
But the question is different. In the example above, there were three operations, they are in the warehouse operations. As a result of the posting, there should have been a negative balance. So why not show it? Yes, we will understand. that this is a mistake, and that there are doubled wiring that led to this. But you are different. With my eyes I see one remnant, but boxing sees something else.
Can you imagine that there are 5 products in 1C, but in fact there are 10? Here is my thought. that in Boxing this should not be.
I see the problem that the numbers that boxing shows cannot be trusted. The product seems to be there, but it is not. There should be a transparent connection between the result and the transactions that led to this. If for some reason there was a doubling of the operation - boxing reflected this in warehouse operations. There are three movements. But they affected only the visual part, but not some inner rest.
https://crm.ohrana.ua/admin/shop/products/530/storage/ 41 pieces, but 10 pieces cannot be debited. Leads are not deleted. There are dozens more of these. Leads are not deleted. And yet the goods cannot be written off, the stage does not change, but the action at the next stage to send a message works fine and dozens of messages are sent. Is that okay too?
https://crm.ohrana.ua/admin/shop/products/530/storage/
41 pieces, but 10 pieces cannot be debited. Leads are not deleted.
There are dozens more of these. Leads are not deleted.
And yet the goods cannot be written off, the stage does not change, but the action at the next stage to send a message works fine and dozens of messages are sent. Is that okay too?
I beg you, come up with a solution, even if it is paid. You don't have to deal with doubling. But if there are two postings, then they should affect the balance. And if there is a remainder, then it must be the same everywhere (albeit negative). In this case, we will be able to update the balance and not catch another year of "unsettled" transactions.
I beg you, come up with a solution, even if it is paid. You don't have to deal with doubling. But if there are two postings, then they should affect the balance. And if there is a remainder, then it must be the same everywhere (albeit negative). In this case, we will be able to update the balance and not catch another year of "unsettled" transactions.
OneBox production wrote: give a list of transactions that need to be deleted, I will do it manually through the database
There are a lot of such goods and it is almost impossible to catch them. This needs to be addressed, not removed. goods https://crm.ohrana.ua/admin/shop/products/606/storage/ https://crm.ohrana.ua/admin/shop/products/530/storage/ both goods were in double movement 1433066 and now cannot be written off from the warehouse But in this movement there were about 20 goods, that is, everyone will have a problem Why didn’t we have this problem before, we perform move operations a long time ago and didn’t change the query settings?
[quote]
OneBox production wrote:
give a list of transactions that need to be deleted, I will do it manually through the database
[/quote]
There are a lot of such goods and it is almost impossible to catch them. This needs to be addressed, not removed.
goods https://crm.ohrana.ua/admin/shop/products/606/storage/
https://crm.ohrana.ua/admin/shop/products/530/storage/
both goods were in double movement 1433066 and now cannot be written off from the warehouse
But in this movement there were about 20 goods, that is, everyone will have a problem
Why didn’t we have this problem before, we perform move operations a long time ago and didn’t change the query settings?
Ptashkin Sergey wrote: Three operations 4.08.2021 at 13:20
deleted
Ptashkin Sergey wrote: https://crm.ohrana.ua/admin/shop/products/530/storage/ 41 pieces, but 10 pieces cannot be debited. Leads are not deleted. There are dozens more of these. Leads are not deleted. And yet the goods cannot be written off, the stage does not change, but the action at the next stage to send a message works fine and dozens of messages are sent. Is that okay too?
as above, just give links to the operations that need to be deleted, I will delete it.
Ptashkin Sergey wrote: And yet the goods cannot be written off, the stage does not change, but the action at the next stage to send a message works fine and dozens of messages are sent. Is that okay too?
depending on who sends messages. If SMS, then it's not normal. If there is a viber or telegram thread or a knock on the side api, then it's normal. Since we have already sent a request there with a request to send the message and we cannot return it back, because after X actions you get an error I can’t show you negative balances, regarding the solution of your question - I’ll think about what can be done
[quote]
Ptashkin Sergey wrote:
Three operations 4.08.2021 at 13:20
[/quote]
deleted
[quote]
Ptashkin Sergey wrote:
https://crm.ohrana.ua/admin/shop/products/530/storage/
41 pieces, but 10 pieces cannot be debited. Leads are not deleted.
There are dozens more of these. Leads are not deleted.
And yet the goods cannot be written off, the stage does not change, but the action at the next stage to send a message works fine and dozens of messages are sent. Is that okay too?
[/quote]
as above, just give links to the operations that need to be deleted, I will delete it.
[quote]
Ptashkin Sergey wrote:
And yet the goods cannot be written off, the stage does not change, but the action at the next stage to send a message works fine and dozens of messages are sent. Is that okay too?
[/quote]
depending on who sends messages. If SMS, then it's not normal. If there is a viber or telegram thread or a knock on the side api, then it's normal. Since we have already sent a request there with a request to send the message and we cannot return it back, because after X actions you get an error
I can’t show you negative balances, regarding the solution of your question - I’ll think about what can be done
https://crm.ohrana.ua/admin/shop/products/620/storage/ delete process operation id 1417006
https://crm.ohrana.ua/admin/shop/products/3135/storage/ delete process operation 1416655
For the products below, delete the process operation 1433066 , for some reason some of the operations were deleted manually, but some were not (Why so?)
https://crm.ohrana.ua/admin/shop/products/3421/storage/
https://crm.ohrana.ua/admin/shop/products/1052/storage/
https://crm.ohrana.ua/admin/shop/products/4133/storage/
https://crm.ohrana.ua/admin/shop/products/322/storage/
https://crm.ohrana.ua/admin/shop/products/1340/storage/
https://crm.ohrana.ua/admin/shop/products/4252/storage/
https://crm.ohrana.ua/admin/shop/products/530/storage/
https://crm.ohrana.ua/admin/shop/products/934/storage/
https://crm.ohrana.ua/admin/shop/products/606/storage/
https://crm.ohrana.ua/admin/shop/products/233/storage/
https://crm.ohrana.ua/admin/shop/products/19/storage/
https://crm.ohrana.ua/admin/shop/products/1537/storage/
https://crm.ohrana.ua/admin/shop/products/3293/storage/
https://crm.ohrana.ua/admin/shop/products/1439/storage/
https://crm.ohrana.ua/admin/shop/products/1689/storage/
https://crm.ohrana.ua/admin/shop/products/296/storage/
https://crm.ohrana.ua/admin/shop/products/1434/storage/
https://crm.ohrana.ua/admin/shop/products/314/storage/
OneBox production wrote: I can’t show you negative balances, regarding the solution of your question - I’ll think about what can be done
Thank you. I really hope for a positive solution to the issue. 1. We have two postings (for example, moving) at the same time. I understand that one of them was carried out correctly, and the second was carried out, but not completely? Or how is it formal? How to distinguish one from the other? which one should be removed? 2. Please explain the logic, I see the balance of 41 pcs, I see receipts with prices and everything that I can see in the box - everything converges. But I can't upload. What numbers does boxing operate on? can they be seen? Why boxing cannot operate with the numbers that it shows in the interface. After all, in fact, they are true and there are no problems with them, even if the operation is doubled? 3. Is it possible to modify so that when updating the balance (balance update), the entire balance is updated, both the one that I see and the one that the box operates on?
[quote]
OneBox production wrote:
I can’t show you negative balances, regarding the solution of your question - I’ll think about what can be done
[/quote]
Thank you. I really hope for a positive solution to the issue.
1. We have two postings (for example, moving) at the same time. I understand that one of them was carried out correctly, and the second was carried out, but not completely? Or how is it formal? How to distinguish one from the other? which one should be removed?
2. Please explain the logic, I see the balance of 41 pcs, I see receipts with prices and everything that I can see in the box - everything converges. But I can't upload. What numbers does boxing operate on? can they be seen? Why boxing cannot operate with the numbers that it shows in the interface. After all, in fact, they are true and there are no problems with them, even if the operation is doubled?
3. Is it possible to modify so that when updating the balance (balance update), the entire balance is updated, both the one that I see and the one that the box operates on?
Ptashkin Sergey wrote: 1. We have two postings (for example, moving) at the same time. I understand that one of them was carried out correctly, and the second was carried out, but not completely? Or how is it formal? How to distinguish one from the other? which one should be removed?
unfortunately not, without a glance in the database
Ptashkin Sergey wrote: 2. Please explain the logic, I see the balance of 41 pcs, I see receipts with prices and everything that I can see in the box - everything converges. But I can't upload. What numbers does boxing operate on? can they be seen? Why boxing cannot operate with the numbers that it shows in the interface. After all, in fact, they are true and there are no problems with them, even if the operation is doubled?
The box does not show negative balances of goods. That is, there may be a situation when you write off the same unit of goods in parallel. Here -1 box does not show but shows 0 on this balance. Once again, I think. what is the best thing to do with it.
Deleted transactions.
[quote]
Ptashkin Sergey wrote:
1. We have two postings (for example, moving) at the same time. I understand that one of them was carried out correctly, and the second was carried out, but not completely? Or how is it formal? How to distinguish one from the other? which one should be removed?
[/quote]
unfortunately not, without a glance in the database
[quote]
Ptashkin Sergey wrote:
2. Please explain the logic, I see the balance of 41 pcs, I see receipts with prices and everything that I can see in the box - everything converges. But I can't upload. What numbers does boxing operate on? can they be seen? Why boxing cannot operate with the numbers that it shows in the interface. After all, in fact, they are true and there are no problems with them, even if the operation is doubled?
[/quote]
The box does not show negative balances of goods. That is, there may be a situation when you write off the same unit of goods in parallel. Here -1 box does not show but shows 0 on this balance. Once again, I think. what is the best thing to do with it.
looks like something went wrong
process https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1457627/edit/
when writing off, it gives an error on the product https://crm.ohrana.ua/admin/shop/products/3436/edit/ about a negative balance, I see that you have already deleted the indicated operations, but the error is still there. What to do?
Good afternoon. Tell me if there is a solution, according to the position https://crm.ohrana.ua/admin/shop/products/3436/edit/ (the details are described above), we can’t write off several orders with this product
Good afternoon. Tell me if there is a solution, according to the position https://crm.ohrana.ua/admin/shop/products/3436/edit/ (the details are described above), we can’t write off several orders with this product
please fix this one too https://crm.ohrana.ua/admin/shop/products/314/storage/
don't sleep is written off in the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1498670/edit/
Thanks
[quote]
Shatokhina Irina wrote:
looks like something went wrong
process https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1457627/edit/
when writing off, it gives an error on the product https://crm.ohrana.ua/admin/shop/products/3436/edit/ about a negative balance, I see that you have already deleted the indicated operations, but the error is still there. What to do?
[/quote]
Look, plz still position https://crm.ohrana.ua/admin/shop/products/1439/storage/ , still I can not write off the above order, but there is already an error on this position
I also cannot write off the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1345471/edit/
swears at the position https://crm.ohrana.ua/admin/shop/products/4575/edit/
[quote]
Shatokhina Irina wrote:
[quote]
Shatokhina Irina wrote:
looks like something went wrong
process https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1457627/edit/
when writing off, it gives an error on the product https://crm.ohrana.ua/admin/shop/products/3436/edit/ about a negative balance, I see that you have already deleted the indicated operations, but the error is still there. What to do?
[/quote]
Look, plz still position https://crm.ohrana.ua/admin/shop/products/1439/storage/ , still I can not write off the above order, but there is already an error on this position
[/quote]
+
[quote]
Shatokhina Irina wrote:
I also cannot write off the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1345471/edit/
swears at the position https://crm.ohrana.ua/admin/shop/products/4575/edit/
[/quote]
+
the same problem on the position https://crm.ohrana.ua/admin/shop/products/19/edit/
we cannot write off the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1512287/edit/
at the moment only this order, the rest are written off
[quote]
Shatokhina Irina wrote:
the same problem on the position https://crm.ohrana.ua/admin/shop/products/19/edit/
we cannot write off the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1512287/edit/
[/quote]
at the moment only this order, the rest are written off
yet another one surfaced https://crm.ohrana.ua/admin/shop/products/3437/edit/
not debited in the process https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1514947/edit/
position https://crm.ohrana.ua/admin/shop/products/296/edit/ in the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/846311/edit/
position https://crm.ohrana.ua/admin/shop/products/530/edit/ in the order https://crm.ohrana.ua/admin/customorder/zakaz-klienta/1345471/edit/ (in this order already the third such position, maybe there is more, but I learn about the next one only after adjusting the previous one)
Please fix these
Shatokhina Irina Client wrote: and please let me know if there is a global solution how to avoid such problems in the future?
yes, you have it above. Do not make parallel requests to the box
corrected.
[quote]
Shatokhina Irina
Client wrote:
and please let me know if there is a global solution how to avoid such problems in the future?
[/quote]
yes, you have it above. Do not make parallel requests to the box
. OneBox production Employee clack clack wrote: corrected.
Shatokhina Irina Client wrote: and please let me know if there is a global solution how to avoid such problems in the future?
yes, you have it above. Do not make parallel requests to the box
requests are not duplicated anymore (already a month ago). How now to solve the fact that for a month we have been catching positions with crooked balances and a negative balance? Can you somehow pull out positions with crooked residuals and massively "correct" them?
[quote]
.
OneBox production
Employee
clack clack wrote:
corrected.
[quote]
Shatokhina Irina
Client wrote:
and please let me know if there is a global solution how to avoid such problems in the future?
[/quote]
yes, you have it above. Do not make parallel requests to the box
[/quote]
requests are not duplicated anymore (already a month ago). How now to solve the fact that for a month we have been catching positions with crooked balances and a negative balance? Can you somehow pull out positions with crooked residuals and massively "correct" them?
There is also a quick option - I can delete all balances and the history of operations in which there were errors and send you a list of products so that you can manually re-register them.
There is also a quick option - I can delete all balances and the history of operations in which there were errors and send you a list of products so that you can manually re-register them.
Good afternoon. We can update api balances across all products. If you delete erroneous postings along with the balances on them, then this will suit us.
Good afternoon. We can update api balances across all products. If you delete erroneous postings along with the balances on them, then this will suit us.
anonymous duck OneBox production Employee wrote: There is also a quick option - I can delete all balances and the history of operations in which there were errors and send you a list of products so that you can manually re-register them.
this is the same list. I deleted part of the entries for the specified products
[quote]
anonymous duck
OneBox production
Employee wrote:
There is also a quick option - I can delete all balances and the history of operations in which there were errors and send you a list of products so that you can manually re-register them.
[/quote]
this is the same list. I deleted part of the entries for the specified products
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