Csv export + change reference Klarna

[Sophie1999]

At the moment we are experiencing issues with the reference subject that is sent from shopify to Klarna in the API. (this was caused by a Klarna integration update gone wrong) Instead of our ordernumber, a URL link is showing in the Klarna platform with reference: 'information from the gateway'. Our financial department has to match orders with invoices based on a unique reference. Unfortunately, 'information from the gateway' is not included in shopify exports. This is an issue since that is the only reference we have on the klarna invoices at the moment. Is there a way to create exports in which we can include the 'information from the gateway' code?

https://shopify.dev/api/admin-rest/2022-04/resources/order

Besides this, we are looking to change the reference that is sent through the API to Klarna. Klarna has informed us that Shopify controlls the information that is sent through the API. If we could change the information that is sent (information from the gateway) into our ordernumber reference, then this would really help with our administration. 

https://docs.klarna.com/platform-solutions/shopify/payments/klarna-payments/

Please see subject: 'matching data fields across the Shopify and Klarna order' for more information. 

  

[Jonathan-HA]

Hey @Sophie1999 ,

Additional gateway information normally would be available in the Order Transaction API: https://shopify.dev/api/admin-rest/2022-04/resources/transaction

The available information in the Transaction API will vary depending on the gateway.

It's not possible to customize Shopify's standard order CSV export, but if you're open to using an app, our app EZ Exporter might be able to help with this.

I can't say for sure, though, if our app can pull that payment reference from the gateway until I inspect the transaction data from your store.

We do have a 7-day free trial so if you'd like to try it out, just contact us after installing the app and provide the myshopify.com URL of your store and we can then inspect the transaction data. If it's there, then we can help you extract it into a separate column in the CSV export.

[Sophie1999]

Hi Jonathan, Thank you for your response. Just to make sure I understand correctly, what you're saying is that Shopify is already sending the ordernumber information within the API. This would mean that Klarna has the ordernumber information and should be able to connect the ordernumber to the invoices, right? In that case, I would expect that Klarna already knows about that and would change the gateway information into the ordernumber. Klarna has mentioned that they are already in contact with Shopify to discuss this matter. Could anyone confirm this?

We will also take a look at the app and we'll get in contact after we've decided to install it.

[Jonathan-HA]

Hey there Sophie,

I was actually referring to the "Information from the Gateway" from your screenshot which *might* be available in Shopify's Order Transaction API.

I don't know what gets sent to Klarna's side from Shopify so I'm afraid I'm of no help here.

On our end, we can help you generate a custom CSV export that can include additional fields available in the Shopify API but not available in Shopify's standard CSV export.

Sorry for any confusion there!

[KristiAtKlarna]

Please also see hopefully helpful information about this at:

https://docs.klarna.com/platform-solutions/shopify/payments/klarna-payments/#matching-data-field-acr...

With the new payments app (https://shopify.dev/apps/payments), Shopify currently no longer allows integrations to set the authorization field or order number.