Struggling Non-profit ~ Desperatily need advice.

Hello,

I volunteer at a nonprofit bookstore that operates an Amazon storefront reselling books, CDs, vinyl records, DVDs, and similar media. Unfortunately, due to a lack of proper inventory systems when the storefront was initially set up, we are now experiencing significant challenges and are at risk of deactivation because of high cancellation rates.

I’ve been trying to generate an accurate “active-only” inventory report to understand exactly what items are currently listed as available on Amazon. However, the reports I’ve pulled include both in-stock and out-of-stock listings, making it extremely difficult to reconcile our physical inventory with what is actually being shown as available online, especially given our high volume of products.

Has anyone encountered a similar issue? If so, were you able to create a reliable active-only inventory list or find a workaround to better match your physical stock with your Amazon listings?

Additionally, any guidance on implementing effective inventory management practices moving forward would be greatly appreciated.

Thank you in advance for your help.