https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hi, Did anyone of you worked with integrating Net...
# suitescript
s
Hi, Did anyone of you worked with integrating Netsuite with Quipt? https://www.getquipt.com/ https://getquipt.com/api/ The feature I want to build is, 1. Send Inventory Data from Netsuite to Quipt 2. Create Quipt Orders in Netsuite 3. Send Order shipment data from Netsuite to Quipt. Anyone out there who could help me out?
r
@Santosh Reddy Hi Santosh, The integration seems fairly straight forward. What issues are you having?
@Santosh Reddy I can help you.
s
Thank you so much Rehan, Should I implement it using SuiteScripts? How do I keep track of each inventory update(cost/qty)? I also want it to be scheduled.. I wanna post data to Quipt every 30 minutes..
How do I exactly approach It since I have never done any integrations on netsuite.
r
Well the first step is authenticating with Quipt. It looks like it supports the use of OAuth 1.0a. You would need to configure the integration on NS end to generate the tokens necessary and authenticate with Quipt.
This entire integration can be developed using SuiteScript. (Scheduled Scripts)
are you familiar with SuiteScript 2.0?
s
No.. I have done little bit coding in SuiteScript 1.0
r
Ok, outside of NetSuite have you done any development work?
s
yes I did..
r
Alright, so you're comfortable with SS1.0?
s
yes I am.
r
the the api you will use to create the requests is nlapiRequestURL
you will need to develop the generation of the tokens for OAuth 1.0a
s
I don't know how to generate the tokens in suitescript.
nlapiRequestURL(scheduled_script, scheduled_script_deployment, params) right?
How do I keep track of each inventory update(cost/qty)?
r
Well you will need the OAuth1.0a.js Lib, and the Crypto-JS.js lib
refer to the help for any clarification
s
Thanks Rehan.. How do I keep track of each inventory update(cost/qty)?
r
Well thats the purpose of the integration, you will need to build out the integrations that it push/pulls data from either system
s
Is there any event trigger I can use whenever an inventory item is updated?
r
Thats a separate record called Inventory Adjustment
b
i would advise against relying on inventory adjustments to track inventory changes
there are many transactions that change inventory, not just inventory adjustments
Use the Last Quantity Available Change (lastquantityavailablechange) date filter to search for items whose inventory has changed
The last quantity available change is the date the quantity available for the item last changed
s
so you're saying to get the results of all the inventory items whose qty is updated in last 30 minutes because I want to keep the qty in sync.
b
usually for scheduled scripts, you write a search for all the records you want to export
in your case, you would search for items whose inventory quantity have been modified within the last 30 minutes
if you want to be more precise, you want to get all items modified since the last time you exported inventory
which means you need to keep track of a date somewhere
i personally like creating a custom record to store that kind of stuff
s
yeah that makes sense..
b
If you are starting out, I wouldn't worry about this stuff first, these are refinements so that you don't send all of your items when instead you can send the few
you should probably worry first about retrieving the data from NetSuite (the search api) and sending it to Quipt (the request url api), interpreting the response (from the request url api)
s
Yeah thanks buddy... I would also need a place to log each record that has been sent to Quipt. Also I should be able to run the process manually. How do I create an endpoint though?
b
that sounds strange
but i think you are looking for how to create a script and script deployment
s
I know how to create a script, script record and script deployment.
b
dont know what you mean by endpoint then
s
When there is an order through Quipt, How do I create it on Netsuite?
b
you probably want to use their Get Orders api
though you will probably want to be careful, their method to avoid duplicate data is unusual
s
Thanks Buddy..
2 Views
Open in Slack
PreviousNext
Powered by