In commerce_reports, we use the "created" timestamp on an order to produce sales reports. This is better than the other alternative, changed, which could be anything (moving from processing to completed for example). The problem with this is when someone creates an order 3 days ago and finally checks out, the sale goes into the report from 3 days ago. Ideally we'd store the checkout -> processing timestamp in the core schema ...

Comments

rszrama’s picture

I configured this through Rules for my eCommerce site: http://www.bywombats.com/blog/01-24-2012/updating-completed-order-timest...

aidanlis’s picture

Brilliant, that will do

rszrama’s picture

Status: Active » Closed (won't fix)

Closing this particular issue out in favor of my recommendation above, and I'm pretty sure there's another issue open elsewhere for figuring out how to better track these state transitions in 2.x.

imiksu’s picture

Please consider to have completed timestamp column in 2.x :)

Nice post btw! Thanks!

rszrama’s picture

I think they're in the roadmap as "revision tagging".