Go to Bottom

Building Sub-SKUs

Sub SKUs are used to track inventory based on product options. A Sub SKU is comprised of a Parent SKU, a delimiter, and the option or options in which the product is offered. For example, a merchant sells numerous types of T-shirts on their Website. The T-shirt product itself is identified by a Parent SKU of 1234. Any option that the customer can select, such as color or size, is added to the Parent SKU. The Parent SKU and various options are separated by a delimiter, typically a dash (-). This produces a unique SKU, e.g. 1234-Red-Large.

 

For those shopping carts that support order options, you can import your inventory with those options and create the appropriate Sub SKUs. Once the Sub SKUs are set up in the Order Manager, the program can convert Parent SKUs with order options on incoming orders into Sub SKUs, making it easier to process orders and track inventory.

 

Instructions for creating Sub SKUs are detailed below:

 

Critical Concepts

System Parameters for Sub SKUs

How to Build Sub SKU’s for a Single Inventory Item

How to Build Sub SKU’s for all Inventory Items Containing Options

Building Sub SKU’s using all Options without Delimiter present

Building Sub SKU’s using Selected Options with Delimiter

Building Sub SKU’s using all Options with Delimiter present

Fields that are copied from the parent when building subSKUs

 

Critical Concepts

 

System Parameters for Sub SKUs

 

Go to the Main Menu>Maintenance Menu>Maintenance tab>Set System Parameters. Click on the Order Options parameter group. Set the following parameters as outlined below:

 

  1. BuildSubSKUs

 

  1. BuildSubSKUDelimiter

 

  1.  WebOptionCodeDelimiter

 

  1. WebOptionPriceDelimiter

 

  1. WebOptionNameDelimiter

 

  1. AddToSubSKUIfNoCodeDelimiter

 

 

How to Build Sub SKU’s for a Single Inventory Item

 

Go to the Main Menu>Maintenance Menu>Inventory & Suppliers tab>Inventory button. Navigate to the appropriate inventory record. Click on the Attributes/Options tab. Click the Build Sub-SKUs for this Item button.

How to Build Sub SKU’s for all Inventory Items Containing Options

 

Once you have created inventory items in your shopping cart, imported them into the Order Manager, and configured the system parameters to create Sub SKUs as you wish, go to the Main Menu>Maintenance Menu>Inventory & Suppliers tab>Build Sub SKUs button. Make the appropriate selections and click Build Sub SKU's.

 

 

Building Sub SKU’s using all Options without Delimiter present

 

The most basic way to create Sub SKUs is to base them on all of the options available for an individual product.  This method uses the entire option text to create a Sub SKU.

 

Configure these system parameters accordingly:

 

  1. AddToSubSKUIfNoCodeDelimiter = TRUE

  2. BuildSubSKUDelimiter = - (dash)

  3. BuildSubSKUs = TRUE

 

Example Item:

Item Name= Tshirt  SKU=1234 

Options:

Color: Blue, Red, White

Size: Large, Medium, Small

 

The resulting Sub SKUs would be:

 

 

Building Sub SKU’s using Selected Options with Delimiter 

 

Another way to create Sub SKU’s is to use what is called a WebOptionCodeDelimiter.  A WebOptionCodeDelimiter allows you to specify which Option and what part of the Option text is used to create Sub SKU’s.  The WebOptionCodeDelimiter can be set to a character of your choice.  In the example below it is set to use a colon (:).  Anything to the Left of the colon will be used for Sub SKU creation. 

 

Configure these system parameters accordingly:

 

  1. AddToSubSKUIfNoCodeDelimiter = False

  2. BuildSubSKUDelimiter = - (dash)

  3. BuildSubSKUs = TRUE

  4. WebOptionCodeDelimiter = : (colon)

 

Example Item:

Item Name= Tshirt  SKU=1234 

Options:

Color:  B:Blue, R:Red, W:White

Size: L:Large, M:Medium, S:Small

 

The resulting Sub SKUs would be:


 

Building Sub SKU’s using all Options with Delimiter present

 

This method of creating Sub SKU’s is useful for building Sub SKUs that include both an option name and an option code.

 

Configure these system parameters accordingly:

 

    1. AddToSubSKUIfNoCodeDelimiter = TRUE

    2. BuildSubSKUDelimiter = - (dash)

    3. BuildSubSKUs = TRUE

    4. WebOptionCodeDelimiter = : (colon)

 

Example Item:

Item Name= Tshirt  SKU=1234 

Options:

Color:  Blue, Red, White

Size: L:Large, M:Medium, S:Small

 

The resulting Sub SKUs would be:

 

Fields that are copied from the parent when building subSKUs

 

Created: 1/19/12

Go to Top