Could one add/update product data within the shop app programmatically?

Hi there,

Getting back into Perch after some time away, and really impressed with how it's come on since early versions - so flexible compared to anything else out there - many thanks to the Perch team! :)

I have a prospective runway customer who I want to implement a web shop for, and the main issue he has is that he sells on other platforms, and keeps a master db of products from which he exports structured data and upload new inventory weekly to the various platforms he uses, and wants to do the same with Perch CMS.

I know you are working on the collections API for v3 (any news on the timeline?), but I was wondering whether it's worth me even digging into using PerchDB to allow import into the shop of new products, skus and quantities, or whether this is a non starter, and I should wait for the collections API (which, might well not even work with the shop).

I can foresee issues like updating existing products when they have sold (setting quantity to zero?) on further weekly imports, and wondered whether I am attempting mission impossible in bending Perch to do something it shouldn't.

Has anyone had experience importing and updating data within Perch from an external data source?

Advice/thoughts appreciated.

Thanks in advance, Al