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 doesn’t 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.

  •         •. 001-099 LOOSE STONES
  • m . 001-039 Diamonds
  • ¨ . 001-009 Diamonds Under 10 Pt

    ¨ . 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 . 100-119 Engagement Rings

    m . 120-139 Wedding Rings

  • ¨ . 120-129 Women’s Wedding Rings

    ¨ . 130-139 Gents’ Wedding Rings

  • m .  140-159 Precious Gem Rings

    m . 160-169 Semi-precious Gem Rings

  • m . 170-179 Class/School Rings

    m . 180-189 Precious Metal Rings

    m . 190-199 Custom Rings

  • •.  200-299 EARRINGS

  • m . 200-239 Gem Earrings

  • ¨ . 200-209 Diamond Earrings
  • (§ ) 200 stud earrings

  • (§ ) 203 fancy

    (§ ) 209 other diamond earrings

  • ¨ .  210-219 Ruby Earrings

  • (§ ) 210 stud 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

  • (§ ) 240 karat gold fancy
  • (§ ) 241 karat gold stud/cuff

    (§ ) 243 gold filled fancy

  • (§ ) 244 gold filled stud/cuff
  • (§ ) 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

  • (§ )

  • m .   260–274 Precious Metal Earrings
  • ¨ . 260–264 Karat Gold Earrings
  • ¨ . 265–269 Silver Earrings

    ¨ . 270–274 Other precious Metal Earrings

  • m .  280-289 Novelty/Other Earrings

    m . 290-299 Custom/ Artist Earrings

  • •.  300-399 BRACELETS

  • m . 300-324 Gem Bracelets
  • ¨ . 300-309 Precious Gem Bracelets

    ¨ . 310-319 Semi-Precious Gem Bracelets

    ¨ . 320-324 Other Gem Bracelets

  • m .  325-339 Precious Metal Bracelets
  • ¨ . 325-329 Karat Gold Bracelets
  • ¨ . 330-334 Silver Bracelets

    ¨ . 335-339 Other Precious Metal Bracelets

  • m .  340-379 Chain Bracelets

  • ¨ . 340-349 Gold
  • ¨ . 350-359 Silver

  • m .  390-399 Other Bracelets & Anklets

  • •.  400-499 NECKLACES

  • m . 400-439 Chain Necklaces
  • ¨ . 400-419 Gold

    ¨ . 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)

  • •. 540-549 BROACHES
  • •. 550-599 PENDANTS

  • m . 550-569 Precious Gem Pendants
  • (§ ) 500 diamond cluster pendants

    (§ ) 504 ruby pendants

  • m .   570-578 Semi-Precious Gem Pendants

    m . 580-589 Other Pendants

    m . 590-599 Lockets

  • •.  600-659 WATCHES & CLOCKS

  • m . 600-629 Gents’ Watches
  • ¨ . 600-614 Dress Watches
  • (§ ) 600-609 Precious Metal/Gem

    (§ ) 610-614 Steel

  • ¨ .  615-629 Sports Watches

  • (§ ) 615-624 Electronic Watches
  • (—) 615 diving I

    (—) 617 diving II

  • (—) 619 analog
  • (—) 621 digital

    (—) 623 analog/digital

  • (§ )  625-629 Automatic

  • (—) 625 diving
  • m .    630-659 Women’s Watches

  • ¨ . 630-644 Dress Watches
  • (§ ) 630-639 Precious Metal/Gem

    (§ ) 640-644 Steel

  • ¨ .  645-659 Sports Watches

  • (§ ) 645-654 Electronic Watches
  • (—) 645 diving I

    (—) 647 diving II

  • (—) 649 analog
  • (—) 651 digital

    (—) 653 analog/digital

  • (§ )  655-659 Automatic

  • (—) 655 diving
  • m .    660-678 Watch Bands

  • (—) 679 batteries
  • m .    680-699 Clocks

  • •.  700-799 GIFTWARE

  • m . 700-719 Crystal

    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

  • m . 800-819 Tie Clips, Chains, Pins
  • ¨ . 800-807 Gold

    ¨ . 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)

  • •. 950-999 REPAIRS/LABOR/APPRAISALS/CUSTOM WORK (for Dummy Sku numbers)
  • m . 950-969 Repairs

  • (§ ) 950 ring repairs

    (§ ) 952 watch repairs

    (§ ) 955 jewelry repairs

  • m .   970-979 Labor

  • (§ ) 970 assembly

    (§ ) 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