HomeHome Product Discus... Product Discus...SmithCartSmithCartUpgrade ProblemUpgrade Problem
Previous
 
Next
New Post
11/5/2012 7:13 PM
 
Hi Kevin,
I have set up a new DNN 6.2.4 with Smith Cart 5.20 and then restored the database backup.

I could not see any products in the buy now module but when the page template files were deleted the main shop buy now module presented all products.

My problem is that now my other buy now modules which are used to present idividual categories dont present products.

Is there anything you can think of that would cause this.

Thanks

Robert
www.soapqueen.com.au
 
New Post
11/8/2012 7:11 PM
 
Hi Robert,

The issue is most likely the TabModuleID assigned to the data being migrated from your previous store. each BuyNow module has it's own unique TabModuleID that is saved with the product so you can run multiple stores in your portal with unique categories and products. Also if you delete a BuyNow module and add it again to the page DNN will assign a different TabModuleID.

The easiest/fastest way to import your data after doing a fresh install would be to do the following:

Add your BuyNow module on your new page, where you want it.
Add a single item to the products, so that it shows up on your new BuyNow module.
Look in SQL Management studio, and jot down the TabModuleID for the new item.
Update the data so your old items (with the incorrect TabModuleID) match the new TabModuleID

For Example:
UPDATE Smith_Products SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Categories SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Product_Variants SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)
UPDATE Smith_Orders SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)

so on and so forth.

Thanks,
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartUpgrade ProblemUpgrade Problem