Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
How to create spreadsheet with Magento Order ID & Paypal Transaction Number
Stephen Maguire
Atlanta, GA USA
Member
March 16, 2015 - 8:08 pm
Member Since: May 20, 2014
Forum Posts: 184
sp_UserOfflineSmall Offline

I need to create a spreadsheet with order number and transaction ID. I’m pretty sure this is something I’d have to do in phpMyAdmin and I’ve looked at the tables but can’t find the relevant tables or data.

Anyone have an idea of which tables I should be look at?

Cheers,
Steve

Avatar
Dave Furness

Founder
March 22, 2015 - 11:05 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Hey Stephen,

Not sure if this helps at all, but stackoverflow seems to suggest this is where the orders are kept http://stackoverflow.com/quest…..ata-stored

Dave

Every expert was once a beginner

Stephen Maguire
Atlanta, GA USA
Member
March 23, 2015 - 1:03 pm
Member Since: May 20, 2014
Forum Posts: 184
sp_UserOfflineSmall Offline

Dave,

Thanks for the suggestion. I’ll take a look.

Cheers,

Steve

Avatar
Jim @ Moogento
Global

Partner
March 31, 2015 - 12:20 am
Member Since: November 7, 2013
Forum Posts: 688
sp_UserOfflineSmall Offline

Stephen, I don’t know if you have pickPack or not, but this is something you can export with that (in the ‘CSV Export’ section). You can make your own custom CSVs (for selected orders) and include the order id/pp transaction id (amongst others).

  • pickPack - smarter Magento packing sheets and warehouse picklists
  • shipEasy - process multiple orders with no sweat & get a visual sales overview easily

Stephen Maguire
Atlanta, GA USA
Member
March 31, 2015 - 11:15 am
Member Since: May 20, 2014
Forum Posts: 184
sp_UserOfflineSmall Offline

Jim,

Thank you for providing a solution.

I do have PickPack and ShipEasy. Setup the report last night and it provided exactly what I need.

Thanks a million.

Steve

Avatar
Jim @ Moogento
Global

Partner
March 31, 2015 - 11:33 am
Member Since: November 7, 2013
Forum Posts: 688
sp_UserOfflineSmall Offline

Hi Steve

Awesome, I love that kind of feedback :)

Great to hear that it’s working well for you!

Jim

  • pickPack - smarter Magento packing sheets and warehouse picklists
  • shipEasy - process multiple orders with no sweat & get a visual sales overview easily

Avatar
Dave Furness

Founder
March 31, 2015 - 8:38 pm
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

Happy Days!

Every expert was once a beginner

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
34 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5221

Posts: 27486

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606