How to integrate magento with netsuite.
# integrations
t
How to integrate magento with netsuite.
t
Do you already have an integration tool? Like Celigo, Boomi, or similar?
t
thanks for your reply Tracy.... we are not using any tool.. but is it possible to integrate it using restlet
Actually we just need to sync customers in netsuite from magento website
t
A one-time sync? Or ongoing?
e
You can craft one yourself using the Magento API. Create a Suitelet that makes the call to the Magento API to grab the customer data and then process it to update NS customer records.
t
@Tracy We need to sync customer in netsuite whenever cutsomer created in Magento..
@Eric B We are not familiar with Magento api. Is there any other approach
e
If you know PHP and you have access to your Magento codebase you can connect to the Netsuite API. Otherwise, you will want to check out connectors from Celigo or Boomi.
s
@Tanu, In Both Magento 1 & 2, you can make use of Magento Event Observers. You need to makke sure you keep track of customers created from Frontend and Admin. Use a global event "customer_save_after" in your case. In your observer, generate the customer data into JSON and make a call to the Netsuite API. Magento's API is easy to work with.
r
FarApp is worth considering
z
independent of platform, syncing data between two (or more) systems has some considerations.. live syncing, based on events on the source side and sending data to the destination seems to be the simplest way. And then come troubleshoots : what if... What if an error arrise on the destination side... How to handling that... What if (ie NetSuite) at the of moment of triggering event in Magento is unaccessible (downtime, maintaining..) What if you want to update existing records... Second approach is batch syncing... Create an PHP, NodeJS job which extract data from both side, compare, define changes (create, update, delete)... From the my experience it is not critically for script execution, but it is for data consumption from/to database whose are involved (NetSuite / Magento) Sometimes I realize solution mixed of two above : Middleware or message broker... Make one REST server which accept data from sender (ie Magento) and store that in queue... Then other procedure watch in rhe queue and try to send data to destination server... If succeeded remove entry, if not... try again or log error...