Moving all of my orders to a new store

[frustrated]

I am moving from one host to another, and into a new installation of ShopSite. I really don't want to lose all of the orders that are in my old store. Is there a way to move these to the new store? The product list is easy enough to download from the old one and then upload to the new one, but there is no option to upload a list of orders.

I tried downloading the orders.xx files from the shopsite-data folder and uploading them in the new store, but they don't show up.

Any help greatly appreciated!

[Jim]

What version of ShopSite do you have?

If it is a newer version all of the orders, product, pages, coupons, customer info etc. is in a file called shopsite_db. You would need to move that file from the old store to the new one. Note that you must use the same authorization file (or at least one with the same serial number, storeid and url ) or you will not be able to see any encrypted data in the new store. The stores also have to be the same version or the databases will be corrupted.

See this section in the help for more information on moving a store. http://shopsite.com/help/8.3/en-US/inst ... intro.html

[frustrated]

They are both shopsite 10, but the old one is Manager and the new one is Pro.

I'd like to move the whole data file, but I worry that won't work due to that difference. Does anyone know the specific files I need to move in order to get the orders moved over?

If not, maybe I can have the new host downgrade me to ShopSite10 Manager, and then upgrade the store once it's moved over.

[Jim]

Did you read my last reply? The order are in shopsite_db.

What host are you moving to? Quite often they will move your store for you.

You should install the new store first and then move the data. Moving from manager to pro should not be a problem as long as your pro store auth file has the same url, storeid and serial number, if it doesn't have the same information any encrypted data will not be usable in the new store that includes order, payment gateway signin, UPS, FedEx, USPS settings etc. Unless the stores are the exact same version of 10 you should upgrade the new store after you have moved the data so that any changes in the new version will be applied to the old data.

You can purchase a store move at http://shopsite.com/support_pricing.html and ShopSite will move the store for you. But as I mentioned earlier some hosts will do it too.

[frustrated]

OK - moving that file got my orders over to the new store!!

Next question - when I click on my order anywhere links in my new store, I get the following error:

Error verifying /usr/home/brushymo/www/cgi-bin/sc/brushy.auth
This store may not be authorized to run ShopSite software. Please contact the merchant or webmaster.

Is this a problem with the new store in general, or do I need to create all new order anywhere links in the new store and update every page of my store? If that's the case, please tell me there is a shortcut for that!

Thanks for your help - it's a little daunting to move, but hopefully this will be over by tomorrow.

[Jim]

If the install path to your new store is not the same as it as in the previous store then yes you will need to modify all order anywhere links to point to the new location.

Go to Merchandising > Order Anywhere and select a product and look at the add to cart link url. That is what it will have to be changed too on you store pages. Usually you can just do a Search and Replace in a text editor and make the changes fairly quickly.

Was the login name for your old store brushy? Is that the login name on the new store? If not you will also need to get a new auth file with that as the storeid. And make sure that the serial number is the same in both stores also. You can find the Serial number for your store on the Preferences > Hosting services screen near the bottom. If that screen has been blocked by your host you can run another cgi that will display the auth file for your store. On the main ShopSite screen replace the start.cgi in the url with diagnose.cgi and hit enter. A diagnostic screen will display and your auth file will be about 2/3 of the way down the page. The last line of the auth file will be something like http://www.yourdomain.com/store:brushy: ... 2:99990002 The yourdomain name should be the same in both the old and new auth files.
The serial number will be the first number, in this case 0001108372 The second number indicates which host you are with and the 2 at the end of the 99990002 indicates the store is a Pro level store. So if you moved to a different host and the last number is the same except for the 2 instead of 1 at the end you did not get your auth file from the new host. Note that this file is encrypted so you can't just change the last line to change the authorized url or to make it a different level, as that would corrupt the file.

[frustrated]

Thanks for your help. The stores have changed logins and serial numbers, so it looks like I'm going to go through and manually change all of my order anywhere links.

I really appreciate you walking me through the ins and outs of this.

[Jim]

Glad to help out. Before you change them all you might want to just change a couple and make sure that they work. Note that you will not be able to view any payment information for old orders in your new store, What was ordered and the person's name and address info will be visible but nothing else. Also if you move over Payment gateway setting, had a real time shippng option enabled, you will need to reconfigure those.