Who do I get the Item Catalog from?
Your DCL Account Manager or Account Representative will provide you with an Excel spreadsheet called the Item Catalog. Creating a part number in our system is crucial for a seamless process, from receiving your items to shipping them out. By completing the item catalog, all essential information can be gathered in one file, eliminating the need for back-and-forth communication for necessary details.
This article will provide insight into the significance of each field and why they are necessary. The Item Catalog will specify character limitations and length for each field.
What are the fields in the item catalog spreadsheet?
Item Number - This is the part or SKU number you use in your system and the number you will send us in your orders. This is a required field and must be no greater than 25 characters in length, contain no spaces or special characters with the exception of hyphens("-").
Description Line 1 - This is a description of your part number. This is a required field and allows for 30 characters.
Description Line 2 - If your description is longer than 30 characters, you can continue the description in this field. This is an optional field.
UOM - This is the Unit of Measure - Each unit will be considered one for DCL. So it will be EA.
UPC number - If shipping into retail your product will require a UPC. DCL will link your UPC to your stocking item number (sku). This allows a smooth shipping process for outbound orders.
COGs - Cost of Goods. This is what the item costs you and not the retail price. We use this amount to help determine how often we cycle count your part number.
Serialize Product Y/N - This is where you let us know if we need to scan a serial number when we ship your product.
Serial Number Format - To ensure accuracy, we implement a secondary validation process for scanned product serial numbers. You will need to provide a sample of the serial number format in the designated field if it consists of a specific number of characters or more, max length is 100 characters.
Lot Y/N - Please indicate here if your product needs to be stored and/or shipped by lot code.
Item Category - To ensure proper classification of the product during shipping, it is necessary to have this information.
Dimension -Retail Box - This information helps us to determine master carton sizes if we need to order them for you.
Weight (oz) - Having the weight of your product will help us with determining freight costs if needed.
Dimension - Master Carton - Having the dimension of your master cartons helps with storage and pallet estimations and determining freight costs if needed.
Weight (lb) -Having the weight along with the dimensions of the master carton helps to estimate freight costs if needed.
HTS Code, ECCN code, License Symbol, Country of Origin - Providing international shipping details is essential. Even if you currently do not have plans to ship internationally, many customers may require it in the future. Providing the necessary information now can prevent any delays when shipping internationally becomes a possibility.
Dangerous Good Y/N - Please indicate with a Y if your product has a battery. This is crucial for us to identify if your product requires shipment with a Dangerous Goods warning label.
Battery or Cell, How many batteries or cells per unit? - In order to determine the appropriate DG warning label for your product, we require some information from you. Additionally, you will receive a form to provide us with more specific details regarding the battery used in your product.
Other DG - If your product has hazardous materials besides batteries, please list them here.
NFMC Class -If you're shipping a pallet, it's important to provide NFMC classification. The acronym NFMC stands for National Motor Freight Classification, and it's a crucial detail for the freight carrier to know what they're transporting.