Printable View
I find the finding of PO very cumbersome currently if I look it is a list of about a hundred pages the highest (and therefore hardest to get to) are the current ones. Can the sort be reversed or otherwise is there a better way to search?
I also tried the advanced search and that does not seem to work for the given order number. So, if I search order 895 it gives me nothing.
This speed seems to be working better now. Probably hosting.
I am also getting this error - can you tell me how you fixed it? Thanks!Quote:
Originally Posted by jderrers
fotofx - The mod already does this for you. Just check all the items for each order and send it at the same time. Each item from the same order will be grouped together into one email. You can even send all your orders at once -- Just be sure to wait while it sends several emails!
Example:
Order 1
1 Widget
2 Cats
Order 2
1 Cat
1 Dog
Check all products to send to your one contractor. It will send the following PO emails:
Email 1 for Order 1
including 1 Widget and 2 Cats
Email 2 for Order 2
including 1 Cat and 1 Dog
JimmyV - This mod wouldn't affect the speed of your site. I also don't quite understand how you are searching for orders. There is no option to do so in the Enter Tracking page. The only place you can search for an order is on the resend PO page. I'll see if there is an easy way to reverse the order on the tracking page, and if there is, I will include it when I release the next version.
brenballa - Are you sure you copied the files to right directories? pdfpack.php should be in your admin directory. All the files that come with fpdf should be in your admin/fpdf directory, except for the fpdf fonts, they should be in admin/fpdf/font.
Hi Gang,
I have the mod working excellent. Is there an easy way to tweak the code so that we can assign a separate shipping method to every Sub Contractor (and obviously to reflect that in a mixed cart)?
thanks
gabstero
SRTURNER47
Thanks, Your right.. even though it shows multiple PO's it is only sending one to the vender. Appreciate all the help. If anyone is integrating a cart to work with adult-wholesale.com drop me a line and I will be happy to give you my modified send_pos.php to get it working.
Steve
gabstero - sure. Just change the part that replaces the shipping method and add an if statement for each of your subcontractors. Example:
change line 443-448 of send_pos.php from
toCode:if ($tmpt[0][7] != 'Cheapest Shipping Method') {
$newzawartosc = str_replace("{shipping_method}",$tmpt[0][7],$newzawartosc);
} else {
$newzawartosc = str_replace("{shipping_method}",'Cheapest',$newzawartosc);
}
Add this for every subcontractor. Replace 2 with your subcontrator's id number. Replace Ship This Via My Way Express with their shipping. Of course, all items will go this way for this subcontractor using this method. You can get as fancy as you want to with your if statements to make this do what you want.Code:if ($subcontractor['subcontractors_id'] == 2)
$newzawartosc = str_replace("{shipping_method}","Ship This Via MyWay Express",$newzawartosc);
NEW VERSION - 3.0 Available! Just uploaded to Zen Cart, so it may take a few days to show up. Here's the link
LINK
Changelog:
*****************************
V3.0 CHANGELOG
*****************************
1) Created a way to send purchase orders to customers that are not in your database. This is great for phone orders, ebay orders, etc...
2) Added the ability to review a purchase order before sending it. This allows you to make changes that are specific to one subcontractor...or just simply change stuff on a P.O. any time before sending it.
3) Added several options to the database to give this mod more flexibility and decrease the effort needed to make this mod do what you want. Here are some notable additions to the database:
- Change a shipping option automatically. For example, you can make a shipping option read "Cheapest" on the P.O.
- Omit things from the P.O. when sent to a customer who is not on Zen Cart.
- Edit messages to customers when PO is sent and when packages ship.
- Edit messages that are placed on packing lists.
- Added the ability to choose whether or not packing lists are sent.
- Choose the packing list filename.
4) Got rid of database entry for Own Stock -- This was redundant. Just use the "Own Stock" subcontractor entry!
5) Moved English language stuff in admin directory to the appropriate language files. This still needs to be done for confirm_track_sub.php. Maybe someday!
6) Automatically retrieves store information for packing list, which makes installation easier -- one less thing to modify.
7) Added the ability to change the sort order of the confirm tracking page.
8) Changed layout of send PO page. Much more info is included for each order and this info is much easier to use and understand.
9) Added the ability to put shipping option in the email header section as well as the email footer section.
10) Added fpdf files -- It turns out there is no license on fpdf, which means it can be included. This makes installation easier!
This version is much easier to install and has many more options that are easily configurable. Enjoy!
I will do it now. This plug is the biggest timesaver ever and I, for one, TRULY appreciate your time and efforts.
:clap:
Kindly,
JimmyV
LOOKS FANTASTIC! Works no problem during several tests so far.
ONE minor thing...
Is there a way to do the same type of sort on the PO send/resend page? I don't current enter tracking info so that area is really not in use.
Yes I know it never ends. Perhaps this is an easy fix but I hate to monkey around in the dark while my site is currently under heavy use.
Thanks a ton!!!Quote:
Originally Posted by srturner47
I looked for that piece of code (lines 443-448 of send_pos.php) but I was not able to find them there. Am I looking in the right send_pos.php (the one in the admin folder)?
thanks a ton!
Gabstero.
Quote:
Originally Posted by srturner47
Quick question.
Will this version 3.0 work with Zen Cart v1.3.7.1
thanks!
gabstero.
hi,
I have this mod installed and some of it works but i cannot get the content & settings to show up in Admin>configuration>purchase orders... It just shows a blank admin page with some headers and nothing else...
Please help
:)
email and phone number in pdf order to subcontractor
I would like to know how to get these on the pdf .
I can get it into the email (email_header.txt) but the pdf seems more complex.
Thanks
gary
www.theclearboxstore.co.uk
Keepsake,
I loaded this file and can not get it to come up on my admin/extra...
JimmyV - Glad you like the mod, and glad to hear your site is so successful. That's actually why I got involved with this mod - as my web site grew, it was just too much work to manually send out orders. This mod has saved me a ton of time and allowed me to focus on customer service, sending out stock orders, marketing, etc... Anyway, I'm not planning on releasing a new version for awhile. I'm pretty happy with the mod as is for now. There are few things I'd like to do in the future, but they can wait! You can easily do this yourself with a few small changes. Just change line 876 and 877 of send_pos.php to:
The resend page already has this behavior by default.Code:$query=mysql_query("SELECT p.orders_products_id, p.orders_id, p.orders_products_id, p.products_name, p.products_id, o.shipping_method, o.delivery_state, p.products_quantity, o.delivery_street_address, o.delivery_city, o.delivery_suburb, o.delivery_postcode, o.delivery_country, o.delivery_company, o.delivery_name, p.products_model FROM ".TABLE_ORDERS_PRODUCTS." as p, ".TABLE_ORDERS." as o WHERE p.orders_id=o.orders_id AND po_sent='0' AND o.orders_status !=3 AND po_number IS NULL ORDER by p.orders_id DESC LIMIT $start, $l_odp_nastronie")
or die('Failed to connect database: 8');
gabstero - Yes, the one in the admin folder. Are you using the new version, 3.0? If so, the code has changed. Just search for {shipping_method}, these are the lines that determine what goes in the {shipping_method} part of your P.O. There are now two places in the code that handle this, as shipping method can be entered in the header OR the footer in 3.0. 2.0 only worked with shipping method in the footer.
I honestly don't know if 3.0 will work with 1.3.7.1. I've heard that 2.0 had some troubles with 1.3.7.1. Never tested it myself. Sorry!
jamie2k - Did you install the SQL patch? That is what puts the options in. You have to cut and paste the code in dbscript.sql to Admin/Tools/Install SQL patches. It is possible I made a mistake with the new SQL patch... I've never tested it myself. All I ran on my site was the SQL update patch, as I was updating. However, I simply cut an pasted this update code in to where it should go in the original SQL patch, so I would think it should work just fine. Let me know!
garyw - Sorry, but the short answer is that it is much more complicated. I can't imagine a way that I could let you rearrange the packing list easily. You'd have to edit the source code to do this. The good news is that all pdf commands are easy to find in the source. They are all in send_pos.php and send_pos_nc.php. The latter is the send to unknown customer, the former is the regular send and resend page. Each pdf creation function begins with pdf->
kburner - It was I who answered your previous question, not keepsake. Again, make sure all files are in the right directory and that you have run the SQL patch. Go through file by file and check! I am almost positive that either this or your SQL patch are your problem.
There are three versions of this mod - 1.3B that keepsake posted at the start of this thread, 2.0 and 3.0 that I uploaded later. But, everyone should have this menu option regardless of version. Try running this address: admin/edit_subcontrac.php Does the page come up?
Thanks for the quick reply. I could not find admin/edit_subcontrac.php. I went to admin/tools/developers tool kit and no file. Plus,looked at my download.
Do I re-load files again but use SQL patch?
It is me again... Sorry to keep bothering you and thank you for your help.
I looked and files are located in same folders as admin, includes, etc. It has own folder called purchaseorders. I can delete and re-load into a file Which one?
That's your problem. You copied the files into a separate directory. There is no folder called purchase orders. This is the folder that the mod was in.
Everything in the purchase order directory should be copied to your main web site directory. You'll notice the admin and email directory there, just like on your main web site directory. That will fix your problems!
Ok very tired. And I am confused. On my main web site directory I have a list of file folders that are called admin, email, includes, etc. I copied the file into this list and extracted the zip file and it created the folder called purchaseorders.
Not sure where to place the file...
ok...think the brain finally kicked in....I take each file and copy to area it should be in like...admin go's into admin area...email files...
Yes I was looking for this type of plug when I first launched 3 months ago because I knew I'd be dead manually processing everything after conversion and then this arrived. The first version was clunky but worked. v 2.0 quite good and v 3.0 hits the spot and solves those few issues that remained.
Again excellent work and I will edit the code as noted. I just didn't want to risk it without some basis of confidence.
Your attention to this thread is to be commended.
:bigups:
Had it working heavily today without any problems so I'd say it is basically free of bugs unless you make an error loading the plug or have somehow modified your site to conflict.
Thanks JimmyV! By the way, don't be afraid to poke around. I'd never coded a thing with PHP, and had only created a website for a class once until I started my website. I've never read a book about PHP or HTML - Everything was learned on the job. Just look at the code, after a while, it becomes obvious what is going on. The changes to v3.0 were gradual on my end, and I have been using it on my site daily. I'm fairly confident everything works, but of course, there is always the risk of a bug here and there. :)
kburner - yes, that will work. But, you are making this much harder than it needs to be. Just compress every file and directory INSIDE the purchase orders directory, upload it to the main directory, and then uncompress. All files should be where they are supposed to be unless you have renamed the admin directory. Your mistake was to uncompress the file as is. FYI- You'll never need the readme or .SQL files to be uploaded. These can always be excluded. However, I do have a file that is VERY important in the root directory - confirm_track_sub.php - so don't forget that!!! If you are new to Zen Cart I have two pieces of advice:
1) Backup before you do anything.
2) Read the instructions carefully included with each mod. They will usually have step-by-step installation instructions.
Good luck!
Upgraded to version 3.0 from 2.0, and have 2 problems
- Heading for admin panels Modules/Shipping, Modules/Payment and Modules/Order Total is Edit Subcontractors
- Can not get past Step 1 when trying "Send PO for Unknown Customer". Select a category in the dropdown, and resets to Top.
Zencart 1.3.8,
Browser = Firefox 2.0.0.14, or IE 6.029
Ack! You caught a bug! :) I'll release an updated version 3.01 to address the issue with the heading titles. The update will be easy, just copy over the following files to upgrade from 3.0:
/admin/edit_subcontrac.php
/admin/includes/languages/english/extra_definitions/edit_subcontrac.php
/admin/includes/languages/english/extra_definitions/send_pos.php
As for the send po for unknown, I really don't have any idea why it won't work for you. I went ahead and tested the file I uploaded compared to the one file I use for send_pos_nc, and it seemed to work fine.... I use firefox as well, both 3beta and 2 depending on the computer. Both work fine....
I do have one idea, and if this is the case, this is a big bug! The add product part of send_pos_nc was adapted from the Edit Orders mod, which was uploaded by Numinix and is available in the downloads section. Could you install this mod and see if this fixes your problem? If so, I'll have to roll up my sleeves to find what edit orders installed that you will need for this to work!
I'll wait to release 3.01 until I hear whether or not this fixes your problem.
For anyone else who has installed this mod, can you check and see if you are having the same problem on the send pos for unknown customers page, and also report whether or not you have edit orders installed. This will help me determine whether or not we have a bug on our hands.
Thanks!
Yes, I have this problem and no I don't have edit orders installed.Quote:
Originally Posted by srturner47
However, I can't make it work anyway: it does not generate pdf packing lists and it does not send out any content in the html part of the email: just
[FONT='Courier New']$EMAIL_MESSAGE_HTML[/FONT]
but I'm not sure if it ever sent out html emails in the past.
(later) I've found some php errors which might help explain:
[FONT='Courier New']Call to undefined function zen_get_orders_comments() in /home/www/web90/web/admin/orders.php on line 871
PHP Warning: Division by zero in /home/www/web90/web/admin/pdfpack.php on line 77[/FONT]
hairydog - are you using zen cart 1.3.8? The undefined function you posted is part of zen cart, not my mod. You'll need the latest version of zen cart for this to work! Also, orders.php is part of zen cart, not my mod (It is the customers/orders page in admin). So, I really am confused as to how you got this error!
One other thought -- Could you have accidentally deleted or overwritten the following file: admin/includes/functions/general.php? This is where the zen_get_orders_comments function is defined.
Very odd. As far as I know, this is the current version of Zen Cart (it says it is the current version) but the functions/general.php file was
$Id: general.php 5435 2006-12-28 19:09:50Z drbyte $
and there is another site with a clean install of Zen Cart that has functions/general.php of
$Id: general.php 7125 2007-09-29 00:03:01Z ajeh $
I wonder if the older version is one that was installed by an add-on?
Anyway, that error has gone away and now I am getting a pdf file generated. But it isn't being sent out with the email and the html version of the email hasn't got the right content. Perhaps there is a similar problem with an email file being wrong.
Think I'm going to have to find out what is wrong with this installation.
[later] Re-installed all the v1.3.8a files and it seems to be better now. Still not sending html emails, but it is now attaching the PDF - so I'll simply use plain text emails. The Unknown Customer bit doesn't work, but you expected that, I think.
It's worth mentioning that there are no 'e' buttons to edit orders - I guess that's because the addon is missing
Glad to hear that fixed your problem! I've never used HTML emails for this, just plain text. I prefer that, especially for subcontractors, as they don't need anything pretty to fulfill orders! :) The PDF file is really for the customers (even though it goes to the subcontractor), so that looks a little more polished.
Hmmm... Not quite sure what you mean about the e for edit orders. The edit orders add-on is not the same as the edit orders included with Zen Cart. You might want to look into that and see what is going wrong. Still sounds like you are missing a few files in 1.3.8a. Also, try clearing your browsers cache. That might be the problem with the e.
Alright. The fix for the headings was easy. But, I can't seem to reproduce the bug with category selection reverting back to "Top". I tried taking out the functions from the edit orders mod, but it still worked fine. I've looked over the code, and I see no issues! :( Could someone who is having this problem please put this debug line into their code and let me know what they get. This will at least point me in the right direction.
On line 514 (the line before // Set Defaults), change from nothing to this:
Please let me know what these values are both before choosing a category, and what they become after choosing a category.Code:echo "Add products category id - ".$add_product_categories_id."<br />Add products category id IsSet - ".IsSet($add_product_categories_id)."<br />Step - ".$step."<br />Current Category ID - ".$current_category_id."<br /><br />";
Installed Edit Orders,, same problem - no step 2Quote:
Originally Posted by srturner47
Installed the debug code at 514.
Before selecting on the dropdown
Add products category id -
Add products category id IsSet -
Step -
Current Category ID - 0
After selecting on the dropdown
Add products category id -Suspect this is not the expected result:no:
Add products category id IsSet -
Step -
Current Category ID - 0
Thanks cropinstop. No, that is not what I want to see. :( I still can't figure out why it works for me, but it doesn't work for anybody else.... I'll keep playing with it and try to figure this out. :frusty:
Thanks so much!Quote:
Originally Posted by srturner47
You are one of the rare ones that actually supports actively his mods! A thing to be very much appreciated!
Thanks for your response also, but I wanted to make sure if I got my question right:
I am curious to know if the tweak you mentioned (with the {shipping_method}) will actually display for the Customer a separate shipping fee per SC in a mixed cart checkout. For example:
Product 1 Price: $34
FedEx shipping fee: $12
Product 2 Price: $34
UPS shipping fee: $25
Product 3 Price: $34
USPS shipping fee: $10
Something similar what the MVS mod (for OSCommerce) does... There you can specify a separate shipping method for each Manufacturer (Sub Contractor) and the shipping price for each product will be calculated according to that.
I suspect that your fix will only allow me (the store administrator) to specify a separate shipping method per SC in the PO sending process, right?
In that case - do you have in mind to add that functionality to it later on?
Even if not, the mod is extremely convenient, and thanks so much again for being on top of things!!!
cheers!
Gabstero
This feature, to be able to specify different shipping options per vendor and having that be added to the cart functionality, would be super fantastic and I would be willing to contribute $$ towards it to help it along.:bigups:Quote:
Originally Posted by gabstero
Thank you for your help. I am a newbee and this can be very challenging. I really appreciate your help. I need this mod badly as I have three vendors I am going to be working with. I am still trying to read all the threads.
Everything loaded except when I go to admin/extras/ po edit subcontracs...I do not see anyway to add them. I may be looking in the wrong place.
Which version is the latest for me to load? I think I may have loaded an older version.
gabstero and lankeeyankee -- No Gabstero, my quick fix wouldn't do this unfortunately. I see what you mean about shipping -- that would be a nice feature to have. It would be a huge amount of work, as I would have to write a new shipping module. I'd be happy to look into it, but this really wouldn't benefit my store, and the changes I have made to this mod were really made for my store...I just thought I could give back to the community by releasing it.
If you were willing to pay for it, I'd be happy to look into it and see if I could do it though... This would really be a totally different mod as it would be a new shipping module, which would really have nothing to do with the PO system -- other than the small fix I wrote about earlier. Unforunately, I can't do that immediately due to personal issues in my life that are simply sucking up too much of my time. I'll PM you if I find that I have the time to take on a project like that...but it would require some generous funds as this would take awhile to write. Another option would be to look around and see if someone else would be willing to do that for a fee. There are tons of people who write code for Zen for money.
By the way, and this is just my 2 cents, I think you are making a big mistake if you intend to charge shipping this way. Free and reduced shipping make a HUGE difference for internet customers. Charging more for adding items to their cart doesn't make sense -- customers should be rewarded for doing so, not punished with additional shipping. Frankly, I think you'd be better off losing money on an order here and there. What difference does it make if you are doing a ton of business? Just my two cents...I'll step down off my soapbox now.
kburner - Just change one of the subcontractors and hit the "insert" button. It will add the subcontractor you just entered. And don't feel bad about being new...Everyone was a newbie at one time. :) BTW- V3.0 is the newest.
As for the unknown customer bug, I'm still stumped. I just don't understand why it works for me... The easiest way to fix it would be if someone who has this problem would let me edit the code and login to their site...but that is asking a lot...I certainly wouldn't let anyone do that to my site! :) I'll keep trying to figure this bug out.
If by log on to their site, you mean login to the zcart admin, I have no problem letting you do that - I am testing on an offline site, and it is backed up 100% to my local desktop. But if you need access to the code, that is a problem because the test site and online site are on the same file system, and I do not know if/how I grant you write access to one subdomain... I guess I could open it up to 777, and only tell YOU where it is...
On tracker.php the orders are listed down the page. Across the top there is a "key" that saysQuote:
Originally Posted by srturner47
Show Customers Orders etc etc
but there is no
Edit Order
to be seen next to any of the orders - even though the other symbols are there.
hairydog - I see the same problem. This has nothing to do with the dropship mod; it appears to be an oversight in the TY Package Tracker mod. I don't use this page often, as I use the PO-Enter Tracking page that is included with the drop ship mod. FYI - the "t" for add tracking id essentially is the edit orders page with a tracking number option.
cropinstop - that would be very generous....right now I simply don't have time to address this problem, but if I can't figure it out, when I do have time, I'll PM you. Thanks!
I never thought of this the way you put it - and really it makes MUCH SENSE!!! Adding a list of shipping charges to each item in the cart is not something I would be attracted in my online shopping experience. You are very right.Quote:
Originally Posted by srturner47
The only thing is that it would make the store admin's life easier.
For example now I have a UPS shipping set as my default shipping in my store even if one SC is shipping FedEx, while others are shipping UPS. I loose on some shipments, and I gain on the others. It seems to be working just fine for now.
An elegant way would be to calculate the total of each SC's product and display a total for the customer on the checkout page saying something like "Shipping Fee for your order: $xx.xx" (without specifying the carrier!!).
Further on, the shipping fee is displayed for the store Administrator on the PO's sent to each SC.
Does that make sense?
Gabstero.
gabstero - Sure does. You might want to try table shipping. It lets you choose the shipping amount based on the total order amount. For example, orders <$25 could charge $5.00 shipping, orders $25-50 could cost $10 and orders $50 or greater could cost $15. I know that still leaves some uncertainty for you as a seller with multiple subcontractors, but it is probably your best bet for the time being.
New Version 3.1 is out! Here is a link:
Version 3.1 Here!
Please read the instruction carefully before upgrading. In a previous post I wrote about replacing three files. I've fixed other problems, so you really need to replace all files. In addition, there is one file that needs to be removed if upgrading from 3.0 to 3.1. Read the instructions first!
*****************************
V3.1 CHANGELOG
*****************************
This is a bug fix release. If you are using 3.0, I highly recommend you upgrade.
1) Fixed problems with adding products on send PO for unknown customer page.
2) Fixed heading problems that caused issues with other headings in Zen Cart.
3) Renamed send PO for unknown customer page to be more consistent with mod.
4) Consolidated files to be more consistent.
Please read the instructions for upgrading carefully!
Special Thanks to cropinstop!
Thanks for the module and support :)Quote:
Originally Posted by hairydog
We have similar issue with the new version 3.1. The PDF is generated as it should.
When we send PO email with no HTML than it sent as it should.
When we send with HTML than we get bellow the subject line (in the body bellow the logo):
$EMAIL_MESSAGE_HTML no other details show neither from the .txt files or data. Next thing we see is the footer Copyright line.
- we were able to send other HTML email with no errors.
We have other issue regarding re-sending PO: the PO number (after the "-" is changed every time we resend it - this could cause duplicate shipping to end user - PO number that sent should not changed.
Thanks
AddVant
AddVant - Sorry. Unfortunately, these are meant to act the way they do. I never implemented HTML emails with this mod because I don't use them. As for the second number, this seems like the behavior you would want. At least it does for me. Here is an example:
Order#502 is sent to ABC Distributing as PO 502-111. They email back and say "We are out of stock!" So--you resend this to another dropshipper, XYZ Distributing, who can fulfill the order . It gets sent as PO 502-112. You already know 502-111 won't be filled because they are out of stock, and in these situations you are probably communicating with your drop shipper about this. So, 502-112 should be the only one that ships.
Make sense?
Another reason you wouldn't want this is that you may need to split a PO up when resending, in which case you would end up with two PO with the same number.
hi thanks for the great mod,
I have installed it, it sends PO to the dropshippers in txt format.
It generates and attaches packing list.
It does not send any notification, to the customer with sending PO to DSH
it does not change the status of the order in the DB.
Where could be the problem?
--------------------------------------------------------------
ZC v1.3.8
Drop Shipping PO Module V 3.1
tracking switched off
(TyTracker not installed)
New problem with "Send for Unknown Customer" (installed version = 3.1b).
Seems to be getting confused SOMETIMES with the name of the option selected.
Input at admin screen
Step 1: Wedding papers
Step 2: Anniversary Rings
Step 3: # of sheets - 1
Step 4: 1
Output to email
1 x Anniversary Rings, Album Style: 1 1157071502
The display after hitting OK on the admin screen had the same error.
If I select the option of # sheets: 10, the error does not occur
I can give you access to my site if you can not reproduce it on yours
XantosNew - It is not designed to send a customer notification when the PO is sent. The order notes are ammended with a comment, but I assumed that most customers do not want an email just to say "Submitted to Shipping Department" or whatever you want to say here. It should change from Pending to Processing at this time with no email notification.
When the item ships, it should change from Processing to Delivered. At this point, the customer is notified by email with the tracking number as well as the order notes being updated. Of course, this won't apply to you because you aren't using TY Package Tracker.
TY tracker shouldn't have any effect on the behavior when a PO is sent. I really don't know why this won't work for you, but I can lead you in the right direction. The code that does this can be found in send_pos.php on line 466 and reads like this:
The first query checks to see if the order has already been marked as processing. This is so that if you send the order to several different subcontractors the order won't get remarked each time. The if statement checks this, and if the order status is 1 (Pending) it writes the order status as 2 with the comments you specified in Admin/Configuration/Purchase Orders/PO-Sent Comments to the database.Code:$query978=mysql_query("SELECT orders_status FROM ".TABLE_ORDERS." WHERE orders_id='$passitw'")
or die("Failed to connect database: 1");
$row978=mysql_fetch_array($query978, MYSQL_NUM);
if ($row978[0] == 1) {
$query555=mysql_query("INSERT INTO ".TABLE_ORDERS_STATUS_HISTORY."
(orders_status_id, orders_id, date_added,
customer_notified, comments)
values ('2','$tm1',now(),'0','".PO_SENT_COMMENTS."')")
or die(mysql_error());
mysql_query("update " . TABLE_ORDERS . "
set orders_status = '2', last_modified
=
now()
where orders_id ='$tm1'");
}
cropinstop - That would be very helpful. Send me an email when I can access it and I will take a look. Also, could you please email me with a few examples of when it does and doesn't work -- This will make my life a lot easier. Thanks!
Also, just an FYI - In the meantime you can just edit the values before sending it. I designed this so that everything is fully editable before sending the email.
By the way, what's the deal with the 1157071502?
srturner47, Many thanks again for great work.Quote:
Originally Posted by srturner47
About HTML issue, is there a way to have customer email send as HTML and only the purchase order to send as TXT? Are you going to add unit cost for PO?
As you described it - that fully make sense!.Quote:
Originally Posted by srturner47
There are few other options that you may want to update the order without updating the PO #:
The supplier said they didn't get the PO, you resend it and now if the do get the first one they have 2 PO with deferent number and may duplicate since on their systems it show as deferent po.
The supplier get the PO and process it in their system with your PO # and they request you to change some remarks or else that do not effect the actual order.
If you can add check-box that if you do it is not update the PO number that will do.
Another suggestion, when you go to re-send page no orders show up until you press the search button. Is there option to show the active PO's?
Thanks again - AddVant
Another sugestion:
For International shipping we need to send Invoice as well, is there option to add send Invoice as well?
What about sending the Packing Slip and/or Invoice to customer in PDF Format?
Can we send a copy of the PO to our email for backup? As well if can be done with the customer Invoice - it can be great!
Thanks - AddVant
It look like the HTML issue come from the default HTML file (/email/email_template_default.html) that expect the send_pos to send:
For example on the mail.php that uses same template file there is the following:Quote:
$EMAIL_MESSAGE_HTML
Hope this helps - Not familiar enough to know how to integrate it with the module.Quote:
$message = zen_db_prepare_input($_POST['message']);
$html_msg['EMAIL_MESSAGE_HTML'] = zen_db_prepare_input($_POST['message_html']);
Thanks - AddVant
AddVant - I see your point, but I am not sure I want to add the ability to keep the same PO # when resending. It could cause serious problems if you split the order up. But, there is an easy work around -- Just check the box to review the email before sending it and manually change the PO number. Your supplier won't get confused - You'll just need to remember, but that shouldn't be too hard.
As for invoicing, that would take a lot of work, as the pdf part would have to be rewritten. You are welcome to take a stab at it, but I'm not interested in implementing this feature at this time. One thing I have considered is creating a mod that would allow customers to print a PDF receipt. I think this would be a great alternative for customer who need to print a receipt....maybe someday.
As for sending a copy to yourself, that is easy to do. Just repeat the zen_mail function, but use your email address. There are several places you would need to do this, here is an example: For regular, non-review POs, see line 499 of send_pos:
Change to:Code:</form><?php } else { if ($_POST[includepackinglistoption] == 'yes')
zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL,PO_PACKINGLIST_FILENAME);
else
zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS);
For reviewed emails, do the same around line 100 of send_pos. For unknown customers, do the same in send_pos_nc...just search for "zen_mail".Code:</form><?php } else { if ($_POST[includepackinglistoption] == 'yes')
zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL,PO_PACKINGLIST_FILENAME);
zen_mail("[email protected]","[email protected]",$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL,PO_PACKINGLIST_FILENAME);
else
zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS);
zen_mail("[email protected]","[email protected]",$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS);
I'll take a look and see if there is an easy way to make this work with HTML option on, as this is clearly a feature people want. If it is easy, I'll let you know how to do it and add this to the next bug fix release.
Dear srturner47,
Thank you for the prompt answer!
Let me know if I can be any assistance for the invoice side and/or HTML or any else needed to make it better.
Have you tryed this module with Super Orders?
AddVant:bigups:
For the Invoice we can use the "PDF Order Center" contribution.
AddVant
srturner47,
thanks for the clarifications. I see now whats the problem.
Could someone please clarify the HTML problem for me? I'm trying to troubleshoot it, but I must have misunderstood, because I can't reproduce the problem. I tried changing the following, and it still works fine:
Admin-Configuration-Email Options-Send MIME HTML when sending Emails-True
Still works fine for me...
Admin-Configuration-Email Options-Email Admin Format-HTML
Still works fine for me...
What specifically are you setting to HTML that breaks this?
*****************************
V3.11 CHANGELOG
*****************************
This is a bug fix release. If you are using 3.0 or 3.1, I highly recommend you upgrade.
1) Fixed problem with incorrect attributes on send PO for unknown customer page.
Please read the instructions for upgrading carefully!
LINK
Hi, this sounds like a brilliant mod. :clap:Quote:
PLEASE NOTE! I have never tested version 2.0 or 3.0 of this modification without Ty_Package_Tracker!! Install at your own risk if you don't use Ty_Package_Tracker!!
I have 2 questions I need to ask:
Did anyone install this without this tracker module? What is the result? Please tell me your versions also.
Is there a live demosite whit this module installed, so that I can see it live before installing it on my zen.
Thanks ppl..:smile:
and now i read that i need super orders to install ty tracker?Quote:
Originally Posted by minshop.no
looks like im not getting sleep until sunday :smile::shocking:
You don't need super orders to install TY tracker. Sorry, as far as I know there is no live demo site. That costs money, and no one is making any money off this contribution.
Don't fret. You must be relatively new to Zen. You should be able to install TY tracker and this mod in about 30-40 minutes. Things are confusing at first, but the more you work and tinker with Zen Cart the easier it gets. Good luck!
ok, great. I think I got the install process clear. IŽll just backup and give it a go.Quote:
Originally Posted by srturner47
You are correct, 1 week in Zen now.(but its a 14 hrs a day week ) :blink:
Thanks for your reply.
Gang - really quick:
Are the customer's comments (entered during checkout in the "Special Instructions or Comments About Your Order" box) forwarded in the POs?
Thanks!
Gabstero
gabstero - no, they are not. But, you can easily add them by either using the "Comments for Purchase Orders" or by using the "Review E-mail Before Sending" feature.
However, comments ARE added to the packing lists when you choose to do so.
SrTurner!Quote:
Originally Posted by srturner47
Fantastic! Thanks a lot! I installed the mod on my Zencart v1.3.7.1 and it works marvellously! SOOOO much better than the previous version!!!
The only thing I had to change (and this comes as a suggestion also) was the path to my admin folder in confirm_track_sub.php to the name I currently have in lines 25 to 28:
For next releases you might want to use a variable to that admin folder since a lot of stores have several different names for it for security reasons.Code:require('admin/includes/extra_datafiles/tracker.php');
require('admin/includes/extra_datafiles/purchaseorders.php');
require('admin/includes/languages/english/extra_definitions/confirm_tracking.php');
require('admin/includes/languages/english/orders.php');
And now back to my original question. I was able indeed to write comments in the "Comments for purchase order" and they were passed along in the email.
However, is there a way to add the value of "Add Customers Comments to Packing Lists" check box to the PO email as well?
Thanks so so much!!!
Gabstero.
Aaa.. and another one ---
there was no PDF packing slip attached to the PO email... Should I configure fpdf somehow?
I didn't find any instructions in the readme concerning fpdf config...
thanks!
Gabstero.
Sorry gang - another one (I am just discovering these as I am testing)
When one does "Send for Unknown Customer", should the latest order (and PO #) be considered to add in the "PO & Order Number" field? Or anything can be entered there?
For example, my latest online order/po number was #16-50. Should I enter #17-51 in that field?
Thanks again!
Gabstero
has anyone figured out how to have the po's email automatically once a day?
gabstero - I see your point about adding comments from the customer, but I must admit I am not highly motivated to add this feature. I kind of like being able to write comments from my perspective when I am sending a PO.
I think you misunderstand the send for unknown customer feature. You can enter anything you want for the PO number -- these POs are not tracked. The send for unknown customer feature is for phone orders, ebay orders, etc... that are not within the Zen Cart system. It is just an easy way to send an email PO with an attached packing list. These orders are not tracked within zen cart, because they are not in zen cart to begin with! Hence -- Unknown Customer. So, you probably want to use a PO # that makes sense for whatever you are doing. For example, if you have an ebay order, you might want to use E followed by the last 4 digits of the auction number. For a phone order, you might want to use P and the first 4 letters of their last name. Etc, etc, etc... Whatever makes sense to remember your POs, use it. You can put anything you want in for the PO # when using the unknown customer feature.
I think someone mentioned before that the packing lists don't attach correctly with Zen Cart 1.3.7. I'd update to 1.3.8 if I were you, that should probably fix your problem. No need to setup fpdf - it should work.
mlangone - No, sorry.
It makes sense. Although I missed some important things to pass along to the SC that were mentioned by the customer in the checkout comments. What I can do is check if there are any important comments from the client, and copy/paste them in the PO's email while reviewing before sending - which I have to add it is a SUPERB addition and thanks a lot for that!Quote:
Originally Posted by srturner47
I was wondering is it possible that the customer comments are wrapped in a similar variable like the others you have in the email templates? Example:
{products_quantity}
{products_name}
{manufacturers_name}
Where are these variable set? Is there a list by any chance?
AHA!!! Okay - not it is clear! Thanks again!Quote:
I think you misunderstand the send for unknown customer feature. You can enter anything you want for the PO number -- these POs are not tracked. The send for unknown customer feature is for phone orders, ebay orders, etc... that are not within the Zen Cart system. It is just an easy way to send an email PO with an attached packing list. These orders are not tracked within zen cart, because they are not in zen cart to begin with! Hence -- Unknown Customer. So, you probably want to use a PO # that makes sense for whatever you are doing. For example, if you have an ebay order, you might want to use E followed by the last 4 digits of the auction number. For a phone order, you might want to use P and the first 4 letters of their last name. Etc, etc, etc... Whatever makes sense to remember your POs, use it. You can put anything you want in for the PO # when using the unknown customer feature.
Thanks again. Although I am so reluctant to upgrade. I have quite a bit of mods on it and I am afraid I will break it. It will happen, I am sure but since the store has traffic, I am reluctant to make the upgrade now. I can live without the attachment. Is there any support thread for the FPDF thing?Quote:
I think someone mentioned before that the packing lists don't attach correctly with Zen Cart 1.3.7. I'd update to 1.3.8 if I were you, that should probably fix your problem. No need to setup fpdf - it should work.
Thanks!
Gabstero
No, there isn't a tag for customer comments, but I like the idea! I'll include it in my next version of the mod...but, unless I find any new bugs that could be awhile as I am very happy with how things are working right now. Here's the code you need to add to send_pos.php on line 236 right below the {po_comments} line:
You'll want to add {customers_comments} somewhere in email_header.txt after making this change. I haven't tested this, but it should work fine. Let me know if it doesn't work and I will fix it.Code:$oatmeal = $db->Execute("select comments from " . TABLE_ORDERS_STATUS_HISTORY . " WHERE orders_id = '" . zen_db_input($row4[31]) . "' order by date_added");
$catmeow = nl2br(zen_db_output($oatmeal->fields['comments']));
$catmeow=strip_tags($catmeow);
$zawartosc2[$i]=str_replace("{customers_comments}",$catmeow,"$zawartosc2[$i]");
By the way, there is no documentation that lists the tags, but there are many to choose from that are not in the example email. Just look around send_pos - you'll find them.
Again, you don't need support for fpdf. It is working fine if you installed my mod correctly. You can even check it -- find the last pdf file in your admin directory and you'll see that it works. The problem is with attaching to the email in 1.3.7.1, not creating the pdf file.
Worked like a charm! THANKS A TON!!!Quote:
Originally Posted by srturner47
One funny thing I observed, is that the mode sends double emails. For example I sent one to myself (as a fictious SC) and I received two copies. I reviewed the PO emails before sending it, so can that be the problem?
AHA!!! Discovered the pdf and it is indeed correctly created. Any suggestion on where should I look why it isn't attached to the PO emails?Quote:
Originally Posted by srturner47
Thanks so much for all your generous help!!
Gabstero.
Has anyone figured out why the emails sent show the "
$EMAIL_MESSAGE_HTML" and not the text that is suppose to show. i used the older version and it worked great. i just did the upgrade to the newest version and everything works great except the email comes with the
$EMAIL_MESSAGE_HTML instead of the drop shipping text order into.
I see some have the same problem, but no solution. or did i miss it.
gabstero - never had a problem with it sending two emails before. Reviewing an email shouldn't make it do this...is it possible you refreshed the page after sending an email? This would cause this behavior -- see the warning on the send PO page. Try again and make sure you don't use the refresh button on your browser - let me know if that fixes the problem.
cowboyfred - I changed the delivery method from the function mail() to zen_mail() so that I could make this mod work with attachments. This is obviously causing problems for some people, but I have been unable to reproduce this problem on my end, so I have been unable to troubleshoot it. Some people have reported that changing from HTML emails to text emails fixes this problem, but I tried both on my end, and it always seems to work fine. Unless someone will grant me access to their admin and ftp that has this problem, I don't forsee a solution for this. If you'd be willing to do this, just PM me the details. If not, I understand -- I wouldn't let someone do this on my site, so I can't blame you! :cool:
Thanks! You are right - it does not happen upon reviewing. But I also didn't refresh the page (I saw the warning). It is still sending duplicate emails. And check this. I added some text in the "Comments for Purchase Orders:" field, and in one of the emails the word "it's" is shown "it's" and in the other one shows "it/'s" (with the escape character).Quote:
Originally Posted by srturner47
I was trying to see if there is a redundant file from the previous PO install that might do this but I wasn't sure where to look for. Would you have any suggestions on where the emailing of the POs is hadled?
OK - I THINK I FOUND IT: I had two different emails set for each subcontractor. Example - the SCs email and mine also - only so I can get a copy of the PO email in my inbox. That actually caused the system to send it twice. Here is how I had the emails set in the SCs:
[email protected], [email protected]
I wonder if the system checks for the numbers of emails in the SC and loops through that many times.
Anyway - I removed my emails for now - I trust that the POs are going out correctly - hehehe...
Thanks again!
Gabstero
I'm getting this error at the top when I click send. Everything seems to work ok!
except the email does not have the PDF file attached.
Warning: Division by zero in /admin/pdfpack.php on line 77
Can anyone help?
Thanks
Running Zen Cart 1.3.8a
Mustang394 - Your store has no name defined in Zen Cart. You need a name defined so that it can put this name on you packing lists -- hence the error. See your admin-configuration-my store-Store Name and give it a name.
Checked it retype and saved the store name still getting the same error. Happens for both send po and send unkown.Quote:
Originally Posted by srturner47
Don't know if this help but her is the function that seems to be causing the error.
I not a programmer so it is like reading Chinese to me. :)
// public functions
function sizeOfText( $texte, $largeur )
{
$index = 0;
$nb_lines = 0;
$loop = TRUE;
while ( $loop )
{
$pos = strpos($texte, "\n");
if (!$pos)
{
$loop = FALSE;
$ligne = $texte;
}
else
{
$ligne = substr( $texte, $index, $pos);
$texte = substr( $texte, $pos+1 );
}
$length = floor( $this->GetStringWidth( $ligne ) );
$res = 1 + floor( $length / $largeur) ;
$nb_lines += $res;
}
return $nb_lines;
}
Has anyone figured out why the emails sent show the "
$EMAIL_MESSAGE_HTML" and not the text that is suppose to show. i used the older version and it worked great. i just did the upgrade to the newest version and everything works great except the email comes with the
$EMAIL_MESSAGE_HTML instead of the drop shipping text order into.
I see some have the same problem, but no solution. or did i miss it.
dscott1966 - Yes. I've fixed it and will be releasing the fix soon.
Mustang394 - There must be some other variable that has zero characters...I couldn't figure out any other reason why this could happen. Try to figure out what that is. If you can't here is a workaround -- replace the function sizeOfText with this function:
Code:function sizeOfText( $texte, $largeur )
{
$index = 0;
$nb_lines = 0;
$loop = TRUE;
if ($largeur != 0) {
while ( $loop )
{
$pos = strpos($texte, "\n");
if (!$pos)
{
$loop = FALSE;
$ligne = $texte;
}
else
{
$ligne = substr( $texte, $index, $pos);
$texte = substr( $texte, $pos+1 );
}
$length = floor( $this->GetStringWidth( $ligne ) );
$res = 1 + floor( $length / $largeur) ;
$nb_lines += $res;
} }
return $nb_lines;
}
Thanks I will give that a try, I have been looking for what might be blank and can't find any thing. Let you know if the new code works.Quote:
Originally Posted by srturner47
That took care of the error, but there is still no file attachment.
Hmmmmm.... Strange. Is it possible that you have turned off pdf attachments? Check Admin-Configuration-Purchase Orders-POs - send packing lists and see if they are turned on.
If they are and the problem persists, go to your admin directory and see if the last packing list is there. If it is there, you know your problem has to do with email delivery. If it isn't you know it has something to do with pdf creation.
Try creating a file with the same name as your packing lists. Put it in your admin directory and see if it attaches when you send a PO.
Quote:
Originally Posted by srturner47
The pdf is is the admin directory but email is not picking it up, I am using the stand zen-cart php email module could that be the problem?
BTW thanks for the quick reply's and help.
Hmmm... I really don't know what could be your problem if you are using 1.3.8. PHP is fine, that is what I use too. Are you sure packing lists are enabled? The mod will create a packing list when packing lists are disabled, it just won't send them. That is really the only thing I can think of. I still think it is weird that you had that error, but I don't see how attaching a file to an email should be affected by an error in the creation of that file when you can confirm that the file is there.
Yeh the created file seems to have all the right info in it. Any idea will file tell it to attach to the email?Quote:
Originally Posted by srturner47
Hi, I have just installed this, and I am getting this error when I go to /admin/customers/po-send/resend
Warning: fopen(packinglist.pdf) [function.fopen]: failed to open stream: Permission denied in /mounted-storage/home54c/sub002/sc35494-IXGL/xxxx.com/zencart/admin/fpdf/fpdf.php on line 1046
FPDF error: Unable to create output file: packinglist.pdf
What directory is is looking for?
Its ok, I got it working - I had to change /admin to 777 and then back to 755 and now it works. --- looking great.
Mustang394 - Sorry, I don't understand your last question.
The more I thought about your question the more I realized that these symptoms sound like someone who is updating and did not install the SQL update. Is that possible?
djjase - Glad to hear it works!
No it was a new install, everything seems to be working except the pdf file is not attached.Quote:
Originally Posted by srturner47
Was wondering where in the code it tells it to attach the file to the email.
I get the same error as everyone else if turn mime on, but neither text or html give me the file attachment.
Hi
This mod seems to be really great. However, I am trying to set up for use in Australia, so some features don't work for me.
I would like help on 2 issues:
How can I change the date format in the packing list to dd/mm/yyyy format (I have changed this for my site as a whole but this date is not formating as I would like.
In the packing list I am getting this error appearing at the bottom of the packing slip: Shipping Option: <img
src=includes/templates/template_default/images/icons/austpos
t_logo.jpg alt=AustPost /> (<font
color="#FF0000">ERROR:</font> - where can I edit out this?
I am not using the Ty tracking module although I have it installed.
I am using the Aust Post shipping module
Thanks
OzNet - That makes sense. If you have a picture for part of your shipping option it won't show up right on the pdf packing list. To take this out, just change these lines from send_pos.php:
change to:Code:if ($countproductsonpo != $countproducts)
$pdf->addNotes(SHIPPING_OPTION.": ".$tmpt[0][7]."\n\n".PO_PARTIALSHIP_PACKINGLIST."\n".$_POST[plistcomments]);
else
$pdf->addNotes(SHIPPING_OPTION.": ".$tmpt[0][7]."\n\n".PO_FULLSHIP_PACKINGLIST."\n".$_POST[plistcomments]);
To change the date format find this line in send_pos.php and send_pos_nc.php:Code:if ($countproductsonpo != $countproducts)
$pdf->addNotes("\n\n".PO_PARTIALSHIP_PACKINGLIST."\n".$_POST[plistcomments]);
else
$pdf->addNotes("\n\n".PO_FULLSHIP_PACKINGLIST."\n".$_POST[plistcomments]);
Change it to whatever date format you want.Code:$invdate=date("m-d-Y");
Enjoy!
Mustang - Sorry. I really don't know what is wrong. My best advice would be to hire someone to take a look at it. If you want to hire me, PM me, but anyone who knows what they are doing should be able to troubleshoot this. It is also possible that your server is somehow having problems attaching things. The file is attached using the function zen_mail. You can search for it in send_pos and send_pos_nc. Good luck!
Just uploaded v3.12. Usually it takes a day or two to show up. Enjoy!
*****************************
V3.12 CHANGELOG
*****************************
1) HTML emails fixed.
2) Added {customers_comments} field for email header.
3) Added a list of fields to readme file.
Link
Mustang: What version of ZenCart you have? If it is v1.3.7.1, it is known that the pdf is knot attaching - not sure why.Quote:
Originally Posted by Mustang394
thanks,
Gabstero
Running Zen Cart 1.3.8aQuote:
Originally Posted by gabstero
http://www.zen-cart.com/forum/showthread.php?t=76632
According to DRBYTE in this thread Zen Cart no longer supports email file attachments.
wonder why they took that out.
A special thank to all those who tried to help, I really do appreciate it.
You are correct, Zen Cart does not support file attachments as far as I know. However, if you look at the zen_mail function in 1.3.8, you will see that this ability has been added to Zen Cart, though as far as I know, it has not been utilized other than to add the ability to the zen_mail function. I believe this is why the attachments don't work with 1.3.7...but that is just speculation as I don't have a 1.3.7 install to look at.
UPDATE: Just noticed this from that thread:
----------
If you were hoping to have the uploaded file included as an attachment to the contact-us email, you should note that as of Zen Cart v1.3.7, there is no support for emailing attachments. That may change in future releases.
----------
That would explain why PDF attachments don't work with 1.3.7. They must have added that ability in 1.3.8.
Again, I highly recommend you hire someone to help you out Mustang. I am fairly confident your problem can be resolved. Good luck!
I may have to down load the install package and look at the un moded files. I wonder if anyone has this installed on 1.3.8 and has the attachments working.
Might try it on a fresh install just to make sure one of my mods isn't causing the problem.
PM Sent.