image16.gif

 


 

 

Product Catalog Overview

The product catalog is the central repository for all products for all sales channels your company manages through CORESense including: POS, Sales Order Interface, Website, eBay, Amazon, Affiliates and custom sales channels.

 

notes.gif

Note: Except where noted, all updates to the product catalog are performed in real-time and reflect immediately on all sales channels.

 

Product vs. SKU

The difference between products and SKUs is important to understand in CORESense as each entity has a very specific role.

 

Element

Role

 

SKU

sample_SKU.jpg

 

 

A SKU (Stock Keeping Unit) is the lowest level at which inventory is tracked, shipped, and replenished. SKUs can contain weight, dimensions, purchasing vendors, reorder points or inventory levels.

 

Product

prod_collage.png

 

 

A Product is a marketing element that includes a bundle of attributes used to sell a set of SKUs on one or more sales channels. Products can contain images, descriptions, Cross-Sells and Up-Sells, etc.

 

 

Product/SKU Relationships

A product always contains a relationship to one or more SKUs. This relationship determines which SKUs are sold to the customer. Two types of product and SKU relationships exist in CORESense: Base Inventory and Possible Inventory from Standards and Upgrades.

 

Base Inventory

Base Inventory is a set of SKUs always sold to the customer when purchasing the product. The table below illustrates the potential combinations for Base Inventory relationships.

 

Combination

Description

Sample

 

 

1 Product = 1 SKU

 

The product has one item with a single SKU.

 

 

A customer purchases the Rawlings Baseball product, and is sold a single SKU, where the single SKU is related to the product as Base Inventory.

sample_-_baseball.png

 

1 Product = Multiple SKUs

 

The product contains multiple items and multiple SKUs.

 

A customer purchases the Baseball Starter Kit product and is sold three individual SKUs including:

  • Louisville Slugger (SKU: louisv5988bat)

  • Easton Baseball Mitt (SKU: eastglvlea09)

  • Rawlings Baseballs (SKU: 825ra-baseball).

   

Although each of the individual SKUs can be sold separately, for this product they are sold as a kit, where all 3 SKUs are related to the single product as Base Inventory.

sample_-_kit.png

 

 

Possible Inventory from Standards and Upgrades

Possible Inventory from Standards and Upgrades is a set of SKUs only sold to the customer if specific standards and/or upgrades are selected. Standards and upgrades are product configurations made available to the customer when purchasing. Typically displayed as drop-downs, each set of options represents a different Configuration Type, such as color or size.

The table below illustrates the potential combinations for Possible Inventory relationships.

 

Combination

Description

Sample

 

 

1 Product  =  1 Configuration Type

 

Each configuration option has a unique SKU.

 

 

A customer purchases the Hanes Men's T-Shirt product, they can choose from four sizes, where all options have the Configuration Type of size, resulting in a total of 4 possible configurations, where each SKU relates to the product as Possible Inventory.

sample_-_tee.png

 

 

1 Product  =  Multiple Configuration Types

 

Each configuration combination has a unique SKU.

 

 

 

A customer purchases the L.L.Bean Turtleneck, they can choose from four sizes and three colors, where all four size options have a Configuration Type named size and all three color options have a Configuration Type named color. This results in a total of 12 possible product configurations, where all 12 SKUs relate to the product as Possible Inventory.

sample_-_tneck.png

 

Base Inventory and Possible Inventory Combination

It is also possible for a product to have both Base Inventory and Possible Inventory from Standards and Upgrades. The table below illustrates the potential relationship.

 

Combination

Description

Sample

 

 

1 Product  = 1 Base SKU + 1 Configuration Type

 

2 separate SKUs are sold; 1 lamp base and 1 of three possible shades.  This is sometimes referred to as a “configurable kit”.

 

A customer purchases the Pottery Barn Lamp, they are able to choose from three shade colors, where all three color options have a Configuration Type named color. This results in a total of three possible product configurations, where all 3 SKUs are related to the product as Possible Inventory in addition to the Base Inventory.

 

sample_-_lamp.png

 

 

 

SKU/Inventory Relationships

The graphic below illustrates the flow of a product/SKU relationship.

 

prod_config_flow.png

 

 

 

 

 

© 2011 CORESense · 1-866-229-2804 · info@coresense.com · 125 High Rock Avenue, Saratoga Springs, NY 12866