We maintain a google doc that has a list of inventory items. Each inventory item also has a SKU number to identify it.
We use another program called Linnworks with our business. Linnworks contains our inventory items (and SKU numbers) on it as well.
The SKU numbers on the google doc and the SKU numbers on Linnworks are identical.
The goal of your project is to make Linnworks update its inventory levels from the google document. I believe that the easiest way to sync the items would be by SKU number.
After you create and install the script, our process should be:
Open Linnworks---> We Initiate Your Script---> Linnworks retrieves inventory levels from the Google doc for every item in Linnworks inventory --->Linnworks finishes script and ends
You can find some info in this simple integration here:
[url removed, login to view]
You should be familiar with Google Docs API.
We need this script completed in 3 days from the time you are granted access to the google document.