Extract Klarna Payment ID from Shopify

Solved

Extract Klarna Payment ID from Shopify

VZIT
New Member
4 0 0

Hi all!

 

Shopify has recently changed its way to work with Klarna and is not providing any longer a way to match Klarna payment with the Shopify order ID. Basically when you download the transaction records from Klarna payments interface, there is no longer the order ID (e.g. #1234) under the column "merchant reference 1", but just a reference code. 

 

There are two ways of matching this code with the order ID in shopify: 

- manually: you open every single order in Shopify and expand a row in the timeline to reveal the Gateway and the payment ID. Then you have to manually copy/paste the code into a spreadsheet to match it with the Shopify order ID. With hundreds of orders, it's very likely to make a mistake.

 

Immagine 2022-08-23 105720.jpg

- export order list from Shopify. The output is a .csv file. The problem is that the Klarna code is not copied in the same line as the order ID, but under it. This is unworkable in a spreadsheet. The columns headers and the data are totally mismatched.

 

So the QUESTION is: is there a way to extract these data from Shopify so I can have a clear match between the Order ID and the Klarna payment on a spreadsheet?

 

PS: I tried with Zapier but the Klarna reference code is not available from there...

 

Thanks!

 

Accepted Solution (1)
Jonathan-HA
Shopify Partner
325 25 100

This is an accepted solution.

Hey there @VZIT ,

 

Have you tried opening the CSV file with Google Sheets?

 

One thing I'm wondering about is whether your spreadsheet software is not parsing the CSV file correctly due to some setting.  It looks like a bunch of other fields got moved to the next row during parsing.

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill

View solution in original post

Replies 6 (6)

Jonathan-HA
Shopify Partner
325 25 100

Hey there,

 

For this part:

 

"- export order list from Shopify. The output is a .csv file. The problem is that the Klarna code is not copied in the same line as the order ID, but under it. This is unworkable in a spreadsheet. The columns headers and the data are totally mismatched."

 

I did a quick test on our test store and I do see the Payment ID column there and the rows do seem to match up for me (though I don't have any order that uses the Klarna gateway but there are values there that are placed in the correct row):

 

JonathanHA_0-1661250364558.png

 

Do you have an example showing the mismatch?

 

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill
VZIT
New Member
4 0 0

Hi, thanks for replying!

This is a screenshot of what I get as "orders_export.csv" from Shopify, after running the "text to column" function.

 

Immagine 2022-08-23 170000.jpg

I'd need the highlighted values on the same line. The "nKvloU0m..." code is the only key to match the Shopify order ID with a line in the Klarna payout .csv file that I download from their portal.

 

I can do it manually of course, but, it would be prone to errors.

 

Jonathan-HA
Shopify Partner
325 25 100

This is an accepted solution.

Hey there @VZIT ,

 

Have you tried opening the CSV file with Google Sheets?

 

One thing I'm wondering about is whether your spreadsheet software is not parsing the CSV file correctly due to some setting.  It looks like a bunch of other fields got moved to the next row during parsing.

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill
VZIT
New Member
4 0 0

Yes, it works! I had never thought it could be the software... Thank you so much!

Jonathan-HA
Shopify Partner
325 25 100

You're very welcome @VZIT , happy to help! 🙂

Co-Founder / Developer at Highview Apps
Our Shopify Apps: EZ Exporter | EZ Inventory | EZ Importer | EZ Notify | EZ Fulfill

Report-Pundit
Trailblazer
325 11 22

Hi @VZIT ,

If you are still looking for a solution then, Report Pundit reconciles the Klarna transactions and Shopify Sales. Once you integrate  Klarna with Report Pundit it allows you to retrieve information such as Payment reference, Payout date, Sale Amount, Tax Amount, Settlement Amount, and many other fields.

You can reach us at support@reportpundit.com

Thanks!

Report Pundit - Instant reports and custom dashboards