Author Topic: Non eBay Sales  (Read 20093 times)

Toadzworld

  • Newbie
  • *
  • Posts: 1
    • View Profile
Non eBay Sales
« on: January 14, 2018, 07:09:15 pm »
Is there a way to add non eBay sales to the sold list? If not that would be a nice feature as I do not have all my products listed on eBay but they are all the same business.

Thanks

Hunter

  • Administrator
  • Newbie
  • *****
  • Posts: 36
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: Non eBay Sales
« Reply #1 on: January 14, 2018, 08:21:12 pm »
You should be able to add your own info to the sold table, butt there are a few columns that must be populated in order for it to work properly.  I'm not sure of those specifics, so Scott will have to give you a more complete answer a little later.  He's out to dinner, and his phone doesn't get along well with forum replies. He should be back here tonight with a more complete answer for you.

Scott

  • Administrator
  • Sr. Member
  • *****
  • Posts: 438
  • https://mycostpro.com
    • View Profile
    • MyCostPro
Re: Non eBay Sales
« Reply #2 on: January 15, 2018, 08:21:11 am »
As Hunter mentioned, YES you can input sales that are not from eBay manually, as long as all of the required fields are filled in.
The obvious ones of course are your cost of goods, shipping costs, how much you sold it for, etc... 
The important one that is not obvious though is the Item/Transaction ID(unique) which is in Column B and hidden by default.  It is populated by an always unique value from eBay and the sheet uses it internally in several processes.   

To display the hidden column(s) turn ON the "click layout assist" button.
Click the double triangle above the "Listing" blue vertical bookmark column separator.
If you want to permanently display the Item/Transaction ID(unique) column, delete the "h" above that column.
Click the double triange again to rehide the unwanted columns.
Turn OFF the "click layout assist button" (should be kept off when not in use, as it can slightly affect the sheet's responsiveness/speed).

You can fill this column in with any value, just make sure it is always unique (not duplicated with another row).  So you can make them 100000, 100001, 100002, (etc).

william_b_noble

  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: Non eBay Sales
« Reply #3 on: April 23, 2023, 08:14:31 pm »
it would be very helpful to have non-ebay sales, particularly from Paypal brought in.  And to automatically correlate ebay expenses with Paypal expenses (when ebay charges shipping to paypal, for example)