Adding Product Product Property fields to Ustore Receipt and Check out page

[dan lixie]

Hello, does anybody have a roadmap on how the add a variable to a store receipt?

Currently my receipt just says the Product name and number of items.

I am selling shirts that come  in sizes S M L XL 2XL and 3XL in a product property dropdown. How could I show that value on each line item of the receipt.

There is some info from 2020, but all the examples have been deleted.

Any help would be truly appreciated.

[Rebecca Brooks]

Hi Dan, 

Unfortunately, there is no way to add product properties and their values to the uStore receipt. I did submit a feature request to our uStore Product Manager to have this considered in a future uStore release. 

We can add product properties and their values to the order confirmation email template. Please reach out to XMPie Support if you need assistance modifying the message template. 

Have a good day,

Rebecca

[Wayne]

Hi Dan,

Technically yes you can add the product properties to the Order Receipt.

First look at the SQL SP Receipt_GetOrderItmesTable - create a new SP to get the items and properties you want.

I recommend you create a sql function to get the Dial Property values

Fully test your SQL SP in SSMS to ensure correct HTML is created.

The receipt uses the TextCompositionParameter Table you will need to add a new entry to make your parameter available like OrderItemsProps 

Then you should be able to add the item  OrderItemsProps to the Store Receipt.

Regards,

Wayne