PPCDATAFEED

How to remove out-of-stock products from Google Shopping

Add a condition to the feed export that keeps only products in stock. Nothing is deleted, and products return by themselves when back in stock.

Google disapproves ads that send people to products they cannot buy. Filter them out in the export itself: other channels keep their own rules, and nothing is deleted.

  1. Go to Feed exports and open the export for Google (or create one).
  2. Under Filters click Add condition, pick the field availability, the operator Exact match and type the value your store uses for products in stock - for example in stock.
  3. After filters at the top shows at once how many products stay in the feed.
  4. Click Save. From the next update on, only products in stock are in this feed.
Feed export “Google Shopping - in stock”: data source Demo store, feed type Google Shopping, Total products 48, After filters 40 (83%); Filters - WHERE availability Exact match in stock

Example

  • Catalog: 48 products, 8 of them out of stock.
  • Google feed after the condition: 40 products - all in stock.
Check the exact value first in the data source Products tab: stores write it as in stock, instock, 1 or yes. If several values mean the same, use Contains any of with one value per line - for example in stock and instock.

To leave the products out of every feed instead, use a rule with Exclude the product - see What a rule can do. More about exports: Create a feed export.

Still stuck? Write to info@ppcdatafeed.com - we answer ourselves and can set it up with you.