Automated SKU Management and Generation | Kornyk Computer Solutions


	Live Chat by LivePerson

Automated Inventory Item SKU Management

Overview

Easily determine the composition of your unique SKU number

The SKU Configurator can be used to determine the composition of the SKU number. Selection of some characters from the item's category, subcategory, vendor's part number, manufacturer or vendor will add them to the SKU number's format. Users can instead choose that an auto-generated number to be part of the SKU.

In addition, you can designate how many items have been created under a category and assign that particular Item Incremented Number anywhere within the SKU configuration.

Examples of the available choices listed above are as follows:

the first two characters of a category
a five-character Item Incremented Number
the first three characters of a subcategory
the first four characters of a manufacturer
a four-character automatically-generated number for a vendor
a specific example of an SKU could thus be as follows:
the category of a computer: CO (for COMPUTERS)
the 40th item configured under the category: 00040
the subcategory: FAN (for FANS)
the manufacturer: PHILL (for PHILLIPS)
the vendor: Ingram Micro (with an automatically generated code of 0009)
Subsequently, the resultant SKU would be CO00040FANPHILL0009.

SKU (Stock Keeping Unit) Automation

On the Setup>Global Settings>Options tab, you will find a Use Automatic SKU feature that when turned on will enable the new SKU Configurator feature in SIMMS.
Vendor SKU field - A SKU field exists in the vendor setup screen if you have configured the SKU manager to utilize Vendor information then the SKU field will display the Vendor SKU portion of the code to be used in the Item SKU code.
Manufacturer SKU field - A SKU field exists in the Manufacturer setup screen if you have configured the SKU manager to utilize Manufacturer information then the SKU field will display the Manufacturer SKU portion of the code to be used in the Item SKU code.
Category and Subcategory SKU field - An SKU field exists in the category and subcategory setup screens. If you have configured the SKU manager to use Category and/or Subcategory information then the SKU field will display the Category and/or Subcategory SKU portion of the code to be used in the Item SKU code.
Item Maintenance and SKU - SIMMS has the capability to assign a particular SKU item number to each inventory item configured in the Inventory Manager, enabling users to automatically assign a particular product's item number based on an SKU formula that can be devised using the SKU Configurator. This can be done upon the creation of an item, with the result that once the selection of either the item category, subcategory, brand (sub-sub category), model (sub-sub-sub category) or manufacturer has been made and the Save button is clicked, the Item number SKU will be automatically created based on the selected option. SKU numbers/barcodes will be generated based on a chosen formula, originating from the category, subcategory, brand, model or manufacturer fields once this feature is activated on the Global Settings>Transactions tab. The final item SKU can thus be alphanumeric, owing to its option choice made in the SKU Configurator.

If flawless standard uniform SKU numbering is important to you then SIMMS is the correct solution. So what are you waiting for? Please contact us at 604-504-4215 by phone or by e-mail at sales@kcsi.ca so we can help you take the first steps towards the solution you have been seeking.

Collapse