I have been looking at CMS over the last several weeks, and it seems they fall into Git-based and API-based categories.
From there, they split into SAAS versus self-hosted.
My impression of most Git-focused and Jekyll-friendly CMS’s are that they are more focused on Markdown / text / blogging / Informational type of functionality.
For now, that isn’t our problem area. Where our bottle neck is, is setting up and maintaining our eStore, which is over 200 products and growing. To date, I have maintained this from a spreadsheet feeding into CSV, and then using Jekyll to iterate the products within each category. For various reasons, this means a template page for each category.
For now, the individual item pages are created through a Python program, and then Jekyll kicks in.
Very obviously the spreadsheet has issues: invalid characters in the text-content-fields can break the load, and handling images for 200 products (typing in the URI to the CSV and uploading the images to the target directories) is obviously a real PITA.
Plus it forces over-simplification on how we need to manage the store.
For example, a simple data structure would be site, site-category, category, product-category, product, brand, product-brand, product-images, customer-type, customerType-category (for discounts) as a start.
I have tried a few of the open-source API-focused CMS packages, such as Strapi and Directus. There are also commercial and hosted solutions, but we don’t want to commit the money there until we know how the site is going to work
Very concerning is that some of the open source packages don’t seem to have a lot of traction, or have an incompatible technology stack (we don’t use PHP and MySQL), or are very buggy…
One of them I have started a test project some 5 times, and each time I get to an issue that means restarting. Not wanting to do that if I have 200 products loaded and we are transacting…
Anyone have a suggestion?