[intro] Before you begin this guide, you should have completed at least one of the following Guides: Adding Products without Variants, Adding Products with Variants, Editing Existing Products with Variants, or Editing Existing Products. Ensure that if you are adding new Products to your EKM online shop you have removed any template products from your spreadsheet before saving it. 

When you have completed this Guide, you will have uploaded a spreadsheet to your EKM online shop. [/intro]

1. Log back into your EKM online shop and click Features on the left-hand menu:

2. Within your Installed Features, scroll down and click the icon to open the Import/Export System:

3. You need to select Import From File:

4. Click the Choose File button to select the spreadsheet you want to upload to your EKM online shop:

5. When you have selected the spreadsheet and can see the name of it displayed on the screen, click the green Upload button: 

6. When the spreadsheet has been uploaded onto the site, you should see it listed alongside the date of upload, file size and file type. You can click the dustbin symbol to delete the file from the system or press the blue arrow to download the file from your website. However, for the next phase of uploading, you need to click the File Name itself:

7. The system will then offer you three options: Test For Errors, Change Column Mappings and Start Import Process. ALWAYS test a spreadsheet for errors before importing it to your EKM online shop. This ensures that the spreadsheet is checked and will not potentially cause any serious issues when it has been imported:

8. When you test your spreadsheet for errors, any issues are highlighted in red within the large window. Click the down arrow symbol in the bottom right-hand corner to reveal what issues have been identified:

9. When the spreadsheet has been tested which can sometimes take a few moments depending on the number of products on it, click the Warnings and Errors bar below the large window to see the details of any problems the spreadsheet has. If there are any errors, these need to be rectified on your spreadsheet before uploading it to the site again and re-testing. If there are any references to ‘Unrecognised Header’, this is a guideline and not an error and can be ignored:

[remember]If there are any issues on your spreadsheet, not these down and then click Back on your browser to return you to the previous page. You will need to click the dustbin symbol to delete the spreadsheet from your EKM online shop, before returning to your copy of it and amending the issues that were highlighted. When you have amended those issues, save your spreadsheet, upload it and test it again. [/remember]

10. When the spreadsheet has been tested and no issues are reported, click the Start Import Process header to import the new products to your site:

11. When you have pressed Start Import Process, you will see this screen. Do not navigate away from it and simply leave the system to complete the task before clicking the Done button:



[contact] If you need our help with your EKM online shop, contact your Account Manager or Customer Support, who will be able to point you in the right direction. We're open from 8am-6pm weekdays and 9am-5.30pm on the weekends. If you'd like to suggest a feature or an upgrade on any of the EKM platforms, please let us know on the EKM Suggestions board. If you have a non-account specific question ask the EKM Team, join us in EKM Community.  [/contact]