Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Backorder / Preorder problems...

 
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 04-04-2018, 08:11 PM
 
kevinrm kevinrm is offline
 

X-Wizard
  
Join Date: Aug 2003
Posts: 1,003
 

Default 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.
__________________
X-Cart 5.4.1.39 Live
PHP 7.4.33
5.5.5-10.3.38-MariaDB MariaDB
Apache 2.4
CENTOS 7.8 64Bit Single Quad-Core E3-1241v3 3.4Ghz 8M 1600 w/ HT
32GB RAM 2x 512GB Samsung 850 Pro SSD RAID 1
Reply With Quote
  #2  
Old 04-09-2018, 10:49 PM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default 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.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following user thanks qualiteam for this useful post:
kevinrm (04-12-2018)
  #3  
Old 06-08-2018, 08:08 PM
 
KevTheIrish KevTheIrish is offline
 

Advanced Member
  
Join Date: Feb 2018
Posts: 50
 

Default 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....
__________________
n0000b rockin 5.3.4.5
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > General questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 11:45 AM.

   

 
X-Cart forums © 2001-2020