If you’re like most Amazon sellers, you probably use Google Sheets to manage areas of your business like inventory management.
We built Synchronize to help connect your e-commerce data with Google Sheets.
1. FBA Inventory
Knowing the current stock level of your products at FBA is absolutely critical for inventory management and order forecasting.
You can pull a daily refreshing inventory count for any SKU directly into Google Sheets with this formula:
=AMAZON_INVENTORY(mysku123)If you’re looking for more granularity – let’s say for example you want to know how many units are on the way to Amazon (“Inbound Shipped” in Amazon terms), just add that as a parameter:
=AMAZON_INVENTORY(mysku123,"inbound-shipped")2. Units Sold
To forecast your inventory and plan for future orders, you’ll need to know how many units per day each product in your catalog sells.
This data point can be frustratingly complicated to pull manually. Amazon has so many reports from “All Orders” to “Business Reports,” which all update at different frequencies and can show conflicting tallies.
We’ve simplified things, pulling your units sold directly from your orders shipped. To get the number of units sold for any particular SKU over a date range, just use this formula:
=AMAZON_SOLDUNITS(mysku123,"2020-08-01 to 2020-08-10")'We’ve also included a bunch of handy date range presets like:
=AMAZON_SOLDUNITS(mysku123,"yesterday")and:
=AMAZON_SOLDUNITS(mysku123,"t30")3. FBA Fees
Amazon charges a shipping free for each product they ship on your behalf. This fee varies based on the weight and dimensions of the product. Sounds simple enough, right?
Wrong. Amazon is constantly measuring and remeasuring items… and they rarely “update” an item’s weight or dimensions in your favor.
That’s why it’s important to stay on top of Amazon and make sure they aren’t incorrectly bumping your products up into the next weight or size tier. Use this formula:
=AMAZON_FBAFEE(mysku123)to keep track of changes to your products’ fees and weights at Amazon’s fulfillment centers.