Mystery Shopping Bible Banner

Yourwebness
Yourwebness
SherryShopperFL

This worksheet is a master list of the available Mystery Shop and Merchandising Companies.  It includes the following sections:

Letter (The first letter of the Company Name, for sorting purposes) (automated field)

The Company Name

Link to the main page website (automated field)

Link to the Login page (if available) (automated field)

Link to the Job Board Page (if available) (automated field)

Link to the Forum/Message Board for the MS company (if available) (automated field)

Shopper ID (many MS Companies do not issue one, if none, enter N/A)

User Name
Password

Date Applied

Address
City
State
Zip Code
E-Mail Address
Phone Number (This number has been formatted already. You enter ONLY the number, no other characters)
Fax Number  (This number has been formatted already.  You enter ONLY the number, no other characters)
Contact Name
Contact Phone # (This number has been formatted already. You enter ONLY the number, no other characters)

Contact E-Mail Address

Company Notes (This field was created by request.  Does a company pay at a certain time, post shops at a certain time, require lengthy narratives.  Make any notes you feel are relevant to  this company).
Updated E-Mail/MSPA certificate date (This field was created when I changed email addressed and needed to get a new MSPA silver certification number issued.  Many companies using Sassie and Prophet make it very easy to make these changes, and others have a profile that you can update also.  But what about everyone else?  You shop for many companies, do you have any easy way of updating everyone?  Not really, but this at least can allow you to know who you have updated, and who you still need to update.
These are just a small number of the available options for using these sorting features that I have incorporated into this spreadsheet.  Please also remember, you can select more than one column.  So you can view your data any way you want to see if.  The possibilities are endless.  Seeing your information the way you want to, that is how you can customize this to your needs and make it your system too.  Remember, to return to the original options, select ALL rather than a specified criteria on all columns you sorted (shown with a small blue arrow), and all of your data will be visible again.

© 2000 - 2007 Yourwebness' Cyber Corner
All Rights Reserved.
Commercial use by written permission only.