BV Commerce Forum
»
BV Commerce Support
»
General Support
»
5.6 - Order Time Stamp Changes Upon Editing
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
My client called me and was wondering why an order jumped out of a sequence after they had adjusted it.
Example order page:
Order 1200
Order 1199
Order 1198
[color=red>Order]
After the edit:
Order 1200
<FONT color=red>Order 1197[/color]
Order 1199
Order 1198
I looked over all of it, asked all the right questions. The only thing that stands out as different is the Timestamp. In the above example, the first order was placed on 3/08/2010. The next two were 3/7/2010 and that last order 3/6/2010. After the edit, the timestamp of the order is now 3/08/2010 which jumps it out of sequence.
Anybody else getting this?
Changing the method in which the order table displays the orders so it's based on order number instead of timestamp is not the solution. In our opinion, the timestamp should be locked forever as it's tied to many important things. |
|
|
|
|
|
|
Rank: Member
Joined: 4/28/2003(UTC)
Posts: 141
|
Its happening on our site to Matt. We are running BV5.6 with updates. Richard www.somethingmorestore.com
|
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
Thanks Richard. Anybody else? |
|
|
|
|
|
|
Rank: Member
Joined: 11/25/2003(UTC)
Posts: 370
|
Looks like there are two date fields in the order table. One is LastUpdated and one TimeOfOrder. From what you post here you are getting results sorted by LastUpdated and it would be better of course to use TimeOfOrder if possible. Could be something else since the edited order did not move to the top. I did however edit a couple orders on a 5.4 version and after saving they still showed in their proper place when viewing /BVAdmin/Orders/Default.aspx |
|
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
Kman, You are correct on the sorting being based on timeoforder however, it's not the real issue in this manner:
The order itself has a time stamp. In this situation, TimeOfOrder has been overwritten with the Last Modified Date. The order was placed on 3/4/2010 and now displays 3/8/2010.
That should never happen.
Potentially..... Entered into accounting system on wrong date. Shipping Emails sent on wrong date. Products not being available for the shipping date because since it's not going to be included in the daily PO's or Packing Slips they're not ordered or gobbled up by another order. Possibly losing the card authorization. etc., etc., etc.
Bottom line, the orginal "Time of Order" should never be overwritten! And I'm wondering if there's a gremlin in 5.6. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
The cause of this is the editing of the order. In order to recalculate discounts, etc. the order is switched temporarily into a non-placed mode to calculate, then back to placed mode after the edit. This causes a reset on the "time of order" stamp.
I've been looking carefully at how we handle edits in BV 6 because of this. Right now, there isn't a quick fix for BV 5 other than my recommendation that you only edit orders that are new and have not been paid yet. That is the safest way to handle things.
Here's what we're doing for BV 6.
1) All transactions (credit card charges, etc.) are logged separately as they are today in OrderPayment objects. This lets us report accurately on actual cash flow on a given date
2) We will only allow editing of orders that are newly received and not yet processed
3) We are building "helper" functionality that will allow you to create a new order based on an old one. For example, if the customer wishes to replace an item in their order we would automatically create a new order with a -1 for the old item and a +1 for the new item. The old order would have be tagged as an update to the original so you can track the history of where this came from.
Any opinions on this would be welcome.
|
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
There's no way to tell the system "please don't reset the original timestamp" without some heavy lifting? |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
I'll look into it again to see if it is possible. If it is possible without ripping the entire order system apart I'll get it into the 5.7 service pack.
|
|
|
|
|
|
Rank: Member
Joined: 12/23/2003(UTC)
Posts: 909
|
Thanks marcus. If it isn't a mega rewrite... that would be nice. |
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
One of the updates caused this problem -- I reported it last August -- Bug 48. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Yes, the problem was introduced in an update. It was introduced during a fix where coupons and offers were not correctly calculated upon order editing. We want to make sure that any correction to the timestamp issue does not reintroduce problems with the calculations.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.