- Microlancer Beta Tester
- Bought between 10 and 49 items
- Sold between 1 000 and 5 000 dollars
- Europe
- Has been a member for 0-1 years
- Exclusive Author
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?
- Exclusive Author
- Has been a member for 2-3 years
- Microlancer Beta Tester
- United States
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.
- Sold between 100 000 and 250 000 dollars
- United States
- Has been a member for 3-4 years
- Referred between 50 and 99 users
- Bought between 1 and 9 items
- Exclusive Author
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.
