I am extending the ecommerce system and so I'm trying to understand the auditing system.
What has me confused is why is there no audit tables on ec_orders or ec_financial_transactions where as almost every other ec_table has an audit table.
It is my impression that auditing ecommerce was somewhat of an after thought. It was never fully implemented, has a crappy interface. And as far as I know, hardly anyone uses it.
When I worked on ecommerce I left this portion largely as I found it.
I haven't looked at the e-commerce package since ACS 3.something, but my memory is that the audit tables are to answer questions like "who cut the price of gizmos on Jan 16?" and "when did widgets start costing $46?"... in that case there's not much point maintaining a history of the orders and transactions tables, because the data in them should be pretty much insert-only...
