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.
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)
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.
Minimum Requirements
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 $3.33 (USD).
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.
The Unit Cost Price for this item would now be $3.50 (USD).
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
Price Trading Partner Number
Price Division
Price Zone
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" or "Y"
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" or "Y" 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.
More Information
Check out our Assortment Collection to see all Assortment articles.