Topics

1

MyCostPro Updates and Version History / New version released (fix) - 1/23/23 - v.20230123.1

« on: January 23, 2023, 10:26:50 pm »

When I released the last update there was a mixup where I was updating a slightly out of date version, so some of the updates from the previous release were "undone".
This is resolved and available for download now:
 - P&L reports updated to include all relevant fees (again) including ad fees, etc.
 - Version note added back to top right of homepage above our logo.
 
New Feature added this version as well:
 - Option for commission client sliding rate to be calculated on "Incremental" or "Highest Rate".  Incremental pays each rate as it progresses in price (recommended), Highest Rate charges a flat rate at the selling price level.

2

Frequently Asked Questions / How to start a new blank file with only the current year

« on: January 16, 2023, 02:58:33 pm »

1. Download the latest version of MyCostPro at https://mycostpro.com/download

2. Set your settings as you prefer on the settings tab; make sure to set the UTC offset to your timezone so the sales will come in matching the time that you sold them.

3. In the Settings tab, set the number of days to go back slightly past the beginning of the year.  (If you have already downloaded a full 90 days, thats OK, move to the next step)

4. Delete the sales from the previous year by carefully following these steps:
  - Click the black FULL SCREEN button near the top right, this will display the row numbering and ribbon bar, etc.
  - Select the row, or multiple rows (be sure it is selecting the entire row(s) by selecting from the row numbering area.)
  - Right click one of the row numbers that you have selected, pick 'Delete' from the drop down list

3

MyCostPro Updates and Version History / New version released (performance improvement) - 1/15/23 - v.20230115.1

« on: January 15, 2023, 06:24:05 pm »

Some users were experiencing performance issues (program wide) related with the ACTIVE X drop down boxes that were on the report tabs (to select month and year for reporting).
They were replaced with standard excel data validation lists, the down side being that two of the reports need to hit a button after selecting the year, but even for users who hadn't noticed, this should significantly improve performance.  The new file is NOW LIVE for download:

Download with your download key and user ID at:  https://mycostpro.com/download

MyCostPro  (New file needs to be downloaded for new features)
 *  ACTIVE X drop down menus for Year and Month on reporting tabs replaced
    - Potentially significant performance improvement sheet wide if you are experiencing unexpected slowdown.
 *  Added MyCostPro version to "note" above the MyCostPro logo on the Home Tab. (hover over red triangle to view)

Server and API changes (New MyCostPro file not required.)
 * Added support for eBay Standard Envelope cost and tracking
 * Added tracking to International Shipping that was not previously available.  (API note, some international shipping costs are still not provided through the current APIs)
 * Added logic to adjust Refund and Partial Refund FVF amounts when it is not being properly returned from API.
 * Corrected Active Item Variation Quantities and BIN price when it was repeating value from initial Listing.

Let me know if you have any questions, thank you!

4

General Discussion / Requesting help from one of you kind users!

« on: January 08, 2023, 01:05:22 pm »

I hope everyone's new year is going well!
I am looking for a user who is willing to let me make a video using their download data to show of some of the more recent features.
(I haven't been selling on eBay lately so I can't use my account)
I would take care to not show any of your customer's information (user names) etc, and I would only show fake COGS and profit results, etc.

Just let me know by replying here or emailing me at support@mycostpro.com

Thank you!

5

Frequently Asked Questions / How to delete sales entries

« on: January 06, 2023, 04:04:33 pm »

To delete sales entries, or any downloaded data in MyCostPro, please follow these specific steps.

Click the black FULL SCREEN button near the top right, this will display the row numbering and ribbon bar, etc.

Select the row, or multiple rows (be sure it is selecting the entire row(s) by selecting from the row numbering area.)

Right click one of the row numbers that you have selected, pick 'Delete' from the drop down list


Let me know if you have any trouble or questions about this!

6

MyCostPro Updates and Version History / New version released - 1/3/23 - Available now!

« on: January 03, 2023, 04:50:40 pm »

