Prices for one customer
How it works
A customer's prices usually come from the price lists assigned to their customer group. Customer pricing goes a step further for individual customers:
- Customer-specific price lists replace the customer group's price lists for that customer. For example, you have a standard B2B price list, but some customers should get lower prices on some or all products. You create another price list, upload its prices in SparkLayer, then set it on those customers.
- A customer percentage discount takes an extra percentage off the customer's prices. For example, your B2B customers are on a price list, and you want some of them to get an extra 25% off those prices.
Customer group price lists
Customer price lists
Customer discount
To choose between these, and a customer group of their own, step by step, follow Give a key account their own prices.
Where customer pricing is stored
Customer pricing is stored in metafields (sometimes called attributes). A metafield is an extra field on a customer's record in your eCommerce platform, like a custom box on the customer's page, which SparkLayer reads. You set the field up once for your store, then fill it in for each customer who needs it.
See Shopify metafields and data mapping, and for other platforms, Metafields in the developer docs.
To check what a customer has, open their page at Customers (opens in your SparkLayer Dashboard in a new tab): Price list override is under Basic information, and Discount percentage under Financial details. Both are read-only there, because they come from your store.
Give a customer their own price lists
A customer's own price lists replace their customer group's price lists.
- Create the price list and add its prices. See Price lists and Upload prices by CSV.
- Note the price list's handle, shown under its name at Pricing,Price lists (opens in your SparkLayer Dashboard in a new tab), for example
vip-pricing. - Make sure the
price_listsmetafield is set up in your store. On Shopify, you can add it from Integrations,Platform,Metafields (opens in your SparkLayer Dashboard in a new tab) by clicking Configure next to SparkLayer metafields. - In the form below, enter the price list handles. It writes the value for you, for example
["vip-pricing","base-list"]. - Click Copy, open the customer in your store admin (on Shopify, the customer's Metafields card), paste the value into the price lists field and save.
sparklayer.price_listsLots of customers? Fill them in one tableShopify
In your Shopify admin, go to Customers, tick the customers and click Edit customers. Click Columns, tick the SparkLayer field under Metafields, then type the values (one row per customer) and click Save. Shopify's guide
Metafield settings, if you create the field by hand
The settings are the same on every platform:
| Setting | Value |
|---|---|
| Custom data type | Customers (on Shopify, at Settings,Custom data,Customers (opens in your Shopify admin in a new tab)) |
| Metafield type | json |
| Namespace | sparklayer |
| Key | price_lists |
| Value | A JSON list of price list handles, as above |
For platforms other than Shopify, see the SparkLayer developer docs.
Give a customer an extra percentage discount
A customer discount takes an extra percentage off the customer's prices.
- Set up the discount field once: go to Integrations,Platform,Metafields (opens in your SparkLayer Dashboard in a new tab), click Configure next to SparkLayer metafields and enable the customer discount. See Add metafields automatically.
- In your Shopify admin, go to Customers (opens in your Shopify admin in a new tab) and open the customer.
- In the customer's Metafields card, find Customer % Discount (click Show all if you can't see it).
- Enter the percentage, for example
25for an extra 25% off, and save the customer.
Lots of customers? Fill them in one tableShopify
In your Shopify admin, go to Customers, tick the customers and click Edit customers. Click Columns, tick Customer % Discount under Metafields, then type the values (one row per customer) and click Save. Shopify's guide
Metafield settings, if you create the field by hand
| Setting | Value |
|---|---|
| Custom data type | Customers, at Settings,Custom data,Customers (opens in your Shopify admin in a new tab) |
| Metafield type | number_decimal |
| Namespace | sparklayer |
| Key | discount_percentage |
| Value | A decimal number, for example 10, 22.5 or 50.25 |
Set the discount_percentage metafield (or attribute) on the customer to the percentage, for example 25 for an extra 25% off. Your developer or agency can set this up with these settings:
| Setting | Value |
|---|---|
| Custom data type | Customers |
| Metafield type | decimal |
| Namespace | sparklayer |
| Key | discount_percentage |
| Value | A decimal number, for example 10, 20 or 50 |
For more information, see the SparkLayer developer docs.
For promotions such as coupon codes or spend thresholds, use Discounts instead.
FAQs
Yes. Price lists set on a customer override the price lists of their customer group.
Yes. Customer-specific price lists set with metafield data are designed for more advanced setups, such as pricing managed in an ERP. See Send prices from another system.
Yes. A customer group can have several price lists. See Assign a price list to customers.
Last updated