What is Data Import/Export?

Import/Export Requirements | Import/Export Examples

The Data Import Wizard is designed to load data into the Inventory, derived from external sources – other providers, dealers, etc. Data source – a normal text file separated, or a data file in xml format.

This Data Import Wizard can send your inventory to the Top online automotive marketplace sites, these are listed below:

Import/Export Requirements (AX10)

Import supports a data file, separated by commas (csv). This format must use the UTF-8 text encoding.

Table – displays the CSV field structure sample which must include field heading and data must be separated with a comma “,” and quotations ( ” ) for each field.

NumField NameValue TypeDescription
1stockStringStock number defined by dealer (can be same as the VIN)
2titleStringTitle of the vehicle (New, Used, Certified Pre-Owned, Other)*
3vinString(17)Vehicle Identification Number (17 characters)
4yearInteger(4)Year the vehicle was manufactured (for example: 1984)
5makeStringManufacturer of the vehicle
6modelStringModel of vehicle
7trimStringSpecific trim of the model
8free_textStringText added by the dealer to show specific details
9typeStringType of vehicle (AGRICULTURAL EQUIPMENT, AIRCRAFT, ATVs, BOAT, CARS & TRUCKS & VANS, COMMERCIAL

TRUCKS & TRAILERS & BUSES, CONSTRUCTION EQUIPMENT, DISMANTLED MACHINE, GO KARTS & SCOOTERS, MILITARY VEHICLES,


MOTORCYCLE, OTHER, PWC/ATV, RVs & CAMPERS, SAVING PLANS (CARS), SNOWMOBILES, TRAILERS)

