Proposal Summary
GoodEarth aims to synchronize the inventory levels of non-inventory items from NetSuite to Shopify.
Requirement
GoodEarth relies on a drop shipment model where many of their products are sent from vendors directly to customers. Business does not hold any stock of such items in their warehouses. Consequently, these items are categorized as “Non-inventory” type in NetSuite. However, on the Shopify website, these items are categorized as normal Products and have associated with stock levels. This situation underscores the need to ensure the synchronization of stock levels for these non-inventory items on Shopify.
Deliverables
Pre-requisites
• Access to NetSuite account.
• Access to Celigo integrator.io.
• Access to Shopify.
• License for at least one custom flow in integrator.io.
Description of the task
The requirement can be achieved by synchronizing the non-inventory items and their associated stock levels from NetSuite to Shopify. The NetSuite “Non-inventory” items can be synced to Shopify as “Simple Products” via the pre-built flow “NetSuite item to Shopify product (add or update)” in the Shopify-NetSuite Integration App by Celigo.
To sync the stock levels of these non-inventory items, a custom Celigo flow can be used. Two custom fields named “Quantity available-Essendant” and “Quantity available-SP Richards” will be created in the NetSuite non inventory items. These custom fields are aimed to hold the quantity available of the corresponding item with their respective Vendors. The custom field will be periodically updated with the accurate stock levels by the EDI integration. The custom Celigo flow would be designed such that it fetches the quantity from the 2 custom fields “Quantity available-Essendant” and “Quantity available-SP Richards” and update to the locations Essendant and SP Richards in Shopify. This stock sync would run in predefined schedules.
Assumptions
• Updating the NetSuite custom fields with the quantity available at the vendor warehouses, are to be managed by the EDI integration of GoodEarth.
• The creation or updation of Products in Shopify is assumed to be handled by the prebuilt product flow in the Shopify-NetSuite Integration App.
• The custom flow will only sync the stock values from the custom fields “Quantity available-Essendant” and “Quantity available-SP Richards” to the locations Essendant and SP Richards in Shopify. Stock in no other Shopify locations will be updated.
• The stock sync from NetSuite to Shopify will not happen in real-time.
• The custom flow for stock sync would only consider the Non-inventory items in
NetSuite.
Risks
• There are possibilities that the Shopify API endpoints may depreciate in future. In such cases the APIs should be updated in the integration.