Messages

421

Feature Requests / Re: After update, keep the hidden and unhidden status

« on: January 16, 2017, 11:15:25 am »

Tian,
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!

422

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.

423

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!

~Scott

424

MyCostPro Updates and Version History / New Version Release 1/15/2017 - Download it Now!

« on: January 15, 2017, 03:14:20 pm »

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

MyCostPro
 * 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 - https://mycostpro.com/affiliate-signup/

425

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!

426

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?

427

Frequently Asked Questions / Re: How do I get Item Purchase Price to auto-populate to the Sold Item List

« on: January 14, 2017, 02:15:55 pm »

etaf10,
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.

428

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

429

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.

430

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:  https://www.youtube.com/watch?v=8jBAjI1O6Q8

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.

Thanks,
Scott

431

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  https://www.youtube.com/watch?v=8jBAjI1O6Q8   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.
~Scott

432

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 support@mycostpro.com

~Scott

433

Frequently Asked Questions / Re: How do I get Item Purchase Price to auto-populate to the Sold Item List

« on: January 07, 2017, 08:01:24 pm »

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.

434

MyCostPro Updates and Version History / New Version Release 1/7/2017 - Download it now!

« on: January 07, 2017, 07:48:50 pm »

New version is available as of the time of this post (1/7/2017):
In this update:

MyCostPro
 * Separated address fields into individual cells - old style "complete address" is still present (hidden by default in the customer section of sold list)
 * Added customer phone number
 * Added Sales Record Number
 * Sold list items will now be sorted properly after updating
 * Added feature to transfer old sheet data to new sheet
 ** Sold list, unsold list, product master, customer master, expense master will all transfer with new feature
 *** This requires the feature on both version of the sheet (old and new), so it will take effect on the next update
 * Fixed bug for Product Master not transferring to sold list if the Product Name was blank - (Incorrectly reported as fixed in last update, I apologize.)
 * Changed initial sold list call to 7 days.  This only affects the first time the sold list is run; each subsequent sold list call is from the time of the last call - until current time.
 ** User can change this to 90 days maximum to populate past data further back.

MyCost Server
 * Download server error "...incorrect user for download..." issue has been resolved
 ** Download the current version of MyCostPro at any time now and in the future with your download key and your user ID.

Coming soon...
Expanded Tutorials section on website https://mycostpro.com/tutorials/

435

General Discussion / Re: Question about Cost of Goods Sold

« on: January 07, 2017, 02:12:43 pm »

On the account info tab, set the number of days to be as far back as the missing sale is, and re-run sold list.
If that doesnt work, please email me the specific item number you are missing.