Import Specifications for the Items Master List

A core table within the Syntelic database is the Item table. It is most commonly used in conjunction with Load Planning where it is an essential source of information for the load diagramming process. Each entry in the Item table defines a specific Item or SKU that is stocked and/or shipped by operations.

Some of the attributes in the Items table are informational (such as descriptive fields) and some are critical to the proper development of load diagrams (such as case cube and weight.

Although the Item master list could conceptually be maintained directly within Syntelic, most Syntelic customers refresh the Item table on a regular basis (typically daily) by importing a file that is made available from an upstream system such as order processing or a warehouse management system.

More guidelines for the formatting of imports can be found here: Import Formatting Guidelines

A summary of the attributes importable for each Item are summarized in the table below. Due to the flexibility of Load Planning, many of the data fields are optional, but a few are required, as indicated by the asterisk (*).

Field NameDescriptionData Type
Division ID*Identifier of the owner division of this resource.Text
ID*Item ID or SKU. Must uniquely identify the item within the division.Text
Name*Description of the item or product.Text
Cube*Actual cubic volume of one case unit.Decimal
Weight*Actual weight of one case unit.Decimal
Product Type*An identifier that categorizes the items into groupings appropriate for process mapping of warehouse operations. Usually describes selection and/or loading types. Required if not included in Ship Order Line file.Text
Family IDAn identifier that categorizes items into groupings of similar products that must can be considered the same for pallet assembly and/or trailer loading/unloading. Usually describes product with similar package size that can be mixed with other items of the group when building pallet layers.Text
Stacking RuleAn identifier that categorizes the items into groupings appropriate for determining which items can be stacked on others or on similar items.Text
Pallet Stack LimitNumber of full pallets that can be packed for storage in warehouse.Integer
Primary Slot IDPrimary warehouse location.Text
Pick SequenceLogical sequence for identifying order in which items are picked.Integer
Alternate Slot IDAlternate warehouse location.Text
Pallet High*Number of layers of product on a standard pallet or other container type.Integer
Pallet Tie*Number of cases per layer on a standard pallet or other container type.Integer
Item WidthActual width of one case unit in inches.Decimal
Item HeightActual height of one case unit in inches.Decimal
Item LengthActual length of one case unit in inches.Decimal
Overhang LengthThe amount by which this item (in a standard pallet configuration) overhangs each of the two narrow sides of a pallet (thus extending the length of the pallet in the longer dimension, typically extending the 48″ length).Decimal
Overhang WidthThe amount by which the item (in a standard pallet configuration) overhangs each of the two wide sides of a pallet (thus extending the length of the pallet in the shorter dimension, typically extending the 40″ width).Decimal
Eaches Per CaseNumber of each units (pieces) per case unit. May be zero if each picking is not applicable.Integer
Manufacturer IDID of item as assigned by manufacturer.Text
Pack SizeDescription of packaging within case.Text
Unit of MeasureDescription of units of measure within case.Text
Scan Product IDID of the barcode located on the outside of the case.Text
UPCUniversal product code that is uniquely assigned to each item.Text
Is Catch WeightYes/No indicator for catch weight items.Boolean
Flexible ColumnsOptional field(s) as defined by the client.Text, Numeric, Boolean, Date