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









  • Make more money with your online store.

  • How I took one Yahoo Store from $15K a year to over $5 Million+ in sales.
  • How I got $10 million in ADDITIONAL sales by changing ONE THING.
  • How to make your store more Google-friendly for more free SEO traffic.

    Input Your Email: