737 posts
  • Author had a Free File of the Month
  • Grew a moustache for the Envato Movember competition
  • Sold between 10 000 and 50 000 dollars
  • Exclusive Author
  • Beta Tester
  • Microlancer Beta Tester
  • Bought between 50 and 99 items
  • Referred between 1 and 9 users
  • Has been a member for 1-2 years
+1 more
greenline says

Hi guys,

I am searching for a quick advice if possible….

I accidentally deleted a product from a magento e-store, how can I quickly restore it without restoring the entire database backup? There are 2100 products, I only need the product with id=1 restored…

Any idea of how I can do that? Any Magento extension or something?

25 posts
  • Exclusive Author
  • Has been a member for 3-4 years
  • Microlancer Beta Tester
  • Pakistan
Ornlu says

There is TrashCan.. but it wont work if you deleted the product already :(

Would have suggested something like mysqldump --databases X --tables Y --where="product_id = 1" but since Magento has a complex database architecture, product info is spread across many tables. So its only going to introduce more problems.

543 posts Magento Elite & Gravity Maker
  • Elite Author
  • Sold between 100 000 and 250 000 dollars
  • United States
  • Has been a member for 4-5 years
  • Referred between 50 and 99 users
  • Bought between 1 and 9 items
  • Exclusive Author
GravityDept says

If it’s just one product, then save yourself a million headaches and just create it again from scratch. It’ll only take 2 minutes. Fussing with DB diffs is going to wreck your week.