Yahoo Store Coupon Manager – Setting Up Coupons Based On Brands
If you’ve ever used the Coupon Manager in the Yahoo Merchant Solutions store manager, you probably know that you can set up coupons that only apply to specific items. You can manually enter a list of codes for the items you wish to apply the coupon to or you can sort through a hierarchy of your categories to find the items you want to include.
This is a great option if you only have a handful of specific items you want to include or if you want to apply a coupon to a whole category. However, there are many times when you may want to set up a coupon based on something else. One of our clients recently wanted to set up a coupon based on the Brand property without searching through all of his categories and shared this frustration with us.
After some thought on the subject, I concluded that a solution would to be for us to program something in the store editor to make this process easier. This could be done quickly and at a small cost. However, I thought it would be nice to also offer a free solution that doesn’t require any custom programming.
A big cartoon light bulb suddenly appeared over my head and I thought, “Hmm…you can pretty easily get all of the data you need to set up a coupon by Brand (or other properties) straight from your Catalog Manager.”
I’m going to be sharing instructions on how to retrieve this data from your Catalog Manger, how to sort it for your needs, and how to prep it for use in the Coupon Manager. Before you peek ahead at the instructions, there are some things you should note.
- Don’t be daunted by the amount of information here. This whole process can be done in 5-10 minutes once you get the hang of it.
- I’m using Excel 2010, so if you are using a different version the directions might vary slightly or the screens might look a bit different.
- You must have a Catalog Manager in order for this to work for you. Legacy accounts don’t have the Catalog Manager feature.
Step One – Download Your Product Catalog
For this step, you will need to click the ‘Catalog Manager’ link in the Edit section of your Store Manager. You will then need to select the ‘Upload/Download’ tab. Finally, click the download button on the far right and save a copy of your product catalog.
Step Two – Open your Product Catalog in Excel
You should have either chosen to open with Excel or to save your file. If you saved it, locate the file and open it with Excel. If you chose to open with Excel, please take a moment to save your file. You should now have something that looks roughly like the image below.
Step Three– Sort Your Data
The only columns you will need are ‘code’ and ‘brand’ (unless you are sorting based on some other property, in which case keep that instead of brand). Delete all of the columns you do not need by right clicking on the column and selecting ‘Delete’. You can also highlight multiple columns to delete many at once.
Once you are down to just the two columns you need, highlight them both. Next, click the ‘Data’ tab in Excel. Click the ‘Sort’ button to open the sort dialog window. In the ‘Sort by’ column, select the column that Brand (or your non-code property) is in. Click ‘OK’.
Your data will now be sorted by brand. Scroll down in your spreadsheet and find your desired brand. Select all the entries in the ‘code’ column that correspond with your brand.
Step Four– Prep Your Data for the Coupon Manager
The Coupon Manager expects your data as a list of codes separated by commas. Instead of manually formatting the data from your spreadsheet like this, I will walk you through a helpful tool to quickly accomplish this formatting.
First, you will need to go to this website: http://www.te-xt.com/
Copy the data you have selected in your spreadsheet and paste it into the website you just navigated to.
Next, click the ‘Append…’ button. Type a comma in the box and click the ‘OK’ button. This should add a comma to the end of each of your codes. You may need to remove the comma after your last code.
Next, click the ‘Remove line breaks’ link. This will put all of your comma separated codes on one line.
Your data should now be formatted properly to paste directly into the target items box in the Coupon Manager.
And, that’s a wrap! I know it can seem a bit scary if this is outside of your normal comfort zone, but I’m confident that if you get through it a few times you’ll be a pro. In any event, if this seems like it’s not for you or you just don’t have time to mess with this kind of thing, feel free to give us a call. We can custom code you a very user friendly page in your store editor that will give you a list of codes you can just copy and paste right from your store. I hope you enjoyed this tutorial!
Have a suggestion for another tutorial? Email us here or leave a comment!