how to make quick OPTIONS drop down lists for Yahoo Stores

Step 1 GET THE ids

in INTERNET EXPLORER
  • edit the AUTHORS page
  • goto CONTENTS field
  • ctrl-a to highlight all IDS
  • ctrl-c to COPY all and then

    in NOTEPAD
  • ctrl-v to paste into a empty notepad
  • ctrl-a to highlight all in NOTEPAD

    open WORD
  • ctrl-v to paste into a empty WORD doc

  • ctrl-H to find/replace
  • replace " " (don't type the quotes, just the space) with ^p

  • ctrl-a to highlight all IDS
  • ctrl-c to COPY all and then

    open NOTEPAD
  • ctrl-v to paste into a empty notepad
  • ctrl-a to highlight all IDS
  • ctrl-c to COPY all and then

    OPEN EXCEL
  • click in cell d-1
  • ctrl-v to paste into column D

    #2 GET THE CORRESPONDING author NAMES

    in EDITOR, browse to the AUTHORS page

    highlight all the names of the authors

    they'll be in the same order as the ids you just got

  • ctrl-c to COPY all and then

    in NOTEPAD
  • ctrl-v to paste into a empty notepad
  • ctrl-a to highlight all in NOTEPAD

    open WORD
  • ctrl-v to paste into a empty WORD doc

  • ctrl-H to find/replace

  • replace "^p " (don't type the quotes, just the space) with ^p
  • this changes all the empty lines with spaces to empty lines

  • replace ^p^p with ^p
  • this deletes all the empty lines
  • replace ^p^p
  • with ^p
  • this deletes all the empty lines

  • replace " " with nothing (replace all)
  • (or however many spaces are at the beginning of a line

    now all the Author Names should be on the same number of lines as the IDs

  • ctrl-a to highlight all names
  • ctrl-c to COPY all and then

    open NOTEPAD (to remove WORD formatting if any)

  • ctrl-v to paste into a empty notepad
  • ctrl-a to highlight all NAMES
  • ctrl-c to COPY all and then

    OPEN EXCEL
  • click in cell f-1
  • ctrl-v to paste into column F

    -- -- -- -- --

  • into cell c-1 paste <option value="
  • into cell d-1 paste THE ID
  • into cell e-1 paste .html">
  • into cell F-1 paste THE name of the author
  • into cell G-1 paste </OPTION<

    -- -- -- -- --

  • copy the c-1, e-1, and g-1 cells and paste into each row that needs it.
  • highlight all the cells c-1...g-1 down until the last row
  • copy ALL, paste into NOTEPAD
  • highlight a TAB between the cell data in NOTEPAD,
  • ctrl-c to copy it
  • CTRL-H to REPLACE ALL
  • paste the TAB character in the first field
  • replace all TABS with nothing.
  • highlight everything and CTRL-C it to copy it.

    This code can now be pasted to the SIDEBAR pulldown between the SELECT TAGS







  • Get Secrets of Million-dollar Yahoo! Stores...
    Read what wouldn't fit in the Dummies book


    MAKE MORE WITH YOUR ONLINE STORE. Rob Snell, Yahoo! Store DesignerLearn how I took one Yahoo Store from 150 visitors a day and $15K a year in gross sales to over 4,000 visitors a day (peak) with $5,000,000.00 (5 million+) in sales.
    P.S. Trade me your email address for my free email newsletter (sent somewhat irregularly), but jam-packed with all  kinds of free tips and tricks.  Look, I won't spam you. Your privacy is protected. I won't  sell your email address, and you can opt out any time you want. Sign up today! And come see me speak about Yahoo! Store at search marketing and retailer conferences all year! -- Rob
    Input Your Email: