a way to generate a report of all products with 0 qty

[pathbooks]

is their a way to generate a report of all products with 0 quantity? I want to delete these out of my system

[dotCOM_host]

You mean 0 quantity in inventory? If you were using Viking Coders' Inventory Manager, it comes with an add-on module for importing and exporting inventory counts. You could simply sort the list by the inventory count (in Excel) to see a list of items that have 0, and then delete those products. You'd still have some manual work to do, but at least getting a list of items with 0 inventory count would be easy...

If you are using the built-in inventory module, there's no such module that I know of. Your best bet would be to open the database in a DBF editor and export it into a flat file, perhaps, then open that in Excel and sort by inventory count to get all the items with 0 grouped together, and then manually delete them from the store.

[Bruce - PhosphorMedia]

You can "hide" out of stock products using an Inventory setting, or you could use VikingCoders Inventory Manager to look up these up and export them.

Of course, you could use our StoreMan product as well.

[wcw]

If you are using the built in inventory system in Miva Merchant and your version of Merchant is 4.14-4.24, there is a $10 module that will export and import the quantities in your inventory. For the products with zero quantity, the count column will be X instead of a whole number. Simply import that flat file into excel and sort on the count column. The flat file shows the product codes, quantity and product name.
http://www.emporiumplus.com/go/wcw/PROD/1AA/1AA00036

[wcw]

> If you are using the built-in inventory module, there's no such module that I know of. Your best bet would be to open the database in a DBF editor and export it into a flat file, perhaps, then open that in Excel and sort by inventory count to get all the items with 0 grouped together, and then manually delete them from the store.

Quantity is not a field in the products database. It is in a separate, related database. So you can't just export the one database and sort on it.