COMPULINK 3300 Overland Avenue, Suite 201 § Los Angeles, California 90034 § 310 × 204 × 5121
More Class Codes Ideas
Description
Below is another 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. Before computerizing, some store managers may have broken inventory down into just six or seven different categories. This may have been enough for manual systems, but to only use six or seven class codes with the Jewelry Shopkeeper would be a waste of its reporting power.
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.
Always try to leave gaps between major class codes to allow for future expansion. When a range of numbers is listed below, such as 001-039 for loose diamonds, it doesnt mean that you have thirty-nine codes for diamonds it means you have reserved up to thirty-nine major class-codes for diamonds for future use even though you may only need four or even just one at the beginning.
NOTE: A new feature in Version 6.0 allows you to reassign class codes. For example if you had assigned Gents Wedding Rings to class codes 131, but later decide that you would prefer to use class code 145, all of the inventory in class 131 could be transferred to 145.
¨ . 010-019 Diamonds: 11-50 Pt
¨ . 020-029 Diamonds: 51-99 Pt
¨ . 030-039 Diamonds: 1ct & Up
m . 040-049 Emeralds
m . 050-059 Rubies
m . 060-099 Other Loose Stones
. 100-199 RINGS
m . 120-139 Wedding Rings
¨ . 130-139 Gents Wedding Rings
m . 140-159 Precious Gem Rings
m . 160-169 Semi-precious Gem Rings
m . 180-189 Precious Metal Rings
m . 190-199 Custom Rings
. 200-299 EARRINGS
m . 200-239 Gem Earrings
(§ ) 200 stud earrings
(§ ) 209 other diamond earrings
¨ . 210-219 Ruby Earrings
(§ ) 213 fancy
(§ ) 219 other ruby earrings
¨ . 220-229 Other Precious Gem Earrings
¨ . 230-239 Semi-Precious Gem Earrings
¨ . 240-259 Plain Precious Metal Earrings
(§ ) 241 karat gold stud/cuff
(§ ) 243 gold filled fancy
(§ ) 246 gold plate fancy
(§ ) 247 gold plate stud/cuff
(§ ) 249 sterling silver fancy
(§ ) 250 sterling silver stud
(§ ) 252 silver plate fancy
(§ ) 253 silver plate stud/cuff
(§ )
¨ . 270274 Other precious Metal Earrings
m . 280-289 Novelty/Other Earrings
m . 290-299 Custom/ Artist Earrings
. 300-399 BRACELETS
¨ . 310-319 Semi-Precious Gem Bracelets
¨ . 320-324 Other Gem Bracelets
¨ . 330-334 Silver Bracelets
¨ . 335-339 Other Precious Metal Bracelets
m . 340-379 Chain Bracelets
¨ . 350-359 Silver
m . 390-399 Other Bracelets & Anklets
. 400-499 NECKLACES
¨ . 420-429 Silver
¨ . 440-439 Other
m . 470-489 Pearl Necklaces
. 500-519 JEWELRY ENSEMBLES/SETS
. 520-520 FINDINGS
. 530-539 OTHER JEWELRY (charms, religious jewelry, coins)
. 550-599 PENDANTS
(§ ) 504 ruby pendants
m . 570-578 Semi-Precious Gem Pendants
m . 580-589 Other Pendants
m . 590-599 Lockets
. 600-659 WATCHES & CLOCKS
(§ ) 610-614 Steel
¨ . 615-629 Sports Watches
() 617 diving II
() 621 digital
() 623 analog/digital
(§ ) 625-629 Automatic
m . 630-659 Womens Watches
(§ ) 640-644 Steel
¨ . 645-659 Sports Watches
() 647 diving II
() 651 digital
() 653 analog/digital
(§ ) 655-659 Automatic
m . 660-678 Watch Bands
m . 680-699 Clocks
. 700-799 GIFTWARE
m . 720-729 Cutlery
m . 730-739 Flatware
m . 740-749 China
m . 750-754 Knives
m . 760-779 Figurines
m . 790-799 Baby Goods
. 800-854 ACCESSORIES
¨ . 809-814 Silver
¨ . 815-819 Other
m . 820-824 Lighters
m . 825-834 Pens & Pencils
m . 835-844 Luggage & Leather Goods
m . 845-847 Money clips
m . 849-852 Cuff Links
m . 853 Knives
. 855-859 OPTICAL
. 860-869 TOOLS, PARTS, CLEANING SUPPLIES
. 870-889 APPLIANCES (Cameras, Audio, Video)
m . 950-969 Repairs
(§ ) 952 watch repairs
(§ ) 955 jewelry repairs
m . 970-979 Labor
(§ ) 972 cleaning
(§ ) 974 setting
m . 980 appraisals
m . 990-999 Custom Made Jewelry
Description
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
2 ______ Gold Filled(overlay)
3 ______ Gold Plate
4 ______ Pewter
5 ______ Silver Plate
6 ______ Stainless Steel
7 ______ Sterling Silver
8 ______ Silver Vermeil
10 ______ 10 Karat Gold
12 ______ 12 Karat Gold
18 ______ 18 Karat Gold
22 ______ 22 Karat Gold
24 ______ 24 Karat Gold
26 ______ Platinum
30 ______ Lead Crystal
35 ______ Miscellaneous Metals
100 ______ Agate
105 ______ Alexandrite
110 ______ Amber
115 ______ Amethyst
120 ______ Andalusite
125 ______ Aquamarine
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
190 ______ Lapis
195 ______ Malachite
200 ______ Moonstone
205 ______ Onyx
210 ______ Opal
215 ______ Pearl
220 ______ Peridot
225 ______ Quartz
230 ______ Ruby
235 ______ Sapphire
240 ______ Sardonyx
245 ______ Spinel
250 ______ Tanzanite
255 ______ Tiger (cats) Eye
260 ______ Topaz
265 ______ Tourmaline
270 ______ Tsavorite
275 ______ Turquoise
280 ______ Zircon
300 ______ Misc. Colored Stones
800 ______ General Merchandise
900 ______ Labor Only
910 ______ Appraisal Only