Migrating product data and changing the TabModuleID

SmithCart
If you have deleted your BuyNow module or have migrated a site and need to change the TabmoduleID on your products follow these steps:
  1. Add your BuyNow module on your new page, where you want it.
  2. Add a single item to the products, so that it shows up on your new BuyNow module.
  3. Look in SQL Management studio, and jot down the TabModuleID for the new item.
  4. 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_Category SET TabModuleID=(NewNumber) WHERE TabModuleID=(OldNumber)