Building Sub-SKUs

Contents of this Topic: Show

Overview

Do not use a "space" or "blank" as a delimiter. It is best to use a printable character such as an underscore, dollar sign or colon, etc.

 

  1. If sub-SKUs are created through the order and product import processes, the program automatically sets the UseForBuild field in the OptionLists table to TRUE (the box is checked) when there is no web delimiter information (WebOptionCodeDelimiter, AddToSubSKUIfNoCodeDelimiter) in the XML. This field is displayed at the Attributes & Options tab of the Inventory interface. You can control whether the program uses the option information in those lists when building sub-SKUs with system parameter HonorUseForBuildForOrderImport.  

  2.  If sub-SKUs are created manually through the Attributes & Options tab of the Inventory interface or through the batch process, the UseForBuild field is only evaluated and applied if system parameters UseModStopInventoryTrk or UseVikingCodersInventoryMgr = TRUE.  These applications provided inventory tracking capability at the sub-SKU level before Miva Merchant introduced their native support. System parameter HonorUseForBuildForOrderImport does not apply in these situations.

Critical Concepts

 

 

System parameters affecting the building of sub-SKUs

 

Most of the parameters mentioned below are in the Order Options parameter group. HonorUseForBuildOnOrderImport is in the Order parameter group.

Go to Main Menu>Settings>System Functions>Set System Parameters.

Set the following parameters as needed to match your business process:

  1. BuildSubSKUs – If TRUE, the program checks imported orders for products marked "Parent SKU" in the Inventory table which include order options (product options). The program uses the Parent SKU, the SKU Delimiter and the order options to build a sub-SKU, and then replaces the Parent SKU in the order with the sub-SKU. The QOH of the sub-SKU is tracked by the program and can also be sent to shopping carts which support real-time inventory tracking at the attribute level.

  1. BuildSubSKUDelimiter – the character OMS uses between attributes when creating sub-SKUs

Example: where "-" is the Delimiter (without quotes)

Parent SKU   1234ABC with options XL and Black results in sub-SKU 1234ABC-XL-Black

 

  1.  WebOptionCodeDelimiter – the program takes the value to the left of this delimiter and adds it to the sub-SKU, ignoring what is to the right of the delimiter

Example:  the web options might be XL:Extra Large, L:Large, Fast:Add(+$20), Slow:Add(+$10), where ":" is the web option code delimiter.

  1. WebOptionPriceDelimiter – this parameter designates the character which separates the base price of the item from its price modifier in the order option (for Yahoo, the price delimiter is "(+ ", without quotes)

Example: the web options might be XL:Extra Large, L:Large, Fast:Add(+$20), Slow:Add(+$10), where "(+" is the web option price delimiter.

  1. WebOptionNameDelimiter – this parameter designates the character which separates the name of the option from the option value

Example: Size = Large  

"Size" it the name of the option, "=" is the WebOptionNameDelimiter, and the value of the option is "Large"

 

  1. AddToSubSKUIfNoCodeDelimiter

    1. If this parameter is set to FALSE and the order option information in the XML does not contain the WebOptionCodeDelimiter (or no WebOptionCodeDelimiter defined in the program) and BuildSubSKUs is TRUE, the value of the option is not added to the sub-SKU when it is built. The option value is added to the option fields seen at Process Orders (or as separate line items if OptionDestination is set to "line items"). This is to accommodate shopping carts that have Text fields (or areas) where customers can enter their option details. A WebOptionCodeDelimiter cannot be added to these option values and most users would not want customer text added to the SKU.

    2. If this parameter is set to TRUE and if a selected order option information in the XML does not contain the WebOptionCodeDelimiter (or no WebOptionCodeDelimiter defined in the program) and BuildSubSKUs is TRUE, the option's entire value is added to the sub-SKU when it is built.

    1. HonorUseForBuildOnOrderImport

    1. if the imported XML does not contain web delimiter information (WebOptionCodeDelimiter, with or without AddToSubSKUIfNoCodeDelimiter), the program sets the UseForBuild field in the OptionLists table to TRUE

    2. if this parameter is set to FALSE, all option lists and all option values where Don't Use = FALSE are added to the sub-SKU when it is built

    3. if this parameter is set to TRUE, only the option lists where UseForBuild = TRUE and option values where Don't Use = FALSE are used to create sub-SKUs

Building sub-SKUs using all Options without a Delimiter present

 

The simplest way to create sub-SKUs is to base them on all of the options available for an individual product.  This method uses the all of the option text to build a sub-SKU.

 

Set these system parameters to the following values:

 

  1. AddToSubSKUIfNoCodeDelimiter = TRUE

  2. BuildSubSKUDelimiter = - (dash)

  3. BuildSubSKUs = TRUE

 

Example:

Item Name= Tshirt  SKU=1234 

Options:

Color: Blue, Red, White

Size: Large, Medium, Small

 

The resulting sub-SKUs would be:

 

 

Building Sub-SKUs using Selected Options with Delimiter 

 

Another way to create sub-SKUs is to use a WebOptionCodeDelimiter.  A WebOptionCodeDelimiter allows you to specify which Option and what part of the Option text is used to create sub-SKUs.  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 is used to build the sub-SKU. 

 

Set these system parameters to the following values:

 

  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-SKUs using all Options with Delimiter present

 

This method of creating sub-SKUs is useful for building sub-SKUs that include both an option name and an option code.

 

Set these system parameters to the following values:

 

  1. AddToSubSKUIfNoCodeDelimiter = TRUE

  2. BuildSubSKUDelimiter = - (dash)

  3. BuildSubSKUs = TRUE

  4. WebOptionCodeDelimiter = : (colon)

 

Example:

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 record when building Sub-SKUs

How to Build Sub-SKUs for a Single Inventory Item

 

  1. Go to Main Menu>Manage My Inventory>View & Manage My Inventory.

  2. Navigate to the appropriate inventory record.

  3. Select the Attributes/Options tab.

  4. Select Build Sub-SKUs for this Item in the Accordion.

  5. The program prompts for confirmation before proceeding with the changes. Select OK to continue.

Inventory: Attributes and Options

 

How to manually build Sub-SKUs in batch mode

 

  1. Create inventory items in your shopping cart.

  2. Import the inventory items into OMS .

  3. Configure OMS system parameters to create sub-SKUs.

  4. Go to Main Menu>Settings>Inventory Functions>Build Sub-SKUs.

  5. Make the appropriate radio button selection in the right-hand pane and select Build Sub-SKUs.

Note: For Yahoo, select "All options list entries" since it does not mark SKUs as "Parent SKUs"

Build Sub-SKUs (DeleteOrphanedSubSKUs=FALSE)

Build Sub-SKUs (DeleteOrphanedSubSKUs=TRUE)

 

Additional Information

Inventory

 

Created:

Revised: 5/7/14

Published: 04/14/16