Is there any way to delete multiple products by filtering with SKU? I have around 1000 products that I want to delete.
The fastest way to do it is to run this query directly.
Everything should cascade nicely. attribute values will be deleted, category relations will be deleted, upsells, crosssells and related and so on.
Kevin S, you can delete product by csv file. Just follow the billow step
Step 1 :
Create a csv file and past the skus which you want to delete from system. Give the file name as skus.csv
Step 2 :
Create & replace a php file in your root directory. Then past the following code
Note : I recommended to you before run this code you must get the backup. I hope its will be help you.
All due respect to Marius, but please don't interact with the database directly if it's at all avoidable. Maybe the related tables will be updated automatically, if your release of Magento and all your extensions are bug-free in all the right places. But if they're not, that sort of thing can destroy your site.
Instead, you can use Magento's own CSV import feature.
Just list your SKUs in a file, simple as:
...etc. Then save as a CSV file.
Then, in System > Import/Export > Import, select Entity Type: Products and Import Behaviour: Delete Entities, and import this file. And that's it!
The none code way
In the admin section under
Then once you have filtered by SKU you can use the checkboxes on the left hand side to select all the items you wish to delete.
Once you have selected the items you want you can use the mass action button on the top right hand side of the grid and select the delete option.
This will prompt you to make sure you a sure you want to delete these items. After selecting yes to this pop-up it will proceed to delete your items. Depending on your index settings you may have to run a re-index after this process.
You can do it programmatically. Here is the code