Inventory File
Description & Use Cases
The inventory file is typically used for the following:
To have a digital reference of Gardner inventory
To upload inventory to internal systems
To show availability on customer websites
Schedule
The file is extracted daily and expected to be available by 8am.
Delivery
The file will be delivered via ftp to be a Gardner or customer ftp location. Each manufacturer will be separated into its own file.
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
INV_{Customer Number}_{Manfuacturer Code}-{YYYY-MM-DD}T{HHMMSS}.csv