[intro]Before you begin this Guide, you must install the Promo Stickers feature and read the accompanying Guide, especially if you wish to use your own custom Promo Stickers where you need to be aware of the image names to add them to several Products at once.[/intro]

In this Guide, you’ll learn how to add Promo Stickers to the Products on your EKM online shop in bulk by using a spreadsheet generated by the Import/Export System feature. This is especially useful for giving a visual indicator to sales, and you can remove the Promo Stickers after the promotion has ended by downloading a spreadsheet, deleting the data in the PromoStickers column and uploading the spreadsheet back onto your EKM online shop.

1. When you have opened the file, you should have a spreadsheet which looks something like this:

The first thing you need to do to the spreadsheet is to add the ‘Edit’ command so that when you upload the file back to your EKM online shop, the system knows that some extra details have been added to an existing Product.

2. Click the A column to highlight it, and then click the Find & Select icon on the top right-hand corner:

3. In the drop-down menu, select Replace:


4. In the window that appears, add the word ‘Product’ in the Find What field and the words ‘Edit Product’ in the Replace With field, before clicking the Replace All button:

This action will amend the ‘Product’ and ‘Product Variant’ rows to read ‘Edit Product’ and ‘Edit Product Variant’ accordingly. When you upload your spreadsheet onto your EKM online shop, the system will be aware that some of the data for the Products has been amended.

Adding the Promo Stickers

Your next step - to make the whole process quicker - is to highlight the ‘Add Product’ rows bright yellow. When adding the Promo Stickers, you need to add them to the Add Product rows only so when they're highlighted, this should make the entire process a lot quicker for you.

5. You can colour the row yellow by clicking on the row number to highlight the entire row and then by clicking the paint icon towards the top left-hand side:

6. When you have coloured in all of your Edit Product rows, scroll along your spreadsheet until you see the PromoStickers column:

7. Using the Promo Sticker name that you’ve already added manually, copy this format when adding in the Promo Stickers for the rest of your Edit Product rows:

8. When you have added Promo Stickers to your Edit Product Product rows, you need to save your spreadsheet by clicking the File button in the top left-hand corner as normal:

Now you have finished working on your spreadsheet, the next step is to upload it onto your EKM online shop.

[more]

[/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]