Jump to content

Advanced Stock Management (Asm) Issue With Warehouse Quantity When Using Supply Orders [Compilation]


newcomer

Recommended Posts

post-819608-0-09754900-1455849229_thumb.jpg

I have researched the shit out of the internet to resolve this issue but none has been successful so far. It is surprising to see such a widespread problem being mostly ignored by PS developers. No less than a dozen topics regarding this bug has been opened but none were resolved.

Following are links that I have compiled that discussed the main problem of ASM.

 
Related folders in root directory:
.../public_html/classes/stock
.../public_html/controllers/admin/AdminSupplyOrdersController.php
 
Following are fixes found on github and forge. Tried but did not work. Maybe I did something wrong. 
   https://github.com/PrestaShop/PrestaShop/commit/      da2ab7a4404282c33d7846d219da4959fc11c641

Background of the problem see following.
 
Supply order process as below:
1)Creation in progress - OK
2)Order validated - OK
3)Pending receipt - Incorrect (Physical Qty and Usable Qty doesn't update. Real Qty updates correctly at this point)
4)Order received in part (Physical Qty and Usable Qty doesn't update. Real Qty updates but quantity shown is qty not received which is wrong)
5)Order received completely (Physical Qty and Usable Qty doesn't update. Real Qty becomes 0 which is incorrect)
6)Order canceled (Physical, Usable and Real Qty does not decrement)
 
After 3(Pending receipt) or 4(Order received in part), front end shows product in stock and able to add to cart. But during checkout returns error that buyer can't pay because the item is not in stock even though the product is still listed as in stock at front end.
 
In Warehouse>Insant stock status, real quantity shows correct quantity, but 0 in both physical qty and useable qty. Could be something to do with this. Also to note is that after clicking received in part, the "Real quantity" is updated reversed. For example, item A received 47pcs instead of Expected 50pcs from Supplier 1. After clicking save, in instant stock status it shows 3pcs. By right it should be 47pcs. Again, by this time under Physical Quantity it should be 47pcs (now it is 0 which is incorrect), and Usable quantity which should also be 47pcs(now it is 0 which is incorrect), assuming that Item A does not have any pending order in cart.
Edited by newcomer (see edit history)
Link to comment
Share on other sites

So I installed Prestashop Cleaner and cleaned the database. Now it seems to be working fine. I also found out if I did not include the unit price (tax exclusive), the real qty will be deducted instead of added. Weird behavior. 

 

I created an extra status No.7 and called it  => 7 - Order received incomplete (Closed). This process should be selected if an order arrived incomplete or somewhat different than ordered. It should be selected right after 3 - Pending receipt. It's actually the same as 6 - Ordered canceled but I think it would be better to create a new status that had a more reasonable status naming. See attached picture:
 
Edit: Except for one little bug. Order valuation is not calculated based on the actual qty received but qty ordered. 

post-819608-0-31949600-1455897550_thumb.jpg

Edited by newcomer (see edit history)
Link to comment
Share on other sites

  • 2 months later...

 

So I installed Prestashop Cleaner and cleaned the database. Now it seems to be working fine. I also found out if I did not include the unit price (tax exclusive), the real qty will be deducted instead of added. Weird behavior. 

 

I created an extra status No.7 and called it  => 7 - Order received incomplete (Closed). This process should be selected if an order arrived incomplete or somewhat different than ordered. It should be selected right after 3 - Pending receipt. It's actually the same as 6 - Ordered canceled but I think it would be better to create a new status that had a more reasonable status naming. See attached picture:
 
Edit: Except for one little bug. Order valuation is not calculated based on the actual qty received but qty ordered. 

 

 

Hi,

 

Is this solution working for you now without any problems? Generally speaking, it's really amazing how this issue has been unsolved so long time?? 

 

In my opinion, ASM should work without any smallest doubt. At least for me it's NO.1 matter to know how many pieces on each items i have in stock for my clients to sell. Re-ordering from supplier, receiving goods - either completely or partially is a function which is a "must" to work properly.

Link to comment
Share on other sites

  • 4 months later...

Amazing malfunction in Advanced Stock Management (PS 1.6.1.7).

 

After a supplier order is fully received, stock remains unaltered.

 

SOLUTION:

It is needed to specify an unit price for each product in your supplier order, if you let zero price for a product, its stock will not be updated!!

  • Like 1
Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...