Show Posts

Topics - Tim Norton

Pages: [1]
Hi folks.

One of the components that I have needed to change for a client is the Sort order of products on Invoices.  I just thought to share that I have managed to do this on both the Admin Invoice generator and on the function that generates the e-mails that go to both the admin and the customer.

The ones for admin is in the order.php located at: admin\model

The one for the e-mails is in the order.php located at storefront\model\checkout

I have temporarily just modified the sql code located in the php files but I intend to build a more concrete framework.

I have also developed features to include barcode or other images on the product level of invoices.

If anybody needs some assistance let me know.

Tim Norton

Templates / 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.


Tips and Tricks / How to add Product Limits by Customer
« on: May 03, 2020, 11:22:09 AM »
Good morning everyone.

I am working with a farmer relief effort, where there will be a volunteer run "store" - basically a distribution center, that will be used to help feed workers brought in to work farms that have been hard hit financially.  We will have a couple hundred products that the farmers will be able to select, but we need to ensure there products are selected fairly based on the amount of physical workers they have available.

Is there a way that I can add a Ratio Based Maximum stock pick.  So, if one farmer has 4 workers and another has 10 then the maximum items selectable is different?

Appreciate any advice I can be given.  This is a 100% volunteer run effort.


Tim Norton

Pages: [1]

Powered by SMFPacks Social Login Mod