Creating a data feed for Rakuten LinkShare

From Spiffy Stores Knowledge Base

Setting up a product data feed for your products is a great way to get added exposure for your online store by syndicating them to a variety of these shopping portals.

Product data feeds are updated whenever you make a change to your products, so you can be sure that they're up to date. To create a data feed for Rakuten LinkShare follow the instructions below.

IMPORTANT!
You need to ensure that all of your products have a SKU (Stock Keeping Unit) before submitting your data file to LinkShare. If you don't do this, they will not accept your submission!


Step 1 - Create a collection of products

Firstly we need to have a list of products to send to LinkShare. To create this, you'll need to create a collection that contains all of the products you want in your data feed. You can create a Standard Collection or a Super Collection. This can be done in the "Collections" section of your store's Toolbox.

If you already have created a collection for another provider (for example Shopping.com), or you just want to have all of your products in your feed, you can skip this step.

Step 2 - Creating your data feed

After you have created your collection, go to the
"Marketing -> Product data feeds" section of your store's Toolbox, and click the "Activate" button in the LinkShare section.

  1. Enter a name for your feed. It's not used anywhere except for your reference
  2. Select the collection you created in Step 1
  3. Enter your Merchant ID that has been provided to you by LinkShare
  4. Click the "Activate" button

Step 3 - Adding your data feed to Rakuten LinkShare

LinkShare currently requires that you upload a text file. Once you have created your file, it is updated every time to make a change to your products, so you may need to manually upload your file every few weeks.

To access the feed, go to the "Marketing -> Product data feeds" section of your store's Toolbox, and click on the URL for LinkShare. You will be prompted to download the file, and you can then upload it to LinkShare.

Adding the LinkShare tracking pixel

To add in a tracking pixel for LinkShare, you'll need to copy the code below, and paste it into the field titled "Additional Content & Scripts" that you'll find in the "Preferences -> Checkout & payment" section of your stores' Toolbox.

Make sure you replace "MERCHANTID" on the first line with the Merchant ID that LinkShare have provided you with.

{% capture mid %}MERCHANTID{% endcapture %}
{% capture ord %}{{ order_number | url_encode }}{% endcapture %}
{% capture skulist %}{% for item in line_items %}{{ item.sku | url_encode }}{% if forloop.last %}{% else %}|{% endif %}{% endfor %}{% endcapture %}
{% capture qlist %}{% for item in line_items %}{{ item.quantity }}{% if forloop.last %}{% else %}|{% endif %}{% endfor %}{% endcapture %}
{% capture amtlist %}{% for item in line_items %}{% if item.taxable %}{{ item.line_price | divided_by: 1.1 | times: 100 | money_rounded }}{% else %}{{ item.line_price | times: 100 | money_rounded }}{% endif %}{% if forloop.last %}{% else %}|{% endif %}{% endfor %}{% endcapture %}
{% capture cur %}{{ shop.currency }}{% endcapture %}
{% capture namelist %}{% for item in line_items %}{{ item.title | url_encode }}{% if forloop.last %}{% else %}|{% endif %}{% endfor %}{% endcapture %}


<img src="https://track.linksynergy.com/ep?mid={{ mid }}&ord={{ ord }}&skulist={{ skulist }}&qlist={{ qlist }}&amtlist={{ amtlist }}&cur={{ cur }}&namelist={{ namelist }}">

Customisable variables in the tracking Pixel


  1. Merchant ID
    Make sure you replace "MERCHANTID" on the first line with the Merchant ID that LinkShare have provided you with.

  2. Tax amount
    As LinkShare require that prices are reported excluding tax, you may also need to adjust the tax rate for your products if you are outside Australia. This can be changed by changing the "divided_by" amount in this example. The divided_by amount of 1.1 applies to the 10% GST in Australia on item prices that include GST.

    If you are in New Zealand, you will need to change this to 1.15. If you are not charging tax in your store, then you don't need to change anything.