| Author |
 Topic  |
|
|
Ocean
Junior Member
USA
75 Posts |
 Posted - 10/13/2009 : 12:57:26 AM
|
I just imported a batch of 556 orders. When I went to the multi order screen, I noticed that none of them were properly processed. No approval rules applied. All orders showed approved, but quantity needed as if it were on backorder, but they all had quantity available. No shipping methods were set, and all customer IDs were 0. I freaked out. I sorted by order number, and noticed that a few of the shipping methods changed right before my eyes. I "refreshed" again and more orders changed. So somehow these orders wound up in my database, viewable on the multi order view before they were fully processed. There was maybe a 10 minute delay between when I first opened up the multi order view to when 100% of the orders within that multi order view finished processing from the import.
Is this delay normal or a bug? |
www.costumealibi.com
www.bikiniblvd.com
www.mycostumeworld.com
www.stores.ebay.com/fashionbloom
www.stores.ebay.com/bikiniblvd
|
|
|
Mark Setzer
Administrator
USA
1629 Posts |
Posted - 10/13/2009 : 06:43:23 AM
|
Assuming you are positive no other import process was running, I would believe this is conceivable if SQL Server is under high load, or is otherwise struggling to catch up to OM's transactions, as they don't necessarily occur immediately - writes have to happen in the server's data and log files in a couple different places before they are "live", and OM doesn't necessarily see the results right away if the server's busy with a lot of changes at once.
We see this behavior on occasion when doing writes - in the order import especially - and have worked around it for now by spinning (delaying) during the execution of a couple critical writes to make sure SQL is likely finished with those operations before we start working with the results of the query again. So in a sense this can be "normal," but I believe it is unusual to see it in the manner you describe. I would want you to review that the orders are in fact "fully processed" as you say, looking for any inconsistency in products assigned to the order, customer matching (if IDs are still zero), and so forth. |
Mark Setzer
Stone Edge Technologies, Inc. |
 |
|
|
Ocean
Junior Member
USA
75 Posts |
Posted - 10/13/2009 : 4:07:27 PM
|
| Mark, all things look 100% normal. I don't think this is related, but on the 5th, I was changing approval rules during an import (stupid). We switched shipping carriers from UPS to FedEx, so I had to adjust all our approval rules accordingly. I didn't feel like waiting an hour for the morning import to finish, so I worked on our approval rules during import. That caused an error message during import (I can't remember exactly what it was), but it continued to process the orders. Then all orders came through exactly as I described above, but they never recovered, so I had to manually unapprove each one, then fill backorders, then approve, then change shipping method, and log payment. That was a 13 hour disaster. The workstation that I was using while changing approval rules seems to be "permanently" messed up. All current imports done on that workstation will fail to process at all. I believe I can solve that problem by copying an OM file from another workstation, but I'll wait until after Halloween to experiment. The phenomenon I described above was from an import done on a "good" workstation. |
www.costumealibi.com
www.bikiniblvd.com
www.mycostumeworld.com
www.stores.ebay.com/fashionbloom
www.stores.ebay.com/bikiniblvd
|
|
|
|
kevin
Administrator
USA
2405 Posts |
Posted - 10/14/2009 : 09:05:40 AM
|
Altering import settings in the Order Manager during an order import is definately not recommended as database conflicts are likely to occur causing run-time errors and potentially halting the import process.
Things to consider if a run-time error was encountered early in the processing cycle during order import.
An import is comprised of three stages:
1) Download of data from website to file
2) Import of data from file to database - orders start off as approved, all items in backorder, no transaction, no customer ID.
3) Orders are "processed" - this is where rules are applied, inventory filled, customer association made, transactions recorded, etc.
If a run-time error was hit on one of the early orders in the processing cycle (#3), the system is designed to attempt recovery from the error for the given order, however, depending on the severity of the error, the system may be unable to continue processing due to secondary error conditions. This would leave all of the remaining unprocessed orders appearing as approved, backordered, without customer and transaction.
If this is what you are seeing (based on second post), the best option is to manually delete the unprocessed orders and re-run the order import. DO NOT attempt to process the orders manually! It takes far too much time and you loose the transaction information from the website thus causing a double charge on customer's card - NOT recommended!
If you encounter the error during re-import then a call to tech support is in order to identify and correct the error condition. |
Kevin Smith
Stone Edge Technologies, Inc.
920 Germantown Pike
Suite 112
Plymouth Meeting, PA 19462
610-994-3699 x112
kevin at stoneedge dot com |
|
|
|
Ocean
Junior Member
USA
75 Posts |
|
|
Ocean
Junior Member
USA
75 Posts |
|
|
Barney Stone
Administrator
USA
5517 Posts |
Posted - 10/20/2009 : 08:01:44 AM
|
quote:
[i]Originally posted by Ocean[/i]
[br]What's the best way to delete several hundred orders in bulk?
The best way is to contact Support for assistance. If you want to try it yourself, here's what to do:
NOTE: This is VERY DANGEROUS! If you make a mistake (e.g. start with order 1234 instead of 12345) you could loose thousands of orders that you do not want deleted! MAKE A BACKUP COPY OF YOUR DATA BEFORE PROCEEDING! Also, if automated processes such as charging credit cards, sending emails or placing drop-ship orders were run, you should NOT try to do this yourself!
Go to the Main Menu. Press control/g to open the Immediate Window in the VB Editor. In the Immediate window (usually located at the bottom of the screen, and labeled "Immediate"), type:
eraseorders
just like that, with no spaces. Then press Enter. At the next screen, you can either enter a range of order numbers to delete or check an option to delete all orders from the last order import.
Again, this process is NOT REVERSABLE, so make sure you back up your data file and know what you are doing before attempting it! If you are not sure, call Support for assistance. |
Barney Stone, President
Stone Edge Technologies, Inc.
610-994-3699 ext. 111 |
|
|
|
Ocean
Junior Member
USA
75 Posts |
|
| |
Topic |
|
|
|
Order Processing Delays?
