[intro]Before you begin this Guide, it is essential that you have installed the Import/Export System which will enable you to export all of your Product information onto a spreadsheet in order to delete and edit existing Products from your EKM online shop. [/intro]
[summary]
[/summary]
In this Guide, you’ll learn how to edit and delete Variants from a Product using a spreadsheet. If you wish to make a structural change to existing Product Variants, such as changing the name, adding additional Variants or deleting excess Variants, this Guide will take you through the steps required.
[remember]In terms of editing Product Variants, if you simply wish to add information onto existing Variants - such as adding Weight, Brand and Custom Attributes for example - this Guide is not necessary, the linked Guides are what you need to follow instead. This Guide is primarily concerned with making structural changes to the Variants, such as changing the Variant Name, and adding new or deleting existing Variants. [/remember]
Exporting your Products to a spreadsheet
1. Log into your EKM online shop as normal, and click the Features tab:
2. On the Features page, click Import/Export System:
3. Click Export To File:
4. Click Export Products:
5. Click Continue to Choose Fields:
6. Click Continue To Choose Download Type:
7. The download type you select depends on the number of Products you have on your EKM online shop. If you have 1000 or less Products, select a CSV File. If you have more than this, you may want to choose an XLSX File instead. Click the relevant green button for the file type you need:
8. Click the blue text to download your file:
The file will be visible in the bottom of your browser window and will automatically be added to the Downloads folder on your computer. Open the file to begin the process of editing and deleting your Product Variants.
9. When you have opened the file, you should have a spreadsheet which looks something like this:
[warning] Before you continue, you need to delete any rows that include Products and Product Variants that you DON’T want to work on, leaving only the Products and Product Variants that you want to edit or delete from your EKM online shop. [/warning]
Editing Product Variants
Edits that require structural changes to existing Product Variants on your EKM online shop require the deletion of the original Product and any attached Variants firstly, and then on the same spreadsheet, the Product and it’s Variants need to be duplicated but this time, they need to include the changes that you wish to make and are added as entirely new Products and Variants.
Copying the original Product and Product Variants
10. Before you edit the existing Product and its Variants, you need to copy it on the spreadsheet. To do this, highlight the rows that include the Product and its Variants:
11. Right-click the highlighted rows and select Copy from the drop-down menu:
12. Right-click in the first empty row of the first column and select Paste from the drop-down menu to paste in the data:
13. This now gives you two copies of the original Product. Your next step is to edit the cells in the Action column that correspond to the original Product, by adding the word ‘Delete’ before the word ‘Product’, like this:
14. This action tells the systems to delete the original version of the Product and it’s Variants, which in my example, are on rows 2 to 5. Rows 6 to 9 hold the version of the Product and it’s Variants that we need to edit:
15. To prepare the copied Product and it’s Variants for editing, we need to amend the command in the Action column, adding the word ‘Add’ before the word ‘Product’, like this:
16. In the ID column, you then need to delete the numbers for the new Product, which in my example is everything on rows 6 to 9:
17. Repeat this process for the Image1, Image2, Image3, Image4 and Image5 columns:
18. Repeat this process again for the WebAddress column:
Now you are ready to perform the actual edits to the Product and its Variants. Select from the choices below:
Changing the Variant Names
1. If you wish to change the names of the Variants, simply scroll along your spreadsheet until you locate the Variant Names column, and amend the names there:
2. After amending the names, you need to save your spreadsheet by clicking the File button in the top left-hand corner as normal:
3. You then need to follow this Guide to upload the spreadsheet onto your EKM online shop.
Deleting Product Variants from an existing Product
1. If you wish to delete all of the Variants from the Product, simply delete all of the Variant rows, leaving just the ‘Add Product’ row. In my example, this is completely deleting the content of rows 7 to 9. You can do this by highlighting the rows and then right-clicking them, before selecting ‘Delete from the drop-down menu:
2. After deleting the Variants, you need to save your spreadsheet by clicking the File button in the top left-hand corner as normal:
3. You then need to follow this Guide to upload the spreadsheet onto your EKM online shop.
Deleting excess Variants from an existing Product
1. If you wish to delete any additional Variants from the Product, you can do this by highlighting the rows containing the additional Variants and then right-clicking them, before selecting ‘Delete from the drop-down menu:
2. After deleting the excess Variants, you need to save your spreadsheet by clicking the File button in the top left-hand corner as normal:
3. You then need to follow this Guide to upload the spreadsheet onto your EKM online shop.
Adding additional Variants to an existing Product
1. If you want to add additional Variants to the Product, then use the empty cells beneath the existing Variants to add in the information, using the existing Variants listed above as a guideline when adding in the details:
[remember] Don’t forget to add in information for your new Variants using all of the populated columns on the spreadsheet for the existing Variants. You will also need to upload the Product Images for the new Variants into the File Manager using this Guide to ensure that your new Variants have images attached to them. [/remember]
2. After adding the extra Variants, you need to save your spreadsheet by clicking the File button in the top left-hand corner as normal:
3. You then need to follow this Guide to upload the spreadsheet onto your EKM online shop.
[more]
- Uploading your spreadsheet onto your EKM online shop
- How to add Product Codes onto existing Products
- How to add Weight to existing Products
[/more]
[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]