How to export auction lots and/or results from GAP

This will explain how to export your auction lots and/or results from GAP (Global Auction Platform) into a CSV file so that you can import them into your website you have hosted with us.

Please note these instructions are correct at the time of writing (Jan 2018), and may be subject to change if GAP change the layout of their system.

Exporting lots vs auction results

The process for exporting lots is the same as exporting results. When an auction hasn't finished, the CSV export doesn't contain the hammer price, but once the auction has finished then it does. The process for exporting the lots originally or subsequently exporting the auction results in the same.

Please ensure that if a lot doesn't sell that the hammer price is entered as 0.

Step 1) Log into GAP

GAP will provide you with a web address, username and password to login (we don't have these details)

Step 2) On the home screen of GAP, click on the "View all Auctions" button

This is highlighted in the screenshot below.

Step 3) Click on the "Edit" button to the left of the auction you want to export lots for

This is highlighted in the screenshot below.

Step 4) Click on the "Lots" menu on the purple toolbar at the top

This is highlighted in the screenshot below.

Step 5) Click on the "Export to CSV" button

This should be on the left hand side of the page, and is a fair way down the page so you might need to scroll down.

This is highlighted in the screenshot below.

Step 6) Save the CSV file

When you press the "Export to CSV" button you should be prompted to save a file. Save this file to your computer.

Step 7) Verify you have the following columns in the spreadsheet:-

If you open up the CSV in Excel, you'll see there are column headers at the top. Make sure you have these column headers, with the names written exactly as below:-

For initial upload of lots:-

Lot Number
Lot Description
Estimate From
Estimate To
Reserve

For auction results:-

Lot Number
Status (eg "Sold" / "Not Sold")
Hammer

Missing columns, or invalid column data, will result in the upload failing so check your spreadsheet before uploading.

Step 8) Upload the CSV to your website using the website manager

Using the website manager provided with one of our websites, upload the CSV to the appropriate area. This may vary from website to website but will be indicated in the instructions and prompts inside the website manager.

If you would like a website which can integrate with GAP, Easy Live Auction, Bidmaster or PACTS, please contact us