Hi Michele,
- Install RazorCart
- Create a store using the Admin-Console (1st created store will have StoreID = 1, if not sure the url will end with the store id: “/DesktopModules/RazorCart/AdminConsole/Home/Index/1”)
- Run the following in DNN SQL Console to link the old tables with the created 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
Please let me know if you have any further questions.
At your service,
Kelli, SC