Import affiliate products into WooCommerce


Hi, I’m Eric, co-founder of Datafeedr. In this video I want to show you how you can
use Datafeedr to import affiliate products into your WordPress WooCommerce store. Instead of setting up a demo site to show
you, I’m actually going to use my own personal Datafeedr site, GearGrabber.net. Let’s take a look. This is the GearGrabber homepage. GearGrabber is set up to sell outdoor gear
like backpacks, tents, sleeping bags, etc… And, all of the products in GearGrabber are
On Sale as you can see on the homepage all of the products have sale prices. To build this site I used the free Storefront
theme from WooCommerce. I of course used the WooCommerce plugin. I’m using the Datafeedr API plugin. Also the Datafeedr Product Sets plugin, the
Datafeedr WooCommerce Importer plugin and the Datafeedr Comparison Sets plugin. So let’s hop back into the backend of our
GearGrabber website. Next, we’re going to take a look at the affiliate
networks for this site. Let’s go into Datafeedr API>Networks. Datafeedr supports over 30 different affiliate
networks which you can select products from. You can see all of those affiliate networks
listed on this page. For GearGrabber I’ve selected Commission Junction
and AvantLink. Let’s go to the merchant’s section. Datafeedr supports over 14,000 different merchants. On my GearGrabber site I’ve selected 9 merchants
from AvantLink and 3 different merchants from Commission Junction. In this video, I’m actually going to show
you how to create a new category in your WooCommerce store and add products to that category. Let me show you what we’ll be doing. If we go into our “Camping Gear” category
you can see we have backpacks, camping stoves. I’m missing a category that I want to add,
it’s called “Headlamps”. I want to display headlamps in my store as
well. So that is what we’re going to do in this
video. So what we’re going to do to get started is
create a new Product Set. A Product Set is where you can search for
products and then associate those products with a category in your WooCommerce store. Let’s take a look at how that’s done. Here, I’m just going to give this Product
Set a name. You can name it whatever you want. Let’s get rid of these for now. We’ll come back to those. And I’m just going to do a simple keyword
search to start with. We’re going to search the product name field
for any product that contains the word “headlamp”. And we’ll click [Search]. This will search all the products in our database
but only return products from those merchants that we selected on the Merchants page. This returned 232 products. What I like to do at this point is scroll
through this list of products and see if they all are what I want to import or do I need
to eliminate some of them because they don’t match. So, I like to just scroll down. OK, here’s a product. This is a rechargeable battery. I actually don’t want this in my category. Let’s keep looking. Here are a couple more. Here’s a pouch, a kit and a case. I don’t want those products in my category
either. I’m going to show you how to remove or exclude
or filter out those products from your searches. So let’s go back up to our search form. So, what I’m going to do is type negative
“-” for exclude and then I’m going to type the word “battery” and “pouch” and “kit” and
“case”. So basically what we’ve done here is now we’re
doing a search for the word “headlamp” that appears in the product name but the product
name does not contain the word “battery” or the word “pouch” or “kit” or “case”. You can learn more about our search operators
by clicking the red question mark down here. This actually allows you to search our documentation. If you just search for “search operators”
you’ll see the first link to the documentation that we have. We have a bunch of different operators you
can use: AND, OR, NOT, EXACT WORD, PHRASE, etc… So if you’re ever stuck, you can just hop
into our documentation right from the WordPress Admin Area, you don’t even have to go to our
website. Let’s get back to our example… So we’ve typed in these words that we want
to exclude from our results so let’s click [Search] and see what we get. OK, so that returned 219 products. It removed about 13 products. We can scroll through these. Those look really good. I’m just going to pop over to the last page
of results to see how those look. And those look good, too. So, the next thing we need to do is since
GearGrabber is set up to only display products which are On Sale we need to set up those
filters as well so let’s do that. I can click the “Add Filter” button. You can filter by many different fields like
Brand, Price, Discount, etc… What we’re going to do here is set it up so
that we’re only including products which are on sale and I also only want to include products
which have a product image. Finally, I want to exclude duplicates. And so here we’re actually going to exclude
any duplicate products from the same merchant which have the same name OR the same image
URL. You can get more information about excluding
duplicates right here. So let’s run this search now. Ok, that returned 72 products so we excluded
a bunch of products which weren’t actually on sale. I’ll take a quick scroll through the results. And those look great. So the next step is to save this search. What we want to do is click the [Add as Saved
Search] button and what this will do is save this search so when this product set automatically
updates in 2 or 3 days from now, it will go out and run this search again so if a merchant
has added a new product to their inventory which matches your search criteria, that new
product gets automatically added to your store. You can of course add products one by one
by clicking the green plus “+” icon here but for this example I just want to show you the
powerful feature of the “Add as Saved Search” functionality. So we’re going to click that. Next thing we need to do is create our category. This is actually going to create the category
in our WooCommerce store. So I’m going to type in “Headlamps” and I’m
going to set the parent category to “Camping Gear” and we’ll click [Add New Category]. So that’s done. The last step here is to publish this. And once this is published this gets put in
the update queue and will start to update momentarily. So, through the magic of video I’m going to
take a couple of minutes, I’ll catch you back on the other side after this is done updating. OK, our Product Set is finished updating,
let’s take a look. Let’s click the “Headlamps” category and that
will take us to the “Headlamps” category in our store and you can see all 72 products
were imported into this category. You can see the category appears over here
in the sidebar. So that looks great. Let’s go ahead and click through to the first
product here. Here we have the single product information,
the name and here we actually have our price Comparison Set. That’s because we are using this plugin here
and this displays prices for this single product from multiple different merchants so we can
let our visitors click through and buy from Eastern Mountain Sports or Amazon or wherever
they want to buy or wherever the best price happens to be. And we get related products at the bottom. So that’s how easy it is to use Datafeedr
to import affiliate products into your WordPress WooCommerce store. Thanks for watching.

11 Comments

Add a Comment

Your email address will not be published. Required fields are marked *