Skip to main content

Inventory updates for Shared NetSuite SKUs in Shopify

Comments

10 comments

  • Official comment
    Mannan Khanna Product Manager

    Hi David and Justin,

    The prebuilt integration between NetSuite and Shopify is designed for a 1:1 relationship between the items. Over the last few months, we've been seeing a few use cases come up for a 1:many relationship and have been offering a small customization in tandem with the prebuilt integration. 

    Eventually, we'd like to include this in the product but I'm uncertain if a timeline has been established for this feature. I'd encourage you to connect with your Account Manager/Customer Success Manager to see how that customization might work for your business needs!

    Best,

    Mannan Khanna

  • Justin Bodin
    Great Answer
    Celigo University Level 2: Seasoned
    Engaged

    I need this badly too.

    How do you currently handle inventory updates from NetSuite to these Shopify variants which tie back to a single NS SKU, David?

     

    0
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Thanks for the comments. One of my customers already has a custom celigo flow to handle this. I may create something similar that leverages the item map and can update multiple variants in shopify.  If I create this I might publish it as a free template.  I have a good number of shopify clients and almost all of them need it.  

    1
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    I have a need for something similar to this:

    • Item is a "Custom" product created in Shopify. Due to the volume of Variants, it is not possible for Shopify to account for all potential outcomes due to the "variant limit".
    • What I would like to be able to do is use a single "SKU" for all the potential outcomes to map to a single Internal_ID in NetSuite.
    • e.g. I have a single product that is customizable on 7 component pieces (each has a different cost to mod) which have 8 color variations each for the customer to select from. As you can see - a lot of potential outcomes.
    • However, when the math is computed - I end up with 72 combinations that allow for the outcomes.
    • So, I would like all 72 outcomes to have the same SKU which I could then map to a "Custom" product defined in NetSuite.

    So the question becomes, how do I adapt the Order Flow or Product Flow to accomplish this?

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi David Gollom,

    Sounds great! We'd love to get your free template published in the marketplace! Any updates on this? Thank you!

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    I figured out a way to make my example work. 

    0
  • Courtney Jordan Experience Strategy & Design Director Community moderator
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Top Contributor

    Hi Gabe Parr,

    That's great! Thanks for letting us know - we'd love it if you'd share how you worked it out!

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    Built a custom product in NetSuite - assigned the Internal ID from it to the SKU of all the "virtual" children in Shopify.

    Presto! Works perfect - comes over as a line item entry with total only and I have excluded the custom product from being mapped in product flow templates.

    Now, the item does not sync in any way from NS to SH, inventory, IDs, or otherwise - but still shows up as a line item on Orders.

    Since it is a custom product - we already have a process in place for items that will require PO via NS to manufacture - upon receipt it is checked in, becomes available, and able to fulfill.

    1
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Hey Everyone, 

    Building a custom one to many NetSuite to Shopify inventory update is still sitting on my pile of good ideas.  The client that spurred me to think about this didn't wind up needing it.  The way I see the current data structures in Shopify IA I don't see why this is a big deal. You can create unique keys for each store, product and variant and use those to update inventory.  I realize that are other parts of the IA and I'm probably being myopic.

    1
  • Justin Bodin
    Great Answer
    Celigo University Level 2: Seasoned
    Engaged

    David Gollom I would still love to see this solution come to fruition!

    0

Please sign in to leave a comment.