Generating a site map for dynamic data

So my site is now done and ready to submit to Google, however I am having issues creating a sitemap for the content (which is dynamic)
with over 7K products I can not get the dynamic product links to show when I generate a site map online. Pages that have static links are no issues and they index on the sitemap.

I know with magento it will create a site map of the products, but how can I get this done using Wappler. Getting away from Magento is why I created this site.
In the old days DMX had an extensions to allow access in to the database, does anyone know the code it added to allow this?