Edit History

Hi

I have a text custom field (required) on product page.

I need that custom field show in orders list, and in SQL manager as well

PS version - 1.6.1.18

This is my SQL comand

SELECT d.id_order AS ID_Registo, o.reference AS ref, os.name AS Estado_Pagamento, o.date_upd AS Data, ai.company AS Matricula,  CONCAT_WS(  ' ', g.firstname, g.lastname ) AS Nome_Cliente,  CONCAT_WS(' ', ad.address1, ad.address2, ad.other, ad.phone, ad.phone_mobile) AS Morada, ad.postcode AS Cod_Postal, ad.city AS Localidade, CONCAT_WS(' ', ai.address1, ai.address2, ai.other) AS Morada, g.email AS Email, ai.phone AS Telefone, ai.phone_mobile AS Telemóvel
FROM psha_orders d
LEFT JOIN psha_orders o ON ( d.id_order = o.id_order )
LEFT JOIN psha_customer g ON ( o.id_customer = g.id_customer )
LEFT JOIN psha_address ad ON (o.id_address_delivery = ad.id_address)
LEFT JOIN psha_address ai ON (o.id_address_invoice = ai.id_address)
LEFT JOIN psha_group_lang gl ON ( g.id_default_group = gl.id_group )
LEFT JOIN psha_order_state_lang os ON ( o.current_state = os.id_order_state )
WHERE os.id_lang =1
ORDER BY d.id_order DESC