Price File
Description & Use Cases
The inventory file is typically used for the following:
To have a digital reference of Gardner inventory
To upload to internal systems
To show availability on customer websites
Schedule
The file is extracted once a week on Sunday and expected to be available by Monday at 8am.
Delivery
The file will be delivered via ftp to be a Gardner or customer ftp location. Each manufacturer will be delivered in a separate file.
File Layout
The file will be delivered in csv format. Description of fields below:
ManufacturerCode Numeric Inventory Available for sale
ItemNumber Varchar(33) Gardner Part Number (MfgCode + MfgPartNumber)
Description Varchar(2) Location ID (01, 11, 31, 51, 40, 63)
ProductCode Varchar(30) Location City ('Columbus,OH','Jacksonville,FL','Franklin,MA','Reidsville,NC','Brown Summit,NC')
Listprice Decimal Manufacturer Code (KOH, MTD, HOP, etc.)
CustomerPrice Decimal Manufacturer Name (Kohler, MTD, Husqvarna, etc)
FactoryFreight Decimal Factory Freight Value
NetWeight Numeric Weight of Product (lb)
Returnable Varchar(30) Returnable Iem
Sellpack Numeric Sell Qty
GrossWidth Numeric Width (in)
GrossDepth Numeric Depth (in)
GrossHeight Numeric Height (in)
MustShipLTL Varchar(30) Must ship LTL
Oversized Varchar(30) Oversized items. Typically dimensional charges apply.
UPCCode Varchar(30) UPC Code
CountryOfOrigin Varchar(30) Country of Origin
TariffCode Varchar(30) Tariff Code
ManufacturerItemNumber Varchar(30) Manufacturer Part Number
Naming Convention
PRICE_{Customer Number}_{Manufacturer Code}_{YYYY-MM-DD}T{HHMMSS}.csv