How do I delete products in magmi

Question

I have been using magmi to import products in bulk, but now need to delete some of them.

How can I do this?

Steven Lynn · Accepted Answer · 2014-08-14 20:16:34Z

8

Add a column to your import with this as the header name: magmi:delete

1 is to delete the product 0 is to not delete the product

You want to use the Product Deleter v0.0.2 plugin.

answered Aug 14 '14 at 20:16

Steven Lynn

8981 gold badge12 silver badges24 bronze badges

In my case Magmi tries to Clean flat tables before reindexing. I'm not sure if that causes this error: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction. There is some timelimit with the hosting package so I guess it is related to that. Is there a way to make it work? Already tried to laynt the delete process with magmi.cli.php in shell but with no luck as it seems to fail the delete task too as products are not deleted. – Webninja Sep 15 '15 at 14:03
Hi, what about product resources like "media files" - Are they also deleted from DB and/or filesystem ? Do you have any experiences about this topic ? Regards – domi27 Oct 12 '16 at 15:53

add a comment |

dgitman · Accepted Answer · 2014-08-14 20:31:47Z

6

First you need to enable the Product Deleter Plugin.

enter image description here Then you need to create a CSV, with columns "sku" and "magmi:delete". For example:

"sku","magmi:delete"
"00001","1"
"00004","1"

Then run your import.

answered Aug 14 '14 at 20:31

dgitman

1951 silver badge8 bronze badges

add a comment |

2 Answers 2