You can export your products along with vendor data either as a one-time export from the Product List, or as an Output Feed that updates automatically. If you want vendor data structured as rows (one row per vendor per product), use an Output Feed with Google Sheets as the file type.
Option 1: One-time export from the Product List
This method works for quick, manual exports. Vendor data is always structured as columns in Product List exports, one column per vendor, and that format cannot be changed.
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 only the cheapest vendor per product is included in the export.
Step 2: Select products and open the export settings
Click Select all
Click Export products
Step 3: Choose attributes and export
Select the attributes you want included (e.g., Product ID, GTIN, Vendor name, Vendor price) and click Export.
The file downloads as Excel or CSV.
Note: In Excel and CSV exports, vendor data always appears as columns. Each vendor gets its own column, and only the cheapest vendor's price fills in for each product. The remaining vendor columns stay empty. This is fixed behavior for Product List exports.
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 and Vendor 2 is the cheapest for product 124. A column is created for every vendor, even though only one price fills in per row.
Option 2: Output Feed (recommended)
Use an Output Feed when you want the file to update automatically, or when you want vendor data structured as rows instead of columns.
Step 1: Create a new Output Feed
Go to Feeds → Output Feeds and click Create Output Feed.
Step 2: Select file type and enable "Have vendors as rows"
In Step 1 - General details:
Under File type, select Google Sheets
Under Multiline, select Have vendors as rows
Note: The Multiline option only appears after selecting Google Sheets as the file type.
With Have vendors as rows enabled, each vendor appears as its own row in the sheet, and product attributes repeat on each row. This avoids the wide, sparse column layout that Product List exports produce.
Product ID | Vendor name | Vendor price |
123 | Vendor 3 | 379.95 |
124 | Vendor 2 | 299.00 |
Step 3: Select products
In Step 2 - Product selection, set your filters (e.g., by product group, brand, category, or feed).
Step 4: Select product attributes
In Step 3 - Product attributes, under Own attributes, select the product fields you want included (e.g., ID, GTIN, SKU, Title, Brand). These fields repeat per vendor row.
Step 5: Configure vendor attributes
Under Vendor attributes:
Enable the vendor data toggle
Set filter: Top X Cheapest → X is 1
Select the vendor attributes you want included (e.g., Domain, Vendor price, difference %)
With the filter set to 1 and Have vendors as rows enabled, each product produces exactly one row showing its cheapest vendor.







