Recent Posts

1

Feature Requests / Re: Possible to add three columns?

« Last post by Scott on January 18, 2020, 02:45:37 pm »

Hi,
Please check that the Click Layout Assist button is set to OFF.

When it is ON you can not copy and paste.  It should always be set to OFF when not in use.

For your second question, do you need help setting up a formula?  I would just need to know the details.

2

Feature Requests / Re: Possible to add three columns?

« Last post by consignmentworld on January 18, 2020, 02:23:03 pm »

Thanks for helping us get back into the forum account.  Not sure what happened there. 

On the first issue.  (copying formulas) I am familiar with how to normally copy and paste formulas between cells.  However, for some reason whenever I attempted to do it in the MyCostPro workbook it wouldn't allow me to.  I tried both right clicking and clicking copy on a cell. but when I went to paste the option is greyed out.  Also, I attempted to do it via the other method where you input the formula in the first cell, left-click the little square in the bottom right corner and drag downward to auto-populate the fields.

Second, I'd appreciate you helping with setting up the columns we need in order to achieve the goals we are working toward.  Thanks in advance for any assistance!

3

Feature Requests / Re: Possible to add three columns?

« Last post by Scott on January 08, 2020, 04:40:56 pm »

Hi, good questions, I think I can help
One of the basic functions built into excel, is the ability to change the formula reference ranges if you copy and paste a formula.
For example, if you put a formula in Cell C1 --> "=A1+B1" and then copy that cell and paste it into C2... it will automatically change the formula to "=A2+B2"

So thats how you can quickly duplicate the formula instead of typing it each time.

For the next question, there are already extra columns in each of the sections that are hidden by default, so you dont need to add new columns, you just need to unhide them.
You can view the video tutorials on that here:  https://mycostpro.com/video-tutorials

Lastly, it sounds like you would only need 2 columns.  One for the commission percentage, and then one to do all of the calculations mentioned.  You dont need to do half of the calculations in one column first and then the rest in a second column... let me know if you need help with that.
The commission paid will automatically be removed from your ROI and profit as long as you choose to put it in one of the columns currently hidden in the EXPENSE or FEES group of columns.
Conversely, make sure to put the percentage of commission in one of the groups of columns that does not affect profit directly, such as the PRODUCT group of columns.

I hope that makes sense, let me know if you have any additional questions.

4

Feature Requests / Possible to add three columns?

« Last post by consignmentworld on January 08, 2020, 08:55:34 am »

So I understand how to use a formula to calculate a percentage for a consignment sale.  However, is there a quicker way to do it rather than going to each item individually and typing it out for every item?

Also, would it be possible to get 3 additional columns added to the Sold Items tab?

The reason I am asking is we have a sales associate who earns a commission on every item sold. This commission is based on the sale price minus any shipping as we offer free shipping.  So as I see it, we would need three additional columns.  First we would need a column in which shows the sale price minus shipping costs.  Then we'd need a column where the commission percentage could be entered, and finally a column that shows the actual dollar amount of any commission owed. 

Additionally, it'd be nice if this commission could also be deducted for the ROI and Profit per item columns as well. 

Thanks in advance!

5

Frequently Asked Questions / Re: Replacing PC

« Last post by Hunter on December 31, 2019, 11:20:15 am »

If you want to continue using the same spreadsheet, just copy it to a thumb drive or CD, and place it on the new PC after you have installed Excel. If you want a new version of the sheet, the instructions to transfer the data to the new sheet are on the account info tab in MyCostPro. 

If you want your boss to use your token, you can just let him use the sheet. If you want him to be able to see your current data without being able to connect to eBay, you can remove your download key from the account info section of MyCostPro, and save as a different file. If you give him this new file, it should contain all of your data, but he will not be able to retrieve more or update your listings.

6

Frequently Asked Questions / Replacing PC

« Last post by SGARBER on December 31, 2019, 07:28:15 am »

I am going to be replacing my desktop pc here in the office.  I am not sure of the process to get MYCOSTPRO security token moved to the new unit.  Additionally, is there a way that my boss can access the spreadsheet as well as me?

7

Technical Support / Re: Year End Cleanup

« Last post by Scott on December 29, 2019, 09:22:57 am »

Right, when checking for a match, if there is no match it will show #N/A, therefore it is not in your active item list.
Just make sure you see ones that are numbers (instead of NA) to make sure the formula doesnt have a typo.  If the formula is put in wrong they might ALL show NA.

Also, dont forget to update your active item list.

One more tip, to save a backup, you can copy and paste the file in windows, and it will make COPY OF... or you can exit FULL SCREEN within MyCostPro and select SAVE AS from the menu to save it as a new file name.

8

Technical Support / Re: Year End Cleanup

« Last post by theparmans on December 28, 2019, 02:09:57 pm »

So if the column value is #NA the item was not found in the active list so it is assumed to be sold.

9

Technical Support / Re: Year End Cleanup

« Last post by Scott on December 28, 2019, 11:51:14 am »

Hi,  thats not a bad idea for a future update so the user can clean up their product master tab very quickly whenever they want...  I will look into adding that in the future.
In the mean-time, you have a few options depending on your comfort in using excel.

The easiest way would be to:

Refresh your active item list.
Add a formula to the right side of your Product Master data (either in an unused column, or add a new column header).
Place a formula [if you are using item title to match]  =match(C4, ActiveList!C:C,0)
[or if you are using SKU to match]  =match(G4, ActiveList!M:M,0)
Then add an auto filter, filter by #N/A
Select all rows, right click, select Delete (or select rows and hit CTRL -)

Just save first
Let me know if you have any questions or need further help.

10

Technical Support / Year End Cleanup

« Last post by theparmans on December 28, 2019, 10:26:52 am »

Is there an Excel Marco to cleanup at year end.  Clean Up would be to remove all sold items from the previous year from the product master. That way when the new year spread sheet is created it will only contain the products not sold instead of all products