Please view our Spreadsheet Setup video that walks through the setup process step-by-step on our Video/Tutorials page.

First, install ODBC Driver.  To setup the ODBC Driver, you need to run the "mysql-connector-odbc-5.1.5-win32.msi" installation file.  Follow the installation wizard for the driver selecting the "Typical" installation option when prompted. The ODBC driver is essential as errors will occur if this driver is not installed.

mysql-connector-odbc-5.1.5-win32.msi driver file

Select the Version for your country from the links below:

US Version     UK Version     CA Version    AU Version

Once you open the spreadsheet, you will see a Setup & Instructions tab. Follow those step-by-step instructions.  (If you don't see the tab, click on the left arrow located at bottom left corner of the spreadsheet. The Setup & Instructions tab is the first tab on the left.)

Depending of the version of Excel you are using, the security warning may not be displayed as shown on the Setup & Instructions tab. Macros must be enabled for the spreadsheet to work. Click on the button in step 2 to create your Authentication Token. If a "Create Token" window is displayed, your macros are running and everything will work. If no "Create Token" window is displayed, macros are most likely disabled. Please visit the Microsoft page to get the instructions to enable macros for your version of Excel.

For Excel 2002 XP: Enable Macro Instructions

For Excel 2003: Enable Macro Instructions

Important: Be sure that you don't click on anything nor change tabs while data is being retrieved and entered. When the spreadsheet is finished pulling items from eBay, the system messages box will read:

"Select April, 2010 & User. Click on 'Get All Items' for that month's items OR insert Item No. and click on 'Get Item' for a single item."

When you pull up the data for your transactions, you will just need to put in your cost into the "My Cost" column as a negative number as well as the Actual Shipping Cost (also as a negative number).

When you purchase the Full Version: You will be emailed with your Unlock Key. In Step 7, you will need to enter this Unlock Key, which will fully unlock your spreadsheet for use throughout 2010.

Additionally, we have a Setup video on our Video/Tutorials page that will walk you through the setup process step-by-step.

Contact us if you have any questions or if you are having trouble getting it set up. We are always happy to help!

 

Advantages of Using EasyAuctionsTracker:

Our spreadsheet application has been Tested & Certified by eBay!
 


 

Save Time with Automated Data Collection!

Avoid Manual Data Entry Errors!

Keep Your Records Organized!

Quick Invoicing for Trading Assistants!
 

Listen to our interview with Danna Crawford from PowerSellingMom.com!
 

 

Copyright © 2007-2010 EasyAuctionsTracker. Designated trademarks and brands are the property of their respective owners.