Creating Pricing

If pricing is required for one of your trading partners, you will have a starting price group provided in your import template. Likewise, if you are downloading an export of your items from Assortment and they have pricing in the catalog, that pricing should be provided in the exported spreadsheet.

Learn about adding a pricing group to your import template.

When creating a pricing group in the template, there are, at minimum, three fields required to provide a price in Assortment:

Price Qualifier = This is the qualifier that identifies which type of price you are providing. Examples include:
- MSR (Manufacturer Suggested Retail Price)
- UCP (Unit Cost Price)
- LPR (List Price)

To learn more about these and other possible Price Qualifiers, click HERE.

Note: Log-in to Training Center is required.

Price Amount = This should be the price expressed as a number. This does not include the currency sign; that is denoted in the Price Unit of Measure field. Examples: 159.99, 1067.12, 700.
Price Unit of Measure = This is the unit of measure/currency associated with the Price Amount. Examples: USD, CAD, MXN.

Other pricing attributes may be required, depending on your trading partner(s) requirements.

Updating Pricing

Pricing can be updated in the template by updating the Price Amount, but only if other specific price fields match the item’s existing pricing data.

Immediate Price Updates

As you have already learned, three attributes are required to provide an item's price. For this item, the Unit Cost Price was previously provided as $4.50 (USD).

Here is how the item's pricing is represented in the Assortment application.

If the Price Amount was changed and the Price Qualifier and Price Unit of Measure remained the same, the price would be updated upon upload.

If the Unit Cost Price is increasing to $4.75, in the Item Import template, change '4.5' to '4.75'.

Save the file, upload into Assortment, and the price will change immediately. By changing the price only, the existing price will update.

This is how the item’s pricing is now represented in the Assortment application.

Note: there is only one Price Qualifier listed for this item.

The Unit Cost Price for this item would now be $4.75 (USD).

Future Price Updates

If, however, you need to not only update the Price Amount but also provide a new Price Effective Date and/or Price Expiration Date, there are two ways to accomplish this.

The first option is to update the Price Amount and the Price Date fields in the Item Import template. Once the updates are saved, upload the template into Assortment. As shown below, the price of this item will increase to $4.85 as of April 1, 2026. The $4.75 price will be in effect until then.

By updating the Price Amount and Dates, a new price repetition has been added to this item in Assortment.

You can still see the current price AND the future price.
The second option is to add a new price group in your template. This method allows you to see multiple price groups within the template as well as in Assortment.
Click image to view larger.

Once the updates are saved, upload the template into Assortment. The pricing in Assortment will look the same for both options.

With this option, the Item Import template will reflect exactly what appears in Assortment.

Additional Requirements

There are four other optional price attributes that, if they appear in the item's existing price group, must appear in the updated price group and must contain the same values (case insensitive) in order for the Price Amount to be updated.

If any of the following additional attributes appear in an item's existing price group:

Price Effective Date - the date the represented item’s price goes into effect
Price Expiration Date - the date the represented item’s price is no longer effective
Price Trading Partner Number - the trading partner-specific identifier assigned by SPS Commerce; only used with UCP (Unit Cost Price)

To learn more about Price Trading Partner Number, click HERE.

Note: Log-in to Training Center is required.

Price Division - identifies the division of a company that pertains to the price qualifier
Price Zone - 3-digit country ISO code

Then these values must appear in the updated price group and must be the same values (case insensitive). If so, upon a subsequent upload the Price Amount would be updated.

The Unit Cost Price for this item would now be $3.50 (USD).

If any of these values (besides Price Amount) varies between the existing price and the updated price, the Price Amount will not be updated and a NEW price will be created.

If any of these price attributes are populated in either the existing price or the updated price but not in the other, the Price Amount will not be updated and a NEW price will be created.

Delete All Prices

Delete All Prices is a unique attribute that serves a specific function in Assortment. When the following conditions are met:

The attribute is included in the import template
The attribute is populated with the value = "1"

Upon upload, any pricing data for the item in Assortment will be removed.

If Delete All Prices is not included on your spreadsheet by default, you can insert a column to the left of your other pricing attributes with the header = “DELETE ALL PRICES”.

Delete All Prices will delete ANY existing pricing for the flagged item/s in the template in your Assortment catalog upon import.

Price Delete

Price Delete is another unique attribute that functions similarly to Delete All Prices, but allows for the deletion of specific pricing per item. Price Delete must be followed by a number corresponding to the specific price group you are looking to delete.

For this item, Price Amount 2, Unit Cost Price, is $4.85 (USD). If only this price needs to be deleted:

Insert the attribute Price Delete 2 to the left of Price Qualifier 2.
Enter "1" in Price Delete 2 for this item.
Upload the template into Assortment.
Upon a successful upload, the Unit Cost Price of $4.85 (USD) will be deleted from Assortment.
If necessary, Price Group 2 can be reused to provide additional price information for the item.

Price Delete will delete ONLY the existing pricing for the specified pricing group(s) and for the chosen item(s) in your Assortment catalog on import.

Tiered Pricing

Tiered pricing is a strategy that businesses use to set the costs of products or services based on the different levels or quantities that customers purchase. For example:

Volume-based tiered pricing: Price per unit decreases as the quantity purchased increases.

Tiered Pricing is only accepted by some Retailers. If this applies, please reach out to your consultant for instructions on how to format your spreadsheet.