Show Posts
361
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
