Contents
Rattail Demo
This page describes some features of the public Rattail Demo.
Please note that you should login as "chuck" with password "admin" to gain full access to the demo.
Shopfoo
This feature is meant to mimic an integration with an e-commerce platform, but specifically one such as Instacart, Freshop, Mercato etc. So basically if you use Instacart, then whenever you encounter the term "Shopfoo" you can think of "Instacart" instead.
The general pattern for "Shopfoo" is where the local product data periodically must be "exported" to the target (Shopfoo) system, by way of e.g. nightly CSV file upload.
What the Rattail Demo does to solve this problem is as follows:
- demo's Product data continues to be updated in real-time, when CORE-POS data changes
demo's Shopfoo Products is a custom table meant to mirror exactly what is on Shopfoo (target) system
- nightly, the Shopfoo Products table is updated per latest Products data (from CORE-POS)
nightly, a new Shopfoo Product Export is generated, which is basically a CSV dump of Shopfoo Products table
(demo does not bother "uploading" the export to a Shopfoo server...b/c there is no such thing (I assume), but normally you would want to do that)
That may seem convoluted at first but it's a well-established pattern in the Rattail world. Advantages to this include:
- Shopfoo Products (local cache) table gives full visibility at all times, of what "should be" present in Shopfoo itself
- plus this table is versioned, so you get a simple but "complete" audit trail for it
- exports are all kept in one place, can easily download individual past ones etc.