Missing order in Shopsite?

General ShopSite user discussion

Missing order in Shopsite?

Postby tahoemountain » Thu May 15, 2008 9:58 am

We recieved an order, paid by credit card and everything. The order is not showing up in our shopsite orders screen and it did not import into my order manager. There is simply a gap in the number sequence in the shopsite order screen.

The credit card transaction is in my Authorize.net account and we recieved an email confirmation just like we do for all other orders from shopsite through our email program.

Anybody know why this would not be showing up in shopsite?
tahoemountain
 
Posts: 11
Joined: Tue Apr 01, 2008 12:40 pm

Postby Jim » Thu May 15, 2008 11:22 am

You will probably need to contact your host to see if the order can be found.

When an order is placed a small order database is created with the name in the format iorder.????.new where the ???? is the order number. This file will be in the data/ip directory for your store. When you go to the backoffice and view orders or download orders the file is sucked into the main orders database and the file is renamed to have a .done extension so it would be iorder.????.done.

If there is a problem with the order file it may be renamed to iorder.????.bad. If an order is accidentally deleted from the backoffice of the store before you have processed it you can rename the iorder.????.done file to iorder.????.new and retrieve it again. These .done files are kept for about 1 week and are then purged. So you only have a few days in which to recover the data if you delete an order.

If the order has a .bad extension then there may a problem with the file and it might not be recoverable. You could rename it to .new and see if it will then be retrieved as a valid order. It this doesn't work you would need to have ShopSite see if they can recover data from the order. This may or may not be possible so if you have the email receipt it would be easier to just process the order from that.

So if you don't have direct access to your stores data directory to try these things you will need to have your host do it for you.
Jim
Site Admin
 
Posts: 4953
Joined: Fri Aug 04, 2006 1:42 pm
Location: Utah

Awesome

Postby BRITANUCK » Tue Jan 27, 2009 11:06 pm

Thank you!

I've had about 4 of these now, and its been a pain each time not knowing how to fix it...

changed the .bad file to .new and worked a charm

:)
BRITANUCK
 
Posts: 32
Joined: Wed Dec 05, 2007 10:47 am


Return to User Forum

Who is online

Users browsing this forum: No registered users and 105 guests