Site structure
Version 5.x > Site structure > eCommerce - Extra field in COM_Order how to show on Invoice? View modes: 
User avatar
Member
Member
filip.beenaerts-gmail - 10/8/2010 8:18:42 AM
   
eCommerce - Extra field in COM_Order how to show on Invoice?
We added a new field in COM_Order which we fill with a generated string. This field is filled via a DB trigger (on insert & on update).

Now we want to show the value of this field on the invoice! How can we do this?
Can we use a custom macro and if yes how do we need to program? Or do we need
to make use of the CustomInfoProvider?

It's a little confusing since the invoice itself is stored as XML in a field of COM_Order so I guess that at the time of saving, this new field must already be available?


User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 10/12/2010 3:06:06 AM
   
RE:eCommerce - Extra field in COM_Order how to show on Invoice?
Hello,


Did you add the new field in Site manager -> Development -> System tables ?

If so, you can refresh the invoice in CMSDesk if you want to see updated values (you can fill out the value with delay). I would recommend you creating a custom macro for the new field like: Macro expressions. Then you can customize the layout of invoice in CMSDesk -> Tools -> E-commerce -> Configuratio -> Invoice

The invoice which receives the customer by e-mail is customizable in Site manager -> Development -> E-mail templates -> E-commerce - Order notification to customer .


Best regards,
Helena Grulichova