Order File
Naming Convention
{Customer Number}_GARORDER_{MMDDYY}.csv
Note: {Customer number}_GARORDER must be included in the name for the file to be picked up and processed as an order. The time or other unique data may be added to the date to make the file unique. This is particularly important if multiple files are being uploaded.
Sample Data
Description & Use Cases
The is used for the following is used to place orders in the Gardner system. This file will typically be automatically generated from the customer system to create a relatively handsoff solution for transferring orders from a customer system or website to Gardner. This file is loosely based on the Amazon order export format so some of the columns are required, but not used.
Schedule
The order should be uploaded to an ftp site provided by Gardner. Contact your sales representative for assistance setting up the ftp site.
Pickup/Delivery
Order files will be retrieved from the website every 30 minutes.
File Layout
The file should be delivered in csv format. Description of fields below:
[Order - Number] Varchar(33) This is the customer purchase order number.
[Amount - Order Shipping] Decimal This is the amount of the order (Column Required, but not Required)
[Date - Order Date] Date Date of the order
[Date - Paid Date] Date Date Paid (Column Required, but not used)
[Customer Email] Varchar(50) Customer Email
[Bill To - Name] Varchar(30) Name of the Billing Party
[Ship To - Phone] Varchar(30) Phone number of the ship-to party
[MFG Code] Varchar(3) Gardner Manufacturer Code
[SKU] Varchar(33) Manufacturer Item Number
[Parent SKU] Varchar(33) Manufacturer Item Number
[Item - Name] Varchar(33) Part Description
[Order Total] Varchar(33) Qty of Item to be ordered
[Service - Package Type] Varchar(33) Package type (Column Required, but not used)
[Ship To - Name] Varchar(33) Name of the Ship-to party
[Ship To - Address 1] Varchar(33) Address of the Ship-to party
[Ship To - Address 2] Varchar(33) Address of the Ship-to party
[Ship To - Address 3] Varchar(33) Address of the Ship-to party
[Ship To - City] Varchar(33) City of the Ship-to party
[Ship To - State] Varchar(33) State of the Ship-to party
[Ship To - Postal Code] Varchar(33) Postalcode of the ship-to party
[Ship To - Country] Varchar(33) Country of the ship-to party
Note:
Each line in the file represents a line item with an item and quantity. Orders will be broken up based on a change in ship-to address.