Faire data reference

A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes whether it uses the export date range or always exports a full current snapshot when that applies.

For configuration steps see Configuring Faire exports.

Products

Product catalog (GET /products) Date range: uses the selected export date range.

Column	Description
Product ID	Product ID from the source platform.
Name	Name.
Short Description	Short Description.
Description	Description.
Brand ID	Brand ID from the source platform.
Taxonomy Type ID	Taxonomy Type ID from the source platform.
Taxonomy Type Name	Taxonomy Type Name.
Lifecycle State	Lifecycle State.
Sale State	Sale State.
Active	Active.
Is Deleted	Boolean: Is Deleted.
Unit Multiplier	Unit Multiplier.
Minimum Order Quantity	Minimum Order Quantity.
Preorderable	Preorderable.
Made In Country	Made In Country.
Wholesale Price Amount	Wholesale Price Amount in the row currency unless noted otherwise.
Wholesale Price Amount (minor units)	Wholesale Price Amount (minor units) in the row currency unless noted otherwise.
Retail Price Amount	Retail Price Amount in the row currency unless noted otherwise.
Retail Price Amount (minor units)	Retail Price Amount (minor units) in the row currency unless noted otherwise.
Created At	Created At.
Updated At	Updated At.
Images	Images.
Options	Options.
Variant Count	Variant Count.

Product Variants

Variants nested within each product (from GET /products) Date range: uses the selected export date range.

Column	Description
Product ID	Product ID from the source platform.
Product Name	Product Name.
Variant ID	Variant ID from the source platform.
SKU	SKU.
Variant Name	Variant Name.
GTIN/UPC	GTIN/UPC.
Wholesale Price Amount	Wholesale Price Amount in the row currency unless noted otherwise.
Wholesale Price Amount (minor units)	Wholesale Price Amount (minor units) in the row currency unless noted otherwise.
Wholesale Price Currency	Wholesale Price Currency (ISO 4217 when applicable).
Retail Price Amount	Retail Price Amount in the row currency unless noted otherwise.
Retail Price Amount (minor units)	Retail Price Amount (minor units) in the row currency unless noted otherwise.
Retail Price Currency	Retail Price Currency (ISO 4217 when applicable).
Available Quantity	Available Quantity.
Weight	Weight.
Options	Options.
Is Active	Boolean: Is Active.
Created At	Created At.
Updated At	Updated At.

Orders

Wholesale orders (GET /orders) Date range: uses the selected export date range.

Column	Description
Order ID	Order ID from the source platform.
Display ID	Display ID from the source platform.
State	State.
Created At	Created At.
Updated At	Updated At.
Ship After	Ship After.
Retailer ID	Retailer ID from the source platform.
Customer First Name	Customer First Name.
Customer Last Name	Customer Last Name.
Customer Email	Customer Email.
Ship To Name	Ship To Name.
Ship To Company	Ship To Company.
Ship To Address 1	Ship To Address 1.
Ship To Address 2	Ship To Address 2.
Ship To City	Ship To City.
Ship To State Code	Ship To State Code.
Ship To Postal Code	Ship To Postal Code.
Ship To Country Code	Ship To Country Code.
Ship To Phone Number	Ship To Phone Number.
Item Count	Item Count.
Order Total Amount (computed)	Order Total Amount (computed) in the row currency unless noted otherwise.
Order Currency (computed)	Order Currency (computed) (ISO 4217 when applicable).

Order Items

Line items nested within each order (from GET /orders) Date range: uses the selected export date range.

Column	Description
Order ID	Order ID from the source platform.
Order Display ID	Order Display ID from the source platform.
Order State	Order State.
Item ID	Item ID from the source platform.
Product ID	Product ID from the source platform.
Variant ID	Variant ID from the source platform.
SKU	SKU.
Product Name	Product Name.
Variant Name	Variant Name.
Quantity	Quantity.
Price Amount	Price Amount in the row currency unless noted otherwise.
Price Amount (minor units)	Price Amount (minor units) in the row currency unless noted otherwise.
Price Currency	Price Currency (ISO 4217 when applicable).
Includes Tester	Includes Tester.

Inventory

Inventory levels by SKU (GET /product-inventory/by-skus), looked up for every product SKU Full export each run: current snapshot; the date range does not apply.

Column	Description
SKU	SKU.
Product Variant ID	Product Variant ID from the source platform.
On Hand Quantity	On Hand Quantity.
Available Quantity	Available Quantity.
Discontinued	Discontinued.

Brand Profile

Connected brand's public profile (GET /brands/profile) Full export each run: current snapshot; the date range does not apply.

Column	Description
Brand ID	Brand ID from the source platform.
Name	Name.
Currency	Currency (ISO 4217 when applicable).
Locale	Locale.
Description	Description.
Website URL	Website URL.
Logo Image URL	Logo Image URL.
Email	Email.
Phone Number	Phone Number.
Address 1	Address 1.
Address 2	Address 2.
City	City.
State Code	State Code.
Postal Code	Postal Code.
Country Code	Country Code.
Created At	Created At.
Updated At	Updated At.

Taxonomy Types

Available product categories (GET /products/types) Full export each run: current snapshot; the date range does not apply.

Column	Description
Taxonomy Type ID	Taxonomy Type ID from the source platform.
Name	Name.
Parent ID	Parent ID from the source platform.
Path	Path.