As businesses experience growth, their ecommerce platform needs often evolve to accommodate expanding demands. One of our valued clients recently underwent significant growth and made the strategic decision to transition their ecommerce platform from Magento to Shopify Plus. This shift was driven by Shopify’s reputation as a leading ecommerce solution, particularly when paired with NetSuite, a combination that has gained widespread popularity among our clientele.

Client Requirements

  1. Item Integration:
    • Synchronize item records, including item groups, between NetSuite and Shopify.
    • Items may have prices in different currencies and can be linked to one or more stores.
    • NetSuite items may be exported to Shopify as a Product or a Variant of a an existing product.
    • Item groups don’t have price on the NetSuite item record. The price of item groups should be dynamically calculated with the price of the member items.
  2. Inventory Levels:
    • Export NetSuite inventory levels from different locations to Shopify once a day.
  3. Order Integration:
    • Export orders from Shopify to NetSuite upon order creation.
    • A customer my need to be created. Look for a customer with the email matching the email on the sales order. If necessary, update the address of existing customers.
    • Export Shopify payments to NetSuite as customer deposits.
  4. Fulfillments Integration:
    • Fulfill orders in Shopify with tracking numbers when orders are fulfilled in NetSuite.
    • The fulfillment integration needs to support partial fulfillments.
    • Members of item groups may be fulfilled separately.

Challenges Faced

  • The client operates two distinct stores/brands under a single NetSuite account, necessitating a solution to accurately export items to one or more stores.
  • Each Shopify store encompasses various markets and currencies, prompting the utilization of GraphQL to effectively update prices in different markets.
  • The client uses item groups, wherein a Shopify order with a single line item may translate to multiple lines in NetSuite when the item groups are expanded. This posed challenges for fulfillment integration.
  • While certain NetSuite items directly map as products in Shopify, others require creation as variants of a parent product, adding complexity to the integration process.

Solution

The solution was implemented with a combination of NetSuite custom fields, scripts and Boomi integration.

  • Custom fields were added to the item record to specify the destination store for item exports
  • A custom record was created to model the Shopify product-variant relationship in NetSuite. This enabled NetSuite users to specify whether a NetSuite item would be exported as a standalone product or as a variant.
  • Item groups don’t have pricing , as their prices are determined by the member items. Custom fields were added to the item group record to store prices in various currencies. A script was created to dynamically calculate these values when an item group or any of its members is updated.
  • The fulfillment integration for item groups presented a significant challenge due to the discrepancy between Shopify and NetSuite structures. In Shopify, item groups are represented as a single line on orders, while in NetSuite, they expand into multiple lines that can be fulfilled separately. We created a Shopify Fulfillment line custom record and a script with logic to create instances of the custom record when the a Shopify line is deemed as fulfilled in NetSuite. This custom record servers as input for the Boomi integration.
  • Finally, the Boomi integration flows were created to sync the records between Shopify and NetSuite.

Reflection

While Boomi proved to be an invaluable tool for integration, implementing intricate logic for complex processes presented its own set of challenges. Specifically, the fulfillment integration required innovative approaches to reconcile the differences between Shopify’s Fulfillment Order record and NetSuite’s item fulfillment structure. This involved the deployment of Groovy scripts in Boomi for data processing.

Feel free to reach out if you need assistance connecting NetSuite with Shopify or have any integration requirements. We specialize in creating integrations using Boomi or directly within NetSuite, and we’re here to help streamline your processes and optimize your business operations. Contact us today to discuss your integration needs!

 

Share this page

Let’s Connect.

Tell us about your project, and we’ll arrange a free consultation call
to discuss how we can help.