newcomer Posted February 19, 2016 Share Posted February 19, 2016 (edited) 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. https://www.prestashop.com/forums/topic/478085-advanced-stock-management-supply-order-does-not-add-stock-at-all/ https://www.prestashop.com/forums/topic/479413-advanced-stock-management-supply-order-is-not-updating-quantities/ https://www.prestashop.com/forums/topic/481653-no-partial-delivery-in-1612-stock-management/ https://www.prestashop.com/forums/topic/1568[spam-filter]understanding-advanced-stock-management/ https://www.prestashop.com/forums/topic/282625-stock-will-not-auto-update-after-receiving-supply-order/ https://www.prestashop.com/forums/topic/316173-advanced-stock-man-and-supply-order-broken-in-16/ https://www.prestashop.com/forums/topic/336474-1606-advanced-stock-management/ https://www.prestashop.com/forums/topic/318609-supply-orders-and-statuses/ https://www.prestashop.com/forums/topic/158246-supplier-order-system/ https://www.prestashop.com/forums/topic/290335-stock-supply-orders-and-stock-management-do-not-work/ https://www.prestashop.com/forums/topic/288896-adding-stock-through-a-supply-order-does-not-work/ https://www.prestashop.com/forums/topic/199983-advanced-stock-management-supply-orders-problem/ https://www.prestashop.com/forums/topic/198620-multishop-stock-quantity-problems/#entry989340 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 http://forge.prestashop.com/browse/PSCSX-6628 - read comments https://github.com/PrestaShop/PrestaShop/commit/357a626de37f636b916e4e1b1692fe00f0fff0bc http://forge.prestashop.com/browse/PSCSX-1453 - read comments 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 February 19, 2016 by newcomer (see edit history) Link to comment Share on other sites More sharing options...
newcomer Posted February 19, 2016 Author Share Posted February 19, 2016 I did notice that in Supply Order mode, one cannot set if the product is *Usable for sale like how it can be set if one were to the clumsy Stock Management>Add Stock.Perhaps this might be a bug? Supply Order disabled qty for sale by default? Link to comment Share on other sites More sharing options...
newcomer Posted February 19, 2016 Author Share Posted February 19, 2016 (edited) 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. Edited February 19, 2016 by newcomer (see edit history) Link to comment Share on other sites More sharing options...
cleaner Posted April 30, 2016 Share Posted April 30, 2016 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 More sharing options...
PrestaImport Posted September 28, 2016 Share Posted September 28, 2016 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!! 1 Link to comment Share on other sites More sharing options...
dandumit Posted April 13, 2018 Share Posted April 13, 2018 Hi, I have an issue as well with ASM : IF an order it's received before supply order then quantity sold it's not subtracted from quantity supplied . Do you have any ideea why ? Regards, Daniel Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now