How can we call NetSuite RESTlet from Shopify Webh...
# suitescripta
AB
03/15/2021, 5:23 PMHow can we call NetSuite RESTlet from Shopify Webhook?
m
michoel
03/15/2021, 7:32 PMYou will need middleware
a
AB
03/15/2021, 7:48 PM@michoel I am trying to use Google Cloud Platform for middleware. Is Google Cloud Platform lifetime free?
m
michoel
03/15/2021, 7:53 PMThey have a pretty generous free tier
michoel
03/15/2021, 7:53 PMa
AB
03/15/2021, 8:06 PMThanks @michoel
c
Craig
03/16/2021, 6:08 AM@AB You'll also need a scheduled job to check for changes periodically, Shopify docs say that the webhook cannot be relied upon 100%
Craig
03/16/2021, 6:09 AMI ended up just using a scheduled job to pull all changes for orders - didn't bother with the webhook as I can't trust it all the time
Craig
03/16/2021, 6:10 AMHardest part is to make sure you only pull records once using timestamp of last pulled record and having a function to search for existing orders to make sure you're not importing duplicates by mistake.
m
michoel
03/16/2021, 6:20 AMWhen I integrated with BigCommerce we wanted real time so used a webhook and backup map reduce for missed/delayed webhooks. Both changed the status in BigCommerce store to mark the order as imported to avoid duplicates, as well as a check in NetSuite by order number
c
Craig
03/16/2021, 7:13 AMIs it even possible to add a flag to a shopify order to say it's already been processed?
Craig
03/16/2021, 7:15 AMMaybe via a custom app
Craig
03/16/2021, 7:17 AMWe also had a 'no third party system' mandate so couldn't use middleware to process the webhook message and shopify won't authenticate with NS. 🤷♀️
m
michoel
03/16/2021, 8:47 AMI don't know about Shopify but in bigcommerce there isn't support for custom fields so we stored some integration data in the staff notes fields as a JSON blob. For "imported" flag though we updated the order status as that was easily filterable by the API
michoel
03/16/2021, 8:52 AMActually it looks like there is now metadata support for orders. Must be a new feature
j
JohnnyC
03/16/2021, 9:48 PMHey guys, Shopify supports tags and meta fields. I suspect tags would be adequate here.
a
AB
03/17/2021, 1:07 PMThanks, @Craig, @JohnnyC and @michoel
57 Views