HLT Posted March 11, 2003 Share Posted March 11, 2003 Current Situation: Website with hundreds of links directly into current OSC store product pages. (example. pages linking to rogaine in the store go to: www.me.com/osc/blah.php?productID=22) Action Taken: Upgrade to MS1. New Product ID's are assigned by new store. (example. rogaine is now: www.me.com/osc/blah.php?productID=10). Not our choice, just what happened. Dilemma: hundreds of links take user to productID=22 for rogaine. rogaine is now productID 10. What is the most effective way to redirect users to the new ID? Id prefer anything that does not involve manually putting code onto the pages of the store. My programmers are opting for this method but I want as FEW code customizations as possible. Seems like there would be server redirects or database redirects, or maybe we can simply change the Product ID using PHPMYADMIN ? HLT . www.hairlosstalk.com Consumer Hair Loss Information & Support Link to comment Share on other sites More sharing options...
loxly Posted March 11, 2003 Share Posted March 11, 2003 How were the products transferred between stores? Did they have a unique ID in the old store? I would think you can go in and change the id's in mysql. [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
HLT Posted March 11, 2003 Author Share Posted March 11, 2003 Actually we just set up a brand new store and I manually entered them all, which coincidentally gave them new ID's. Anyone confirm whether one can go in and just modify the number using PHPMYADMIN on the sql database? HLT . www.hairlosstalk.com Consumer Hair Loss Information & Support Link to comment Share on other sites More sharing options...
loxly Posted March 12, 2003 Share Posted March 12, 2003 Ah. I plan to use Easy Populate to transfer to the new store, after I check to make sure the tables and field names are the same. I assume that they are for the established product fields. [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
Ajeh Posted March 12, 2003 Share Posted March 12, 2003 Actually we just set up a brand new store and I manually entered them all, which coincidentally gave them new ID's. Anyone confirm whether one can go in and just modify the number using PHPMYADMIN on the sql database? HLT Is it too late to reload the all the product tables and category tables from the old store to the new store so the product_ids match? Link to comment Share on other sites More sharing options...
HLT Posted March 13, 2003 Author Share Posted March 13, 2003 Yes. This isn't an option. I don't want the buggy old store (very old version too) to be incorporated into the new store in any capacity, code or databases. We came up with a solution that does a redirect for the products. HLT . www.hairlosstalk.com Consumer Hair Loss Information & Support Link to comment Share on other sites More sharing options...
Ajeh Posted March 13, 2003 Share Posted March 13, 2003 And as we all sit hanging in suspense ... :shock: What was the solution? :D Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.