Question 1

Q:  In the 2022 file how can I manually add items that I sold on other platforms?

joshsinsel · Accepted Answer

First, you’ll need to create a manual token on the tokens menu. Open the Tokens Menu (on the Easy Auctions Tracker menu).
In the Buy/Sell/Both column, choose Manual and then enter the name of the ID you’d like for these manual entries.
Close that menu by clicking on the Tokens button again.
Click on the Manually Add Order button at the top of the screen on the Easy Auctions Tracker menu
Type in the data into row 11 for your first item. Be sure the item number is unique for each item (it can be letters, it just needs to be unique for each item). You’ll need to scroll over to see the Item Number column but columns can be moved around in this version with drag and drop.
Each time you want to add a manual item, click on the Manually Add Order button and then type in the data.

Question 2

Q: In the 2022 file, what has changed with Actual Shipping Costs?

joshsinsel · Accepted Answer

A: eBay announced in July 2021 that the Actual Shipping Cost would no longer be available through the API calls for Developers, so we did not originally add it into the 2022 file. Since eBay is still currently reporting it, we have added it back in. Please understand that this is no longer supported by eBay, and we have no control over the ongoing use of this functionality. eBay has announced this will stop working in the near future (it was supposed to stop working by now) and they have already removed documentation for this functionality from their website.

The orange-colored column labeled “Other Shipping Costs” contain the costs downloaded from the discontinued API call. The column labeled “Shipping Labels” contains the costs downloaded from the new API call and will continue into the future. With this new API call, items shipped with individual shipping labels (not bulk shipping) will be entered into the Shipping Labels column. Bulk shipping labels will be downloaded into the fees data and calculated into the overall Profit & Loss, but cannot be linked to a specific item.

If the Actual Shipping Cost is downloaded into the Shipping Labels column, it will not be downloaded with the old call into the Other Shipping Costs column.

The updated file (2022J) can be found on our website. Contact Us if you have questions.

Question 3

Q: Why is ##### displayed on some of my columns?

joshsinsel · Accepted Answer

A: The #### error just means the column is too narrow to display the number. Widen that column and the number will appear instead of the error.

Question 4

Q: Which version of Excel is needed to run the sheet?

joshsinsel · Accepted Answer

A: Microsoft Excel (2013 or higher) or Office 365 PC Install are required for Easy Auctions Tracker. The free version of Excel cannot run macros, which are used in our sheet to communicate with eBay’s servers.

Question 5

Q:  I have an item that is showing #N/A in the Net Profit/Loss column on the eBay Selling tab. How can I fix this?

joshsinsel · Accepted Answer

A: Here are a few things to check:

-check to be sure there’s an Owner listed in column Z. It is set to automatically default to My Item, but occasionally an owner is not automatically selected. If there’s no owner selected, be sure to choose My Item or the client that it belongs to.

-if the owner field isn’t an issue, scroll over to the My Cost column (D) and see if there’s an incorrect entry such as two decimals or another character that doesn’t belong there.

Question 6

Q: I am getting an error that says "you did not select a valid user." How can I fix this?

joshsinsel · Accepted Answer

A: This error message on the eBay Selling tab is indicating that there’s an issue with your token with eBay. Go to the Setup & Instructions tab, click on “Create Token” and follow the steps. If you have more than one token, be sure to create them one at a time (create and fetch the first token before creating the second one). Don’t delete the current token in your sheet; it will be updated when a new one is created. The transactions you already have in the sheet will remain there.

Question 7

Q: How can I get my Welcome Email and Unlock Code after purchase? I don't see it in my spam folder.

joshsinsel · Accepted Answer

A: The Welcome Email can be viewed on our site at: https://easyauctionstracker.com/welcome/

Question 8

Q: Can this be used on a Mac computer?

joshsinsel · Accepted Answer

A: This is one option for Mac users. You'll need to be sure you have license keys for both Windows and Office. We cannot provide Mac support (only Easy Auctions Tracker support): https://support.apple.com/en-us/HT201468

Mac systems cannot run the macros in our sheet (which are used in our sheet to communicate with eBay’s servers). Microsoft Excel (2013 or higher or Office 365 PC Install) are required for our sheet.

Question 9

Q: How many eBay accounts can be added to Easy Auctions Tracker?

joshsinsel · Accepted Answer

A: Up to five eBay tokens/accounts can be added to one spreadsheet file. To add more eBay accounts/tokens to your sheet go to the Setup & Instructions tab and complete step 2 for each one. Just be sure you assign a different name for each token. This is the name that will appear in the drop-down box in cell C1 on the eBay Selling tab (or on the eBay Buying tab).

You will just need to choose which token/eBay account you want to retrieve data for before clicking on the "Get All Items" button. You'll need to do this for each separate eBay account. The eBay Selling tab is a running list of all transactions for all of the accounts. You can view Monthly Data or Yearly Data for one, several or all of your accounts on the Monthly Summary and Yearly Summary tabs. The Profit & Loss tab will show the sum of all of the accounts.

If you'd prefer separate files for each account to keep your data completely separate, we can offer you a discount on the second & subsequent files. Just let us know how many spreadsheets you'd be looking to purchase.

Question 10

Q: Can Easy Auctions Tracker be used on more than one computer?

EAT Support · Accepted Answer

A: You could transfer the file between computers by emailing it to yourself back and forth, using a flash drive or with a cloud service.

Question 11

Q: How long does eBay store my information and how long can I access my data?

EAT Support · Accepted Answer

A: eBay stores your listing information for three months. For example you can retrieve May's transactions in August. Once the listing information is downloaded into the spreadsheet, it is saved as part of the file and will be retained even after eBay removes the information from its servers.

Easy Auctions Tracker is an Excel file that is stored on your computer. You can access it in the future for as long as you have the file. We recommend users save a backup copy of their file about once per month on a separate hard drive such as a flash drive or on a cloud service in case anything ever happens to their file or to their computer.

FAQs

Q: In the 2022 file how can I manually add items that I sold on other platforms?

Q: In the 2022 file, what has changed with Actual Shipping Costs?

Q: Why is ##### displayed on some of my columns?

Q: Which version of Excel is needed to run the sheet?

Q: I have an item that is showing #N/A in the Net Profit/Loss column on the eBay Selling tab. How can I fix this?

Q: I am getting an error that says “you did not select a valid user.” How can I fix this?

Q: In the 2022 file how can I manually add items that I sold on other platforms?

Q: In the 2022 file, what has changed with Actual Shipping Costs?

Q: Why is ##### displayed on some of my columns?

Q: Which version of Excel is needed to run the sheet?

Q: I have an item that is showing #N/A in the Net Profit/Loss column on the eBay Selling tab. How can I fix this?

Q: I am getting an error that says “you did not select a valid user.” How can I fix this?

Load More