Extract Klarna Payment ID from Shopify

[VZIT]

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.

 

- 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!

[Jonathan-HA]

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):

Do you have an example showing the mismatch?

[VZIT]

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.

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 · 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.

[VZIT]

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

[Jonathan-HA]

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

[Report-Pundit]

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!