Rakuten / Summer Sales 2019

We are still waiting for information on how to set up the 2019 Summer sales for this marketplace. Come back soon!

Here are a few tips to help you prepare your sales on Rakuten.

Make sure you anticipate the set up of the sales campaigns at least one week before they start!

1. Legal information about sales

To learn all about the French legislation concerning sales, see this article from the DGCCRF (French Authority for Competition, Consumer Affairs and the Prevention of Fraud): http://www.economie.gouv.fr/dgccrf/consommation/pratiques-commerciales/soldes

2. Creating a sales campaign

You first need to create a sales campaign from your Rakuten back office which will cover a specific period, in this case from June 26, 2019 until August 06, 2019 inclusive. This campaign will have a unique identifier that you will need to be able to configure your sales campaign in Lengow. We will come back to this in more detail below.

Here's a manual published by Rakuten which explains how to create this sales campaign.

3. Configuring your sales in Lengow

3.1 What fields do you need to populate?

If you want to discount your items on Rakuten, you must populate these 3 fields in the feed that is transmitted to them:

  • “Prix d’origine”: The original, non-discount price of your articles
  • “Prix de vente”: The discount price of your articles
  • “Code opération promo”: A specific code including the identifier (ID) of the promotion campaign that you will previously create directly in your Rakuten back office. We will see the details below.

3.2 How to display your sales items

You will therefore need to match your fields and those of Rakuten in this way:

  • "Prix d’origine" : Original, non-discount price of the item
  • "Prix de vente" : Current discount price of the item
  • "Code operation promo" :  Rakuten expects the value corresponding to this nomenclature: “[@id:id_campaign@pr:{old_price}@np:{new_price}]” or “[@id:id_campaign@pr:{old_price}@pct:{percentage_of_discount}]”. 

It is very unlikely that you will have a field in your source feed that corresponds exactly to this promotional operation code.

Therefore, you will have to create a virtual field in Lengow. This virtual field is empty by default, so you will need to populate it with an automatic rule which will be based on the fields in your source feed. We will see an example below. For additional information, consult the documentation.

3.3 Case 1: you have a "price_discount" field

1/ Make sure that your sales campaign has been created in your Rakuten back office and retrieve the campaign identifier (ID).

2/ Match the "Prix d’origine" and "Prix de vente" fields of PriceMinister with the corresponding fields in your source feed. In Lengow this is in the "Field matching" tab of the "Feed Management" section.

3/ Create a virtual field that you will name "Priceminister_ code_operation promo" in the "Source feed" tab of the Feed Management section. Be careful not to use dashes, accents or special characters when you name your field.

4/ Once this field is created, you can then match it with the  field "Code opération promo" that you will find in the "Field matching" tab of "Feed management".

5/ Create an automatic rule to populate this field in the "Automatic rules" tab of the "Feed Management" section.

Choose the condition that allows you to select only the products that you want to discount (e.g. if "Pricenorebate" is higher than the "Price_discount") and choose to perform the following actions:

"Priceminister_ Code_operation promo" becomes: [@id:id_campaign@pr:{Pricenorebate}@np:{Price_discount}] with: 

  • @id: the id of the campaign created on Rakuten (example: 181).
  • @pr: the old product price before the sale.
  • @np: the new price or the sale price.

Example for an item of my source feed:

  • Old price: €100
  • New price: €70
  • Campaign ID: 181

Here is the value that you get for this item in the "Code opération promo" field of the optimised feed that is available on Rakuten: “[@id:181 @pr:100@np:70]”

3.4 Case 2: you have a "percentage of discount" field

You do not have a "prix réduit" field in your source feed but you do have a "percentage of discount" field.

1/ Make sure that your sales campaign has been created in your Rakuten back office and retrieve the campaign identifier (ID).

2/ Match the "Prix d’origine" field of Rakuten with the corresponding fields in your source feed. In Lengow this is in the "Field matching" tab of the "Feed Management" section.

3/ Create a virtual field that you will call "Priceminister_ code_operation promo" in the "Source feed" tab of the "Feed Management" section: Be careful not to use dashes, accents or special characters when you name your field.

4/ Once this field is created, you can then match it with the field "Code opération promo" that you will find in the "Field matching" tab of "Feed management".

5/ Create an automatic rule to populate this field in the "Automatic rules" tab of the "Feed Management" section. Choose the condition that allows you to select only the products that you want to discount (e.g. If "{percentage_of_reduction}" is higher than "0") and choose to perform the following action:

"Priceminister_ Code_operation promo" becomes: “[@id:id_campaign@pr:{old_price}@pct:{percentage_of_reduction}]” with:

  • @id: the id of the campaign created on Rakuten (example:181).
  • @pr: the old product price before the sale. 
  • @pct: the percentage discount.

Example for an item of my source feed:

Old price: €100
Percentage of discount: 30%
Campaign ID: 181

Here is the value that you get for this item in the "Code opération promo" field of the optimised feed that is available on Rakuten: “[@id:181 @pr:100@ pct:30]”

When you have finished configuring the sales, always be sure to check the optimised feed that is send to Rakuten.

As a reminder, once the URL of the optimised feed has been transmitted to Rakuten, all modifications made to the optimised feed, such as this configuring of sales, are automatically taken into account by them during the indexing that follows your modifications: it is therefore not useful to send back the URL of the optimised feed.

Attention, the application of mathematical calculations in the price fields of the promotional campaign is not possible due to the presence of brackets requested by Rakuten.

3.5 Duration of your sales campaign

Attention, the sales campaign will last the entire period that you previously defined in your Rakuten back office, even if you decide to remove the discount of your feed before the end date: this means that the discount price will still be displayed on Rakuten until the end of the period that was set initially.

If you want to interrupt your sales campaign, you have the following options:

1/ Go to your Rakuten back office and manually disable the items that you no longer want to discount.

2/ Go to your Rakuten back office and delete them, and then create a new sales campaign with your new dates. Then go to your Rakuten feed in Lengow and edit your automatic rule to change the ID of your new Rakuten sales campaign.

4. Contact Rakuten 

In the event of a problem, you can contact the Rakuten support team at the following address: support.pro@priceminister.com. The commercial service is available at this address: infopro@priceminister.com

5. Useful links

Procedure for sales and promotions on Rakuten
Animation of your Rakuten shop