Skip to main content

How to Bulk-Upload SKU Commissions?

Quickly compile a list of products along with their corresponding commissions to enhance your offer strategy.

Written by Andre Tan
Updated over 2 weeks ago

Product-level commissions allow you to set specific commission rates for individual products in your store. If you want to incorporate product-level commissions (SKUs) into your commission structure and have too many to add individually, follow these steps to upload them quickly:

1. Go to Affiliate > My Offers.

2. Choose an Offer Name from the list (or create a new one, then return to add the list of SKUs).

3. Click Product Level Commissions from the menu on the left.

4. Click the Upload SKU CSV button.

5. Select how you’d like your SKUs list added:

  • Add new SKUs and update pre-existing SKUs.

  • Delete all existing SKUs, then replace them with new SKUs

6. Click Download CSV template file.

7. Add your product details under the column headers: SKU, PRODUCT_NAME, COMMISSION_TYPE, COMMISSION_AMOUNT (additional currency header details below)

Important Note: You need to enter PERCENT_OF_SALE, FLAT_RATE, or FLAT_RATE_PER_ITEM under the COMMISSION_TYPE column. Please format the text exactly like one of those three options (fully capitalized).


In the COMMISSION_AMOUNT column, do not include any special characters (e.g., $, %). Only numerical values should be included.

8. Once completed, drag and drop your file or click into the box to browse for it.

9. Click Upload changes. (Depending on how many product-level commissions you are uploading at a time, you may have to wait a short while before they populate in your account)

Note: Since you are explicitly telling Refersion what commission to apply to each SKU, discounts will not be applied to items that have a product-level commission applied to them. They remain constant for product-set commission amounts.

If you need to factor in discounts to an offer containing SKUs, you’ll need to calculate them at the whole offer level.

Currency Header - Optional

Customize Commission Currency

If commissions for specific SKUs are different than the default currency you have set for your account, you can specify that: Add a CURRENCY column after the COMMISSION_AMOUNT column in your CSV file.

In this column, you should place the three-letter code of the specific commission’s currency.

You’ll find the codes and supported currencies in the following article:

Rows without a specified currency will default to the account’s default currency.

Did this answer your question?