Inventory updates for Shared NetSuite SKUs in Shopify

Integration Apps
,
1

Hey Guys,

It's pretty common in Shopify to share the same NetSuite Item/SKU across multiple Products/Variants in Shopify. The Celigo Shopify item map should allow you to update inventory across multiple variants (in multiple stores) from one Item in NetSuite. However, the data returned to the Shopify inventory flow is being summarized at the item level and only supports one variant per store. Are there plans to change this?

Thanks!!

2

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?

3

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

4

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.

5

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?

6

Hi @davidgollom,

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

7

I figured out a way to make my example work.

8

Hi @gabeparr,

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

9

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.

10

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.

11

@davidgollom I would still love to see this solution come to fruition!

22

Looking for a solution to this as well, where two SKUs in Shopify need to be mapped to the same item record in NetSuite.