SupaBase Integration with Shopify

We have PHP code for an integration between MySQL and Shopify. We want to move the database over to SupaBase and create the necessary edge functions in SupaBase to replicate the PHP read and update integration scripts to Shopify.

Need help with :
* Reading product data from Shopify into a SupaBase Table "Shopify Inventory" (Edge function)
* Writing an SQL snippet comparing 2 tables ("Shopify Inventory" and "ERP Inventory") with each other to populate another table "Shopify Update" in order to determine which items should be updated on Shopify.
* Updating Shopify product pricing and inventory levels from the "Shopify Update" table in SupaBase (Edge function)

The edge function should update the Shopify Inventory table (In SupaBase) as soon as a new product has been added, or a line item should be removed from the table once the product is deleted in Shopify.

Then the table called "Shopify Update" must be monitored for when entries are posted into the table in order to trigger the Shopify Update edge function.

We have written this in PHP and have the code files to provide a deeper understanding of how we want it to work.

The ERP Inventory table we will write the edge function for that. For setup purposes we will provide a table with data to ensure the logic works.