You can export your products along with the lowest vendor price, either across all vendors or limited to selected competitors.
While this can be done as a one-time export from the Product List, best practice is to create an Output Feed if:
The file needs to be updated dynamically
You need structured vendor data using the “Have vendors as rows” (Multiline) option
Why “Have vendors as rows” (Multiline) can be a best practice
One product can have multiple vendors
Each vendor has its own name and price
Example with multiline enabled
Product ID | Vendor name | Vendor price |
123 | Vendor A | 99 |
123 | Vendor B | 105 |
When “Have vendors as rows” is enabled:
Each vendor becomes its own row
Product information repeats per vendor
The data becomes structured and analysis-friendly
Option 1: One-time export from Product List
This method is suitable for quick, manual exports.
Step 1: Filter for the cheapest vendor
Go to the Product List:
Click Add filter
Under Vendor filters, select Top cheapest → X is 1
Click Apply filter
This ensures that only the cheapest vendor per product is included in the export.
Step 2: Select products and open the export settings
In Products → Product List:
Click Select all
Click Export products
This opens the export window.
Step 3: Choose attributes and export
In the Export window:
Select the attributes you want included (e.g., Product ID, GTIN, Vendor name, Vendor price)
Click Export
The file will now download as Excel or CSV.
Why vendor data appears as columns in Excel or CSV
When exporting to Excel or CSV, vendor data is automatically structured as columns. This format is fixed and cannot be changed for Product List exports.
Example
ID | Vendor 1 price | Vendor 2 price | Vendor 3 price | Vendor 4 price |
123 |
|
| 379.95 |
|
124 |
| 299.00 |
|
|
In this example:
Vendor 3 is the cheapest for product 123
Vendor 2 is the cheapest for product 124
The file needs a column header before any data can be inserted. Therefore, a column is created for each vendor, even if only one vendor’s price will be filled in per product.
Excel and CSV files require a fixed column structure with defined headers:
Each vendor must have its own column
Each column must have a header before data can be placed in it
For that reason:
The system creates one column per vendor
The column header is the vendor name + price
Only the cheapest vendor’s price is filled in
The remaining vendor columns stay empty
Option 2: Create an Output Feed (Best Practice)
You can also use an Output Feed when:
The file needs to be updated automatically
You want vendor data structured as rows instead of columns
Step 1: Create a new Output Feed
In Feeds → Output Feeds:
Click Create Output Feed
(Available on the front page or in the upper right corner)
Step 2: Select file type and enable multiline
In step 1 - General details for the Output Feed setup:
Under File type, select Google Sheets
Under Multiline, enable Have vendors as rows
(it gets available when you selecet google sheet)
Why “Have vendors as rows” (Multiline) can be a best practice
A product can have multiple vendors
Each vendor has:
Name
Price
With “Have vendors as rows” enabled:
Each vendor becomes its own row
Product information repeats per vendor
The file becomes structured and analysis-friendly
Example:
Product ID | Vendor name | Vendor price |
123 | Vendor 3 | 379.95 |
124 | Vendor 2 | 299.00 |
This structure avoids the empty vendor columns that appear in Excel or CSV exports.
Step 3: Select products
In Step 2 – Product selection:
Set your filters
Filter by product group, brand, category, or feed logic if needed
Example:
Set filter: Feed is X
Step 4: Select product attributes
In Step 3 – Product attributes:
Under the own attributes section, select your product attributes (e.g., ID, GTIN, SKU, Title, Brand)
These fields will repeat per vendor when Multiline is enabled.
Step 5: Configure vendor attributes
In Step 3 – Product attributes:
Under the Vendor attributes section:
Enable the vendor data section (toggle on)
Set filter: Top cheapest → X is 1
Select the vendor attributes you want included (e.g., Domain, Vendor price)
Because Multiline is enabled:
Only the vendor ranked #1 (cheapest) generates a row
Each product will have exactly one row
The structure remains clean and analysis-ready