I just deleted a product and created a new similar one but I didn't think that the product ID would be a new one. I have created links to this product page whose ID is #37. The new ID is #39.
Is there any way to change the #39 to #37, so I will not have to edit my web links to #39?
Results 1 to 6 of 6
-
7 Apr 2010, 01:42 AM #1
New Zenner
- Join Date
- Apr 2010
- Posts
- 7
- Plugin Contributions
- 0
How to change product ID for new created product to the one that was deleted?
-
7 Apr 2010, 05:45 PM #2
New Zenner
- Join Date
- Apr 2010
- Posts
- 7
- Plugin Contributions
- 0
Re: How to change product ID for new created product to the one that was deleted?
ok, I found the solution myself.
go to phpMyAdmin ---> Table: products ---> products_id
Just edit the products_id
-
Re: How to change product ID for new created product to the one that was deleted?
Um ... bad idea ... cuz now everything else related to the details of that product is now out of sync, like the description, the categories it's linked to, all its attributes, everything.
If you're gonna muck around in raw database tables, at least go study the relationships between all the other tables which interact with it.
A starting point for that would be here: http://www.zen-cart.com/wiki/index.p...atabase_Schema.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
7 Apr 2010, 06:10 PM #4
New Zenner
- Join Date
- Apr 2010
- Posts
- 7
- Plugin Contributions
- 0
Re: How to change product ID for new created product to the one that was deleted?
oh yes, you are right, the product was dissappear from its category but can be accessed by direct-linking to it.
any suggestions for further editting?
-
Re: How to change product ID for new created product to the one that was deleted?
You'll have to fix the product number everywhere else that the old number is used anywhere in the database.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
7 Apr 2010, 06:16 PM #6
New Zenner
- Join Date
- Apr 2010
- Posts
- 7
- Plugin Contributions
- 0
Re: How to change product ID for new created product to the one that was deleted?
ok, i'll try that
thanks.
Reply With Quote
Similar Threads
-
v151 How do I change the URL for my site to the new one for GC's Emails?
By Bikerstuff in forum General QuestionsReplies: 6Last Post: 16 May 2014, 11:47 AM -
how to prevent image from being deleted when a product is deleted?
By denniszc in forum All Other Contributions/AddonsReplies: 7Last Post: 7 Mar 2013, 03:01 PM -
When I add a new product another product in the same category gets deleted!
By advhealth in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 17 Jan 2013, 01:03 AM -
how to undisplay the new product for that month from zen-cart?
By wufoxuan in forum General QuestionsReplies: 1Last Post: 6 Mar 2010, 01:01 AM -
Add a new product to cart that is created dynamically
By iamromeo007 in forum General QuestionsReplies: 3Last Post: 1 Apr 2007, 02:37 PM
Bookmarks