Easy way to keep track of products sold?

[cjenkins08]

I currently sell a single item in various quantities. At the end of the month I go to history > basic search > payments received and print that report.  From there I paste the report into excel and total the Payment Column and the Fees Column.  I can then easily write in the number of products that were sold on each line.

Example: If I see 4.99 I know that 1 was sold,  If i see $19.99 I know that 10 were sold on that order.

I then add the number of items sold to come up with my cost basis.

My question is, I will soon be selling two new and different products that sell for different amounts.  What is the easiest way to keep track of the 3 different items being sold?   It seems doing it the way I am above would not work well as I would have to print the Payments Received Report, then find each order and see what was sold.

How does everyone else handle this?

Thanks

[snowshoe]

One method that works well for others is to export your transaction history to a CSV file, then you can use an application like Excel to sort and manage your data.  See this user guide for tips:

https://www.paypalobjects.com/webstatic/en_US/developer/docs/pdf/pp_merchantsetupadministrationguide...

[cjenkins08]

I have played around with what seems like all of the reports, and I still don't see an easy way to show which particular items were sold.

There are people who sell 1000s of different items in one store, which reporting do they use to track the individual items that were sold.

Which report will display the payments received and the item id or ids associated with each payment.

Thanks

[snowshoe]

We export our data and use Excel to manage it.  (works great for us)

[cjenkins08]

I understand that data can be exported to excel, but I've yet to find a report that will transfer out each item id purchased.

Could you possibly explain the process used a bit more in detail.

Example

John Doe buys product  ID123 and ID124 and this happens 100 times out of the month with the item ids varying.

How can I generate a report in a Paypal that will list the transacation and the item id/ids that were sold with each transaction without me having to manually go back in and look at each transaction to get the item that was sold.

[snowshoe]

Unfortunately what you're looking for is not there, thus the export method.  Note, the Report feature has improved quite a bit since the beginning but, it's not yet the one size fits all solution.