After a gift card product is purchased the details of the gift card order are saved to the “Smith_GiftCard” table:
[ProductID]
[OrderID]
[GiftCardCode]
[GiftCardName]
[GiftCardSubject]
[GiftCardMessage]
[SenderCustomerID]
[SenderDNNLogin]
[ReceiverCustomerID]
[ReceiverName]
[ReceiverEmail]
[InitialValue]
[RemainingAmount]
To pull gift card data by order line you will need to join on the Smith_StoreOrderDetails table with the Smith_GiftCard table on the following fields:
•OrderID
•ProductID
You can also view the details of the gift card transactions by doing the following:
1. Navigate to your BuyNow module and select “Gift Cards” from the Store Admin Menu as follows: