Catalog by Product Type Suggestions Catalog by Product Type Suggestions and Product Code Factors
If you are using B2B, you will only need to enter catalog for product you sell that is not currently part of the B2B program. The pages that follow are a guide to entering those items.
Carpet Style Name-Product Code Factor Determined by Carpet Width:
The Style Name field should include the name of the series/line. Additional product information, including weight, width, and cut pile can be included in the style name or description field. Cost should be entered in SY or SF, depending on system setup.
Examples: Style Name: IMPRESSIONS 28 OZ
Color Name: ANTIQUE BEIGE
Style Name: IMPRESSIONS 28 OZ 6’
Color Name: ANTIQUE BEIGE
Sheet Vinyl Style Name-Product Code Factor Determined by Vinyl Width (see manual for chart):
The Style Name field should include the name of the series/line. Additional product information, including grade, width, and pattern match can be included in the style name or description field. Cost should be entered in SY or SF, depending on system setup.
Examples: Style Name: VEGA II
Color Name: 12345
Style Name: VEGA II 6’
Color Name: 12345
VCT/Vinyl Tiles/Plank-Product Code Factor 02:
The Style Name field should include the name of the series/line, as well as the product dimensions if available in multiple sizes. Additional product information, including installation method and wear layer thickness can be included in the style name or description field. Quantity per box and cost should be entered in SF.
Examples: Style Name: EXCELON PREMIUM
Color Name: PERSIMMON
Laminate Flooring-Product Code Factor 08:
The Style Name field should include the name of the series/line, as well as the product dimensions if available in multiple sizes. Additional product information, including installation method and wear layer thickness can be included in the style name or description field. Quantity per box and cost should be entered in SF.
Examples: Style Name: ORIGINAL TILES
Color Name: HICKORY
Laminate Trim Pieces-Product Code Factor 08:
The Style Name field should include the name of the series/line and the trim/molding type. Additional product information, including product length, can be included in the Style Name or Description field. Cost should be entered by the piece.
Examples: Style Name: QUARTEROUND
Color Name: NATURAL
Or
Style Name: STAIR NOSE
Color Name: T12345
Hardwood Flooring-Product Code Factor 08:
The Style Name field should include the name of the series/line, as well as the product dimensions if available in multiple sizes. The species should also be included in the Style Name field. Additional product information, including installation method and type (e.g., solid, engineered) can be included in the style name or description field. Quantity per box and cost should be entered in SF.
Examples: Style Name: HERITAGE 2 ¼ RED OAK STRIP
Color Name: NATURAL
Style Name: HERITAGE 3 ¼ WHITE OAK PLANK
Color Name: GUNSTOCK
Hardwood Trims-Product Code Factor 08:
The Style Name field should include the name of the series/line and the trim/molding type. Additional product information, including product length, can be included in the Style Name or Description field. Cost should be entered by the piece.
Examples: Style Name: QUARTERROUND
Color Name: NATURAL
Style Name: STAIR NOSE
Color Name: GUNSTOCK
Ceramic Field Tile-Product Code Factor 02:
The Style Name field should include the name of the series/line, as well as the product dimensions if available in multiple sizes. The Tile Finish should also be included in the Style Name field. Additional product information, including application location can be included in the style name or description field. Quantity per box and cost should be entered in SF.
Examples: Style Name: BARCELONA 13 MATTE
Color Name: VERDE
Or
Style Name: BARCELONA 6X9 MATTE
Color Name: VERDE
Ceramic Accessory Tiles-Product Code Factor 08:
The Style Name field should include the name of the series/line and The Tile Finish should also be included in the Style Name field.
This category is used for all ceramic tile sold by the piece, which will include, decos, listellos, bull noses, soap dishes, etc. In the name field, use the style name, the size, the type and the finish. In the cost field of the catalog screen enter the cost of the piece.
Examples: Style Name: BARCELONA 2X6 LIST GLOSS (listello)
Color Name: BLANCO
Style Name: BARCELONA 3X4 SBN MATTE (surface bullnose)
Color Name: GRIS
Natural Stone-Product Code Factor 07:
This product is available in slabs or in pre-finished sizes. Pre-finished items should be entered like ceramic tile above as it is bought and sold in sf and has a specified sf/ctn. Slabs come in whatever size is available, however, it is costed and sold by sf. Both slab and pre-finished stone can be in the same product code, if preferred, but it is not required. Note: (When receiving stone in slab form, use the dye lot field of the receiving screen to enter the actual size of the slab.) Use the description field of the catalog screen to enter how many sf/ctn if it applies.
Example: Style Name: TRAVERTINE 13X13 (for pre-finished stone)
Color Name: VERDE
Style Name: MARBLE (for slab stone)
Color Name: BLANCA/GRIS
Supplies and Other Items:
The section below is for supply type products or non-flooring items. Please pay careful attention to the following points. Remember, what you put in the style name field is your price point break, so if there are different costs because of color, add something in the style name field to identify each price group.
Adhesives-Product Code Factor 08:
In the style name field, use the brand, the brand’s name and the container size. In the color field use the type of adhesive. The description field of the catalog screen can be used to enter the spread rate.
Example: Style Name: HENRY’S 350 1 GAL
Color Name: MULTIPURPOSE ADHESIVE
Area Rugs-Product Code Factor 08:
In the style name field, enter the name of the rug, the size to the nearest full foot and the shape of the rug. In the description field, enter the exact size in feet and inches.
Example: Style Name: MY GARDEN 7X9 OVAL (7’2” X 8’11”)
Color Name: BURGUNDY
Blinds-Product Code Factor 07:
Since these are custom orders, you will need to create generic descriptions and use notes extensively in the F6 job line comments and also in the PO Notes. In the style name field, use a generic description. In the color field use the word CUSTOM.
Example: Style Name: PVC BLINDS or WOOD SHUTTERS
Color Name: CUSTOM CUSTOM
Caulk-Product Code Factor 08:
Enter 3 letters for the brand, identify if it is sanded or un-sanded, and if the tube is available in different sizes, this must be in the style name field. Use the color number and name in the color name field.
Example: Style Name: CCU CAULK SAND 16 OZ or CCU CAULK U/SND 16 0Z
Color Name: 100 WHITE 100 WHITE
Cleaners-Product Code Factor 08:
Use three letters to indicate the brand, the brand’s name of the product, and the size of the container in the style name field. In the color name field, enter the type of product. Use the description field of the catalog screen to enter the spread rate.
Example: Style Name: ARM ONCE N DONE 32 OZ
Color Name: FLOOR CLEANER
Cove Base-Product Code Factor 08:
This item has so many options that you will have to create a code in order to differentiate the items. You must address, brand, size, species, straight or cove edge, gauge, strip or coil and color groups. In the color name field use both the number and the name.
Below is the example for Roppe, 4” vinyl cove base, 1/8” gauge, color group 1 in strips. In the description field of the catalog screen, enter how many lf/ctn or 4 lf/strip.
Example: Style Name: ROP 4VC 1/8 G1 STRIP
Color Name: 101 BLACK
Grout-Product Code Factor 08:
In the style name field, use 3 letters to indicate the brand, identify sanded or un-sanded, and the bag or container weight. Again if color drives the price this must be indicated in the style name field also. In the color name field, enter the color number and name. In the description field of the catalog screen, enter the spread rate.
Example: Style Name: MAP SANDED 25 LB STD
Color Name: 101 WHITE
Metals-Product Code Factor 08:
Since gold metals are generally more expensive than silver, the color must be in the style name field along with the description of the item. Metals are general either sold by the foot, or pc. In the description field of the catalog screen, enter how many lf/stick.
Example: Style Name: GOLD 1” FLATBAR/PC or GOLD 1” FLATBAR /LF
Color Name: CARPET METAL CARPET METAL
Padding-Product Code Factor 08:
Use the weight and gauge in the style name field. Do not use each of the vendor’s names for the same products or your inventory will be all over the place. You will still be able to change the vendor you buy from, PO by PO.
Example: Style Name: 8 LB 7/16” or 6 LB 1/2"
Color Name: REBOND REBOND
Paint-Product Code Factor 08:
Premixed paint will need the brand, the finish, grade, species and the container size in the style name field, with the color name in the color name field. Unmixed paint will need the brand, the base description, grade and species, finish and container size in the style name field and in the color name field use the words BASE PAINT. You may want to add an over bill amount in the catalog screen to cover cost of tints added to these items. If your vendor uses a code to indicate these things and it is more familiar to you in that fashion, you may use the brand and the code to indicate this, as there may not be enough room in the style name field.
Example: Style Name: BEN 10203040-1 or BEN EX/O DEEP SAT 1
Color Name: BASE PAINT BASE PAINT
BEN for Benjamin Moore, 10 for exterior, 20 for oil or water base, 30 for deep, and 40 for satin finish. The –1 would be the 1 gallon size.
Vinyl Reducers-Product Code Factor 08:
In the style name field, enter 3 letters of the brand, the item number the vendor uses when you buy it, and the color group again if color drives the cost. In the color name field use the color number and name. In the description field of the catalog screen enter the purpose of the piece and its size.
Example: Style Name: JOH CTA-XXX-1 GP1 (CARPET TO TILE 12’)
Color Name: 47 BROWN
Seam Sealers-Product Code Factor 08:
Use 3 letters for the brand, a description, and weight/size of container in the style name field. In the color name field put whether is it a low or hi gloss sealer. In the description field of the catalog you can enter the spread rate.
Example: Style Name: DOM 35080 500 ML
Color Name: HI GLOSS KIT
Stair Treads & Risers-Product Code Factor 08:
Enter 3 letters of the brand, the height of the item, the species, gauge and the color group if color drives the cost. Roppe 8” Rubber Riser, 1/8 gauge, color group 3 would look like
Example: Style Name: ROP 8RR 1/8 GP3
Color Name: 85 BURGUNDY
Thinset-Product Code Factor 08:
In the style name field enter the 3 letters for the brand, a description and the container size. In the color name field enter the color name. In the description field of the catalog screen, you can enter the spread rate.
Example: Style Name: CCU THINSET 5 GAL
Color Name: WHITE
Underlayments-Product Code Factor 08:
Many different types of underlayment will be entered here. There will be brand specific/size specific items for laminates, plywood of different shapes and sizes, and ceramic backer boards of different sizes. Create the description as you would buy and sell it in the style name field. In the color name field, enter UNDERLAYMENT. Enter the cost of the item as the smallest unit you will buy it by. In the description field of the catalog screen enter what you see in ( ) next to each example.
Examples: Style Name: 4X8 1/4" LUAN (32 SF/SHEET) cost would be for a full sheet.
Color Name: UNDERLAYMENT
Style Name: 4X4 1/4"LUAN (16 SF/SHEET) cost would be for half a sheet
Color Name: UNDERLAYMENT
Style Name: HARDIBACKER 3X5 (15 SF/SHEET)
Color Name: UNDERLAYMENT
Style Name: WIL WHISPERWALK 100’ ROLL
Color Name: LAM UNDERLAYMENT
LABOR CATALOG ITEMS-All Are Product Code Factor 10
Each major floor material type should have its own Product Code. Under each product code, enter any description of a type of labor or expense that would be paid or reimbursed to an installer, entering your standard cost per unit and sell per unit. Leave the GL account code blank as it will default to your product code setup. Use both the style name field to define to service. Since many of these services are identical “Regular Install”, the color name is used to identify the product being installed. The cost entered here will be used is for job costing and as the default labor to pay when processing the installer bill. It will not hit your general ledger for cost of labor here. Instead labor costs will hit the general ledger when the installer bill is entered in AP. Your job cost will be corrected at the time you enter in the installer bill in Job Labor Maintenance in the Installation Module.
Examples of Product Codes:
L1 CARPET LABOR
L2 VINYL LABOR
L3 VCT/VINYL TILE LABOR
L4 LAMINATE LABOR
L5 HARDWOOD LABOR
L6 CERAMIC LABOR
L7 BLIND LABOR
L8 STONE LABOR
Style Name: TRIP CHARGE
Color Name: CARPET LABOR
Style Name: TRAVEL/PER DIEM
Color Name: CARPET LABOR
MISCELLANEOUS OTHER COSTS & CHARGES-Product Code Factor 09:
These are all non-inventory and non-labor items. They can be used to add a cost or sell to a job without addressing inventory or paying anyone to do it. A cost and sell should be entered here in each catalog item. The cost will be used for job costing purposes only. It will not hit your general ledger for cost.
Examples: Style Name: SAMPLES (cost could be 3.00 and sell could be 5.00 each)
Color Name: CARPET
Style Name: FREIGHT LOCAL
Color Name: CHARGE
Style Name: FREIGHT OVER 25 MILES
Color Name: CHARGE
If you have any item that cannot be found above, please feel free to contact support@rmaster.com or ask your trainer for advice on how to create the catalog for the item. Please also make sure you have entered a cost and a sell on each item. You can verify cost by going to Inventory Control, Inventory Reports, Catalog Listing. Select by Product code or product type and click on “only print items with no cost” and then choose Print. If any items appear, go back to Catalog Maintenance and make your corrections. There are many pricing options for entering sell amounts, and these are all explained in the manual. However, at the very least, start by entering margins by product code for all branches and all vendors. This option can be found in Inventory Control, Catalog A-F Pricing Maintenance/Print. You can always go back later and edit and change, vendor by vendor, catalog item by catalog item, branch by branch using margins or product pricing.
1
RollMaster