Restoring Deleted Products

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   How do I restore a deleted product?
I exported the deleted products thru Custom Data Export
There's a field that says Removed/Deleted
I changed the number from -1 to 0
However, when I go to Import Wizard, it asks me to Map Fields, I mapped SKU to SKU, but how do I map Remove/Deleted? There is no match for that option, and if I leave it blank it doesn't restore anything.
The wiki just says to import it back, but doesn't explain how.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
TruSake Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-November-2009 Status: Offline Points: 15	Post Options Post Reply Quote TruSake Report Post Thanks(0) Quote Reply Topic: Restoring Deleted Products Posted: 06-January-2012 at 10:00am
	How do I restore a deleted product? I exported the deleted products thru Custom Data Export There's a field that says Removed/Deleted I changed the number from -1 to 0 However, when I go to Import Wizard, it asks me to Map Fields, I mapped SKU to SKU, but how do I map Remove/Deleted? There is no match for that option, and if I leave it blank it doesn't restore anything. The wiki just says to import it back, but doesn't explain how.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 06-January-2012 at 11:40am
	If it's just a few products, and if you have access via SQL Studio, I'd just go hit the records directly and avoid using the import tool.

TruSake Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-November-2009 Status: Offline Points: 15	Post Options Post Reply Quote TruSake Report Post Thanks(0) Quote Reply Posted: 06-January-2012 at 1:16pm
	nope, no access to SQL studio, need to use import

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 06-January-2012 at 1:20pm
	If the host is Godaddy, they have SQL access via the control panel. If not Godaddy, are you totally certain about the answer? Who is the host?