I am currently using Stich (https://www.stitchdata.com/docs/integrations/saas/shopify) to automatically bring in Shopify data into a database. Because of this, there's not much I can customize...but from what I can see in the generated tables, if a customer used multiple payment types (e.g. part gift card, part credit card), there's no way to see how much the customer paid with each of the different payment types.
For example, when I look at one particular order where the customer paid partially with a gift card, the payement_gateway_names table does list gift_card, but in the order tables, the order is only shown as one row with the full order amount being paid by credit card.
Any help in finding a way to separate the order amount and attribute by the different payment methods?