1336 posts
  • Won a Most Wanted contest
  • Has been a beta tester for an Envato feature
  • Has sold $10,000+ on Envato Market
  • Has collected 50+ items on Envato Market
+7 more

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
  • Has been part of the Envato Community for over 4 years
  • Has been a beta tester for an Envato feature
  • Sells items exclusively on Envato Market
  • Located in Pakistan

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.

775 posts Magento Elite & Gravity Maker
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Located in United States
  • Has been part of the Envato Community for over 5 years
+4 more

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.

Helpful Information

  • Please read our community guidelines. Self promotion and discussion of piracy is not allowed.
  • Open a support ticket if you would like specific help with your account, deposits or purchases.
  • Item Support by authors is optional and may vary. Please see the Support tab on each item page.

Most of all, enjoy your time here. Thank you for being a valued Envato community member.

Post Reply

Format your entry with some basic HTML. Read the Full Details, or here is a refresher:

<strong></strong> to make things bold
<em></em> to emphasize
<ul><li> or <ol><li> to make lists
<h3> or <h4> to make headings
<pre></pre> for code blocks
<code></code> for a few words of code
<a></a> for links
<img> to paste in an image (it'll need to be hosted somewhere else though)
<blockquote></blockquote> to quote somebody

:grin: :shocked: :cry: Complete List of Smiley Codes