Question about Cost of Goods Sold

[WBird]

Hello, thank you for MyCostPro. I appreciate its usefulness. Two questions:

Is there a way to enter my purchase price in the Active Listings sheet? (I sell unique items - not items that I restock)

Sometimes the actual postage paid varies from the amount charged the buyer. Is there a way to enter those differences?

Thank you!

[Scott]

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.

[WBird]

Thanks for your response. I am only seeing one column for shipping and handling. On my spreadsheet it is between "sale price" and "SKU". I am using the full screen. Can you give me a little more direction on where the other postage field is?

Also, I have one sale from about 12 hours ago that does not show up in my SOLD sheet, though I have updated it a couple times. It's not in my ACTIVE sheet either. Any advice? Thank you. I appreciate this tool you have created.

[Scott]

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!

[WBird]

Hi. No matter what I do, there is one Sold listing that does not show.

Also, my Listed On date is not being autofilled. Is there something I need to change?

Your advice about expanding the columns worked. Thanks a lot.

[Scott]

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.