Hello from Norway 👋 Sorry if this is not the correct channel. I am looking for a solution to aid in pushing some fields between a woocommerce shop and erp. From the erp I need to sync some fields across to the shop with intervals, price and quantity for the most part. But from the shop to the erp I have to sync back the quantity when a order is created. I have not tested Meltano yet, wanted to get some insights first if this might be the right tool for the job? Has anyone done something similar?

Hey @Jon Kristian Nilsen! 👋 Most loaders in the ecosystem work with databases, but I know some folks have used Meltano to push data to APIs. For example: https://hub.meltano.com/loaders/target-hubspot. Also, you could use tap-mysql and target-mysql to manage data movement on the woocomerce side, and you might wanna extract from views that match how the erp expects to receive the data.

Thanks for your reply and suggestions. I will look into that :)

The "hard" part for these styles of integrations is really the transformation part in the middle ie how do you get to a point you have a table that has all the updates that need to be pushed to the erp

Thanks, I didn't realize one would have to have a middle "in-between" storage which is what i recon the postgres is for.

You can theoretically do it with just stream maps