Skip to content

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.

Yahoo Store Coupon Manager Target Items

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.”

Link To Yahoo 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.

Download Yahoo Catalog Manager

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.

Yahoo Catalog Excel File

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’.

Sorting Data in Yahoo Catalog Manager

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.

Te-xt.com Shortcut

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.

Type a Comma

Next, click the ‘Remove line breaks’ link. This will put all of your comma separated codes on one line.

Remove Line Breaks

Your data should now be formatted properly to paste directly into the target items box in the Coupon Manager.

Yahoo Store Coupon Manager Target Items

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!

Stephanie Rawson

Stephanie has 15 years of self-taught HTML and web design experience along with an associates degree in Information Technology from Colorado Tech. Her previous experience in eCommerce and customer service gives her a unique insight into what clients and their customers are looking for. Outside of work, Stephanie is active in Christian ministry and loves geeky hobbies.

Binge on our blogs!

Holiday Checklist Part 2 with cookies and Christmas present.

The Ultimate Holiday Checklist- Part 2: Web Development

Holiday Checklist Part 1 with cookies and Christmas present.

The Ultimate Holiday Checklist- Part 1: Marketing

Holiday PPC Prep

Prepping your PPC Account for (Black Friday, or, uhm…) the Holiday Season

Leave a Comment





We love keeping up with trends & updates... do you?!

Scroll To Top