Hello everyone, and Happy New Year!
We have just released a significant update which is NOW LIVE for download:

Download with your download key and user ID at:  https://mycostpro.com/download

MyCostPro  (New file needs to be downloaded for new features)
 *  Client Commission Support added
    - Setup screen allows user to set various options including how to pair the client by SKU, etc.
    - Calculated commission and client information is automatically added to sales list tab
 *  Mileage Tracking screen and yearly summary added
 *  Replaced Performance Snapshot with more powerful and flexible PRO Query screen
    - See filtered results to match multiple criteria, view summary and itemized list if needed
 *  Changed characteristics of how the download duration days are updated (simplified)
    - Changed default duration to 90 days instead of 7
 *  Added additional line item details to all of the various reports and P&L statements
 *  Added additional options for BULK SHIPPING (located in the Account Info / Settings tab)
    - Add bulk shipping transactions to the sales transaction tab (only previous option)
    - Send bulk shipping transaction information to the EXPENSE TRACKING tab (separate from item sales tab)
    - Ignore bulk shipping transaction information (do not import) - if user prefers to enter manually
 * AD FEEs will now tie directly to the individual Transaction instead of the general listing.  A new column was added for these.
 * All VBA macros are now code signed with a Microsoft-trusted provider, allowing for more granular policy control for security-focused users.
 * Replaced 'Click Layout Assist' fucntion with updated Hide / unhide 'h' column button

Server and API changes
 * We are continually adapting to eBay API changes and optimizing for enhanced speed of download, additional data points that can be retrieved, etc.  These continuous changes throughout the year do not require a new file to be downloaded.

Thank you so much for everybody's feedback in making these changes!
Let me know if you have any issues with the new file.

7

Current Events / Happy New Year 2023!

« on: December 31, 2022, 02:28:28 pm »

All -
Just to give you a heads up we are about to roll out a pretty big update to the MyCostPro file.
Normally we try to make all of our changes behind the scenes (server-side) but this update adds several new features and improvements to the existing file, so it will require a download to see the new stuff.
I will make a detailed update post as soon as the file is available, HOPEFULLY it will be finalized by New Year's Day, but it is possible it could be pushed back a day or so (I will explain more in the update post when I make it)

I just wanted to give you a heads-up incase you are about to start working on the new year's data, you might want to wait a day or so.

I hope everyone had a successful 2022!

Scott

UPDATE:  This will be released SOON, but not tonight, I apologize for the delay.

8

Technical Support / Trouble with your shipping cost information?

« on: December 30, 2022, 11:17:36 am »

Here is the status of shipping cost information with the new eBay APIs.


1.)  Bulk Shipping (w/ multiple shipments) - The new APIs do not contain the item transaction information paired with the individual cost of each shipment.  It only includes the total and the transactions that make up the bulk shipment.  To account for this information we have included a separate line item in your sold item tab as we cannot accurately put them in the individual row of each sale. 
  * With the newest update (January 3rd, 2023) the user can choose to send these bulk costs to Expense tab, Sold item tab, or Ignore them completely. *

2.)  Paying for shipping with PayPal - The new API will NOT return shipping costs if the shipping is paid for out of your PayPal account.  You can adjust this at the bottom of the page where you pay for the label, choose the option to pay with ebay account balance.


3.)  Non-USPS shipments (Fedex, UPS, etc) - These shipments will return the shipping cost, but it will not return until after the label is scanned and used;  Ebay treats all non-USPS shipping vendors as 'pay on scan' and USPS as 'pay on print'.  If your non-USPS shipment is missing shipping information, you can reset the download duration to go back far enough to cover that sale, and re-download sales, and it will populate the missing shipping cost (assuming the label has been scanned and used).


4.)  All other shipments (including bulk shipment with single item) should return with no issues, so please let me know if you have any issues not mentioned in 1-3 above.


Additional Background -

