Proposal Summary
This proposal outlines a comprehensive solution for itegrating the required items in NetSuite to Shopify.
Requirement
Pure Care has a customer that is looking at launching a Shopify website that will allow their patients to purchase products. They are looking at Pure Care as the vendor. Pure care’s product Squ’s will be used on their Shopify platform. Currently they are using an import of excel file to shopify for facilitating the same. Instead of this they will require to automate this process by an item integration.
Deliverables
- We will establish a connection between shopify and Netsuite via suitescript.
- We will create a custom check box named “Sync to Shopify” within NetSuite’s item records. User can check this check box if they want to send this item to Shopify. Once this check box is checked we will send the item to Shopify.
- If the checkbox is unchecked for a synced item, indicating a removal from the integration, we’ll ensure to unsync it from Shopify.
- We will send the item SKU(itemid), Item Image URL(storedisplayimage), West Pricing, Website Display Name(storedisplayname), Webstore Description(storedescription).
- When a synced item’s item SKU, Item Image URL, West Pricing, Website Display Name, Webstore Description is changed from NetSuite. We will update the same in Shopify.
- Regarding quantity updates, a scheduled script will monitor changes in available stock every 15 minutes. Any changes to the available quantity will be sent to Shopify during each scheduled interval.
- We will use the following field mapping,
NETSUITE SHOPIFY
Item Name/Number (SKU) SKU (Stock Keeping Unit)
Website Description Description
Item Display image Media
Price Level Price
Website Display name Title
Quantity available Quantity
Assumptions
- We will send will send the sum of available quantities from all locations to Shopify.
- Even if the items has quantity pricing, we only considered the WEST prices of minimum quantity for item pricing. Heighlighted below,
- Only inventory items will be synchronized between NetSuite and Shopify.