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”.
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.
DECLARE @StoreID INT = 1
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.