Need someone who actually knows Zen Cart. This is a small tweak; probably just a couple of lines of code at most.
I have a small file used to create an "order pull list" in my zen store. The code isn't particularly clean but it works. I want to add the products_model number from the products table (not from the orders table!) after the product name in each order. It will be placed where the *** is currently between the ( ). The file is attached.
The data must come from the products table because we'll be using the products_model number for warehouse location purposes and the number may change from the time the order is placed and the time it is fulfilled. Pulling the products_model number from the orders table could result in outdated warehouse location information.
I will not give FTP to my store so you must do your work in your own test store. The completed project will be the file properly edited with the necessary line or lines added. I know this is a simple job for the person who knows how to make the proper query. Please bid accordingly.