361
General Discussion / Re: Cost of Goods
« on: July 16, 2017, 05:25:01 pm »
. Np... that's why I'm here!
eBay Selling, Made Easy
News:
Welcome to the MyCostPro forum! This is the place to discuss anything MyCost.
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.
. Np... that's why I'm here!
362
General Discussion / Re: Cost of Goods
« on: July 15, 2017, 04:42:58 pm »
My guess is the formula is pulling the price out as a "string" value (alpha-numeric). Use "value()" in the formula to make sure it stores it as a number.
example:
=VALUE(LEFT(G3,FIND("-",G3)-1))
I think this will solve the issue and the ROI and profit should calculate automatically...
example:
=VALUE(LEFT(G3,FIND("-",G3)-1))
I think this will solve the issue and the ROI and profit should calculate automatically...
363
Technical Support / Re: VBA Password Error When Closing the Spreadsheet
« on: July 14, 2017, 07:58:20 pm »
This just perplexes me, because no matter what I do I cant duplicate it. We will continue to investigate...
364
General Discussion / Re: Cost of Goods
« on: July 14, 2017, 07:56:54 pm »
Wow, good idea to add data to the ebay listing that isnt normally available for your record keeping!
Also in the future if you need any help with formulas like that, dont hesitate to come to me directly and I can let you know how to do what you want by formula.
Also in the future if you need any help with formulas like that, dont hesitate to come to me directly and I can let you know how to do what you want by formula.
365
General Discussion / Re: Cost of Goods
« on: July 13, 2017, 07:53:56 pm »
ssheldon,
Thanks for the good questions, im going to do my best to help out here.
Q) You want to know if you can use *wildcard* on SKU field instead of item description field
A) Not currently, but I understand the scenario and how it could be helpful. Keep in mind the SKU field would have to populated on the ebay side, so that it would be included in the sales download, or else there would be nothing to tie the two together. Let me know if im explaining that poorly. If its a big item for you maybe we can start a new thread on the product feature forum to make sure we get all of the details right.
Q) Add cost of goods sold column to Active Listing Sheet as well as additional info (inventory source, cost, and purchase date) to help with end of year inventory.
A) The Active Listing Sheet is just a snapshot of what is currently "active" so any data you input there would go away after the item sold. For that I create the Product Master tab. If you think it would be helpful, I can update that to include the inventory source and purchase date (cost is already there). Also, I will explain below* how to update your active items into the Product Master very quickly.
*Make Product Master for all of your Active Listings Quickly.
Update your active listings with the "check active listings on ebay" button, then:
1. On the Active Item List tab, make sure the "Click Layout Assist" button is set to ":off"
2. Highlight a list of Item Titles by left clicking the mouse (hold it down) and drag to select as many item titles as you want (they will be highlighted in light blue)
3. Hit Ctrl-C to copy to the clipboard
4. Navigate to the Product Master tab. (Click Home, then Product Master)
5. Click (single left click) in the first empty cell for Listing Description
6. Ctrl-V to paste. [optionally, you can use "paste-special, values only" to keep the formatting cleaner visually]
7. Now you can fill in your COGS and they will be saved and automatically transferred to the sold item tab
Thanks for the good questions, im going to do my best to help out here.
Q) You want to know if you can use *wildcard* on SKU field instead of item description field
A) Not currently, but I understand the scenario and how it could be helpful. Keep in mind the SKU field would have to populated on the ebay side, so that it would be included in the sales download, or else there would be nothing to tie the two together. Let me know if im explaining that poorly. If its a big item for you maybe we can start a new thread on the product feature forum to make sure we get all of the details right.
Q) Add cost of goods sold column to Active Listing Sheet as well as additional info (inventory source, cost, and purchase date) to help with end of year inventory.
A) The Active Listing Sheet is just a snapshot of what is currently "active" so any data you input there would go away after the item sold. For that I create the Product Master tab. If you think it would be helpful, I can update that to include the inventory source and purchase date (cost is already there). Also, I will explain below* how to update your active items into the Product Master very quickly.
*Make Product Master for all of your Active Listings Quickly.
Update your active listings with the "check active listings on ebay" button, then:
1. On the Active Item List tab, make sure the "Click Layout Assist" button is set to ":off"
2. Highlight a list of Item Titles by left clicking the mouse (hold it down) and drag to select as many item titles as you want (they will be highlighted in light blue)
3. Hit Ctrl-C to copy to the clipboard
4. Navigate to the Product Master tab. (Click Home, then Product Master)
5. Click (single left click) in the first empty cell for Listing Description
6. Ctrl-V to paste. [optionally, you can use "paste-special, values only" to keep the formatting cleaner visually]
7. Now you can fill in your COGS and they will be saved and automatically transferred to the sold item tab
366
Feature Requests / Re: eBay Monthly Store Fee
« on: July 13, 2017, 07:15:11 pm »
I like this idea, and it is in the pile for future development.
Thanks for the input!
Thanks for the input!
367
Technical Support / Re: VBA Password Error When Closing the Spreadsheet
« on: July 13, 2017, 07:13:28 pm »
Hi,
Excel 2007 is just fine (I actually wrote most of the software using excel 2007).
I have not been able to replicate this issue. If anyone that is having this issue is willing to do the following and report back, I would really appreciate it: Uninstall Office Excel 2007, and reinstall.
There may be an issue that Microsoft has since patched.
Excel 2007 is just fine (I actually wrote most of the software using excel 2007).
I have not been able to replicate this issue. If anyone that is having this issue is willing to do the following and report back, I would really appreciate it: Uninstall Office Excel 2007, and reinstall.
There may be an issue that Microsoft has since patched.
368
General Discussion / Re: Cost of Goods
« on: July 11, 2017, 08:38:13 pm »
Hi,
I'm glad you're enjoying the program so far.
Let me try to help you out with your question.
The costs and additional details can be entered immediately in the product master* tab.
Once the item sells it will pull this data into the sold item data; these are paired together by the item listing ti
Since you are selling one-off items, you may choose to use the sku field for something like the supplier name if that is more valuable in your specific case.
Let me know if I can be of further assistance.
*fixed my typo (thanks hunter!)
I'm glad you're enjoying the program so far.
Let me try to help you out with your question.
The costs and additional details can be entered immediately in the product master* tab.
Once the item sells it will pull this data into the sold item data; these are paired together by the item listing ti
Since you are selling one-off items, you may choose to use the sku field for something like the supplier name if that is more valuable in your specific case.
Let me know if I can be of further assistance.
*fixed my typo (thanks hunter!)
369
Current Events / eBay offering price matching to compete with Amazon and Walmart
« on: July 01, 2017, 09:00:30 am »
What do you all think about this?
It's only affecting the "ebay deals" items apparently (fortunately)
https://techcrunch.com/2017/06/21/ebay-will-now-match-amazons-walmarts-and-others-prices-on-over-50000-items/
It's only affecting the "ebay deals" items apparently (fortunately)
https://techcrunch.com/2017/06/21/ebay-will-now-match-amazons-walmarts-and-others-prices-on-over-50000-items/
370
Off-Topic / List of free USPS priority box weights
« on: June 22, 2017, 09:07:26 pm »
Ever wonder how much weight the box actually adds to your package? FITSHIPPER has compiled this list with the weights of many of the Priority Mail shipping boxes you can get for free from USPS.com.
https://blog.fitshipper.com/2017/06/22/usps-priority-box-weights/
https://blog.fitshipper.com/2017/06/22/usps-priority-box-weights/
371
eBay and PayPal Fees / New fee category
« on: June 09, 2017, 05:27:54 am »
Ebay released a new fee category a few days ago: Guitars and Bass at the low rate of 3.5%.
Unlike other categories this also applies to non-store owners, however the max fee cuts off at $350 for non-store owners, and $250 for store owners.
Does anybody sell guitars that can tell me what prompted this?
Unlike other categories this also applies to non-store owners, however the max fee cuts off at $350 for non-store owners, and $250 for store owners.
Does anybody sell guitars that can tell me what prompted this?
372
General Discussion / Re: Will eBay multiple choices of items listings populate into MCP?
« on: May 13, 2017, 08:38:47 am »
Hi,
These are returned as "variations". And, yes, you get all of the variation detailed information in MyCostPro. Unhide the PRODUCT column section (it's in-between the INCOME and CUSTOMER sections) on the sold item page to see this info. Let me know if you have any trouble.
These are returned as "variations". And, yes, you get all of the variation detailed information in MyCostPro. Unhide the PRODUCT column section (it's in-between the INCOME and CUSTOMER sections) on the sold item page to see this info. Let me know if you have any trouble.
373
Technical Support / Re: Cant select between Months in reports.
« on: May 04, 2017, 04:17:38 am »
Thats odd for sure... can you send me a screenshot of what you see when the dropdown works but it only says January? Seeing it might help me to figure out what is going on.
374
Technical Support / Re: Cant select between Months in reports.
« on: May 01, 2017, 08:13:58 pm »
Shane,
Awesome that you like MyCostPro so far! I want to help figure out whats going on: The Month dropdowns are Active X content, can you confirm that you have active x enabled? Also, please let me know your windows and excel versions.
Thanks,
Scott
Awesome that you like MyCostPro so far! I want to help figure out whats going on: The Month dropdowns are Active X content, can you confirm that you have active x enabled? Also, please let me know your windows and excel versions.
Thanks,
Scott
375
General Discussion / Re: Dashboard Categories
« on: April 21, 2017, 08:41:47 pm »
Hi,
Sorry you're having trouble... I will need to gather a bit more info to determine what is going on. Please email me the following to support@mycostpro.com :
* MS Office version
* Windows version
* A screenshot of the problem
Sorry you're having trouble... I will need to gather a bit more info to determine what is going on. Please email me the following to support@mycostpro.com :
* MS Office version
* Windows version
* A screenshot of the problem