This function allows you to sync the average units sold per day, for any given Faire SKU, into Google Sheets. Inputs Examples Returns the average number of units mysku123 sold on Faire each day over the last 30 days (total units sold, divided by 30). Returns the average number of units sold each day on …
=FAIRE_DAILYUNITS() – Average daily units sold over a date range Read More »
Want to sync the product name/title from an Amazon SKU into Google Sheets? Then this is the function for you! Inputs Examples Returns the product name/title for mysku123.
Our Faire to Google Sheets integration allows you to sync data like Units Sold by SKU, or raw reports like “all orders” directly into Google Sheets. See all of our Faire functions here. With Synchronize, you can sync Faire to Google Sheets and integrate this wholesale channel directly into your inventory management spreadsheets and other …
Want to sync Faire raw order data into Google Sheets? Then this is the function for you! Inputs Examples Returns a raw list of orders from the trailing seven days. Your function will always be refreshed to show the latest set of “t7” orders. Learn more about date ranges here. Historical Data When you connect …
Want to sync your Faire units sold data into Google Sheets? Then this is the function for you! Inputs Examples Returns the number of mysku123 units sold on Faire yesterday. Returns the number of units sold on Faire over the trailing 30 days (31 days ago, through yesterday) for the SKUs in cells A1 through …
=FAIRE_SOLDUNITS() – Units sold over a date range Read More »
Here is a complete list of the Google Sheets functions Synchronize enables for Faire sellers:
Want to sync your Faire revenue data into Google Sheets? Then this is the function for you! Inputs Examples Returns yesterday’s total Faire revenue for mysku123. Returns last month’s total revenue for the Faire account labeled Faire Store A. Returns the year-to-date total revenue across all Faire integrations. Historical Data When you connect a Faire …
=FAIRE_REVENUE() – Total revenue over a date range Read More »
This function allows you to sync the average units sold per day, for any given Shopify SKU, into Google Sheets. Inputs Examples Returns the average number of units mysku123 sold each day on Shopify over the last 30 days (total units sold divided by 30). Returns the average daily units sold on Shopify year to …
=SHOPIFY_DAILYUNITS() – Average daily units sold over a date range Read More »
Want to sync your Shopify revenue data into Google Sheets? Then this is the function for you! Inputs Examples Returns yesterday’s total Shopify revenue for mysku123. Returns last month’s total revenue for the Shopify account labeled Shopify Store A. Returns the year-to-date total revenue across all Shopify integrations. Historical Data When you connect a Shopify …
=SHOPIFY_REVENUE() – Total revenue over a date range Read More »
Here is a complete list of the Google Sheets functions Synchronize enables for Shopify sellers:
