[intro] Before you begin, you need to ensure that you have created a Drop Down List Product Option manually by following the steps within this Guide. You then need to have exported your Products to a spreadsheet and deleted any rows that contain Products that you don’t want to add the Drop Down List to, but keep the rows containing the Products you want to add Options to, and your guideline Product where you've already added the Product Option manually.[/intro]
In this example, I’m going to add a Drop Down List Product Option to one of my existing Products. I have exported all of my Products to a spreadsheet and then deleted all of the Products I don’t want to add Product Options to from it. This is my test shop, so there’s only a handful of Products on it - you may want to add a Drop Down List to lots more!
Before I exported my spreadsheet, I created a Drop Down List Product Option on one Product (‘EKM Events’) using the steps in this Guide. I have not deleted this Product from my spreadsheet yet as I’ll be using this as a guideline and will delete it before I upload the spreadsheet back onto my EKM online shop.
1. The first thing you need to do is create an empty row beneath the Product that you want to add the Drop Down list to. You can do this by right-clicking on the far left-hand side and clicking Insert:
2. On the Product row for the Product you’re adding the Drop Down List to, amend the Action column to read ‘Edit Product’. If the Product has any Variants, be sure to amend these to 'Edit Product Variant':
3. Now you need to scroll to the right on your spreadsheet, until you find the columns OptionName, OptionSize, OptionType, OptionValidation, OptionItemName, OptionItemPriceExtra and OptionItemOrder, as these all list the various different details required for your Drop Down List:
OptionName
This is the name you have given to your Drop Down List.
OptionSize
This is the maximum number of characters which can be used when creating this Product Option.
OptionType
‘DROPDOWN’ is the kind of Product Option you’ve chosen.
OptionValidation
This area is blank as I did not enforce Option Validation on my Drop Down List. If I did want Option Validation, I would need to add ‘NotEmpty’ in the relevant cell for my Drop Down List.
OptionItemName
This is the name I’ve given to each of the Options a customer could choose, separated by a colon.
OptionItemPriceExtra
This is the price each choice is, in the order the choices are displayed, again, separated by a colon.
OptionItemOrder
This is the order that the different choices are displayed. ‘1’ is the first choice.
4. Your next step is to copy the contents of the Product Options cells for your guideline Product into the Add Product Option row, like this:
5. If you need to make any amendments to the Option to suit a different Product, make sure that you retain the format of that of your original guideline Product. When you have finished adding the Drop Down List to your other Products, you need to delete your guideline Product - both the Product, Product Variant (if there are any) and Product Option rows - and then copy the CategoryPath, ID and Name cells from the Edit Product row into those on your Add Product Option row:
6. This will attach the new Product Option to the Product. You now need to save your spreadsheet and upload it to your EKM online shop by following the steps in this Guide.
[caution]You cannot edit Product Options. You can only Add or Delete them using spreadsheets. If you wish to edit any aspect of an existing Product Option, you will need to duplicate the Product Option rows for the Product on your spreadsheet and copy these to the rows below. For the first instance of the Product Option, amend the Action column to read ‘Delete Product Option’, and then for the second copied version, amend this to ‘Add Product Option’ and change the details of the Product Option accordingly.[/caution]
[more]
- How to add Product Options using a spreadsheet
- How to add Product Options using a spreadsheet - Text Box
- How to add Product Options using a spreadsheet - Text Area
- How to add Product Options using a spreadsheet - Image
[/more]
[contact] If you need our help with your EKM online shop, contact your Ecommerce Expert or the Customer Support Team, who will be able to point you in the right direction. We're open from 8am-6pm weekdays and 9am-5.30pm 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 to ask the EKM Team, join us in the EKM Community. [/contact]