What do the prefix and suffix mean in the "Payment Reference" data in the Shopify CSV order export?

Retired Boards Appdev Customers Discounts And Orders
1

Hi guys,

In Shopify’s default CSV order export, there’s a column called “Payment Reference” which is the checkout ID.

This data is not available in the Order API but shows up in the Order Risk API under the field checkout_id. However, the API only returns the numbers but the Shopify CSV has a prefix of “c” and a suffix of “.1” (or .2, .3 sometimes).

Does anyone know what determines the suffix of .1, .2, .3?

Thanks!

2

It seems to be the number of times that the user tried to pay with a card, that is the number of failed attempts plus 1.

1 Like
3

Hey Butters,

That does seem to be the case, thank you!