How to Filter, Remove, or Exclude a Large Batch of Products by ID
- Prepare a list of product IDs in your favorite spreadsheet or text editor
- Only one identifier is needed per product
- You can select any identifier field that is added to the feed on the Define Fields page
- Ensure that there is one product ID per line
- Duplicates and blank lines are OK (will be ignored)
- Product IDs are case-sensitive and should not have any leading or trailing spaces
- Select the list of product IDs in your application and copy them to clipboard.
- Go to My Account
- Click Manage for the desired feed
- Click Product Filters
- For Criteria, select the identifier field, e.g. 'id', and equals as the comparison operator
- Paste the product IDs into the text box
- Click the Add Filter button
A separate filter will be created for each ID in the list. You will see a warning for duplicate IDs, and only one filter will be created for that ID.
There is no limit to the number of filters you can add. However, if you have over 5000 filters, the filters page will become difficult to work with. Check the other articles in this topic for better techniques.