Forums / Managing Customers and Orders / Missing orders - appear upon order num search

Missing orders - appear upon order num search

Views: 838

Results 1 to 5 of 5
15 Jul 2012, 10:11 PM
#1
makenoiz avatar

makenoiz

Zen Follower

Join Date:
Mar 2006
Posts:
284
Plugin Contributions:
0

Missing orders - appear upon order num search

We are missing 2 orders from Admin > Customers > Orders. If we search for this missing order numbers they appear. If we look at the orders in Apsona, they are both there but just completely missing from Admin > Customers > orders page. We many orders and these are the only two instances of a missing order record in admin.

There is nothing at all in common with the orders out side of the fact that they did conclude successfully with no problems. They are both in the database.

Locations, payment type (One free shipper one Visa with Authnet Processor), purchased items, names everything is different from one another so I dont see any commonalities that might cause a problem.

I have looked in the orders table in DB to see if there are any indications - corrupt data? - but nothing. It looks great. I cant explain this and would love some input if anyone has any.

Thanks

Zen Cart v1.3.9h

22 stores and counting! Ive been zenned.

15 Jul 2012, 10:19 PM
#2
makenoiz avatar

makenoiz

Zen Follower

Join Date:
Mar 2006
Posts:
284
Plugin Contributions:
0

Re: Missing orders - appear upon order num search

I did find a commonality: order status = 0. What would cause that? Ill search forum now.....

22 stores and counting! Ive been zenned.

15 Jul 2012, 11:22 PM
#4
makenoiz avatar

makenoiz

Zen Follower

Join Date:
Mar 2006
Posts:
284
Plugin Contributions:
0

Re: Missing orders - appear upon order num search

So the link above was interesting but still does not explain why we have 100+ orders entered just fine and 7 (I found a few more) with orderstatus 0. Im going to scan the db data on these order and see if there is any thing at all to explain what in the order would trigger order_status=0 to be set.

Hope this can help someone else.

22 stores and counting! Ive been zenned.

16 Jul 2012, 2:12 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Missing orders - appear upon order num search

Typically caused by addons which don't properly update the order status, including setting it to 0 because they don't actually define a value for it when storing updates.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.