Opencart 2.0.3.1 - Some products not showing up in category lists

Question

In the Opencart admin area I have four categories (A B C D) and 20 products (1-20). I first created the categories and checked the Top box under data so that they would show up on the home page. I then created the products, 1-16 under category A, 17-18 under B, 19 under C, and 20 under D. However when I visit my store front, there are no products under C or D, and product 18 is missing from category B. Products 1-17 are all showing up where they should be.

I have SEO urls turned off, so this is not the root of the issue. The meta tag for all categories and products is set to "random" as I am still setting everything up.

Where should I begin troubleshooting in order to solve this issue? I tried adding some more products, and though I have added them to categories they still won't show up.

Answer 1

The problem is the availability date. OpenCart now autopopulates it. If OpenCart can't find your time zone it defaults to UTC which can make the availability date the following day for some people.

Please assign previous availability and check its working proper.

Answer 2

Also, Pre-Order items do not show on the category pages, which seems like a bug to me. On the Data tab from the edit product page there is a "Out of Stock Status" Setting which when set to Pre-order items do not show on the category page.

Answer 3

The problem is the availability date. In that the date shall not exceed the current date. For example if today is 06-17-2016 and if we give 6-18-2016 in date_available, that particular product will not be counted and not displayed too, even though the product can be viewed from the dashboard.