BACKGROUND
I have an online store. Previously, I used PayPal “Buy it now” buttons, and I had a button for each product. I would then periodically export the data from PayPal (download history as CSV) and it would have the following field/value pairs:
Item Title: Type of product (e.g., Nintendo DS)
Option 1 Name: Type of product (e.g., Nintendo DS)
Option 1 Value: Color (e.g., red)
Users were limited to ordering one item per order. I used this information to analyze what are the top selling products/variations in the store in Excel, and I have a few years of historical data.
DRUPAL COMMERCE
I recently moved the store to Drupal Commerce, although I am still using PayPal for payment (PayPal Payments Standard/WPS) via the Commerce PayPal module. This works very well, and users are still limited to one item per order. However, when I export the transaction data from PayPal, it now looks like this:
Item Title: Shopping Cart
Option 1 Name: null
Option 1 Value: null
Is it possible to set the Item Title and options somehow during checkout with Commerce? If not, how can I analyze my new sales data in Excel in a way that is (at least mostly) consistent with the years of PayPal exports I already have?
Sponsored by SupremePR