Ajeh:
First, fix your site for Known Bug Fixes:
http://www.zen-cart.com/forum/showthread.php?t=82619
specifically it looks like your Upcoming product is marked as Out of Stock and is still showing in the Upcoming Product Center Box ...
Thank you very much for the reply, it pointed me in the direction I needed! The upcoming products listing is now working as I want it to. My supplier for that store uses the same "in stock" quantity field, in their tab delimited Excel file, for showing how many will be in stock on a certain day, as they do with products that are currently in stock.
I wrote a program that takes that Excel file and manipulates the data of each product, and then uses the results to create a file for Easy Populate v1.2.5.4 (EP) to use to import (and manage) inventory to the store. When I decided to show ALL prices as a "special" in the store, which is a markdown from the manufactures suggested list price, I failed to set the EP field named v_status to "0" when the supplier was showing an inventory that was currently in stock (in the EP v_products_quantity field) but which would not actually be available until the date shown in the EP v_date_avail field.
I used EP to get a complete list of all store products so I could look at it in Excel. Only 4 products had an EP v_products_quantity field of greater than "0" along with an EP v_date_avail field showing a future date and a v_status field having a value of "1". In those 4 cases, that represented what the stock would be but only on and after the date shown in the EP v_date_avail field. But my program had set the EP v_status field to "1" instead of to "0" in those 4 cases. This particular combination of EP field settings will cause ZC to list the products as to be available at a later date (as I want it to do) but also allow a user to click a link in that same list and see the product and add it to the cart! Setting v_status to "0" in those cases altered that behavior so that ZC would report that product as being not found if the link is clicked in the future availability list and so the product cannot be added to the cart, which is exactly what I want and how the store behaves now. Because only 4 products were acting wrongly when clicked in the future availability listing, I was just lucky to have noticed the issue by clicking on a link!
Bottom line is: If a product has an EP v_date_avail field that is not empty and it points at a future date, then make sure the EP v_status field has a value of "0". Then the EP v_products_quantity field content will be ignored by ZC as if there was no stock even though that field shows there is stock (which will be available on the date shown in the EP v_date_avail field). I've no idea if ZC will or will not effectively set things as visible to the user to place into the cart (the same as setting the EP v_status field to "1") once the date shown in the EP v_date_avail field arrives but only if the EP v_products_quantity shows a value above zero (I'm betting it doesn't, but I think it should).