Hi Reymondo, thanks for your reply!

That's a great way around the issue. Yes, the inactive items are greater than the active ones. But I'm not using the online version, I am on Enterprise Desktop version 20.0 with advanced inventory. I tried to follow your instructions but it seems like the menu is different... 

Do you have a solution for my desktop version? I also need to clean up the quantities. FYI- we bought a company and inherited their 10 year old database. So I need to delete wrong quantities (zero out qty on many inactive items, and update the active ones).  I am about to complete an integration with Webgility and need to get a clean start before I start importing all the sales data that will come via their integration (sales price & quantity per item). I have already updated the prices in the item "card" both cost and sales price. I also just turned the advanced inventory on, to create several warehouses that we will be using through ShipBob (3PL). So for now, as a start point I need to default all items to my main warehouse, so later we will be transferring items from one Site to another based on the reports I will pull from their website. I was thinking of doing also an excel import to transfer items from site A to B on a periodic basis. This may be a an exercise we will be doing once per week or even more often if demand requires us to. Do you thing this is a good idea? Or I should not "risk it" and do actual inventory transfer (manually from the inventory menu)?

Any thoughts are welcome.  Has anyone in the community tried to integrate with Webgility and/or Shipbob? Any Best Practice or experience you can share??

Thank you community. Your help has been very helpful. This is great.