PI Import Definition Setup - Product Mapping field descriptions

The Product Mapping view shows where you map your import files, so that Product Import knows where to find information in the import file.

The field values that are listed show on the Product Mapping view, but may not be enterable for all import types. Each field is listed in the table. It includes a description, and what import type it is available [Yes or No for Delimited, Fixed, or Trade Service]. If you are mapping a fixed length or Trade Service file, you must specify a beginning field locator and the length of the field. Most fields are not accessible for Trade Service files. These fields are predefined, or they do not exist.

  • Begins: If you are mapping fields for fixed length or Trade Service files, specify the beginning field locator number. This instructs Distribution SX.e as to the exact starting location of each field within the record. See the example of the Product Mapping section for a fixed length import file, below.

  • Length: The exact field length must be specified for each field you are mapping for fixed length or Trade Service files.

Field Name Description Delimited Fixed Trade
Cash Discount This is the terms percent field that is stored in Product Catalog Setup or Product Setup. Y Y N
Cost This is the amount the vendor or manufacturer charges you for the item and can be used to calculate the price or cost. The assumed decimal placement that is defined on the Required view is applied to this value. Y Y N
Cross Reference The X-Ref, or cross reference, fields are used to map information in the import file used to create an interchange type record in Product Extended Product Cross Reference Setup. They are also used to update the Vendor Product field in Product Warehouse Product Setup. Up to four cross reference fields can be imported. If you define a cross reference field, you can indicate which type of Product Extended Product Cross Reference Setup record should be created in Product Import Price/Cost Multipliers Setup. Y Y Y
Cubes This is the cubic volume of one stocking unit. Y Y N
Date This is stored as the effective date in the Product Import Edit File. It is used to determine when this product record can be updated into the This is stored as the effective date in the Distribution SX.e database. Y Y N
Description You can map one or both product description fields. Y Y N
List Price This is the list price of the item, or the recommended sale price to your customer. It can be used to calculate the price or cost. The assumed decimal placement that is defined on the Required view is applied to this value. Y Y N
MSDS Flag If the item is MSDS-controlled, this field is flagged. This updates the MSDS flag in the Product Catalog Setup or Product Setup. Y Y N
MSDS Sheet This is the MSDS Sheet# for items that are MSDS-controlled. Y Y N
Notes This is the field loaded in as notes. It may be the full product name and description, or the vendor, line and product, or miscellaneous information. N N N
Price/Cost Location of the value that is used to identify or create Product Special Price/Cost Setup records to be associated with an Product Setup product or Product Special Price/Cost Setup catalog product Y Y N
Product This is the product identifier for this item. It may be the same locator number you specify for the cross reference field(s) (X-Ref). Y Y N
Product Line The product line can be used to distinguish one product grouping from another, and is often referred to by Trade Service as the commodity code. It may not be the same as the product line in Product Lines Setup or product category in SA Table Code Values Setup. This is an optional field. Y Y N
Rebate Cost Location of a value that is loaded into the Rebate Cost field in either Product Warehouse Product Setup or Product Catalog Setup. Y Y Y
Rebate Subtype Location of a value that is loaded into either the Product Warehouse Product Setup Rebate Sub Type or the Product Catalog Setup Sub Type Y Y Y
Rebate Type Location of a value that is loaded into either the Product Warehouse Product Setup Rebate Type or the Product Catalog Setup Rebate Type Y Y Y
Standard Pack Unit Location of a value that is loaded into either the Product Warehouse Product Setup Standard Pack or the Product Catalog Setup Standard Pack after it is validate against units set up in SA Table Code Value Setup and Product Extended Unit Conversion Setup. Y Y Y
Supersede If the product is superseded, this is the supersede product name. Y Y N
Unit This is the unit of measure. This updates the Special Price/Costs fields Unit in the Product Catalog Setup or Product Setup record in Distribution SX.e for Trade Service imports only, which are pre-mapped. You cannot change this field. N N N
UPC Label and Section The UPC (Universal Product Code) may be a separate code defined as the UPC code. It may also be a combination of the manufacturer, vendor, line, or product (NAED /EDP #). These fields update the UPC # in Product UPC Information Setup, which is 24 characters in length.

The UPC is comprised of six 12-digit segments; the first two and last two segments are user-defined. The 3rd and 4th segments are reserved for the vendor and UPC# product number portion of the UPC. The segments are defined in SA Administrator Options.

If you do not have a segment defined in SA Administrator Options [other than the vendor and product segments], it does not show in the UPC Sections portion of the PI Import Definition Setup window.

Note: If you are mapping the UPC# for a delimited file, you must map the whole number in the product segment only. During Product Import Entry Update Products, the whole number is parsed based on the SA Administrator Options settings.
Y Y N
User 1-5 These are text fields that can be loaded into the edit file. A custom program must be created to use the values in these fields. Up to five user fields can be imported. Y Y Y
Vendor The vendor code is important if the file contains products for more than one vendor. It is not the Vendor Setup number. This is an optional field. Y Y N
Weight This is the weight of the item. Y Y N