If you need to export product and order data from your old shopping cart system to smith cart.

In SQL Management Studio

1. Connect to the database you are exporting "from" or importing “to”
2. Right click on the database you are exporting from to start the Import/Export wizard
3. Select the "Tasks" item, then either click on the "Import Data..." or "Export Data..." menu item.
4. Follow the wizard

Here are the cart tables that contain data that needs to be backed up:

Smith_Products
Smith_Product_Variants
Smith_Categories
Smith_CategoryProduct
Smith_Manufacturer
Smith_Orders
Smith_OrderDetails
Smith_Customer
Smith_PayHist

Here is a good link that explains how to export/import data using SQL Server:
http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

I recommend exporting to sql server tables instead of flat files or xls because you will encounter less data type conversion errors when importing the data to the cart tables if you are importing sql server to sql server.

If you have your database in xls you can also use the smithcart import feature

Hi David,

Due to the gap between versions, you may run into data conflicts when re-importing your existing data to a newer release as new fields are added in almost each release of the cart and are initialized properly when populated thru the sc ui.

I recommend a fresh install of the same version of the Cart you are running now (4.67) on a clean install of DNN and use the instructions above to export then import your data. Once the data has been moved, then you can go ahead with the upgrade which should properly initialize any new fields.

Both the data backup and import as well as clean install with data backup instructions are outlined in the following forum post: http://www.smith-consulting.com/Forum...

We can also migrate the store data for you if you purchase the Module Upgrade Service located at the following link - https://www.smith-consulting.com/pd/P...

Important: When upgrading, it is always recommended that you first do the upgrade in a test environment and make sure you have a full backup before installing on your live site in case you need to rollback.

Hope this helps!