There are a couple ways to assign custom commission rates by SKU in your ShareASale account, and we've outlined these methods, considerations, and examples below.
If you'd like to assign custom commission rates by SKU, you'll first need to ensure you're passing back product-level data in your pixel. The below parameters are the Product Level Tracking parameters that are required to be passed back in the pixel for your transactions if you'd like to set up SKU-level rates:
skulist= the values passed back to this parameter refer to the individual SKUs that were purchased for the order
pricelist= the values passed back to this parameter refer to the prices for each individual SKU that was purchased for the order
quantitylist= the values passed back to this parameter refer to the quantity of each SKU that was purchased for the order
IMPORTANT
When Product SKU Commissions is enabled for your account, we will reference the values that are passed back to the pricelist= parameter when calculating the commission amount, as opposed to the value that's passed back to the amount= parameter (which refers to the sub-total for the order), and any SKUs that have not been assigned a custom commission rate will default to your program's base commission rate. Your program's default commission rate must also be set up a percentage-based rate if you'd like to enable Product SKU Commissions for your account. If your default commission rate is set up as a flat amount rate when Product SKU Commissions is enabled for your account, our system will register the rate as a percentage-based rate by default.
If you're not sure if you're currently passing the appropriate parameters to assign custom commission rates by SKU, please feel free to reach out to us at merchantdevelopment@shareasale.com, and we'll be happy to review.
Once you're passing the appropriate Product Level Tracking parameters in the pixel for your transactions, our team will enable the Product SKU Commissions setting for your account. This setting will allow you to assign custom commission rates by SKU. Once this setting has been enabled for your account, you can assign custom commission rates by SKU in your Datafeed or via Commission Rules. Please see below for more information:
Datafeed: If you'd like to assign custom rates for each SKU listed in your Datafeed, you will need to update and re-upload your Datafeed file.
- In Column 41 (customCommissions) you'll enter the custom commission rate for each SKU listed in your Datafeed. For example, if you'd like to assign a custom rate of 10% for a specific SKU, you would enter 10 in Column 41 for that SKU.
- In Column 42 (customCommissionIsFlatRate) you would leave this column blank for a specific SKU if the data entered in Column 41 for that SKU is a percentage value. For example, if you entered 10 in Column 41 and wanted to specify that it's 10%, you would leave Column 42 blank. If you wanted to indicate that the custom commission is a flat rate (as opposed to a percentage) you would enter 1 in Column 42 for that SKU.
Commission Rules: Alternatively, you can set up Commission Rules in order to assign custom rates based on a specific SKU, a list of SKUs, etc.
There are several SKU-level condition options that can be used when setting up your SKU-level commission rates, and we've provided definitions for each below:
Starts With: This condition should be used if you'd like a custom rate to be assigned based on the SKUs prefix. For example, if you have several SKUs that start with TEST (ex: TEST-1, TEST-2, TEST-3) you can use this condition to assign a custom rate if a SKU is purchased that starts with TEST.
Equals: This condition should be used if you'd like a custom rate to be assigned based on the specific SKU that's purchased. For example, if you'd like to assign a custom rate only for one SKU, you'd use this condition to define the SKU that needs to be purchased to trigger the custom rate.
Contains: This condition should be used if you'd like a custom rate to be assigned based on the exact string that's written for the condition - meaning the entirety of all numbers, commas, etc.
Ends With: This condition should be used if you'd like a custom rate to be assigned based on the SKUs suffix. For example, if you have several SKUs that end with TEST (ex: 1-TEST, 2-TEST, 3-TEST) you can use this condition to assign a custom rate if a SKU is purchased that ends with TEST.
In Comma List: This condition should be used if you'd like to assign a custom rate for a select group of SKUs. For example, if you'd like to assign a custom rate if any of a select group of SKUs are purchased (ex: 123, 456, 789) you can use this condition to define the select SKUs that will trigger the custom rate.
Not In Comma List: This condition should be used if you'd like to assign a custom rate based on the SKU that's purchased not being present in your defined list of SKUs.
A common request we receive from merchants is: "How can we exclude a specific SKU from commission eligibility?" We've included the setups below to accomplish this setup:
1. Go to TOOLS > Commission Rules
2. Click Add Custom Rule
3. Under Commission Action select Set to percentage from the drop-down menu and enter 0 in the following field
4. Click Add Condition
5. Click Product SKU list matches a specific value under TRANSACTION CONDITIONS
6. Select Equals from the first drop-down menu, enter the applicable SKU in the following field, select Apply only to matching SKUs from the last drop-down menu, and click Continue
7. Click the orange Save button at the bottom of the page
If you'd like to exclude more than one SKU from commission eligibility, you'll choose In Comma List from the first drop-down menu at Step 6, and enter the applicable SKUs in a comma-separated list in the following field.
If you'd like to review the values that are being passed back to the Product Level Tracking parameters for your orders, you can download the Transaction Detail Report and view the data in the following columns for each order:
skulist - Column Y
pricelist - Column Z
quantitylist - Column AA
Please don't hesitate to reach out to us at merchantdevelopment@shareasale.com if you'd like to learn more about Product Level Tracking and how to accomplish your desired commission settings.