Netsuite-Shopify : One SKU with Multiple Variants.

Payments + Shipping & Fulfilment

Topic summary

Issue: Shopify supports customer selection of tire color variants (black, red, blue, orange) for custom bicycles, but inventory in NetSuite doesn’t align. Current setup uses one SKU per part, causing inaccurate stock tracking despite checkout working fine.

Request: Guidance or videos on how to correctly manage inventory and sync between Shopify and NetSuite for variant products.

Suggestion offered: Model each finished bike as a NetSuite Assembly Item (a product built from components). Example assemblies:

  • Bike with black tires = Frame + Bars + Black tires
  • Bike with orange tires = Frame + Bars + Orange tires
    This approach tracks component inventory while representing each variant as a finished good.

Status: No links, configuration steps, or integration settings provided. The suggestion is conceptual only. Shopping operations are unaffected, but inventory accuracy remains unresolved. Discussion appears open with key questions about best-practice setup and learning resources still unanswered.

Summarized with AI on January 1. AI used: gpt-5.
1

I’m looking for help understanding what I’m doing wrong with my Netsuite/Shopify connection. To give a plain simple example, let’s say I’m selling custom bicycles.

I had originally made one SKU for each part of the bike. So let’s use tires as an example. They’re the same cost, but we have black, red, blue and orange tires. The customer can select which color they’d like when checking out. This process works in Shopify - however, for inventory management, I can’t get the data to align properly in Netsuite.

Is there somewhere I can watch videos or learn more about the inventory management process between Shopify and Netsuite? Because right now I can’t find anything and we’re starting to get more confused and a bit frustrated.

Thankfully the shopping process isn’t delayed right now - but we can’t keep our inventory right.

Thank you

2

The bike with black tires would be an assembly.

Components could be:

Frame

Bars

Black tires

The bike with orange tires would be an assembly.

Frame

Bars

Orange tires