AbleCommerce Shopping Cart Software

Hi there..

we are manually keying in a few entries between our data import and time to cut over and I forgot to set the new servers time back to last month so the transactions would be in the right month..

I was taking a look at ac_Orders selecting OrderDate where OrderId was > = to the order number I started entering.

So the question(s)..
1. Is it ok if I simply do an update on these OrderDate times or will it mess things up somewhere else

Select OrderId,OrderDate
FROM ac_Orders
WHERE OrderId >

2. I Noticed the time is to the either to the clock tick or 1/10000 os a sec "2010-04-08 00:05:00.320"
will it mess things up if multiple orders are the same time / value?

3. Is the same true that it's ok to Edit the ac_Payment field PaymentDate

Select OrderId,PaymentDate
FROM ac_Payments
WHERE OrderId > =

I've read that editing ac_OrderShipments field ShipDate was ok but I'm not sure about these other two dates
Thank you

Luke

Ok well everything appears to be ok after update the OrderDate first the the PaymentDate then ShipDate

My update query for any one that is not up on SQL that I ran in the Microsoft SQL Server Manager query window was

UPDATE ac_Orders
SET OrderDate = '2010-03-28 10:10:21.087'
WHERE OrderId Between 3840 AND 3855

and

UPDATE ac_Payments
SET PaymentDate = '2010-03-28 11:10:21.087'
WHERE OrderId Between 3840 AND 3855

I'm a little complexed as to the time reference perhaps that's because of GMT but an entry of 22:00:00.089 seems like 2 or 4 pm while we with our server in MST

Luke