Downloading Datafeeds – CJ

Affiliates who make good use of available datafeeds usually have good traffic and higher sales because they are offering more content and information on their site. Datafeeds must be kept up-to-date to be useful because pricing and inventory affect the customer experience and can impact the quality of your site.

If you’re ready to start learning to handle a datafeed directly, you have a few different steps to learn:

  • How to find a datafeed and download it so you can manipulate the information inside.
  • Loading that selected information to the server for your site.
  • Creating a page or post template that pulls the information about 1 product from that loaded information.
  • Updating feeds when information changes

What is a datafeed exactly?

The easiest way for me to visualize a datafeed is to see it as a spreadsheet. Even though it is usually presented as a CSV file, that just means commas are separating the data you would normally see in a spreadsheet cell. You can upload a CSV file into a spreadsheet and conversely, you can save a spreadsheet as a CSV file.

A datafeed is an inventory sheet of the merchant’s products. Each row (think spreadsheet) represents one product. If the product comes in different sizes, different colors, different anything – each choice will have its own row.

The cells going across the row are for the various bits of information you need to display that product on your site: Name, Landing Page, Large Image, Thumbnail Image, category, Retail Price, Sale Price, etc. There are many ways a network can choose to accept datafeeds; each network usually sets up the template criteria so they are uniformly structured.

How do I get a datafeed from Commission Junction?

This mini tutorial will show you the first step: How to find a feed at Commission Junction (CJ) and download it so you can see and use the information inside.

It’s pretty easy and straightforward to get it directly from CJ. If you’ve never done it before, login to your account and then go first to the tab Account and then to the tab Services:

It will probably say “You don’t have any services selected”, but if you have already set up datafeed exports in the past, you will see them listed. You want to click on Create Product Export. Then you will see this:

  1. Make sure your email is the one where you want notification sent
  2. Leave the TAB format as-is
  3. Choose how you want to access the feed: via FTP, https, email, etc. If you choose FTP or https at CJ, you will get a password in your email. If you choose email, it will arrive almost immediately as a gz zip file.
  4. Leave date format as-is
  5. Check the website – change it on the drop down if necessary
  6. Leave the “opt out of delivery notifications” unchecked so you are notified when there’s a new feed
  7. Now find the merchant you want on the right-side list, highlight the merchant name and click the <<<<< arrows to move that name into the blank box. You can see that I have moved most of the Snow merchants with feeds to the left box as an example for you.
  8. Hit SAVE and you’re done!

Now your account services tab will show this new subscription and any others you add. My preference is to obtain the feed via CJFTP. You’ll be notified when a new file is available, you have so many days to retrieve it and you’ll receive the instructions and password via that email address. Using whatever FTP software you prefer, just retrieve the file at your convenience. If it’s a small file, the email delivery might be easiest, but when you have many subscriptions, just the notifications will be enough to manage in your email.

Now you have access to CJ datafeeds. Use the entire product catalog OR pick and choose a dozen individual products that match your topic or your site. Learn to pull whole feeds into your site or grab the individual cells and make the links part of your post or html content.

You don’t have to be a technical wizard to make use of product datafeeds.