Custom Records Method for Unique Item Aliases in NetSuite

The Custom Records method allows you to manage unique item aliases in NetSuite, facilitating efficient synchronization of products and orders. This approach is especially beneficial when dealing with alias stock keeping units (SKUs), helping to maintain inventory accuracy and streamline order processing.

Why Use Custom Records for Item Aliases?

Using custom records helps prevent potential issues that arise with duplicate SKUs, ensuring that each ItemId remains unique across your NetSuite account. This is critical for maintaining proper inventory management and avoiding order conflicts.

Steps to Set Up Custom Records for Aliases

Follow these steps to create custom records that will house your aliases:

1. Navigate to Customization > Lists, Records, & Fields > Record Types > New.
2. In the Name field, enter a name for your new record type, such as Item Alias.
3. Ensure that the Include Name Field checkbox is selected. This name will represent your alias SKUs.
4. Click Save to establish the record type.
5. Open the created custom record type and access the Fields subtab.
6. Click New Field to add a field.
7. In the Label field, enter Original Item.
8. From the Type dropdown, select List/Record.
9. Then, in the List/Record dropdown, choose Item.
10. After setup, create alias items by adding records of this type, where the record name will be the alias SKU linked to its original item.
11. Finally, access the NetSuite Connector settings and include the IDs and fields for the alias SKU records created in the Alias SKU Settings section under Order options.

Benefits of Using Custom Records

• Flexible Aliases: You can assign multiple aliases for each item without needing to remap anything in the connector, simplifying management as your inventory evolves.
• Enhanced Data Control: This method allows for richer data descriptions for alias SKUs, giving more tailored information in marketplaces or shopping carts.
• Streamlined Order Processing: This setup integrates smoothly with NetSuite Connector ensuring accurate inventory commitment when orders come in.

Considerations

While custom records provide flexibility, be aware that:

• Matrix Item Limitations: This method does not apply to matrix item types. If you need to handle SKUs for matrix items, a different approach is required.
• Transfer Order Restrictions: Kit items are not allowed on transfer orders. Ensure your alias SKUs won't be included in such transactions to avoid complications.

With the appropriate setup of custom records for alias SKUs, managing diverse product listings becomes efficient, ensuring clarity and accuracy in your inventory management practices.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

• Implement custom records to effectively manage item aliases in NetSuite.
• Ensure unique ItemIds for each SKU to avoid posting errors.
• This method allows for flexibility without remapping in NetSuite Connector.
• It enhances data presentation for aliases, aiding in eCommerce strategy.
• Be cautious of limitations imposed by matrix items and transfer orders.