I need to create an order for my supplier

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   When locating apparel products, I see that I can search for all products or for in-stock products only. However, I need to search for out of stock subproducts only (or products below the re-order level), in order to create an order for my suppliers.

Identifying products showing in the 'all products' search which are not appearing in the 'in stock' search, it seems that an item shows as in stock if one or more of its subproducts are in stock. I need the reverse, i.e. for a product to show if one or more of its subproducts is out of stock. Perhaps I can do this by writing a custom query.

Has anyone experienced this difficulty, or resolved it?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bodyexposed Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 16-September-2008 Location: London UK Status: Offline Points: 6	Post Options Post Reply Quote bodyexposed Report Post Thanks(0) Quote Reply Topic: I need to create an order for my supplier Posted: 06-October-2008 at 1:04pm
	When locating apparel products, I see that I can search for all products or for in-stock products only. However, I need to search for out of stock subproducts only (or products below the re-order level), in order to create an order for my suppliers. Identifying products showing in the 'all products' search which are not appearing in the 'in stock' search, it seems that an item shows as in stock if one or more of its subproducts are in stock. I need the reverse, i.e. for a product to show if one or more of its subproducts is out of stock. Perhaps I can do this by writing a custom query. Has anyone experienced this difficulty, or resolved it?
	Richard Bonfield Underwear store for men http://www.bodyexposed.co.uk

bodyexposed Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 16-September-2008 Location: London UK Status: Offline Points: 6	Post Options Post Reply Quote bodyexposed Report Post Thanks(0) Quote Reply Posted: 16-October-2008 at 12:38pm
	I've answered my own question, and created a low stock list by editing a copy of viewStock.asp. If anyone wants the code, drop me a line.
	Richard Bonfield Underwear store for men http://www.bodyexposed.co.uk