• Submit a Request
  • Sign in
    • User Guides
    • Community Forum
    • Video Guides
    • Back to EKM
Sign In
Settings
Support Home

User Guides

Back

Designing your Shop

Building Your Shop

Marketing

Settings

Processing Orders

Back

Account General Domains Tax Cart & Checkout Delivery Payment Gateways

Back

Products Webpages Mobile Shop Features Partner Features Stax Import/Export

Back

Email Promoting SEO

Back

Theme Editing Images ekmTags

Back

Orders

Community Forum Video Guides
My Activities Back to EKM Submit a Request
  1. EKM Support Centre
  2. User Guides
  3. Import/Export
Related Articles

Related articles

  • Import/Export System - Adding Products without Variants
  • Bulk Uploading Images
  • Import/Export System - Editing Existing Products with Variants
  • Features - Product Attributes
  • Carousels

For more EKM news, tips and articles see the EKM blog.

Visit the Blog

Not what you're looking for? Open a new support ticket or view a request.

Submit a Request

Call us

0333 004 0333

Mon - Fri | 8:00am - 6:00pm

Email Us

support@ekm.com

Email | Mon - Sat

Import/Export System

Avatar Eve Bolan 05 February 2018 16:54

[intro]When you have completed this guide, you will have installed the Import/Export System feature, ready to edit existing Products or add completely new lines to your EKM online shop. Before you begin, you should understand how to use the EKM Edit Product window, bulk add Product Images, Product Variants, Attributes and have determined the Navigation within your EKM online shop. [/intro]

[summary]

  • Installing the Import/Export feature
  • Creating a Template spreadsheet

[/summary]

If you wish to add and edit products to your EKM online shop using spreadsheets, you need to install Import/Export System on the Features page. This feature is used to export lists of Products, Categories, lists of Product and Category Images, Customer Details and Orders onto spreadsheets. It can also be used to import data too, such as new Products and Categories and edits to existing Products.

Installing Import/Export

1. To install the Import/Export feature, log into your EKM online shop and click the Features tab:

ie1.PNG

2. Click the Import/Export System icon:

ie2.PNG

3. Click the green Install Feature button to add this feature to your EKM online shop:

ie3.PNG

Creating a template spreadsheet

When working with the Import/Export System feature, we recommend that you create a template spreadsheet first to work with. This involves exporting your Products to a spreadsheet and deleting all but one from the spreadsheet to use as an example.

If you are adding completely new Products to your EKM online shop, before you create your spreadsheet, manually add a Product first using the Edit Product window, which will become your Template Product. Ensure that this Product has all of the possible fields completed, including Price, Description, Name, Product Images, Product Code, Brand and any Custom Attributes that you would like to add to all of your other new Products.

If some of your new Products have Variants, such as different colours or sizes, ensure that your template Product has the same. The same goes for Product Codes, such as GTINs, MPNs or SKUs, and any other Product Attributes too. This ensures that when you create your spreadsheet, you can use this template Product as a guide for adding details to the rest of your new Products.

When you have completed this task, you need to bulk upload all of the Product Images for your other new Products to your File Manager - you can find out how to do this by clicking here. 

When the Product Images have been uploaded and the template Product has been created, you need to generate your spreadsheet.

[tips]Whilst it's not essential that you have used spreadsheets before to use the Import/Export System, it is worth discovering which program you will be using on your computer to open and edit your spreadsheets, and locating the Find/Replace tool. This handy bit of functionality will save you lots of time when you are editing the data on your spreadsheets! [/tips]

1. Click Export to File:

ExporttoFile.PNG

2. Then click Export Products:

Export5.png

3. Keep the box ticked for All Products and click Continue:

Export6.png

4. Leave all of the checkboxes on this page ticked and click Continue To Choose Download Type:

Export7.png

5. If you have less than 1000 products to edit or bulk add to your website, select a CSV file. If you have more products than this, select an XLXS file:

Export8.png

6. Click the link to download the template spreadsheet. You’ll then see this message:

ie9.PNG

7. Click the link provided to download your spreadsheet and then choose from the following guides:

  • Adding new Products without Variants 
  • Adding new Products with Variants
  • Editing Existing Products 
  • Editing Existing Products with Variants

[more]

  • Claiming your free EKM domain name
  • Adding an SSL Certificate to your EKM online shop
  • Purchasing an email address on EKM Domains
  • Submitting your EKM online shop to Google
  • Social Plugins

[/more]

[contact]If you are still struggling with your spreadsheet, get in contact with us so we can help you! Your Account Manager will be able to edit and upload your spreadsheet for you, whilst the Customer Support Team can talk you through the steps required to complete the task yourself. We're open from 8am-6pm weekdays and 9am-5.30pm on the weekends.[/contact]

Was this article helpful?
0 out of 0 found this helpful

Want advice or to ask a specific question? Reach out to our community

Connect with us

Tweet your question to @ekm_uk and Follow us for service announcements.

© 2002 - Ekm Systems Ltd