10bodyStringBody style of vehicle (Convertible, Coupe, Hatchback, Limousine, Minivan, Other, Pickup, Sedan, Sport Utility, Suv, Truck, Van, Wagon)
11mileageIntegerOdometer value
12price_currentIntegerCurrent price of car
13price_wholesaleIntegerPrice charged to wholesalers who buy large quantities for resale
14price_costIntegerThe price a dealer paid for the vehicle
15InternetPriceIntegerInternet price of the vehicle
16MSRPIntegerManufacturer Suggested Retail Price
17BookValueIntegerThe value is based on the original cost of the vehicle without depreciation, amortization or impairment costs made against the vehicle.
18exteriorStringExterior color of vehicle
19interiorStringInterior color of vehicle
20doorsIntegerNumber of doors
21engineStringType of engine
22transmissionStringType of transmission
23drive_typeStringDriving wheels of the vehicle
24fuel_typeStringFuel Type (Gasoline, Diesel, Hybrid, etc.)
25warrantyIntegerVehicle warranty, 1 – if warranty exists, 0 – if none
26warranty_descriptionStringWarranty Text
27descriptionStringDescription of the vehicle
28picsStringURL of the photos for the vehicle
29conditionStringCondition of vehicle (Excellent, Good, Average, Poor, Undefined)
30optionsStringVehicle options, separated by a comma
31URL_YouTubeStringYou Tube video URL
32URL_MASStringMake-a-Show video URL (export only)
33date_in_stockStringThe date on which the vehicle was uploaded into the inventory
34DealerNameStringDealer’s name
35DealerContactPersonStringDealer’s contact person
36DealerPhoneStringDealer’s contact phone number
37DealerEmailStringDealer’s e-mail
38DealerAddressStringDealer’s address
39DealerCityStringDealer’s address (City)
40DealerStateStringDealer’s address (State)
41DealerZIPIntegerDealer’s address (ZIP code)
42DealerCountryStringDealer’s address (Country)
43DealerIDStringThe ID of the dealer
44DealerLOTStringDealer’s LOT
45DealerGroupStringDealer’s Group
46CertifiedIntegerWhether the vehicle is certified or not (1 / 0)
47CategorizedOptionsStringVehicle options with categories; a category is separated from an option by @ and options separated by a comma (Exterior@Black, Interior@Leather)
48MarketClassStringe.g. 2WD Small Pickup Trucks / 4wd Sport Utility Vehicle
49User_price1IntegerUser’s (Special) Price of the vehicle
50User_price2IntegerUser’s (Special) Price of the vehicle
51User_price3IntegerUser’s (Special) Price of the vehicle
52Comment1StringA comment regarding the vehicle
53Comment2StringA comment regarding the vehicle
54Comment3StringA comment regarding the vehicle
55VIDEO_URL_1StringURL of a custom movie
56VIDEO_URL_2StringURL of a custom movie
57VIDEO_URL_3StringURL of a custom movie
58VehicleIDIntegerThe ID of the vehicle
59DetailURLStringThe URL of the details page of the vehicle
60price_monthlyStringMonthly payment
61mm_codeStringM&M code (South Africa only)
62license_plateStringPlate Number
63sub_categoryStringSub Category (TRUCK&TRAILER)
64engine_makeStringEngine Make: GMC; Detroit; Duramax etc. (TRUCK&TRAILER; RVs & CAMPERS)
65engine_powerStringHorse Power (TRUCK&TRAILER; MOTORCYCLE)
66brake_typeStringType of breakes (TRUCK&TRAILER)
67truck_statusStringStatus of the Truck: Available (TRUCK&TRAILER)
68trailer_statusStringStatus of the Trailer: Available (TRUCK&TRAILER)
69status_detailsStringStatus details (TRUCK&TRAILER)
70over_driveBooleanOverdrive: 0;1 (TRUCK&TRAILER)
71suspensionStringSuspension Type (TRUCK&TRAILER)
72ratioStringRatio (TRUCK&TRAILER)
73tiresStringTires (TRUCK&TRAILER)
74wheelsStringWheels Type: All Steel; Aluminum Outside; All Aluminum; Steel Disc etc. (TRUCK&TRAILER)
75wheel_baseStringWheel Base: 132; 134 etc.(TRUCK&TRAILER)
76AxlesStringAxles: Single; Tandem; Quad etc. (TRUCK&TRAILER)
77axle_typeStringAxle Type (TRUCK&TRAILER)
78spread_axleStringSpread Axle (TRUCK&TRAILER)
79front_axleStringFront Axle: 9000; 12000 (TRUCK&TRAILER)
80rear_axleStringRear Axle: 20000; 21000 (TRUCK&TRAILER)
81internal_heightStringInternal Height (TRUCK&TRAILER)
82heightStringTruck height (TRUCK&TRAILER; RVs & CAMPERS)
83lengthStringTruck length (TRUCK&TRAILER; RVs & CAMPERS)
84widthStringTruck width (TRUCK&TRAILER; RVs & CAMPERS)
85sleeper_typeStringType of the sleeper (TRUCK&TRAILER)
86insulatedStringInsulted: Yes/ No (TRUCK&TRAILER)
87passengersStringNumber of passengers (TRUCK&TRAILER)
88sleepsStringNumber of sleeps (TRUCK&TRAILER; RVs & CAMPERS)
89doors_descriptionStringDoors type: Swing; Roll up etc. (TRUCK&TRAILER)
90side_doorsStringSide Doors type: Curbside etc. (TRUCK&TRAILER)
91gateStringGate: Yes/ No (TRUCK&TRAILER)
92dump_locationStringDump Location (TRUCK&TRAILER)
93flatbedStringFlatbed (TRUCK&TRAILER)
94cabStringCab type: Standard Cab; Crew Cab etc. (TRUCK&TRAILER)
95compositionStringComposition: Aluminum; Steel etc. (TRUCK&TRAILER)
96tank_typeStringTank Type (TRUCK&TRAILER)
97floorStringFloor type: Aluminum Floor etc. (TRUCK&TRAILER)
98extendableStringExtendable (TRUCK&TRAILER)
99detachableStringDetachable (TRUCK&TRAILER)
100bottom_loadStringBottom Load (TRUCK&TRAILER)
101frameStringFrame Type (TRUCK&TRAILER)
102compartmentsStringCompartments (TRUCK&TRAILER)
103pneumatic_sizeStringPneumatic Size (TRUCK&TRAILER)
104vapor_recoverStringVapor Recover (TRUCK&TRAILER)
105hoppersStringHoppers (TRUCK&TRAILER)
106gallonsStringGallons Capacity (TRUCK&TRAILER)
107reefer_manufacturerStringReefer Manufacturer: Thermo King etc. (TRUCK&TRAILER)
108carsStringCars (TRUCK&TRAILER)
109ballastStringBallast (TRUCK&TRAILER)
110payloadStringPayload (TRUCK&TRAILER)
111steeringStringSteering (TRUCK&TRAILER; RVs & CAMPERS)
112sizeStringSize (TRUCK&TRAILER)
113safety_chainsStringSafety Chains (TRUCK&TRAILER)
114couplerStringCoupler (TRUCK&TRAILER)
115tongueStringTongue (TRUCK&TRAILER)
116deck_widthStringDeck Width (TRUCK&TRAILER)
117deck_heightStringDeck Height (TRUCK&TRAILER)
118rampsStringRamps (TRUCK&TRAILER)
119fendersStringFenders (TRUCK&TRAILER)
120chargerStringCharger (TRUCK&TRAILER)
121type_of_motorStringType of Motor (MOTORCYCLE)
122air_conditionersStringNumber of Air Conditioners (RVs & CAMPERS)
123slidesStringSlides (RVs & CAMPERS)
124water_capacityStringWater Capacity (RVs & CAMPERS)
125awningsStringAwnings (RVs & CAMPERS)
126gvwrStringGVWR (RVs & CAMPERS)
127dry_weightStringDry Weight (RVs & CAMPERS)
128chassisStringChassis (RVs & CAMPERS)
129jackStringJack (RVs & CAMPERS)
130self_containedStringSelf Contained (RVs & CAMPERS)
131generatorStringGenerator (RVs & CAMPERS)
132price_headerStringHeader Price (RVs & CAMPERS)

*Title (New, Used, Certified Pre-Owned, Other)

Incoming in the feedTreated as
N or NEWNEW
U or USEDUSED
SALVAGESALVAGE
Any containing "CPO" or "CERTIFIED"CERTIFIED PRE-OWNED
"", "NO", and ANYTHING ELSEUSED
Numeric "0"NEW
Numeric "1"USED
Numeric "2"CERTIFIED PRE-OWNED
Numeric "3"SALVAGE

Import/Export Manuals And Examples

You can download an example of importing data files here:

CSV format options:

  • Data Separator – , (comma)
  • End of Line – Unix-style line-endings: LF (Line Feed, 0A – hexadecimal) or Windows-style line-endings: CRLF (Carriage Return Line Feed characters, 0D0A -hexadecimal). Please DO NOT use Mac-style line-endings (CR)
  • Field Separators – ” (quotation mark)
  • Image Separator – ; (semicolon)
  • Option Separator – , (comma)

Important! XML file requirements:

  1. XML file must have only 2 levels and be well-formed;
  2. XML file must have a title
  3. The file should begin with tag <vehicles> (in plural) and end with </vehicles> (in plural);
  4. Every vehicle should be set between 2 tags: <vehicle></vehicle> (in singular);
  5. If there is no info in the tag, it should stay empty (never delete it). Ex.: <engine></engine> or <engine />
  6. All images should be included in one line, delimited with semicolon;
  7. The field order for each vehicle must be constant.
Your message has been received.
An engaged representative will contact you shortly.
Thank you.
OK