Hoping you can help. I am looking to create a feed to power my text ad campaigns.
The quirk is, I need it to look at all product variants and show the lowest price. So in a case of a fashion retailer with a certain t shirt, if the red version is £9.99 and the blue and white is £14.99, it knows to pull the £9.99 price point in the feed.
It should be a case of looking at all the products on that url and looking up the lowest price point.
We use datafeedwatch for the creating the feed. The challenge is, does anyone have an app that exports out all products, the sku number, its price and the url into Google sheets, and can be scheduled to run every day?