Author Topic: Updating invoice template for stockpick  (Read 1577 times)

Offline Tim Norton

  • Newbie
  • *
  • Posts: 6
  • Karma: +2/-0
    • View Profile
Updating invoice template for stockpick
« on: May 10, 2020, 11:24:48 PM »
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

Offline maxter

  • Full Member
  • ***
  • Posts: 181
  • Karma: +60/-0
    • View Profile

 

Powered by SMFPacks Social Login Mod