We (and most developers that utilize the eBay APIs) used to gather the shipping cost information through the 'selling manager' API.  EBay deprecated the 'selling manager' API and now only provides the shipping cost information through their newer 'Finances' API which comes with the restrictions mentioned in 1-3 above.
We have been in contact with the eBay Developer Support team about these issues and they have internally created a 'feature request' ticket to address #1 (above).  They have provided feedback that #2 & #3 (above) are functioning as intended.

9

MyCostPro Updates and Version History / Bulk Shipping Update (re: eBay Shipping API update) - 11/19/2022

« on: November 19, 2022, 05:18:28 pm »

As many of you know, the eBay API used for shipping was deprecated, and a new API took its place that is not fully functional.
The current API does not always return item transaction information in order for us to link the shipping cost to a specific sale, and it NEVER returns transaction information for bulk shipping.

The eBay Developer Support team has responded indicating that they have escalated to development support requesting additional API functionality to fix this, but they did not give any time frame for a resolution.

In order to provide as much information as possible for your (our customers) downloads, we will be creating a line item for the  BULK SHIPPING amount, which will include the sum of all of the items shipping costs for that transaction.
Since we cannot break the amount out accurately for each item, we will lump them together as a row in your sales download.

We anticipate this change to roll out the evening of 11/19/2022.

If anyone has any questions or concerns about this update, please let us know as soon as you are able.  Thank you for being loyal MCP customers!

10

MyCostPro Updates and Version History / Shipping API update - 10/27/2022

« on: October 28, 2022, 05:45:06 am »

Thursday evening we updated the source for shipping cost data to match changed made by eBay.  Let us know if you see any issues!

If you have recently had missing shipping information you can now reset your download duration and it should populate now.
  * Go to the Account Info / Settings tab
  * Input the number of days to go back to cover the missing shipping
  * Click the 'reset duration' button
  * re download your sales

11

MyCostPro Updates and Version History / August 2020 minor update - 12 digit Order Number now returns with your sales

« on: August 06, 2020, 05:35:12 am »

MyCostPro will now include the 12 digit Order Number xx-xxxxx-xxxxx in the Transaction details of your sales (no download required if you unhide the column in the Transactions section).

A new version of the MyCostPro download is available where the column will be visible by default.
- This download also fixed bug that prevented all "x" marked Active Listings from transferring to Product Master if you had over 1,000 Active Listings

As always, you can get the newest version here with your download key and user ID:
https://mycostpro.com/download

12

MyCostPro Updates and Version History / Memorial Day update released! -5/25/20- New version available for download now!

« on: May 25, 2020, 09:06:11 am »

MyCostPro Memorial Day update (5/25/2020) - Live now

 * Button added to Active Listing page to send specified Active listing items to the Product Master tab (See tutorial below)
    - Place an X in each row you want to send to the Product Master tab, click the button to send them

 * Overall streamlining of internal calculations, especially changes to the widget calculations
    - Should improve speed during navigation on very large MyCostPro files

 * Default settings added in the Account Info / Settings tab
    - Full Screen OFF will prevent automatically entering Full Screen mode when MyCostPro starts
       (Full Screen mode hides ribbon bar, and column and row labeling to make more visible room for your eBay data)
    - Currency setting will update the whole sheet to various currency symbols, or remove them.  Click the apply button after selection...
    - Widget calculation mode can be set to auto, or on-click only.  (On click mode will prevent calculating the widgets until the refresh button is hit to prevent excessive calculations in the background)

 * Reporting improvements
    - 12 month Total added to yearly report chart
    - New widget drop down selections added for 'yesterday' and '7 days'

* Click-Layout-Assist button will default to OFF upon re-opening MyCostPro file
    - This mode being ON can negatively impact performance as well as clip-board functionality, and should only be turned on to quickly change your page layout, and then back OFF.


To download the update just put your userID and download key in at:
https://mycostpro.com/download

Post here if you have any questions about the update!

13

MyCostPro Updates and Version History / Listing Date now returns for sold items and new MCP file available 11/9/2019

« on: November 09, 2019, 11:40:55 am »

