The Product Export report creates an Excel file that you can update and re-import to change a supplier’s product list. It is commonly used to update supplier pricing from year to year.
Description
Use the Product Export report to make permanent changes to a supplier’s product list. The report displays results in a grid. When exported to Excel, it uses a format that can be imported back into Boomer at the supplier level.
An event-level price list cannot be imported at the supplier level. Run the Product Export report to generate the correct format for a supplier import.
Report Example
Available Filters
Use the following filters to select the supplier, revenue types, products, and information included in the export.
| Field Name | Available Values | Default |
|---|---|---|
| Supplier | All suppliers defined in the system | None |
| Revenue Type(s) | All revenue types in the system | All |
| Product(s) | Products defined for the selected revenue types | All |
| Include Attributes | Yes No |
No |
| Include HTML Description | No Yes |
No |
| Format | Boomer Simple (not re-importable) Floor Plan Products Only |
Boomer |
Filter Details
Supplier: Selects the supplier whose products you want to export. No supplier is selected by default.
Revenue Type(s): Selects which revenue types to include. All revenue types are included by default.
Product(s): Selects products associated with the chosen revenue types. All products are included by default.
Include Attributes: Determines whether the export includes product attributes and their configured values. No is selected by default.
Include HTML Description: Determines whether the export includes the product’s HTML description. No is selected by default.
Format: Selects the layout of the export. Choose Boomer for a file that can be re-imported. The Simple format cannot be re-imported. Floor Plan Products Only limits the export to floor plan products. Boomer is selected by default.
Exporting and Updating the File
After running the report, click the blue disk icon in the report parameter area and choose Excel to export the results.
In Excel, update the product columns as needed. Do not change the Product ID. Boomer uses this unique number to match products during re-import.
The Default Advance Price and Default Standard Price columns are highlighted because they are commonly updated at the supplier level.
For instructions on re-importing the file, see Importing Products.