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 »
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 »
Here is a complete list of the Google Sheets functions Synchronize enables for Amazon Seller Central users:
Hey My Wife Quit Her Job listeners 👋 Use the link below to start your free trial. We’ll extend your trial from 14 days to 30 days, and apply a 20% discount for your first 6 months.
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.
