Messages

421

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.

422

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

423

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

424

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

425

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.

426

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/

427

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.

428

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

« on: January 07, 2017, 12:19:42 pm »

Can you let me know when you downloaded the version of the sheet you are using?
As a temporary fix, make sure there is a product name filled in, it should work.  (You can fill in anything).
But I am 99% sure this issue has been fixed in the latest version.  Do you have a number of days you can input on the Account Info tab? (that was added in the newest version)

Dont worry, if there is still a problem I will fix it and you wont have to retype all of that. 

429

General Discussion / Re: Question about Cost of Goods Sold

« on: January 06, 2017, 04:08:07 pm »

Hi.
Click the "Click Layout Assist button" and then you can hide and unhide the hidden columns of each section by clicking the double triangles above the category bookmarks.
See this video around the 3:40 mark to see it in action.

https://www.youtube.com/watch?v=8jBAjI1O6Q8

Also, I think it is visible by default in the newest version on of the sheet.   If you want to go ahead and download the current version, just head to https://mycostpro.com/download  with your download key and grab it.

The new version of the sheet also has the ability to set the date range that you want to check, so for some reason if you are missing a sold item you can set it to check back to that day.  That is located in the account settings tab.

Let me know the result!

430

General Discussion / Re: Question about Cost of Goods Sold

« on: January 04, 2017, 05:52:50 am »

Hi.
I will answer your 2nd question first:  There are two different fields for postage.  One is for the shipping that you charge the customer, the other is for the postage that you pay to ship the item.  If you print your postage through ebay, it should pull in the correct amount for both of these fields.  Also, you can manually change the postage value (that you paid) to whatever you like directly in the sold listing tab if needed.

For your first question I think I need to find out more about what you want to accomplish.  Did you want to avoid putting these item purchase costs directly into the sold list after they sold. Perhaps you want to record all of it up front instead of filling it in as it sells?
If thats the case you can fill them in the product master (even though they are one time selling items) with the item description (ebay listing title) and purchase price (and anything else you want to automatically fill into the sold list when the item sells)

Let me know if thats not what you were after.

431

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

« on: January 02, 2017, 07:46:51 pm »

Hi,
If you are putting the item description in that matches the item description on the sold list, it will auto-populate with the data you put in.  If you want to send me a few screenshots at support@mycostpro.com I will see if there is anything that you or I are overlooking, and im sure we can get this fixed up.
For the taxes, do you mean sales taxes that you pay at the time of purchase for the item?  I think that column caused some confusion in previous versions, which is why it was removed, let's discuss that further as well to make sure I understand what you're looking for.

432

Technical Support / Re: Custom Labels

« on: January 02, 2017, 12:53:38 pm »

Hi,
There are many fields that ebay offers for us to include in our download, im not sure exactly which would match the "custom label" description you gave.
If it is SKU, we are currently downloading that.  It is probably hidden from your default view.  If you are unsure about how to hide and unhide the columns, let me know and I will guide you to a tutorial.
If that is not the field you seek, there are lots of extra fields that we included that are for the user to put whatever data they want in.  They are also hidden by default.

Let me know if you need further assistance.

433

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

« on: January 02, 2017, 12:49:32 pm »

Im not sure if I understand the issue you are describing.

If you are trying to update details from the Product Detail tab to the sold list:
You can use the button either on the Product Detail page "Apply updates to sold list" or you can use the button on the Sold List tab "Fill in Product Master Details".
Either of these will fill in the details from Product Detail tab to the Sold List tab.  Keep in mind it only fills in where there are blanks.
Once they are filled in the Product Detail tab, all NEW sales that match that description will auto populate with that information.

Let me know if I am not understanding your issue.

434

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

« on: December 31, 2016, 07:42:15 pm »

Hi,
I want to let everyone know that we have identified some scenarios where the product information does not update from the product master tab to the sold list tab.

This will be fixed and available for re-download 1/1/2017 (target date).

Sorry, and thank you.

HAPPY NEW YEAR!

435

Feature Requests / Re: Freeze Item Title

« on: December 28, 2016, 01:48:35 pm »

Mr. Tee thanks for the request.  We will see how the general interest is for this, but in the mean-time please see if this helps you:

You can exit full screen mode (the black button on the top right) and this will bring back the standard excel ribbon bar, from here you can add freeze pane from the VIEW section of the ribbon bar.

Alternatively, you can turn ON the "Click Layout Assist" feature, and you can hide columns or put them into bookmark view by clicking on the header descriptions, so that they dont take up so much of the screen.
Have you tried that feature?