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.
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 »
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 »
Want to sync your Amazon FBA tier by SKU into Google Sheets? This function allows you to pull the FBA tier for any SKU, so you can keep an eye on which products Amazon is considering standard sized or oversized. You can also provide a date (optional) to get the FBA tier for a SKU …
=AMAZON_FBATIER() – Get a SKU’s FBA fulfillment tier Read More »
Want to sync your Amazon referral fees by SKU into Google Sheets? This function allows you to pull the Amazon referral fee for any SKU. You can also provide a date (optional) to get the referral fee for an SKU at a specific historical point. Inputs Examples Returns the current Amazon referral fee for mysku123. …
=AMAZON_REFFEE() – Get a SKU’s Amazon Referral Fee Read More »
Want to sync your Amazon FBA fees by SKU into Google Sheets? This function allows you to pull the FBA fulfillment fee for any SKU. You can also provide a date (optional) to get the FBA fee for an SKU at a specific historical point. Inputs Examples Returns the current FBA fulfillment fee for mysku123. …
=AMAZON_FBAFEE() – Get a SKU’s FBA fulfillment fee Read More »
