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

Please download and install the Driver File from the link below. This is essential as errors will occur if this driver is not installed:

Click Here to Download 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.

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.

Excel 2000 users: You should be prompted to enable macros each time you open the spreadsheet. If you're not prompted, please visit the Microsoft page at the link below to get the instructions to enable macros for your version of Excel:

For Excel 2000: Enable Macro Instructions

For Excel 2002: 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 January, 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: In Step 7, you will need to enter the PayPal email address and Transaction code to unlock your spreadsheet.

Additionally, we have a Setup video on our Video/Tutorials page. Updated video coming soon.

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!