SerendipityOA Order Tracker Spreadsheet 2.0
Our Order Tracker 2.0 spreadsheet is a very powerful, automated tool that we use every single day in our Amazon FBA business.
Not only does it allow you to track your order’s quicker and more efficiently than a regular spreadsheet, it also organizes your sheet for you automatically, helps to streamline your shipping process, gives you a ton of different data points on the units you have purchased and so much more.
The spreadsheet does take a few minutes to set up, but you only need to do this once. After that, you can save a ton of time in your regular day to day operations.
Features of The Order Tracker spreadsheet include:
- OA, RA & Wholesale Order Tracker Sheets
- Separate order tracking for OA, RA & Wholesale. Automation is built in to organize and move each product under the correct supplier.
- Visual indicators to inform you weather you have received the correct amount that you have ordered from your supplier
- Streamlined shipping process with visual indicators to inform you weather your items need to be added to a shipping plan or already have been added to a shipping plan.
- Dashboard
- Dashboard which provides a ton of valuable information at a glance including: how many units you have on order total, how many units you have left to send to FBA, total cost & potential profit of units you have on order and more.
- Inventory on Hand Tracker
- Helps you keep track of any overstock. This worksheet also includes a built in shelf/bin system & visual indicators for old and expiration dated inventory.
- Supplies Order Tracker
- Helps you keep track of any shipping or business supplies that you or your staff have ordered and received.
- Daily Spend Tracker
- Assists you in setting and hitting daily and monthly spending goals to help your business grow. The Daily Spend Tracker automatically pulls in your order information from the rest of the spreadsheet and displays how much you have spent each day along with what your goal is for that day and month.
-
Stats Dashboard
- Shows you an entire breakdown of all of your suppliers and provides you information about how many units you've ordered from that supplier and information about any outstanding items you have ordered but not yet received from them
-
Taxes Dashboard
- Shows you an entire breakdown of all of your suppliers and provides you information about the total purchases made from each supplier along with the expected taxes that you should have paid on those purchases
- Shows you an entire breakdown of all of your suppliers and provides you information about the total purchases made from each supplier along with the expected taxes that you should have paid on those purchases
Order Tracker 2.0 demo: https://youtu.be/7MS5FJD99HU
Order Tracker 1.0 demo & overview: https://youtu.be/r0SAItND2As
Video on how to activate script: https://youtu.be/WetVr9wKldQ
Video on how to set up the Order Tracker with SellerAmp: https://youtu.be/JTEs07y5VhU