Importing Large Key Orders by CSV
PLEASE NOTE - This feature is only available to our trade account customers. Find out more details about trade accounts here.
If you have a large list of different key codes to order, our new CSV upload feature makes light work of adding the codes and quantity. This simple guide details how to use the import feature.
- First, create your list of codes using a spreadsheet program, such as Microsoft Excel. Using the first 2 columns in your sheet - Column A for the KEY CODE and Column B are for the QUANTITY required of each code, start entering codes on Row 1. DON’T include any column headers/titles.
- Add all the key codes you need to the spreadsheet, ensuring there are no spaces in the key codes and each line has a key code and quantity. Please note: If you require a mixture of different types or series of keys, you will need a separate file for each or you can order them normally by manually entering the keycodes on the website if there is a small amount.
- Once your list of key codes is complete, the file needs to be saved in a CSV format. You can find this option when you select the dropdown menu on the ‘Save as type’ under your file name. Make sure the file type is CSV (Comma delimited) - don’t save as any other CSV option.
- Whilst signed in to your Trade Account, navigate to the product you need to order (you can use the search to get to the product quickly). Once you're inside the product page, you will have access to the ‘Upload a CSV’ button just above where you would manually enter the key number you want to order. Select your CSV file and import. The website will then populate the product page with your list of key codes (if you have a large list, please allow a little time for the codes to import).
- Then click the ‘add to basket’ button and continue the ordering and payment process as normal.
Please note that large files can take a while to upload to our system. Please bear with it and do not leave the page you are on until this process is complete.