Show Posts

Messages - Tim Norton

Pages: [1]
Thank you.  As soon as I have some bandwidth I'll put something together.


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 / Re: How to add Product Limits by Customer
« on: May 07, 2020, 04:34:51 PM »
Thanks Maxter. I will look at that feature.  I haven't utilized locations, as the farmers are really just customers who are ordering from one location.  But I'll see if it can be hacked into a solution.

Thinking out loud here (or out typed?):

What I was thinking was to build a quick MySQL table extension to capture worker counts per farm.
I would then look to see if I can build a product selection extension to take the value in the Maximum Selection field and build a new Maximum Selection calculation:

Ie. (`Maximum Selection` * Workers).

If Locations helps with this, then great.  If not, I'll give myself a crash course in PHP to see if I can build this myself.  I'm more of a Java/C# guy....but if anybody has any ideas that would make this more efficient I'm happy to chat.

As I noted before, this is a Volunteer run aspect...I'm making no money out of it, other than for my business being acknowledged on their website.  If anybody offers to help I would ensure you get similar credit (and rights to resell the idea).  I can't post the link due to forum rules but reach out and I can share details.

Tips and Tricks / Re: How to add Product Limits by Customer
« on: May 06, 2020, 09:28:41 PM »
OK.  So, they want to set limits on how much of each product can be ordered from the warehouse at any one given time, based on the amount of workers they have on hand.

So, one farmer may have 5 workers, and the other may have 20.  Therefore, the second farmer should be able to select a maximum of 4 times the amount as the first.  Does that make sense?



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