Messages

436

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. 

437

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!

438

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.

439

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.

440

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.

441

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.

442

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!

443

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?

444

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

« on: December 28, 2016, 11:24:23 am »

OK, So I understand that you are trying to keep track of active item costs.  If you want to put the cost of an item in before it sells you can do it in the product master tab. 
The items on the Product Master tab tie to the sold list by the "ebay item description" field. 
So for example, if you sell "New 1000 pack of widgets"
you would put that in as the item description in the product master, and fill in the purchase costs, and they will transfer to the sold list when they sell.
You can also use the button to refresh items that have already sold, in case you add the information to the Product Master tab after the item has already sold.

Ill be sure to make an animated tutorial for this to go in the tutorial section as well, thanks for the question!

445

eBay and PayPal Fees / Current eBay Fee Tables for reference

« on: December 27, 2016, 12:29:51 pm »

Current eBay Store fees as of 12/27/2016:
For eBay sellers that are considering subscribing to one of eBay's store subscriptions.  If anyone wants this in spreadsheet format just let me know and I can post it up as a free download.