Price Lists

Introduction

Price lists are a central feature to SparkLayer and they allow you to set specific pricing for specific customer groups. The SparkLayer Dashboard lets you manage your available price lists and gives you powerful tools to set the exact pricing you want for your B2B customers

Getting started

In order to get started with Price lists, there are a number of steps to follow:
    1.
    First, a Price list needs to be created; this can either be done manually in SparkLayer or automated from your backend system
    2.
    Next, prices then need to be imported into the Price list. You can either do this manually using our built-in CSV import tool, or automate this from your backend system (learn more here)
    3.
    Finally, the Price list needs to be assigned to a Customer Group in order for customers to see these prices when they login to your website.

Creating a price list

To create a new price list, click the Create Price List button on the top right.
You'll then be prompted to complete the following information
Item
Details
Handle
The unique handle (i.e. ID) of the price list that is sent to the backend system. This should match what is set up in the backend system, e.g. base-list
Name
The price list name as displayed in SparkLayer
Currency
The default currency, e.g. GBP
Finally, when you click the Create price list button, the newly created price list will then show in the list available.
Item
Details
Handle / ID
The ID of the price list
Name
The price list name (e.g. as stored in your backend system)
Currency
The default currency, e.g. GBP
Actions
The ability to manually upload prices via a CSV file
Please note, if you're connecting your backend system to SparkLayer, price lists should only be manually added if they aren't automatically imported via your backend system.

Importing a price list

Manually importing prices via a CSV

Please note, prices should only be manually uploaded if you're not looking to synchronise your backend system with SparkLayer.
To get started, click Upload prices on the Price list you want to add prices to. You'll then be prompted with the following screen and asked to upload a CSV file.

Sample CSV file

The structure of the CSV file is very simple and you can download a sample here.
The columns should be set up as above, the last 2 columns are not required. And the qty column is for tiered pricing.
Column
Details
Required
sku
The product SKU as set up in your eCommerce platform or backend system
Yes
price
The unit price for the SKU at the quantity set in column 4 (qty)
Yes
tax_type
The price configuration as either gross or net
No (defaults to net)
qty
The quantity of the SKU for the specified price for tiered pricing (see below)
No (defaults to 1)
Specifying quantity in your CSV file
The quantity field in the sample CSV file (named qty) lets you define the price the customer pays for that specific quantity of the item. For example, for 1 unit, the price may be £20.99, but for 5 the price may be £14.99. SparkLayer calls this 'Tiered pricing' and when set up, the customer will clearly see the tiered pricing on the product page. Learn more about tiered pricing.

Validating the CSV file

When you upload the CSV file, you'll then be shown validation messages based on the content of the file. If the CSV file successfully passes validation, you'll be notified and shown a sample of what has been imported.
Clicking Save Price List will then import the file into SparkLayer and customers will then see these prices when logged in.

Validation warnings

If the file cannot be imported, e.g. missing prices or an incorrectly formatted file, you'll be notified with relevant details.
It's important to note that a file can be successfully imported but include missing data, e.g. perhaps a product SKU doesn't exist and prices cannot be matched. You'll be notified of affected SKUs and notes on how to remedy the issue.

Synchronising price lists with your backend system

If you're looking to import your price lists into SparkLayer automatically from your backend system (e.g. ERP), you'll need to send price list data via the SparkLayer API.
Learn more about how this works in our guide here.

Assigning price lists to customers

Once you've created and uploaded prices for your Price list(s), you can then assign these to different customer groups. This means you can control which customers see which prices when they sign into your website.
Learn more about how to set up customer groups in our guide here.

The base price list

The base price list is a fallback price list that is enabled by default for all SparkLayer accounts. It’s really there to allow you to test how SparkLayer works and lets you set up sample B2B pricing that will then display for B2B customers that haven’t been assigned a custom price list.
In reality, you're likely to have multiple price lists that may be assigned at a customer level, and you can follow our guide above to set this up.
That said, if your B2B pricing set up in your backend system is very simple and you have need for just one price list for B2B customers, you could use the base-list as your main price list to trigger B2B pricing on your storefront.

Checking price list data

You can check if price list data has been assigned to an individual product by using the Product Data Lookup tool. From the Data Feeds Tab, click Products and from within the Product Data Lookup tool, search for the Product External ID you have just modified. In the Pricing Data section of the returned JSON, you should then see the pricing data you’ve sent to SparkLayer via the API.
In this example, prices have been sent with tiered pricing
If you can see the pricing data, this confirms that price list data has successfully been sent.
Last modified 15h ago