Want to sync your Amazon Subscribe and Save data into Google Sheets? This function allows you to pull the number of active subscribers for any SKU in your catalog. You can also provide a date (optional) to get the number of subscribers at a specific historical point. Inputs Examples Returns the number of active Subscribe …
=AMAZON_ACTIVESNS() – Get the number of active Subscribe and Savers for a SKU Read More »
Want to sync your Amazon FBA revenue data into Google Sheets? Then this is the function for you! Inputs Examples Returns yesterday’s total Amazon revenue for mysku123. Returns last month’s total revenue for the seller account labeled Seller Account A. Returns the year-to-date total revenue across all Amazon integrations. Historical Data When you connect an …
=AMAZON_REVENUE() – Total revenue over a date range Read More »
This function allows you to sync the average units sold per day, for any given Amazon SKU, into Google Sheets. Inputs Examples Returns the average number of units mysku123 sold each day over the last 30 days (total units sold divided by 30). Returns the average daily units sold on Amazon year to date for …
=AMAZON_DAILYUNITS() – Average daily units sold over a date range Read More »
Want to sync Amazon raw reports (like “Manage FBA Inventory” or “All Orders”) 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 …
=AMAZON_REPORT() – Sync raw reports from Seller Central Read More »
Want to sync your Amazon listing prices into Google Sheets? Then this is the function for you! Inputs Examples Returns the latest price for mysku123. Return your Amazon price for mysku123 on 2022-06-15. Historical inventory data starts being logged once you sign up for Synchronize and connect your Amazon account.
Want to sync your Shopify units sold data into Google Sheets? Then this is the function for you! Inputs Examples Returns the number of mysku123 units sold on Shopify yesterday. Returns the number of units sold on Shopify over the trailing 30 days (31 days ago, through yesterday) for the SKUs in cells A1 through …
=SHOPIFY_SOLDUNITS() – Units sold over a date range Read More »
Want to sync your Shopify inventory levels into Google Sheets? Then this is the function for you! Inputs Examples Returns the latest Shopify inventory count for mysku123. Returns the Shopify inventory count for mysku123 on 2022-06-15. Historical inventory data starts being logged once you sign up for Synchronize and connect your Shopify account.
Want to sync your Amazon FBA units sold data into Google Sheets? Then this is the function for you! Inputs Examples Returns the number of mysku123 units sold on Amazon yesterday. Returns the number of units sold on Amazon over the trailing 30 days (31 days ago, through yesterday) for the SKUs in cells A1 …
=AMAZON_SOLDUNITS() – Units sold over a date range Read More »
Want to sync your Amazon FBA inventory levels into Google Sheets? Then this is the function for you! Inputs Examples Returns a list of all integrations connected to your Synchronize account. Returns a list of only the Shopify integrations connected to your Synchronize account.
Want to sync your Amazon FBA inventory levels into Google Sheets? Then this is the function for you! FBM support is coming soon. Inputs Examples Returns the total FBA inventory for mysku123. Returns the total FBA inventory in “unsellable” status. Returns the total FBA inventory for mysku123 on 2022-06-15. Historical inventory data starts being logged …
