Tracking File
Description & Use Cases
The tracking file is typically used for the following:
To have a digital reference of recent shipments and tracking numbers
To upload tracking/shipment information to internal systems
To show tracking on customer websites for drop ship orders
Schedule
The file is extracted daily and expected to be available by 8am.
Delivery
The file will be delivered via ftp to a Gardner or customer ftp location.
File Layout
The file will be delivered in csv format. Description of fields below:
AvailPhysical Numeric Inventory Available for sale
GardnerPartNumber Varchar(33) Gardner Part Number (MfgCode + MfgPartNumber)
InventLocationId Varchar(2) Location ID (01, 11, 31, 51, 40, 63)
InventWarehouseName Varchar(30) Location City ('Columbus,OH','Jacksonville,FL','Franklin,MA','Reidsville,NC','Brown Summit,NC')
ManufacturerCode Varchar(3) Manufacturer Code (KOH, MTD, HOP, etc.)
ManufacturerName Varchar(30) Manufacturer Name (Kohler, MTD, Husqvarna, etc)
MfgPartNumber Varchar(30) Manufacturer Part Number
Naming Convention
SHIP_{Customer Number}_{YYYY-MM-DD}T{HHMMSS}.csv