Dynamic Collection for New Arrivals based creation date (for Shoptimized theme)

New Member
1 0 0

On the homepage we want to show a collection of products in a grid created in the last period (e.g. 14 days), but limited to X products (e.g. 24 or 36) and pagination for more if there are any.

At this moment we do this by filtering tagged products (e.g. "newarrival"), but this is very limited and not manageable for >100,000 products. This store gets new products on a daily basis, so we are looking for a future proof solution.

Can this be done?

If so, can someone help me with the liquid code for this?