Menu Close

Get Support From ShopWired Close

We are conducting schedule maintenance

Subscribe To Updates
Prefer To Live Chat? Chat directly with ShopWired support Available 9.30am to 5.30pm Monday to Friday (extended hours coming soon) Quickest response time
Send A Message
Response within 24 hours

Menu Close


Trade pricing bands

The trade pricing bands feature allows you to set prices for each of your products by creating a 'pricing band' and then assign trade customers to a band.

For example, you may have 3 different levels of pricing for your products for 3 different types of customers. So you can create three separate trade pricing bands (e.g. group A, B and C) and then assign each trade customer to one of those bands.

The trade pricing bands feature works in the same way as the two other ways to set pricing for your products for your trade customers, in that when a customer is logged into their trade account they'll see the prices for your products as you have set them for the band they belong to (without seeing any other price).

Creating a trade pricing band

To create a new pricing band, select 'b2b' from the left menu and then 'create pricing band'.

You'll need to give the band a name, so that you can identify it when assign a trade customer to it, e.g. 'group A'.

Next, you can select each of your products and, if applicable, the product variation, and then enter the price that the trade customer should pay. Please note that the pricing that you enter should obey the same rules as the normal pricing that you enter for a product (i.e. whether you are entering the price including or excluding VAT according to your VAT settings).

As shown on the example below:

Click the 'add another' link to add more products to the band.

If you don't assign a product and price to the band, then the trade customer will pay the normal price for the product.

Please Note!

To use this feature, if your products has variations then you'll need to make sure that you have entered a SKU code for each product variation.

Importing trade prices into a trade pricing band

If you have a lot of products to add to a trade pricing band, you might prefer to create the prices using a spreadsheet and import that spreadsheet. To do so, you'll need a spreadsheet with 3 columns

Pricing Band ID

Each row in the spreadsheet represents a separate product or product variation. Products and/or variations are identified with a SKU code so you'll need to assign SKU codes to each of your products and variations to use the import system.

You can obtain the ID of the pricing band by looking at the URL of the page you are viewing (when viewing the pricing band) in your browser's address bar. The last number in the URL is the ID, e.g.


in the above example the ID is 3.

(the above is an example of what your spreadsheet will start to look like)

When you've created your spreadsheet you'll need to save it as a CSV file (if using an Apple select 'Windows Comma Separated (CSV) file').

Once saved, click the 'import prices' button in the top right of the page and select your file. Once the import is complete you should check a few of the prices to ensure they have imported correctly.

Assign a trade customer to a pricing band

When adding/editing a trade customer account, scroll to the 'trade discount' section.

Select the pricing band that you want to assign the customer to from the 'trade pricing band' drop down.

If the customer is assigned to a trade pricing band, then this will override any percentage discount set for the trade account.

Automatic assignment

If you'd like new trade accounts to be automatically assigned to a pricing band (when their account is activated) you can select the pricing band from the b2b settings page of your account.

Select 'settings' from the left menu and then 'b2b settings'.

Locate the 'default trade pricing band for new accounts' setting and select the pricing band from the drop down list, as shown in the example below.