It is possible to prepare a spreadsheet file of vehicles updated to the system and import in one go. This is useful for example when bulk changing the sale prices of vehicles in stock. They can simply be imported rather than keyed in manually.
The first step is to format the spreadsheet file. The spreadsheet should have column headings in row 1 which contain some or all of the following (the mandatory ones are red):-
Field Name |
Description |
Example |
Stock |
Vehicle Stock No |
123 |
Make |
Make of Vehicle |
Ford |
Model |
Model of Vehicle |
Focus |
Reg |
Registration No |
AB12DEF |
Colour |
Colour |
RED |
Mileage |
Mileage |
12345 |
RegDate |
Registration Date |
01/02/14 |
Type |
Type of Vehicle (Car, Commercial) |
Car |
Retail |
Retail Price |
10000.00 |
WebPrice |
Web Price |
9750.00 |
PreviousPrice |
Previously advertised privce |
9850.00 |
GuideRetailprice |
Suggested Retail Guide Price |
10250.00 |
ChassisNo |
Chassis No |
SFAXX112415315366676 |
EngineNo |
Engine No |
1345112215 |
Trim |
Trim |
Leather |
ManufacturerOrderCode |
Manufacturers Order No |
C12345 |
OrderStatus |
Manufacturers Order Status |
In Transit |
KeyTagNo |
Key Tag No |
132 |
AdvertisingText |
Advertising Text (for web site) |
One Owner, Full Service History, Leather, Air Con, Cruise Control |
AdvertiseOnWeb |
Advertise on Web Site Exports (1=Yes, 0=No) |
1 |
AvailableForSale |
Is car Available for Sale (1/0) |
1 |
Location |
Location of Vehicle |
On display |
IgnitionKeyNo |
Ignition Key No |
312442 |
ImmobiliserCode |
Immobiliser Code |
1234 |
AlarmCode |
Alarm Code |
2314 |
DoorKey |
Door Key No |
23422 |
BootKey |
Boot Key No |
234 |
RadioCode |
Radio Code |
3333 |
CDCode |
Cd Player Code |
3335 |
TelephoneCode |
Telephone Code |
8888 |
EtchCode |
Etch Code |
989880890 |
AudioSerialNumber |
Audio Serial No |
79877 |
EstimatedPrepCosts |
Estimated Preparation Cost |
500.00 |
PreparedForSale |
Prepared for Sale (1/0)_ |
1 |
UserDefinedData |
||
NoOfPreviousOwners |
No of Previous Owners |
2 |
AttentionGrabberShort |
Short Headline used on some web exports |
Full Service history |
AttentionGrabberLong |
Long Headline used on some web exports |
Full Service History - One Owner Car |
SubHeadline |
Sub Headline used on some web exports |
Leather |
VideoUrl |
Link to online video of the vehicle |
http://www.youtube.com/4363ege5 |
PreparationStatus |
Preparation Status (offset - 1,2,3 etc) |
1 |
ImageStatus |
Image Status (offset - 1,2,3 etc) |
2 |
AdvertisingCategory |
Advertising Category (offset 1,2,3) |
4 |
ManagersComments |
Managers Comments used on some web exports |
Unique car with high specification - reduced Price |
Options |
List of Options used on some web exports |
Leather, Cruise Control, Air Conditioning, Electric Windows |
FeatureUpgrade |
List of additional Non standard features - used on some web exports |
Bose Stereo |
Origin |
Origin of the Vehicle eg UK, Import |
UK |
ServiceHistory |
Full Service History (1/0) used on some web exports |
1 |
SpecialOffer |
Special Offer flag (1/0) used on some web exports |
0 |
DeliveryCostIncluded |
Cost of Delivery included - used on some web exports |
0 |
ExDemo |
Ex Demo Vehicle Flag (1/0) used on some web exports |
0 |
TaxIncluded |
Road Tax Included (1/0) used on some web exports |
0 |
HPICheck |
HPI Checked (1/0) used on some web exports |
1 |
FranchiseApproved |
Franchise Approved Vehicle (1/0) used on some web exports |
1 |
HasV5 |
V5 Available flag (1/0) used on some web exports |
1 |
RegFeeIncluded |
First Registration Fee Included (1/0) used on some web exports |
0 |
DealerApproved |
Dealer Approved Vehicle (1/0) used on some web exports |
1 |
PreRegistered |
Pre Registered new vehicle (1/0) used on some web exports |
0 |
CarDataCheck |
Car Data Check carried out (1/0) used on some web exports |
0 |
Comment |
Comment - used on some web sites |
Ford Focus, Full Service History in Leather with advanced Climate Control |
SourceOfSupply |
The source of supply of the vehicle - this can be a supplier or a location as needed |
Auction |
To import the file, on the Vehicle Administration toolkit click on the Update Vehicles Button on the Import/Export Menu Tab :-
This will prompt for the file to import and will then import the file updating stock records for the vehicles in it. Any errors will be reported on screen.