How to Easily Import Products from Affiliate Data Feeds into a WooCommerce Shop

- written by

If you have a client that is looking to build a huge affiliate site using WooCommerce, Datafeedr just might be your solution.

It lets you import affiliate products directly into your WooCommerce store, allowing you to take advantage of both what WooCommerce can do and the power behind your WordPress site.

It also allows you to search for products you want to promote across the various networks and merchants you are affiliated with.

One cool feature is the ability to display price comparison on product pages easily.

Datafeedr – Easily Run Your Affiliate Marketing on WooCommerce

I have installed datafeedr with the WooCommerce Importer, Product Sets and Comparison Sets add-ons. The first thing I will do is, under configuration, add my ID and Key. Also, if you use Awin, Zanox, Amazon, Patnerize or Effiliation, you will need to add additional IDs and Keys.

If you are using the WooCommerce importer plugin, it will not import Amazon products. But as I will show you in a bit, if you have Amazon products in your WooCommerce store, you can use the Comparison Sets plugin and will need to set the Amazon API for that.

configuration of datafeedr

Adding Networks

At the top of the previous page, you were asked to select your affiliate networks. Here is the full list of networks datafeedr works with:

I simply choose the networks that I am an affiliate of and add my affiliate ID (which is easy to find), save and I’m connected. Below is an example:

Adding Merchants

Next I will add some merchants. Datafeedr supports more than 14K merchants in 30+ networks. But all merchants are not available. There are four reasons that you might not find your merchant:

  • They don’t offer a data feed.
  • Datafeedr has not applied to the merchant’s program.
  • Their application was not accepted.
  • The merchant’s feed is sub-standard and doesn’t work well.

If you do not find your merchant, you can contact datafeedr and they will do their best to add them to the system.

Here is the list of merchants I have connected with:

With each network, I will search for merchants to add to my lists. For this example, assuming I sell small kitchen appliances, I have added three merchants through Commission Junction. (I also added some in my other networks.)

Adding a Product Set

Next, I need to search for the products to add. You will see that they will automatically be added as a WooCommerce product.

Searches can really be refined and you can add multiple filters to narrow down your search.

At this point, I can either add single products or create an entire category of products through the selected merchants. Let’s say we want to add a category for coffee makers. As you can see, we get a total of 886 results:

search for coffee makers

I’m going to filter this down to show only products that are on sale and that have an image and want to remove any duplicates from the same merchant. This takes me down to 38 products.

If I scroll down, I find that in my results I also have filters.If I I don’t want these added, I can do a couple of things. First, I can simply remove them one by one, or I can add an operator in my search to exclude the word filter. This can be done on as many words as needed. An example might be some kind of electronic product that also includes adapters, cords, etc., in the results.

You will see that with these exclusions, I am now down to 28 products, all coffee makers.

Now I will Add as Saved Search. You can see that I can update the saved search as well. You will want to save the search as datafeedr will update your product set every couple of days. This makes sure prices are up to date and it will also automatically add any new products a merchant might have added that meet your search requirements.

Next, I will add a WooCommerce category to import these into and select it.

Lastly, I am ready to publish and have these imported as WooCommerce products. They are in a queue so I just wait a few minutes to see my imported products.

Affiliate Products on Your WooCommerce Store

Now we can click on our category and see the products on our site. You will notice that they all list the sale price since I filtered my products for only those on sale.

If we click through to a single product, you see that everything has been imported, and related products are listed as well.

Comparison Sets

Another great feature that comes with this plugin is called Comparison Sets. There are several settings you can use to control this option.

Of course, the number of comparisons you have on a product will depend on the number of merchants you have connected. For example, under my coffee grinders, you can see the results of two merchant price comparisons.

price comparison on product page

Datafeedr – Easy to Use

I was impressed by how easy this was to use. In the past, I have sold some affiliates through a WooCommerce site and to be honest, it was a hassle. Setup was cumbersome and there was no way to have products automatically updated.

Connecting to the networks was seamless, and creating a product set was simple.

If you are looking at creating a WooCommerce store using affiliates or adding affiliate products to your existing store, I would look no further than DataFeedr.

Listen to DataFeedr Founder

Tune into my Do the Woo podcast and you can learn even more about affiliates and DataFeedr from found Eric Busch.

Only the posts on the builder blog here may include affiliate links. If you click on them and make a purchase, I'll get a commission, at no cost to you.