Products not showing up in collection page

I agree.

I have all kinds of “theories” as to why this bug happens from the Cache, browser cache, server cache, Shopify CDN to database CRON jobs… whatever…

alas… all my “theories” all fall by the wayside.

The simple facts for us on any shop we manage are as follows:

  1. Yes, there is indeed a BUG in the “collection” process
  2. Sometimes it gets fixed by “waiting” a few days
  3. Other times nothing happens
  4. When we have to launch a new collection and it needs to be done ASAP:
    we ALWAYS end up deleting the “auto-add” collection,
    making a new collection,
    manually adding the products (immediately, in the same action as creating the collection)
    and hoping it works.

We have plans to “capture” this problem in a screen recording next time it happens.

I would encourage you to do the same using something like Camtasia, record the screen and show it to Shopify to say “look. see? its real” and if enough people do that I think they will address it.