orders.dbf problem

[Kent Multer]

Hi folks --

I was just doing some troubleshooting on a client's site, and I noticed something weird. The orders.dbf file seems to contain every order that's been placed, all the way back to #1001. But in the admin, only the last few months of orders are listed. I guess that somehow, the old batches got deleted from Batches.dbf, but the orders themselves were not deleted. So:

- does anyone know how this happened? Seen it before?

- any recommended fix, other than just going in and manually deleting the old orders (and orderitems, and ordercharges)?

Thanks --

[Vic - WolfPaw Computers]

To my knowledge, orders.dbf has always kept a complete history of orders.

[Kent Multer]

No, normally, when you delete a batch, it also deletes the orders.

[wcw]

What is in the batch field of the order.dbf for those that did not get deleted?

[Kent Multer]

All the order.dbf records have valid-looking batch numbers, starting with 1. Batches.dbf has entries for batches going all the way back to 162, which was created in Feb. 2005. But the Miva admin only shows batches going back to October 2006.

"Curiouser and curiouser ..." The store has OUI, so I tried checking in OpenOrders. Here I can see all the batches that are listed in batches.dbf. Some of the older ones are marked "closed," which have something to do with why admin doesn't show them. I never noticed before that batches.dbf has a CLOSED field. What is this used for?

It still doesn't make sense to me why closed batches would be hidden from admin users. And none of this explains why there are lots of even older orders, whose batches have been deleted, so that they can't be viewed either by admin or OUI. Any thoughts?


Thanks --

[Vic - WolfPaw Computers]

Setting the closed flag just hides it in Admin.

[Kent Multer]

That's a new one on me. Is there a way to close or "un-close" batches in admin?

[Vic - WolfPaw Computers]

Only 2 ways I know of are manually editing the database and removing the flag, or with Truxoft's UltraBatch which contains a function for managing closed batches.

[Kent Multer]

This client doesn't have Ultra Batch ... but I see that OpenBatches allows you to turn the Closed flag on and off, so I suppose that's what the client's been doing.

Thanks --