Today we released an update that will fill in the Listing Dates on the sold item tab.  (As requested in the "Feature Request" section of the forum)
This change is live now, and will work in your existing file, but please note the following:

* The "Listing Date" (column G) is hidden by default. 
* The default formatting of the column is set to "Generic", so the formatting doesn't "look" like a date (but it is)

If you want to see Listing Date we have a new version of the sheet available to download that takes care of everything, or if you want to keep your existing file simply follow the steps below.

To hide/unhide columns on sold item tab
 - Click the "Click Layout assist:" button so that it reads ":ON"
 - Click the double triangle above the vertical column bookmark for "Listing"  (scroll all the way to the left of the sold item tab to find this)
 - Delete the "h" above "Listing Date" and any other columns that you want to be displayed by default, add an "h" to hide any
 - Click the double triangle above the "Listing" column bookmark again (to toggle hide)
 - Click to turn "Click Layout Assist:" button back to "OFF" (leave this off whenever not in use)


To Change the formatting to display as a date
 - Click the FULL SCREEN button (this will display the standard excel ribbon bar menu).
 - Right click column G column header (right click on the "G")
 - Select "format cells..." from the drop down
 - Select Date format and select which one you like from that list
 - Click the FULL SCREEN button again to maximize your MyCostPro display area

14

MyCostPro Updates and Version History / MyCostPro now receives Managed Payment Fees

« on: October 06, 2019, 10:18:59 am »

We are pleased to announce, that effective immediately, eBay Managed Payments will be available with the rest of your data and seamlessly integrated into the "Paypal Fee" column.
For PayPal users that have not yet made the switch, rest assured this will in no way affect your data, it will continue as always getting the Paypal fees.

As this update was made to our servers, users will not need to download a new MyCostPro file
Note: Future downloads will see the "Paypal Fee" column header renamed to "Payment Fee" to more accurately describe it's contents.

If you would like to get missing Managed Payment data for up to the past 90 days simply follow the steps outlined below.
Please save first if you are not familiar with using excel, and if you need help don't hesitate to contact me at support@mycostpro.com

Note:  By design, MyCostPro will not overwrite values that are already in the Sold Item tab.  This includes "0".

Step 1 (Delete the zeros currently if there are any in the paypal fee section from when you started Managed Payments)
  -Starting with the first sold item's paypal fee, (which you can tell because it will be "0")
  -Left click and drag to select all of the fees which have "0"
  -Hit the Del (delete) key on the keyboard  -OR- Right click and select "Clear Contents"  (Do not select "Delete..." from the list!)

Step 2 (Update your previous sales to get the Managed Payment Fees)
  -On the Account Info tab change the number of days to go back far enough for these sales.
  -Click the "Apply Duration" button
  -Re run your Sold Item download

15

Frequently Asked Questions / Useful links for MyCostPro

« on: September 17, 2019, 04:02:18 pm »

Purchase (sign up):
   https://mycostpro.com/purchase/

Change subscription (add/remove accounts, powerseller speed upgrade, etc)
   https://mycostpro.com/change-subscription/

Free 2 week trial of Powerseller speed upgrade (automatically reverts back, does not change your billing)
   https://mycostpro.com/speed-upgrade-trial/

Cancel subscription (sorry to see you go!)
   https://mycostpro.com/cancel-subscription/

Check eBay token status / renew eBay token
   https://mycostpro.com/ebay-token-status

Retrieve your download key to your PayPal email address
   https://mycostpro.com/forgot-download-key/

Contact us
   https://mycostpro.com/contacts/

Direct support email
   support@mycostpro.com

Download MyCostPro file (get the latest version, you can download at anytime while subscribed)
   https://mycostpro.com/download/

Check the MyCostPro server status
   https://mycostpro.com/mycost-server-status/

TUTORIALS
   https://mycostpro.com/getting-started/
   https://mycostpro.com/getting-started-2/
   https://mycostpro.com/faq/
   https://mycostpro.com/tutorials/