Proposal summary
This proposal covers the Shopify Integration to update the line level location in sales orders according to the location in Shopify
Requirement
The location in shopify order has to be added in the item line in NetSuite sales order
Prerequisites
Please provide us the shopify API key and password to establish connection with Shopify.
Our Solution
We are planning to develop a map reduce script which can connect to shopify. We’ll be using an identifier here in sales orders to found out whether the location is already set or not.
In the get input data will get all the sales orders in pending fulfilment status. In reduce context we will iterate through these lines and find out the specific order line in Shopify using the etail order line id field. We will call the fulfillmentOrders API to get the location data from Shopify.
After we set the location, we will flag the identifier as true. So that in the next working of script, this sales order won’t be considered.
Assumptions
- We won’t be considering the item lines which have dropship items because the location in these item lines will be already set using the prevailing script.
- The Kit item including drop ship inventory member items will be considered while setting the location because they won’t be considered in the prevailing script.
- We’ll be only considering the following locations in Shopify.
- Simplee Warehouse
- SGK Warehouse
- Dropship Warehouse
- At the creation of order, the location details won’t be set in the order line. The location will be Simplee warehouse itself. It will be set later based on the schedule.
- We will be using etail order line id field to set the location in item line.
- We are planning to schedule the script in every 15 minutes
Risks
- We assume that there won’t be any issue when we only considering Non dropship items
- We can expect 1 hour delay even we scheduled the script for 15 minutes. So, we assume that the IF creation won’t be happening at this time duration.
- We will not be doing any location validations in Item Fulfilment record
Time
24 Hours