Updating Pricing at the Supplier Level

  1. Boomer Commerce
  2. Store Administrator Guide
  3. Product Management

Updating Pricing at the Supplier Level

When you need to update the default pricing for products saved under a main supplier, you can export the supplier's current product data, update the pricing in Excel, and then import the file back into the supplier.

Important: The spreadsheet format used at the supplier level is different from the format used when updating pricing within an event. Do not use an event-level price export for a supplier-level import.

Step 1: Export the Supplier's Products

  1. Navigate to the Reports tab.
  2. Run the Product Export report.
  3. In the report parameters, select the Supplier Name.

The Product Export report is run for one supplier at a time.

You can leave the remaining report parameters at their default settings. However, if you also want to review product details such as weights, dimensions, or descriptions, set Include HTML Description to Yes.

If you are only updating pricing, you can leave Include HTML Description set to No.

If You Do Not See the Product Export Report

If Product Export does not appear in your Reports menu, the report may not be available to your current security role. Contact support to request access to the report.

Step 2: Download the Excel File

  1. Click View Report.
  2. Click the disk/save icon.
  3. Select Excel File.
  4. Save the file to your computer.

Step 3: Update Your Pricing in Excel

Open the exported Excel file and make the necessary pricing changes.

If you are applying a percentage increase across multiple products, Excel formulas can make the process faster. For example, to increase pricing by 10%:

  1. Insert temporary working columns next to your existing pricing columns.
  2. In the first row of your working column, enter a formula referencing the existing price.

For example:

=ROUND(K2*1.1,2)

In this example:

  • K2 is the cell containing the original price.
  • 1.1 increases the price by 10%.
  • 2 rounds the result to two decimal places.

If you prefer to round pricing to the nearest whole dollar, use:

=ROUND(K2*1.1,0)

Repeat the same process for your other pricing column, updating the cell reference as needed.

Step 4: Apply the Formula to All Products

After entering the formula in the first pricing cell, use the fill handle in the bottom corner of the cell to drag the formula down through the rest of the column.

Repeat this process for each pricing column you are updating.

Step 5: Convert the Formulas to Values

Before importing the file back into Boomer, the calculated prices should be converted from formulas into standard values.

  1. Highlight the completed working column.
  2. Copy the selected cells.
  3. Use Paste as Values to paste the results back into the column.
  4. Confirm that clicking a cell now displays a value rather than a formula.
  5. Repeat for any additional pricing columns.

Step 6: Clean Up the Spreadsheet

Once your updated pricing columns contain values:

  1. Copy the original pricing column headers onto the new pricing columns.
  2. Delete the old pricing columns.
  3. Confirm that the spreadsheet contains the correct column headers and updated values.
  4. Save the Excel file.

Step 7: Import the Updated Pricing

  1. Navigate to Main Suppliers.
  2. Search for and open the supplier you are updating.
  3. Select Products.
  4. Click Import Products.
  5. Select your updated Excel file.
  6. Click Import.

Your supplier-level pricing is now updated.

How This Affects Existing Events

When supplier pricing is updated, events that have not already been locked down will also receive the updated pricing.

If an event's pricing has already been locked down, the supplier-level update will not overwrite those event-specific prices.

Best Practices

  • Always use the Product Export report when preparing a supplier-level pricing import.
  • Do not use an event-level pricing export for a supplier import.
  • Save a copy of your original export before making changes.
  • Convert all formulas to values before importing the file.
  • Confirm your column headers match the original export before deleting your old pricing columns.
  • Review upcoming events to understand which ones will inherit the updated supplier pricing.