Jan 30: Welcome to your IAPC Dashboard! This has been a labor of love getting this up and running, but we’re excited that it’s finally here!
In case you didn’t read the email we sent you in full, here are all the important things that you need to know:
PLEASE NOTE: NUMBERS MAY NOT BE UP TO DATE While the dashboard itself is functional, the data is very likely not up to date. As part of the creating this dashboard, we have been migrating to a new and better inventory management system. During this period, we have been keeping all inventory and shipping data separately, and have been actively working to enter this data into our new system. We have all of the data up to date for all of our warehouse clients through October 31 (this is why you haven’t received any warehouse invoices for November or December yet). We are working hard to enter the rest and are hoping to be fully caught up within the next couple of weeks. But in the meantime, some of the numbers on your dashboard may look a little wonky or not be fully up to date.
UNDERSTANDING THE DASHBOARD:
Number or Units Shipped Per Month: This simply shows you the total number of units we have shipped for you per month, broken up by sales channels (your site, Amazon, OakieBees, etc). The number per month shows the total for all of the different products you have in our warehouse, and is not currently broken down by title or product type.
If you have shipped more books to us over the past few months, you will see that amount listed as “Receiving” – this will appear as a negative number
—–
Total Earnings Per Month: This is only your total earnings on OakieBees or in our Itty Bitty Book Nook stores. We do not estimate or include your earnings from your own site, Amazon or other sources in this calculation
—–
This & Last Month: An oddly named section (I’m not sure who came up with this…), this section will detail any shipments that have gone out for your books in the current or previous month. Only products that have had active shipments will appear here.
On the top line for each product, you’ll see the title for your book or product, along with the author name, the quantity in stock, the base inventory (this is how many we started with when we began entering the data into this new system – we will likely remove this column from view in the future), the ISBN number and cover price (these are likely to be blank for now), and the total quantity that we have shipped last month and this month.
If you open the top line its, (click the right facing carrot before the title of your product), you’ll see a list of all of your orders, starting with the name of the recipients, the source of the orders, the date and month when the sales order was created, the PO number, the number of units shipped, the fulfillment price, the shipping address (typically listed as just the city and state), our shipping method, the postage cost, the tracking number (for now, you’ll only;y see the last 4 digits of any tracking number – once we are caught up and are entering data daily, we will include the full tracking numbers). At th end of the row is how much you are owed for that shipment, if the line item came from either OakieBees or the Itty Bitty Book Nook.
—–
Storage: This is simply how much your storage cost is for the current month. This number will drop throughout the month as you get more orders that we ship, and your inventory gets reduced (we charge storage based on the quantity in stock on the last day of the month).
—–
Fulfillment: This is how much your fulfillment cost is for the current month.
—–
Postage: This is how much your postage fees are for the current month.
—–
Returns: This shows the number of returns we’ve received for your book. It does not show how much your fees are for returns – just the number of returns received
—–
Quantity in Stock: This is the total number of units you have in stock in our warehouse – it is a cumulative number, and not yet broken down by title or product type
—–
Net (+/-): This shows how much is owed. If the number is negative, it means that you use that amount, and will be reflected in your invoice for the current month. If the amount is positive, then that means that we owe you money (your earnings through OakieBees and the Itty Bitty Book Nook were higher than your storage, fulfillment and other costs) – these will be paid on the last day of the following month.
—–
Total Earnings: This is a total of how much you have earned in the current month through OakieBees and the Itty Bitty Book Nook
—–
Estimated Invoice: This is your total invoice for the current month, adding together storage, fulfillment and postage. Please note that there may be additional costs in your invoice that are not shown here, such as the cost of returns or any requested services like shrink wrapping, assembly, etc.
—–
Current Contest Place: We will very often run sales contests for OakieBees with cash or other prizes. This section will show you what place you’re in in the given contest
—–
Points: In the future, we’ll be introducing a points-based system where you can accumulate points towards rewards. Once we do, this is place where you can see how many points you have. More on this to come.
—–
PLEASE VIEW THIS LOOM VIDEO FOR A COMPLETE OVERVIEW IN USING THE DASHBOARD: https://www.loom.com/share/425e1893203f448cafc3a454c4313e17