AbleCommerce Shopping Cart Software

Does this change the timestamp on records being INSERTED into the database?

In database we store datetime in universal time without timezone offsets. Timezone information is stored as store setting. When you insert a product it will convert local date time to universal time and similarly when you load it will convert back to local time using time zone information.

Ok, thank you. Apparently the time on the server is off.. when you insert a row do you get the time from sql or from the webserver?

From web server.

I had a issue with this on reports.. I was trying to compare sales reports to what I downloaded into quickbooks. I could not get quickbooks and the AC reports to have all of the orders match as to which day the orders where placed. I could change my timezone settings to get dates to move around on the AC reports but I would always have at least 1 invoice up or down a day still. If quickbooks transfer is using the date in the DB is there some way to get the reports to use that same date?