Skip to main content
All CollectionsGetting Started
Setting List Pricing
Setting List Pricing

Assign list prices to grouped items based on the criteria you choose

Mike Banting avatar
Written by Mike Banting
Updated this week

The "list price" in WholeCell is used in two ways:

  1. As an advertised price (shown to your customers) in public inventory reports and on the B2B Customer Portal

  2. As the default sold price when inventory is added to a Sales Order without a price

You can set the list price across various groupings of your available inventory using the Pricing page.

Method 1: One-by-one

You can add the list price for each product variation on this page in the Price field.

WholeCell will automatically save the price you enter in that field. No need to look for a Save button below.

Method 2: Spreadsheet Upload

The most efficient way to price a large number of product variations in bulk is by uploading a spreadsheet with your product prices.

First, download your current product variations from the Pricing page. For this example, we'll be updating the list prices for "TESTSKU3a" and "TESTSKU4a:

Then, on the downloaded spreadsheet, add your prices in the Price column. Save the spreadsheet...

...then upload.

Done. You can do this for all the product variations in the downloaded spreadsheet.

Method 3: Classic Bulk Pricing Tool

Another method is the classic Bulk Pricing tool. This tool allows you to group items together and set the list price for all items in one action.

To do this, click on the '$ Bulk Pricing' button above the Pricing table.

On the Bulk Pricing page, click the 'Grouping' button to see the categories you want your inventory grouped into. Leave a check on the attributes that need to be separated, and uncheck the attributes that you'd like to group together for faster pricing. For example, if you have different prices for different model colors like 'Black' and 'Gold', leave 'Color' checked. Otherwise, uncheck 'Color', and those models will be grouped onto the same line.

Once you've selected the grouping you want, wait for the page to refresh and then add or update prices on the price fields.

For my example below, I grouped my inventory based on 'Capacity' and 'Grade'. Based on this, I will adjust the prices of all B Grade, 32 GB, Apple iPad 4s. The amount that you type gets saved automatically.

Method 4: Pricing from the Product Catalog

You can also set the prices of your product variations by uploading a spreadsheet to the Product Catalog. First, download your current products.

Then, on the downloaded spreadsheet, add a "Price" header and set the prices for the product variations for which you want to set the price. Save...

...and then upload.

That's done!

Did this answer your question?