CLASSES
Major Class Code Ideas
----------------------
Below is a sample major class code listing. As always, the
organization of your own listing should reflect the relative
importance of the various inventory types in your store and also the
amount of detail you want in inventory and sales reports. A greater
number of major class codes yields more specific reports but
requires more effort in categorizing merchandise when it is entered
into the computer.
You can have up to 999 major class codes, but that would be too many
for most stores to keep track of. The sample below represents a
quite detailed listing Ä you may prefer a simpler one. Be careful
not to make the listing too simple though. For a manual system 8
categories might have seemed enough but for an organized
computerized system 50 major codes should be considered the low-end
and 150 might be on the high end.
To make the classes easier to remember, you can also assign a
mnemonic to each major class code number, such as GWR for Gents'
Wedding Rings. The number is always required with the letters
optional; you could use letters on all or just a few of your major
codes.
Always try to leave gaps between major class codes to allow for
future expansion.
Note that major codes do NOT usually reflect the vendor or brand.
Each inventory item entered also is assigned a vendor and brand code for that.
In certain cases you may partly assign major codes by vendor. For example,
If a certain specialty designer is usually collected by customers then the
fact that the item is a ring or bracelets may be of less significance than
the designer. E.g. in that case you might have 750 Joe's Enamel Broach,
755 Joe's Enamel rings, 760 Joe's Enamel Bracelets. (instead of grouping
them with the rings, braclets and broaches as would be normal.)
> LOOSE STONES (001-099) - 160 Semi-precious Gem Rings
- 005 Diamonds Under 10 Pt - 170 Class/School Rings
- 010 Diamonds: 11-50 Pt - 180 Precious Metal Rings
- 020 Diamonds: 51-99 Pt - 190 Custom Rings
- 030 Diamonds: 1-2Ct
- 040 Diamonds: Over 2Ct > EARRINGS (200-299)
- 200 Dia stud earrings
- 050 Emeralds - 203 Dia fancy earrings
- 060 Rubies - 209 other diamond earrings
- 070 Other Loose Stones - 210 Ruby stud earrings
- 220 Other ruby earrings
> 100-199 RINGS - 230 Semi-Precious Gem
- 100 Engagement Solitaire Earrings
- 110 Engagement Fancy - 235 Plain Precious Metal
- 120 Women's Wedding Bands Earrings
- 130 Gents' Wedding Bands - 240 karat gold fancy
- 140 Precious Gem Rings - 241 karat gold stud/cuff
----------------------------------------------------------------------
- 243 gold filled fancy - 570 Ruby pendants
- 244 gold filled stud/cuff - 580 Semi-Precious Gem
- 246 gold plate fancy Pendants
- 247 gold plate stud/cuff - 590 Other Pendants
- 249 sterling silver fancy - 595 Lockets
- 250 sterling silver stud
- 252 silver plate fancy > WATCHES & CLOCKS (600-659)
- 253 silver plate stud/cuff - Gents' Watches (600-629)
- 260 Karat Gold Earrings - 600 Gts Precious Metal/Gem
- 265 Silver Earrings - 610 Gts Dress Steel
- 270 Other precious Metal - 615 Gts Diving Quartz
Earrings - 619 Gts Analog Sports
- 280 Novelty/Other Earrings - 621 Gts Digital Sports
- 290 Custom/ Artist Earrings - 623 Gts analog/digital
Sports
> BRACELETS (300-399) - 625 Gts Automatic Dress
- 300 Precious Gem Bracelets - 625 Gts Automatic Sports
- 310 Semi-Precious Gem
Bracelets - Women's Watches (630-659)
- 320 Other Gem Bracelets - 630 Lds Precious Metal/Gem
- 325 Precious Metal - 640 Lds Dress Steel
Bracelets - 645 Lds Diving Quartz
- 325 Karat Gold Bracelets - 649 Lds Analog Sports
- 330 Silver Bracelets - 651 Lds Digital Sports
- 335 Other Precious Metal - 653 Lds analog/digital
Bracelets Sports
- 340 Chain Bracelets - 655 Lds Automatic Dress
- 340 Gold - 655 Lds Automatic Sports
- 350 Silver
- 390 Other Bracelets & - 660 Watch Bands
Anklets - 679 Batteries
- 680 Clocks
> NECKLACES (400-499)
- 400 Gold Necklaces > GIFTWARE (700-799)
- 414 Gold Herringbone Chain - 700 Crystal Hollowware
14K - 710 Crystal Decorative
- 418 Gold Herringbone Chain - 720 Cutlery
18K - 730 Flatware
- 424 Gold Rope Chain 14K - 740 China
- 428 Gold Rope Chain 18K - 750 Knives
- 430 Gold Box Chain - 760 Figurines
- 440 Gold Diamond Cut Chain - 790 Baby Goods
- 460 Platinum Necklaces
- 470 Silver Necklaces > ACCESSORIES (800-854)
- 480 Other Chain Necklaces - 800 Tie Clips Precious
- 490 Pearl Necklaces - 805 Tie Clips Other
- 810 Lighters
- 500 Jewelry Ensembles/Sets - 815 Pens & Pencils
- 520 Findings - 820 Luggage & Leather Goods
- 530 Other Jewelry (charms, - 825 Money clips
religious jewelry, coins) - 830 Cuff Links
- 540 Broaches & Pins - 835 Knives
> PENDANTS (550-599) - 850 Optical
- 550 Precious Gem Pendants - 860 tools, Parts, Cleaning
- 560 Diamond cluster Supplies
pendants
----------------------------------------------------------------------
- 870 Appliances (Cameras,
Audio, Video)
> REPAIRS/LABOR/APPRAISALS/
CUSTOM WORK (950-980)
(for Dummy Sku numbers)
- 900 Ring Sizing
- 910 Ring Repairs
- 920 Jewelry repairs
- 930 Watch Battery
- 935 Watch Repairs
Electronic
- 940 Watch Repairs
Automatic
- 950 Custom Made Jewelry
- 960 Assembly Labor
- 965 Cleaning Labor
- 970 Setting Labor
- 980 Appraisals
- 999 Shipping, Misc
-----------------------------------------------------
Minor Class Codes
Below are some sample minor class codes. Note that there may be some
redundancy between the major and minor class codes. For example. You
may have a specific earring category for 14 Karat gold earrings Ä
so why have a minor class code for 14 Karat Gold? The reason is so
that you could run a sales or inventory report for all the 14 Karat
gold items, regardless of whether they are rings, bracelets, watches
or earrings. You can have up to 1000 minor class codes, but that is
probably far too many for most stores. The minor class codes do NOT
have the option for an equivalent in alphabetical characters.
1 Brass 190 Lapis
2 Gold Filled(overlay) 195 Malachite
3 Gold Plate 200 Moonstone
4 Pewter 205 Onyx
5 Silver Plate 210 Opal
6 Stainless Steel 215 Pearl
7 Sterling Silver 220 Peridot
8 Silver Vermeil 225 Quartz
10 10 Karat Gold 230 Ruby
12 12 Karat Gold 235 Sapphire
18 18 Karat Gold 245 Spinel
22 22 Karat Gold 250 Tanzanite
24 24 Karat Gold 255 Tiger (cats) Eye
26 Platinum 260 Topaz
30 Lead Crystal 265 Tourmaline
35 Miscellaneous Metals 270 Tsavorite
100 Agate 275 Turquoise
105 Alexandrite 280 Zircon
110 Amber 300 Misc. Colored Stones
115 Amethyst 800 General Merchandise
120 Andalusite 900 Labor Only
125 Aquamarine 910 Appraisal Only
130 Bloodstone
135 Cameo
140 Chrysoberyl
145 Citrine
150 Coral
155 Cubic Zirconia
160 Diamond
165 Emerald
170 Garnet
175 Ivory
180 Jade
185 Kunzite
---------------------------------