How can I upload one price list and apply it to many facilities?

Last Updated: May 2024

You have the option of adding global price lists to your account to associate with multiple facilities, rather than creating pricing for each facility individually.

This will allow you to upload one or more global price lists and apply them to your facilities as appropriate. This is also a helpful way of ensuring that all of your facilities are tied to the correct price lists and that those lists are kept up-to-date.

Once a global price list is added to a facility, these prices will function as regular facility contract pricing and will automatically populate in an event when a matching catalog item is used.

There are some important factors to remember when using global reusable price lists:

When you assign a global price list to a facility, it will replace all existing pricing for that facility.
If you have applied a reusable price list to a facility, any attempt to upload individual prices will remove the global list from that facility.
Any edits to catalog prices must be done at the Global Price List level and will apply to all facilities with that price list assigned.
Global Prices Lists do not allow for price appending to existing lists. If you load a new spreadsheet to the global price list, it will completely replace all existing prices. For instance, if you have a global price list of 1,000 items and you want to add 100 new items, you will need to load a new list with all 1,100 items.

To add a reusable price list:

As an admin in the console, navigate to the Directory section and click on the Price Lists section
Click “New Price List”
Click “Upload”
Next, you'll need to select the price list from your computer. See the image below for which column headings belong in a reusable price list upload file (manufacturer, catalog #, price).
1. Make sure that the correct manufacturer is entered on each line for each catalog number, or the import will not work.
2. Note: with this feature you can add multiple manufacturers to the same spreadsheet.
3. We recommend creating a very descriptive file name, which probably includes the date, so that you can easily manage your price lists and ensure they are kept up-to-date over time.
Next, map the column headers from your spreadsheet to the appropriate fields in the Price List. For each field, use the drop-down menu to select the appropriate column headings from your spreadsheet.
After you've mapped your fields, you will see a display of the prices being added where you can make small adjustments, if necessary, to your pricing. Clicking on the pencil icon will allow you to edit the price; clicking on the red “x” icon will remove that price from the list.
Once you're done, you'll be brought to the detail screen for that price list where you can make any adjustments going forward

Now let's assign that price list to a facility:

Navigate to the Directory section of the console and click on Facilities
Locate the Facility you would like to assign this list to, and click on “Pricing”
Next select the option for “Use an existing (reusable) price list”
Note: Assigning this price list will clear away any prior contract pricing for this facility.
Then select the appropriate price list from the menu.
Then click “Apply”

That’s it! You’ve just added a global price list. You can repeat that process as many times with as many facility/price list combinations as needed.

How can I upload one price list and apply it to many facilities?

Reusable Global Price Lists enable you to manage less lists, and assign them to the relevant facilities instead of on a 1-1 basis.

To add a reusable price list:

Now let's assign that price list to a facility: