Uploading Vehicles to Websites

 

Vehicles currently can be uploaded to Car Sales (Autogate) and Dealer Solutions

 

These uploads can be scheduled to run daily (multiple times) and can also be run manually at any time.  However, although the website host will receive the uploaded file immediately, whether the changes made will be applied immediately is dependent on the website provider. 

 

The selection criteria for used vehicles can be determined by various parameters and combinations thereof.  Contact a consultant if you would like these changed.

 

Progress Codes 

A/C statuses

Locations (physical or selling)

Franchises

Previous Usages

Minimum Kilometres

Exclude 0 sell price

Available Date (Number of letters sent date – figure below)

 

 

The extracts can also be setup to include New & Demo vehicles.  

These can be controlled by Progress code & Sale type on the Sales Brief tab.

 

Other parameters available to be set:

New Vehicles – don’t upload Memo / Notes field

 

Selling Price (Retail) 

For Used vehicles, This is the Gross Sales Value (Specification Tab) or this is overidden by  Internet Selling Price field on the Purchase Brief tab if populated


For New vehicles the this is the Gross Sales Value (Specification Tab) or this is overridden by  Internet selling price on in the Vehicle menu under More Details

 

 

 

Notes can be entered into the Features box on the Identity tab for Used vehicles to upload to websites and the Memo/notes field for New vehicles.

 

In addition there are an additional 1000 characters that can be made available for both New & Used vehicles, however these require an additional module to be added to the system and therefore incurs a one-off setup fee (CV Module).   This then makes the Supplier Notes box available, selected by right clicking on the Vehicle price (selling price) spec line:

 

suppnotes.JPG

 

 


 

In addition vehicle options can also be ticked to send to the web.

 

These options can be defined in Vehicle administration / Vehicle Menu / Tick Sheet.

 

 

Also specification line descriptions will also be sent unless excluded in parameter EXCLVSPC

 

 

Certain Previous usage types for Used vehicles can be configured to be either included (Identity tab):

 

 

Certain Physical Locations can also be selected.

An email address can be specified so that a copy of the uploaded text / csv file is emailed to a recipient.   (the photos are not emailed as too large)

 

The extract can be set to access multiple VSB companies and combine into one file for upload.

 

Run the Web Extract Program

 

 

Select the required extract from the Vehicle Stockbooks menu:

 

 

 

You can alter the Last download date – this is used to determine which vehicles’ photos are uploaded.   Only vehicles which have been added / modified since the last download will have their photos re-uploaded.

 

Click the Upload button.

 

This will process the extract.


 

 

When the Vehicle transfer complete pop-up is displayed the process is complete.  

 

Click OK.

 

 

To Add Photos for Autoline Extracts

 

 

Save the photos on your PC into the C:\rev8work directory.

 

Go to Vehicle administration, choose Amend.

 

On the Definition tab click the ellipsis next to Picture.

 

Select Manage pictures.

 

Select the Picture name in the left pane (Pictures on PC):

 

 

Then click the Transfer button. 

 

Note: Do not name the photos beginning with the stock number – precede the name with a letter N or U.


 

 

Click the Picture name in the right pane (Pictures on Server): 

 

 

Then click the Assign picture(s) to vehicle button.

 

This will copy the image and rename it XXXXXX-NNN.jpg, where XXXXXX = stock number and NNN = picture number.

 

Click Close when complete – then Save the vehicle.

 

Note:  To be able to use the Delete option, an access level of 8 or higher is required.

 

 

Running the extract.

 

The extract can be run manually from the VSB menu at any time.   It can also be added to the timed operations menu to run automatically once or multiple times per day.

 

This is covered in the setup manual.

 

When running the extract manually, the email to field can be overwritten with a different email address for this particular time. 

 

No Photos can be ticked so the extract will run considerably quicker.

 

All Photos can be ticked so all photos for all vehicles being uploaded are sent – not just those vehicles added / modified since the last extract was run.

 

 

 

 

 

 

 

The parameters are accessible through Country Specific / AK / Vehicle Stockbook / Vehicle Extract Parameters 

 

 

NameFIELDValueDescription
Extract codeCODEKWDExtract Code (to be used when creating the Menu in VSB)
FTP IP AddressFTPIPADRftp5.carsales.com.au:2222FTP Address
FTP Login IDFTPLOGINxxxxxxxxxFTP Login
FTP PasswordFTPPASSWxxxxxxxxxFTP Password
Last run dateLASTRUND30/11/2014System populated
Last run numberLASTRUNN4System populated
Local directoryLOCALDIR

