DataFeedWatch Blog | Data feed optimization tips

Exclude a List of Products From Your Data Feed

Written by Jacques van der Wilt | February 5, 2016 12:16:21 PM Z

Do you want to sell more through your shopping campaigns? Removing the unprofitable, seasonal, out-of-stock and low-price products from your shopping feeds is one of the solutions.

Advertising fewer products will ensure that your budget will be spent wisely on the products that are giving you the best bang for your buck.

There are numerous criteria based upon which you can remove products from the feed: seasonality, performance data, price, margins, brands, product types and many more.

 

What do you do when you need to create a rule for products that have nothing in common? They are from different brands or categories, have different prices, colors or other attributes. So there is not a single rule by which you can capture them.

Remove a List of Product From Your Feed

IS IN LIST is another small functionality that makes DataFeedWatch great to work with. You can upload a file with products and use them to create rules, like Excluding them from a data feed.

Most probably you have all these unrelated products already in a list. Armed with it you can make a rule that applies to all products that are in that list:

Let's assume that you have a CSV file with all the unique IDs of all the products that you would like to exclude. You can create a rule that says: Exclude  IF  'id'   is in list and then click the browse-button to select the file with these IDs. This will ensure that all the IDs in the list are excluded from your feed (only on the channels of your choice).

The list of products that needs to be excluded can be either uploaded from your desktop or from an URL (Google Spreadsheets, for example). Check this post if you want to learn more on how to optimize your product feeds with Google Spreadsheets. 

If you later want to quickly see what was in that file, just mouse-over the file name and you will see the content of your csv in an overlay.

There are various ways in which you can exclude a product from the feed and if you want to tap into the potential of excluding products from your shopping feeds we recommend you go over at: How to Exclude Products From Your Feed the Right Way.

Sometimes advertising fewer products will get you more sales. Just make sure to focus your attention on the products that are bringing in the best results.

If you are an online merchant and you have found this post useful, then you will probably find our eBook The Complete Guide to Data Feed Optimization useful.Download it and learn how to improve the quality of your data feed.

Next Read: How Excluding Products From Your BigCommerce Store Can Boost Sales