X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   General questions (X-Cart 5) (https://forum.x-cart.com/forumdisplay.php?f=66)
-   -   Backorder / Preorder problems... (https://forum.x-cart.com/showthread.php?t=76159)

kevinrm 04-04-2018 08:11 PM

Backorder / Preorder problems...
 
I'm not sure why the last thread on this topic was locked but problems remain.

We hare having a few issues with the backorder /preorder module. I put in a ticket for this.

1) Person orders 6 items, of which 4 items are backordered. The remaining 2 items which are NOT backordered, however, are NOT removed from inventory properly - they should be. Changing the shipping status of this order from backordered to shipped doesn't change anything, the 2 items are never removed from inventory. This totally screws up our inventory.

This is causing us major inventory issues because we are running a sale and so far we have over 100 orders and they are mixed up, some of these have backordered items along with non-backordered items within the same order. Why this does not take the inventory of the non-backordered products?

2) As someone else mentioned, under Orders >> Backordered products there is a huge list of orders with backorders pending. The problem here is we used this module LAST year as well, all of those backorders were eventually shipped. However, this list still shows every single order which has ever had a backordered status, even from last year - all of which have been shipped long ago. So now this list is getting extremely huge - there is no pruning or way to remove last year's backorders. Once the order has been shipped and is no longer in backorder status, it should be removed from this list but no.

qualiteam 04-09-2018 10:49 PM

Re: Backorder / Preorder problems...
 
As far as I see our support engineers have replied on this in the HelpDesk.
Just in case someone faces the same problems, I'm copying the answers into there:

Quote:

1) Person orders 6 items, of which 4 items are backordered. The remaining 2 items which are NOT backordered, however, are NOT removed from inventory properly - they should be.

This was caused by missing database records (which for some reasons were not imported during the module upgrade).

Run the following SQL query:
Code:

SELECT p.id, p.payment_status_id, ps.code AS 'payment_status_code', p.shipping_status_id, ss.code AS 'shipping_status_code', p.incStock FROM xc_order_status_properties AS p LEFT JOIN xc_order_payment_statuses AS ps ON ps.id=p.payment_status_id LEFT JOIN xc_order_shipping_statuses AS ss ON ss.id=p.shipping_status_id;

If you don't see records with "BO" in the 'shipping_status_code' column, then it is the case.

To re-run the module upgrade hook use the following command in an SSH terminal to your server:
Code:

php xc5 utils:runHook classes/XLite/Module/QSL/Backorder/upgrade/5.3/5/post_rebuild.php

You may check if the "BO" records appear in the database after executing this script.

Quote:

2) As someone else mentioned, under Orders >> Backordered products there is a huge list of orders with backorders pending.

This seems to be caused by the use of custom order statuses. The module drops the "backorder" flag for orders when their status changes from "Backorder" to any of the built-in statutes. Since you switched the status from "Backorder" to a custom one, the module failed to catch that moment and decided to not update the flag.

The developer will try to revise this logic in future versions of the module.

For now, as a temporary solution, you can manually switch the status back to "Backorder" and then to any of the built-in statuses ("Shipped", or "Delivered").
This should help.

KevTheIrish 06-08-2018 08:08 PM

Re: Backorder / Preorder problems...
 
@qualiteam

Quote:

This seems to be caused by the use of custom order statuses

Has this been addressed yet? I see the post is a few months old....


All times are GMT -8. The time now is 07:36 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.