Hi everyone. I have a request to modify the invoice to include one of the resource images that I have attached to each product. I have read through all of the prior mentions of invoice modifications but none seem to be entirely clear on how to do this.
I need to know what is the default location of an invoice.tpl to modify, and what MySQL table is the full data located in so I need to know if I need to add a sql view or something to pull the data forward.
Basically, the simplest version of the query that identifies the image is:
SELECT resource_path FROM `abe7_resource_map` A
LEFT JOIN `abe7_resource_descriptions` B ON A.resource_id = B.resource_id
WHERE sort_order = 2 and A.object_id = {product_id}
Any help would be appreciated.
Tim