Sending data from ERP/CRM to e-commerce platform like Shopify

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

Exploring options to send data from ERP/CRM to e-commerce platforms like Shopify using custom connectors in Airbyte


Question

Hi all, I’m new to Airbyte and I work within the e-commerce area. I created as an experiment a custom connector for Magento API, but I see that I can’t use it as a destination, same for other e-commerce platforms like Commercetools or Shopify that have readymade connectors. What would be the best way to send data coming from a system like an ERP or CRM to a platform like shopify for example?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["erp", "crm", "e-commerce", "shopify", "custom-connector", "destination"]
2

I believe you would need to develop a custom java destination that implements the Shopify API

3

https://docs.airbyte.com/connector-development/tutorials/building-a-java-destination

4

Airbyte doesn’t currently really support the Reverse ETL use case, although I know there are some plans for this in the future. (They <https://airbyte.com/blog/airbyte-acquires-grouparoo-to-accelerate-data-movement|acquired a company called Grouparoo> some time back that does is focused on the Reverse ETL side of things.)

We’re currently using Airbyte for ETL and https://www.getcensus.com/reverse-etl|Census for Reverse ETL (users auth to our webapp, then we pass that along to the other systems which they don’t see or interact with—everything is done over the API). This has worked well, but I’m looking forward to being able to consolidate since it’s often the same systems we’re pulling data from, enriching, and then wanting to push back into.

5

thank you so much <@U035912NS77> this is really valuable info! I will check into a reverse ETL solution. for better scaling I’m thinking of also using airbyte to extract data form the ERP to a data warehouse and then use a reverse ETL to stuff data from the warehouse to shopify

6

Which ERP are you using Tony?

7

Pyramid, is not one of the most common :smile: but it has some popularity in the nordic countries

8

Good to know. I am somewhat familiar with Sage 100 ERP.