Vehicle Inventory Data Exchange Specification
OverviewCopied!
This document specifies the requirements for automotive inventory data exchange between AutoIPacket, LLC ("iPacket") and dealer partners. It covers data formats, file naming conventions, and transfer protocols needed for inventory integration.
CommunicationCopied!
Data transfer is handled via SFTP protocol. Inventory files should be uploaded according to your agreed schedule, typically daily or in real-time.
File FormatCopied!
- Format: CSV (comma-separated values)
- Filename:
VehInv_DealerCode.csv - Fields: Quoted text, first row contains headers
- Empty fields should be quoted ("")
Example:
"Dealer ID","Stock Number","VIN","Year","Make","Model" "123456","1A123","1HGCM82633A123456","2023","Honda","Accord"
Field SpecificationsCopied!
Each file contains data for one dealer in comma-delimited format. Data fields are quoted, comma-separated, with the first line containing headers, followed by data.
Empty fields still appear quoted but with no data.
Sample DataCopied!
"Dealer ID","Stock","VIN","Stock Type","Inventory Date","Year","Make","Model","Body Style" "123456","1A123","1HGCM82633A123456","N","20240315","2024","Honda","Accord","Sedan"
Field ListingCopied!
| # | Header Label | Description | Data Type (max length) | Required |
|---|---|---|---|---|
| 1 | Dealer ID | Dealer code | Alphanumeric (100) | Yes |
| 2 | Stock | Vehicle Stock Number | Alphanumeric (25) | Yes |
| 3 | VIN | VIN | Alphanumeric (17) | Yes |
| 4 | Stock Type | Vehicle Type (N=New, U=Used) | Alphanumeric (1) | Yes |
| 5 | Inventory Date | Date vehicle stocked | Date (YYYYMMDD) | Yes |
| 6 | Invoice Amount | Invoice amount | Numeric (9,2) | No |
| 7 | MSRP | Manufacturer's suggested retail price | Numeric (9,2) | No |
| 8 | Status | Inventory status | Numeric (1) | No |
| 9 | Certified | Certified pre-owned (Y/N) | Alpha (1) | No |
| 10 | Odometer | Current mileage | Numeric (11) | No |
| 11 | Year | Model year | Numeric (4) | Yes |
| 12 | Make | Vehicle make | Alphanumeric (15) | Yes |
| 13 | Model | Model name | Alphanumeric (35) | Yes |
| 14 | Body Style | Vehicle body style | Alphanumeric (50) | Yes |
| 15 | Exterior Color | Exterior color | Alphanumeric (55) | No |
| 16 | Interior Color | Interior color | Alphanumeric (55) | No |
| 17 | Model Code | Manufacturer's model code | Alphanumeric (35) | No |
| 18 | Trim | Trim level | Alphanumeric (300) | No |
| 19 | Drivetrain | Drivetrain (FWD/AWD/4WD) | Alphanumeric (20) | No |
| 20 | Engine Description | Engine description | Alphanumeric (100) | No |
| 21 | Transmission Desc. | Transmission description | Alphanumeric (75) | No |
| 22 | Internet Price | Internet selling price | Numeric (9,2) | No |
| 23 | Sale Price | Sale price | Numeric (9,2) | No |
| 24 | In Service | Date vehicle placed in service | Numeric (8) | No |
| 25 | Engine Cylinders | Number of cylinders | Numeric (2) | No |
| 26 | Description | Custom description | Alphanumeric (2500) | No |
| 27 | City MPG | Fuel mileage city | Numeric (4) | No |
| 28 | Highway MPG | Fuel mileage highway | Numeric (4) | No |
| 29 | Dealer Certification | Dealer certification type | Alphanumeric (50) | No |
| 30 | Image URL | Image URLs separated by " | " | Alphanumeric (64000) |
| 31 | Image Last Modified | Last updated datetime for images | Datetime | No |
| 32 | Video URL | Vehicle video URL | Alphanumeric (500) | No |
| 33 | Video Last Modified | Last updated datetime for video | Datetime | No |