Handling Inventory Items with Alias SKU
You should create separate inventory records for every item rather than creating alias stock keeping unit (SKU).
However, if you already have alias items for order processing, the NetSuite Connector can support them. Although requiring additional set up, the NetSuite Connector can support, for example, multiple SKUs in your marketplace or cart that should match with a single SKU in NetSuite when posting orders.
When using alias SKUs, you need to make sure each SKU's ItemId is unique across your NetSuite account. If more than one SKU uses the same ItemId, it can post to the wrong item in NetSuite.
The following methods enable you to handle or manage alias SKUs. Choose a method depending on your records and business scenario.
Method for Kit Items
This method helps you sync products and orders for your kit items.
For every alias of an item (for example, if an item has an SKU called base), create a kit item with one component item—the original item (base). The SKU of the kit item will be the alias SKU. No extra setup in NetSuite Connector is required.
When orders are imported, they will import against the kit item, which will correctly commit inventory from the single component item.
Advantages
-
No additional set up in the NetSuite Connector is required.
-
The NetSuite Connector can synchronize these alias kit items to your marketplaces or carts.
-
If the items are synced to your marketplaces or carts, a kit item can contain extra data beyond what's set for the original item. A kit item can have a title, description and other information. NetSuite Connector still needs all the fields that a marketplace or cart requires populated for the kit or alias item. But the values for those fields aren't taken from the component or base item. This lets you set different values for those fields on the alias item instead of the base item, but you still need to specify values for those fields.
-
This works better than using alias SKUs. If you sell items under more than one listing, this way helps you manage them more easily.
Limitations
-
This method cannot be applied to matrix item types. If you have matrix items set up and need to support alias SKUs, use the next method.
-
Kit items cannot be included on Transfer Orders. But if your alias SKUs need to be on transfer orders, use the next method.
Method for Custom Records
This method helps you sync products and orders for your kit items.
To set up custom records to add aliases:
-
Go to Customization > Lists, Records, & Fields > Record Types > New.
-
In the Name field, enter a name for the record type, like Item Alias.
-
Ensure that the Include Name Field box is checked. The record names will be the alias SKUs.
-
Click Save.
-
Open the created custom record type and click the Fields subtab.
-
Click New Field.
-
In the Label field, enter a label, like Original Item.
-
In the Type dropdown field, select List/Record.
-
In the List/Record dropdown field, select Item.
For more information, see Working with Records, NetSuite Record Types and Creating a New Custom Record Type.
-
Now you can create an alias item by adding new records of this type. The record name will be the alias SKU and it should have one field for selecting the original item.
-
Open NetSuite Connector and go to Settings > Order. In Advanced Options and under the Alias SKU Settings section, enter the IDs and the field of the SKU alias records you created.
Using this method, every item can have several aliases. This means you don't need to add more fields for item aliases. When you need more aliases, you don't have to remap anything in NetSuite Connector as you add them.