Order Attributes Null even though data is present in database?

Shopware 5 Programmierung
#1

I want to edit my email template of order confirmation from the backend and use the given variable from the variables column. But it shows the value of every order attribute null in the backend. The record present in the variable column is of the most recent order, and I have some records of my custom attribute column named “order_comments”  in the “s_order_attributes” table. I want to use the “{$attributes.order_comments}”  variable but since it’s showing it’s value null I cannot see any data in it.

Below I have attached images.

The image of the backend email template.

http://prntscr.com/ncl4ps

 

Image of the database custom attribute field.

http://prntscr.com/ncl7c0

 

#2

Have you already created an order after creating the attribute? The mail context on the right is only updated when you sent the mail via the process it is normally send with. In your case an order in the frontend.

1 Like
#3

@Moritz Naczenski schrieb:

Have you already created an order after creating the attribute? The mail context on the right is only updated when you sent the mail via the process it is normally send with. In your case an order in the frontend.

Yes I have made an order and also filled the order_comment field. As you can it in the image I have provided of the database. I then refreshed it and again checked it

 

#4

I know this thread is a bit old but I am facing the same issue but with s_order_details_attributes.attribute1 - 6 fields. The variable examples on the right show “null”, the preview shows nothing and when placing a new order, the data is also not populated. It is definitly in the database.