FTP DirectoryFTPDIR
Specific Directory if required on FTP site
Host nameHOSTNAME
Not Required
DescriptionDESCTest Upload CarsalesDescription for own identification
Dealer codeDLRCODE14510Dealer Code (Supplied by upload site)
Valid Progress codesVLDPROGCZValid Progress Codes for Used Vehicles
Valid AC status codeVLDACSTAAValid Account Status Codes for Used Vehicles
Valid Demo ProgressVLDDPROGDSValid Demo Progress Codes (New Stock)
Valid locations_1VLDLOCNSMANValid Location to select (type defined in USELOCN field )
Valid locations_2VLDLOCNS
Valid Location to select
Valid locations_3VLDLOCNS
Valid Location to select
Valid locations_4VLDLOCNS
Valid Location to select
Valid locations_5VLDLOCNS
Valid Location to select
Valid locations_6VLDLOCNS
Valid Location to select
Valid locations_7VLDLOCNS
Valid Location to select
Valid locations_8VLDLOCNS
Valid Location to select
Valid locations_9VLDLOCNS
Valid Location to select
Valid locations_10VLDLOCNS
Valid Location to select
Multi runs per day?MULTIRUNYSystem populated
Only use Available?USEAVAIL
Set to "Y" if letters sate being used
Valid franchisesVLDFRANSBList of valid franchise letters (blank = all)
Manual last runMANLASTR01/12/2014System populated
PRUSAGE to includePRUSAGE
Previous usage codes to include (used vehicles) (blank = all)
Export data typeEXPTTYPE
System populated
Signature class codeSIGCODES
Not Used in AU
SBT class codesSBTCODES
Not Used in AU
Lexus Cert PreownedLCPOCDES
Not Used in AU
Valid demo sale typeVLDDSALE
Valid Demo Sale Type (new stock)
FTP ping delayFTPPINGD0FTP timeout settings
FTP total time outFTPTOTTO50FTP timeout settings
FTP xfer time outFTPXFRTO50FTP timeout settings
Verify ftp transferFTPVERFYNWhether to verify the FTP Upload.
No notes for demosNODEMNOTYExclude the Notes field from uploading on new stock
SHIPNO for N retailSHIPNO
Not Used in AU
Output .txt onlyTEXTONLYYHave the extract created with a .txt extension
Text only incl photoTEXTPHOTYAlso send photos with the above .txt upload
Next vswww codeNEXTCODE
Used to enter another extract code to have them joined together
VSB companyVSBCO
VSB company of the next code to be joined together
Export to local dirEXPRTLOC
Not Used in AU
Local export dirEXPRTDIR
Not Used in AU
Allow vehicle renew?RENEWVEH
Not Used in AU
Suppress Model Col ENOMODEL
Suppress the upload of the Model Column ( E )
Secure FTP?SECFTPYFor Secure FTP sending of files
Site IDSITEID
Site ID variable for manipulating filename
Location IDLOCNID
Site Location variable for manipulating filename
Filename formatFILEFRMT
Filename Format variable for manipulating filename
ID field formatIDFORMAT
ID variable for manipulating filename
Picture files formatPICSFRMT
Picture files format
Email file toEMAILTOsystimesupport@systime.co.nzEmail address to have the csv / txt file emailed to each time the extract is performed
CSV field seperatorSEP
The field separator in the file created (blank = comma)
Exclude 0 Sell PriceEXC0SELLNY = exclude those with no sell price set
Minimum KilometersMINKMS0Minimum number of recorded kilometres before vehicle will be selected
Veh Desc sourceVDESCSRCPGVOrder of source for obtaining the vehicle description - P - Police Book, G - , V - VSB desc field
Last target for BMW_1LASTTAR0Not Used in AU
Last target for BMW_2LASTTAR0Not Used in AU
Last target for BMW_3LASTTAR0Not Used in AU
Exclude vspec optionEXCLVSPCCTP|Reg|Stamp|PDI|Matsvspec options not to be selected and added into the options column
ORC code (Reg/Trfr)ORCCODEREGOTRANOn road cost vspec options to be removed from the selling price to calculate the excl ORC field on some websites
File extensionEXTENSNcsvThe file extension to use.
Location to useUSELOCNSWhether to look at S - Selling location or blank = Physical Location.
New/Used ?NU
N or U - Blank select Both
Modal Analysis Codes_1MODANAL

Modal Analysis Codes_2MODANAL

Modal Analysis Codes_3MODANAL

Modal Analysis Codes_4MODANAL

Modal Analysis Codes_5MODANAL

Modal Analysis Codes_6MODANAL

Modal Analysis Codes_7MODANAL

Modal Analysis Codes_8MODANAL

Modal Analysis Codes_9MODANAL

Modal Analysis Codes_10MODANAL

Extract MODANAL?DISPMOD
Y/N To extract the Model Analysis field to last column
Valid New Prog codesVLDNPROGCValid New Progress Codes (New Stock)
Valid new sale typesVLDNSALE
Valid New Sales Types (New Stock)



Troubleshooting

 

1)    Vehicle is not on the internet, run the extract and enter your email address to ensure the vehicle is being selected.

 

2)    Vehicle is not selected.

Ensure the VIN is 17 characters long.

Check the A/C Status / progress code / sale type / locations are valid for selection according to parameters.

 

3)    Website is not updating – call site and check if they are receiving the file.

Try making an FTP connection from your PC or server using the details in the parameters.