A client of mine has an offline order fulfillment system that I developed for her. I'm now adding the ability to download Ubercart orders from Ubercart's mySQL back-end. The difficulty I face is in knowing how to query for "all new orders since the last time I checked." An Ubercart order, once downloaded, will not undergo any further processing within Ubercart; thus, its status will not change after this point. (Once an order has moved through check-out and is paid for, its status becomes "Payment_Received" - and this is one criterion I use when selecting orders to download.) For obvious reasons I don't want to simply download all "Payment_Received" orders each time and figure out which ones are new.

The easiest thing to do would be to somehow flag an order when it's downloaded. Can I add a custom status; say, "Downloaded"? or can I add a column in the uc_orders table to hold the flag?

Thanks,
Chap