Importing Vehicle Changes

Modified on Thu, 12 Oct 2023 at 01:52 PM

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 :-

 

clip0619

 

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. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article