Upgrading from SmithCart to RazorCart

RazorCart and SmithCart are separate modules and can run side by side in the same portal.  RazorCart uses the same database and tables as SmithCart, so upgrading is easy.   This article assumes that you already have both SmithCart and RazorCart installed.  RazorCart requires DNN 8.03 and above.  You can view a full installation guide here.

Step 1 - Add a New Store

Once you have installed RazorCart, Navigate to the DNN Admin Menu and select RazorCart Admin Console.
Once in the RazorCart Admin console, you will want to create a new store:
The first store you create will have StoreID = 1.  If you are not sure, go to the RazorCart admin console and look at the url, it will end with the store id.  For example, “/DesktopModules/RazorCart/AdminConsole/Home/Index/1”.

Step 2 - Run the following SQL Statement

Navigate to the DNN SQL Console and run the following SQL statement.  If your StoreID is not "1", then replace the first line of the SQL below with your StoreID.


UPDATE {databaseOwner}{objectQualifier}Smith_Products SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ProductTemplate SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Category SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_EmailCampaign SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Coupons SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Customer SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_EmailTemplateSC SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipCategories SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipFree SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipMethods SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_InvoiceTemplate SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByAmount SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByQuantity SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByWeight SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Manufacturer SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShippingByZipCode SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Analytics SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_ShipZone SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_OrderDiscounts SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_PayHist SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_StoreOrders SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_PaymentMethodsZones SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_PriceClass SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_SubscriptionSC SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_Tax SET StoreID = @StoreID

UPDATE {databaseOwner}{objectQualifier}Smith_TaxStates SET StoreID = @StoreID

After you run the SQL statement above you should see all your SmithCart data in RazorCart.
If you have any questions, please Contact Us.

Add Feedback