Maybe I just don't know how to do it...
...but I think the ability to do the following would be great additions (if they aren't already doable):
1. Supplier Profitability report showing the actual units sold. It's nice to see Supplier A is 32% of my income, but if I have 40 different products, I would like to know on one page how many of each product from that one supplier I sold.
1(a). From the same item - Inventory Valuation should include Supplier column so I can sort by it so I can see how much inventory from that one supplier I have still on hand - for both FBA and FBM combined. I shouldn't have to look at FBA then FBM to try and get the full picture.
2. N/A list that shows you which items are considered N/A. Right now in Supplier Profitability it shows me profitibility for 5 units from "N/A" supplier, but when I click on "N/A" it shows me no products. I think it's pulling items that I sold before I started using the program that have not been replened yet and didn't have supplier listed at the time, but I can't see which ones those are.
2(a). From the same item - I would like to be able to run a report of all items in inventory which are not assigned to a supplier. This would allow me to clear up old data and make sure it is assigned accordingly for relavant reports.
3. Dashboard - Could you add a YTD Widget along with the current monthly widget?
4. Along the lines of a previous post to these forums - better utilization of "Unlisted Inventory" - let me input inventory for Amazon (supplier, cost, purchase date, expiration date, etc etc) but not assign it to FBA/FBM - instead it sits there until I'm ready for a shipment, then allow me to import it into a new Batch from a simple "Import From Unlisted" buttom where I could batch select items to pull into an active batch that I'm prepping.
5. Kind of an afterthought - I would prefer Sales and Inventory to be default "all", and then allow me to use Advanced to screen between FBA and FBM as needed. It would also be nice to search either of those listed by Supplier as well.
Thanks again for taking the time to read this!
-
Hi Walter,
Thank you for commenting, and apologies for not seeing this when it initially posted!
We are looking at ways to provide more information for the Supplier profitability report, so this has been added to the user suggestion currently in place. I have added the request about the Supplier Column or option to the Inventory Valuation report as well.
For the N/A list in Supplier Profitability, that could be sales for items no longer listed in your inventory. In order to find these transactions, navigate to the Accounting>FBA Sales page, click on the Advanced button and search for ALL by clicking on the button that defaults to "last 1 month" and changing to ALL. Once they have populated, export the report and then sort the file to group suppliers. You can then add in the suppliers to that .csv file and import it back into your sales page to correct this:
Bulk Import Accounting Details Into Sales
For the supplier, make sure you use the Cost Per Order ID selection detailed in the above article as that is the only option that lets you change supplier. Also, make sure to take note of the red text for warnings about cost changes if you are going to update any costs.
The Dashboard does allow you to set the time frame, in the upper right corner of that page:
For the Unlisted Inventory, you can add it there as inventory but then select it as Merchant or FBA when you add it into the batch (since the batch is set to either MFN or FBA when you create it). The Unlisted Inventory isn't classified either way, just tied to an Amazon listing or not when you add items there. The import feature though is a current suggestion so we have that on our list. For the default selection, we have also forwarded that suggestion to our developers. But instead of default, have it remain as you set it until you change it. Much like on the List & Prep page when you set the search for Amazon +Unlisted Inventory, Amazon Only, or Batch only searches.
I hope that helps!
Please sign in to leave a comment.
2 comments