Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Scott

Pages: 1 ... 25 26 [27] 28
Technical Support / Re: sold listings didnt transfer to mycostpro
« on: January 16, 2017, 11:22:14 am »
In the more recent versions of the sheet we changed the default query to 7 days.  But dont worry, you can still go back 90 days.
Just go to the account info tab and change the number of days to 90, and click the button.
Then the next time you run the sold list update it will grab everything from the last 90 days.  It doesnt matter if you already ran it for 7, it will update the rest and put it all in the correct order.
Then after that, every time you run the update it will get the data from the timeframe since the last time you updated it, so you wont need to mess with that account info section again if you dont want.

Feature Requests / Re: One button to change the $ to pound sign
« on: January 16, 2017, 11:18:00 am »
Actually I just answered a similar question earlier today!  Changing the default currency is very high on our list of to-do items. 


Feature Requests / Re: After update, keep the hidden and unhidden status
« on: January 16, 2017, 11:15:25 am »
Good question.  I will add it to our list of improvements to try to get implemented.  Currently only the data (below the headers) is getting transferred, so it doesnt include your hidden/unhidden column settings.

Thanks for the feedback!

Frequently Asked Questions / Re: Does MyCostPro Support UK users?
« on: January 16, 2017, 09:07:24 am »
The sheet works fine for eBay UK, but they may need to get a custom file from us to convert the default currency type.  It is one of the many planned updates to allow users to change their own default currency type, were trying to focus on the the largest requests first and work our way down.

Technical Support / Re: Column Names Change After Update
« on: January 16, 2017, 09:03:24 am »
Thats a good point, I didnt think about transferring over the header names as well...
In the mean-time, if you want to quickly update the whole thing:
Save first incase there is any problem.
Turn off Click Layout Assist
Exit full screen mode
In the OLD sold list Right click on the row number 10 so it selects the whole row, and pick Copy
Go to the NEW sold list and right click on row number 10 and pick paste.

Let me know if that doesnt do the trick for you!


New version is available as of the time of this post (1/15/2017):  visit   with your download key
In this update:

 * Enabled relisting of unsold items
 * Changed (improved) the method of tying listing insertion fees and upgrade fees to the sold item and unsold item records.  (Should capture all, and will not duplicate)
 ** May need to update sheet from brand new blank sheet to take effect.
 *** Does not impact sellers that have 100% free insertions with no extra insertion upgrade fees.
 * Fixed the P&L overhead expense categories not updating to match customized user-setup categories

MyCostPro Affiliate Program
 * Announcing the MyCostPro Affiliate Program!
 * Earn up to $6 per referral - see link for details -

Technical Support / Re: Multiple Item Orders
« on: January 15, 2017, 02:10:10 pm »
Great to hear!  I have a feeling you might be able to help new users out a bit if you stick around on these forums.  You are going to be a PRO in no time!

Technical Support / Re: VBA Password Error When Closing the Spreadsheet
« on: January 14, 2017, 02:30:04 pm »
This is very strange indeed.  Are you closing by exiting full screen and clicking the X on the top right?

We did have an issue for a while where the items would not auto populate without the product name... that should now be fixed in the current version.
Is it working for you if you click the button to manually update it?
It should work now where as long as you have the item description exactly matching, they will fill in either when the item sells and is added to the sold list, or afterward if you hit the button to manually update them.
I did quite a bit of testing after last update, and I can not get it to fail.  So if you have the newest version I might need to get some more information from you to figure out what the issue is so I can try to replicate it.

Technical Support / Re: Multiple Item Orders
« on: January 12, 2017, 05:54:38 pm »
Please email me the item number-transaction number so I can investigate :)

Technical Support / Re: VBA Password Error When Closing the Spreadsheet
« on: January 12, 2017, 05:53:29 pm »
SOLUTION (Posted by Ssheldon)

In Dropbox settings preferences, switch the Badge setting from Always Show to Never Show

Also, newest version of the sheet (available 7/27/2017) should prevent this issue if you save using the new save button.

Technical Support / Re: it is very slow
« on: January 12, 2017, 05:52:28 pm »
Please check out some of the tutorials I have such as:

You have the choice to enter the product price either on the Sold List directly, or on the Product master tab, and then transfer it to the sold list.
You never need to enter anything on the Product Master tab if you would prefer to enter it directly onto the sold list.

So basically:
You will download the sale, and enter the purchase price.  Then review to make sure everything else looks good (if you did not ship through ebay you will probably have to fill in your shipping postage price as well).

If you want to put the prices for everything here, or email me privately, I will review with you to see why the Profit does not match what you expected.


Feature Requests / Re: Pull in Tracking Numbers & Sales Tax Collected
« on: January 11, 2017, 08:25:36 pm »
Hi.  Great suggestions!  Please check to make sure you have the latest version, because they are already in place :)

There is a hyperlinked tracking number, but keep in mind, the shipping needs to have been purchased through the eBay shipping label service;  this is not a bad thing because they offer a significant discount over purchasing shipping directly through USPS and FedEx.

If you dont see this information, it may be hidden, please check out this tutorial video   that shows how to hide and unhide data (you can skip to the ~3:40 mark)

Also in the latest version the columns were separated into address, city, state... where they used to be all in one cell.  The sales tax collected is there, but it also is probably hidden if you dont see it.  See above about how to hide and unhide columns from view.

I hope this helps, please let me know if you need further assistance.

Technical Support / Re: it is very slow
« on: January 11, 2017, 06:12:09 pm »
Hi, first please make sure this is the only spreadsheet that is open at the time.  If that is not the case, please email me with your computer specifications at


Everyone please excuse me, this bug has NOW been fixed in the new version that is up as of a few minutes ago.
What I thought fixed the issue had not, so thank you everyone for alerting me and bringing it to my attention again.

Pages: 1 ... 25 26 [27] 28