Configuring Faire Exports

Set up Faire exports to send wholesale product, order, and inventory data into Google Sheets, BigQuery, or Excel.

Overview

After connecting Faire, use the Export Builder to create exports. Each export can include one or more data tabs (for example Products and Orders) and writes to a single Google Sheets spreadsheet, BigQuery dataset, or Excel file.

Prerequisites

Faire connected (see Connecting Faire)
A Google Sheets, BigQuery, or Microsoft Excel destination configured

Create an export

Go to Export Builder and create a new export.
Select Faire as the source and choose your connected account.
Select a destination (Google Sheets, BigQuery, or Excel).
Give the export a name.
On the configuration page, choose a date range and select the data tabs and columns you want.
Save the export and run it manually to validate the output.

Available data tabs

Each enabled tab writes to its own sheet tab, Excel worksheet, or BigQuery table. Nested fields (prices, addresses, options) are flattened into columns; list fields are exported as JSON text.

Products: your product catalog, including lifecycle state and category
Product Variants: individual SKUs, pricing, and options for each product
Orders: wholesale orders with retailer and shipping details
Order Items: line items for each order, including quantity and price
Inventory: on-hand and available quantity by SKU
Brand Profile: your connected brand's public profile details
Taxonomy Types: Faire's product category reference data

Date ranges

Date presets (including Since last export and Maximum) apply to date-filterable tabs such as Products, Product Variants, Orders, and Order Items. Reference tabs like Inventory, Brand Profile, and Taxonomy Types export in full each run.

Append vs replace

For each tab you can choose append (add new rows) or replace (overwrite existing data). Use append with Since last export when you want incremental history in Sheets or Excel.

Scheduling

After saving an export, set a schedule from the export detail page so data refreshes automatically. Manual runs are always available from the same page.