fotofx - glad that worked for you!
And someone should really delete the spam from the last two messages and close those two accounts. Don't know why someone would spam this message board anyway, as all links are nofollow.
Printable View
fotofx - glad that worked for you!
And someone should really delete the spam from the last two messages and close those two accounts. Don't know why someone would spam this message board anyway, as all links are nofollow.
Hiya,
I'm trying to install this mod on a clean installation of 1.3.8a on my localhost server and am getting this:
http://www.nzstitchers.co.nz/Untitled-1.gif
It's also breaking the menu bar (won't drop down).
Anyone else had this?
Thanks!
Anyone?
Is there any way to track Unkown Customers PO's?
nsanford - It sounds like a <?php is missing from your file. Check the beginning of this file: admin/includes/functions/extra_functions/purchaseorders.php It should begin with <?php . I think some older versions of this mod had <? instead of <?php which causes problems with some versions of PHP. Let me know if that doesn't fix your problem.
kwilsuzn - Unfortunately, there is no way to track purchases from unknown customers. My thinking in designing this feature was that most people with unknown customers were already tracking them through an alternate system like Quickbooks, ebay, Amazon, etc... The unknown customer feature just makes it easy to send purchases orders with a pdf packing list and, when using v4, a text file attachment.
First of all Hello to everyone,
Couple of days ago I installed zencart and easy-populate. This site is under construction obviously.
I have just come across the dropshipper module which I can't get my head around to install. I am not really familiar with .php and .sql so this is a novoice area for me, but I am ready to learn, break and fix (just kidding).
Your help would be much appreciated.
Thanks,
Harry
The Tech Store
noobuser -- I'd be happy to help, but I'd need more specifics about what you don't understand. Read the instructions carefully, and you should be able to implement them. Good luck!
A lot of users have expressed a desire for this mod to send purchase orders automatically when a new order is received. So, I've implemented this feature, and I am releasing the newest version 4.5 of Drop Shipping Purchase Orders. There are two options for automatically sending purchase orders: a cron job and integrating it into the checkout success page which will send the purchase order as soon as the order is received. Of course, manually sending purchase orders is still available. More information is available in the user manual, which can be accessed by clicking on the link in my signature. For those of you who have purchased 4.0, 4.5 is a free upgrade as you have 1 year of free upgrades included. Just login, go to your account, and redownload it. Enjoy!
V4.5 CHANGELOG
*****************************
1) Added the ability to automatically send orders, either through a cron job or from the checkout success webpage.
2) Added a link to the send orders and resend orders page that will check all the orders on the page.
3) Fixed problem with adding products to a purchase order for an unknown customer when the product is located in the top category.
What I don't understand is this --
*****************************
INSTALLATION & CONFIGURATION
*****************************
0) Install Ty_Package_Tracker and configure it properly before you continue. The definition of carriers is the most important one, as our module will plug into it for consistency. If you are not interested in the tracking functionalities of this module, skip this step.
How do I install this Ty_Package_Tracker (confirm_track_sub.php) ? How do I run this? Where do I copy this?
Thanks
Hi,
I managed to install both TY_package_tracker as well as dropshipper module...
harry
Hey Guys,
I believe that this is great. I do have a few questions though and I hope someone can answer them. I'll lay down my problem and if someone could please let me know if this is going to be the solution, then i thank you in advance.
I will be dealing with multiple dropshippers. I'm in Canada, one of my dropshippers is in the USA, the other is here in Canada, and there might be more. Will this script allow me to say ok, if someone orders something from Dropship 1 & Dropship 2, will it add the costs for both of these based on where the client is in corelation to the clients location?
Dropshipper 1 Charges me a flat $30 to bring in from the USA.
Dropshipper 2 Charges based on UPS's pricing.
Thanks so much for the information guys, i truly hope that this is what i need :smile:
Sorry, but this mod has nothing to do with a shipping module. This mod is used for easily sending and tracking purchase orders that you send to subcontractors. It also generates packing lists for these purchase orders, and the paid version has text file attachments. For more information on its features click on the link in my signature and download the manual from that page.
Not to hijack the thread but I thought I'd point you in the right direction. What you need is Ceon's Advanced Shipper module, it is well worth the cost and is incredibly flexible to match your specific needs. www.dev.ceon.net/web/zen-cart
Have a Drop Shipper that insists on receiving POs via fax.
Can the Drop Shipping Orders Module print the order (more specifically Print to Fax)?
Up to now I have been emailing the order to myself, printing, trimming, and faxing manually; but that gets old, and there must be an easier way...:huh:
You've got a couple of options for faxing. If you are looking for the packing list, there is a way for fpdf, the pdf script that is used to create the packing list, to output directly to the browser instead of the file. I remember doing this when I was testing out packing list functionality so that I wouldn't have to constantly download the file to check it out. I don't remember exactly what the command is, but fpdf is well documented and you should be able to figure it out. Then, you could print the file to a fax directly from acrobat reader. The line you'll need to change is:
$pdf->Output(PO_PACKINGLIST_FILENAME, "F");
This line may be slightly different in the free version, but it will still have the $pdf->Output command. The letter F stands for file. You'll need to lookup what stands for output directly to browser and replace the F with this. See fpdf's website for more info.
As for the purchase order email itself, the easiest way is to simply check the box for reviewing and editing an email before sending. Then, cut and copy the contents to a text editor. From the text editor, click print, and print to fax. If you want to make it a little easier you could easily modify the code so that the review and edit functionality simply outputs the email in the browser and then you could print to fax directly from the browser. The code for reviewing and editing can be found after this line of code:
if ($_POST[reviewthensend] == 'yes') {
Hope that helps!
Has anyone been able to modify this so it can be sent automatically? I don't want to have to buy the commercial version and haven't had the time to dig into the code yet to see about making the modification. If you have the code to do automatic emailing please share!:bigups: I will add it to the code base and repackage it for the free downloads section.
Easy for you maybe:huh:, but I am a communications system designer, not a coder..
Can you give me a hand, or point me to where I get see an example on how to send the PO to the brower?
And... would be even better if I could choose to route to email or browser, depending on the dropshipper.
OK, so this is a major enhancement - I can dream...
Hi,
Just a quick question. I have numerous supliers which this would work great for. I also have 1 supplier which is purely wholesale so i have to buy all the items from them and ship them out myself.
Can this mod do a 'bulk' order for multiple products?
An example would be that i have 10 orders to fulfill, i have to order 7 of these from the same supplier to be delivered to myself as i cant have them dropshipped, can i have 1 purchase order created automatically with all these 7 items on and just my delivery address?
Many thanks
Paul
Just a minute..
Not a lawyer, and maybe I do not understand how contributions on this site work, but seems to me if the author of a contribution has a paid version of a feature that adds functionality beyond the free version, I don't think people can/should be reproducing the functionality and posting it for free in the downloads section...
Well, first off, since it interacts with zencart code and zencart is covered under the GPL the commercial version is open source and covered under the GPL regardless of what the author may want to license it under, and the code can be modified and freely distributed without any legal issues. The only possible thing that someone can do in this situation is to copyright the readme files to prevent people from distributing the installation instructions.
Secondly, I never asked someone with the commercial version to post anything. I was asking if anyone has modified their version to send the POs automatically. Whether or not someone wants to post their commercial version is up to them, but that's not what I was asking for. But there is nothing wrong with someone posting code from the commercial version if they want to.
Wilkesy - You can do some of this with this mod, but not everything. With v4 and 4.5 you could individualize the purchase order so that some suppliers got your address instead of the customers. With v3, you could click on the review/edit box and you could edit the purchase order to include your address instead of your customers (a little more work, but it would still do the job). And, any version will group all products from the same order into one purchase order. However, if you had several orders that would go to the same supplier, each order would have its own purchase order. Unfortunately, there is no way around this at the current time unless you edit the code.
cropinstop - The pdf packing list would be easy, you'd just need to change that one letter. The purchase order itself would take some coding. If you'd like I could do it for you for a small fee. PM me if you are interested.
lankeeyankee and cropinstop - If anyone wants to add enhancements to this mod and release it, I have no problem with that. Please remember that I am not the original author of this mod. I have spent a significant amount of time enhancing this mod, but version one I had nothing to do with. I decided to start charging after version 3 because all the enhancements after v3 didn't help me at all - other than the alternating colors for orders, I love that! But that was a small change! :), they were simply features others had requested.
Just finished version 5! There are some great new enhancements in this version. Most of the features in this version allow more customizations for different subcontractors. With v4, you could customize a PO, but your customizations were limited in certain ways. This version adds new ways to customize POs. The biggest change was the addition of a system to automatically change any text in an email AFTER the tags have been processed. This allows you to modify things like shipping types to shipping codes, your model numbers to manufacturer models numbers, etc... In addition, almost everything is subcontractor customizable now, including email titles, attachment file names, and text file mime types. I've also added several new tags that make address customization possible -- this will be great for those who have different address formats or those who need different parts of the shipping address in different cells of a tab-delimited text file attachment. The full changelog is below. See the manual in the link in my signature for more info. If you've already purchased v4 or v4.5 the update is free. Just login to your account and redownload your previous purchase.
V5.0 CHANGELOG
*****************************
1) Added the ability to change text from any email or text file attachment. This can be done for individual subcontractors or for all subcontractors. You can also specify whether to do this for both the email body+subject and the text file attachment or just one of them.
2) Added optional custom email titles for different subcontractors.
3) Added optional custom packing list attachment filename and text file attachment filename for different subcontractors.
4) Added custom mime types for text file attachments. Can be done for all subcontractors or for individual subcontractors.
5) All tags, except for product specific tags, will work in any section of the email or text file attachment now, including the product section. Note: Email title tags are still limited. See manual for more info.
6) Added {shipping_method} tag to limited email title tags.
7) Added several new tags which give you the ability to break the addresses down into smaller sections like state name, state abbreviation, zip code, street address, etc...
8) Fixed problem with custom text file names not working.
9) Now compatible with PHP4 because it uses html_entity_decode instead of htmlspecialchars_decode.
10) Various code improvements and tweaks.
I have been using the drop ship for a while now and just now its starting to damage the pdf files when they are sent:
http://www.poolfiltersusa.com/images/damage.JPG
The permissions are correct -- if I resend the PO about the 5th time it works?
Disk space is ok.
Any ideas?
That's very strange. Try opening the files directly from your admin folder. They will still be there after the email is sent. This could rule out a problem with your email. If it is a problem with your email, you'll probably need to contact your server and see if they've done anything to their email system that could cause problems with attachments.
The other thing you could try is re-uploading the fpdf files. They are in admin/fpdf. You can copy them directly from the zip file you got for the mod or get them at fpdf.org
Hello, Just installed this module. How do I add/change the email address for the dropshipper which the module sends out?
Thanks
You'll find it under Extras -> POs Edit Subcontractors.
Thank you :-)
Great mod.
I just installed the 3.12 to try it for a while - How do I use the "PO - change shipping from"?
Lets say I want "freeoptions" - mine reads "Free Shipping"
to be "Cheapest"
Thanks
Erez
Hello everyone! I have a problem. Im using version 3.12 and our drop shipper is wanting the PO sent in XML format to there ftp site? Is there anyway this can be done?
erez -- Put the current shipping option name in change shipping from and then put "Cheapest" in change shipping to. It must match exactly, so if it doesn't work I'd check your database and grab the shipping name directly from the database. Its quite possible that there is some html code in the shipping name.
mahoneys -- Version 5 should be able to create the XML file using the text file attachment feature. However, this will not send it to an FTP site, it will only attach it to an email PO.
hi i'm using v3.12 of mod and I like it a lot.
I'm concerned about the security of the confirm_tracker_sub.php function which allows vendors to key in tracking numbers by themselves.
It seems that this is likely to be a security loophole as anyone who knows about the confirm_tracker_sub.php page can easily view customer information and modify tracking information.
what are the security features u have in place at the moment regarding this?
I suppose it is a slight security risk. To use the file, your intruder would need to know both a PO number that has not been shipped and they would need to know which subcontractor you sent it to. Otherwise, they won't get much from this file!
Version 5 has an additional issue which could disclose the admin directory. However, the installation instruction have a way to prevent this by creating a code that must be used via HTTP GET. If you are really worried about it, create a variable with HTTP GET and assign a code to it. Then, check the code before the script is run. Problem solved. Then, just modify all instances of linking to confirm_track_sub.php by adding this code in.
Is it possible to add additional info into the purchase orders that are sent.
i.e. in our store database we also store cost prices, p&p prices for individual products and attribute prices.
Could the purchase order contain this information as well so it produces a full purchase order?
Fantastic module though especially with the tracker mod installed as well. Says me loads of time creating manual PO's
Is it possible to send one purchase order to a supplier even if a customer orders 5 products
Yes - purchase orders are automatically grouped by order and vendor, so just check the checkboxes, and it will send all the products from your order that are for that subcontractor in one email PO. Click the link in my signature for Drop Ship 5.0 and then click the link in the product description with the manual. Read pg. 47 for more detail on how POs are grouped. This manual is for v5, but the same principles apply as to how POs are grouped in v3.
Yes - you can add extra information by clicking the box to edit your PO email before sending it and add or change whatever you want to. If you want to automate it, you could always add any tags that you want by making some simple modifications to the source code of admin/send_pos.php. Again, see the manual for v5. There is a better list of the tags that you can use (although I do think there are a couple of these tags that don't work in v3). Sorry, the documentation for v3 just isn't as good as it is for v5.
Great site by the way!
Is there a way to make this mod show the orders in reverse?
Mine shows the first order ever on the first page. I think it would make better sence to have the latest order show first.
How Can i make it do that?
Yes. Click on "Show Newest Orders First". This will reverse the order. I'm not sure if this feature is available in v3 or not, but it is in v5 for sure.
But.....this really shouldn't be a problem. Just make sure old orders have the status you configured as PO SHIPPED STATUS from the configuration page. Then, they will disappear as the system will recognize that they have already been shipped. Much nicer solution for you as the page won't be cluttered with old orders! :)
v3 is the only one in the downloads section.
Is there a permanent way to make the newer ones go first?
Also I am looking to modify the ***->
Is there a way to change ***-> ??
I cant find it in developers tool kit....
milobloom - v3 is the latest free version. v5 is paid, hence not in the Zen Cart free software add-on section.
Not quite sure what you mean by ***-> .... Is it something in the email? If so, you need to edit the email files in the email directory.
I mixed up posts... ***->
has nothing to do with this module... Got my posts crossed sorry...
-----------------------------------------------------
I am getting this error when I go to send
(Its on the first page)
Warning: Division by zero in /home/nothingb/public_html/admin/pdfpack.php on line 77
I tried replacing functions/general
I tried changing my admin folder to 777
But nothing changed...
Also maybve the problem is in generating the pdf
if there a way to change it to text?
I know... I am running the 3 off the download sections.
I dont know if I get the $$ version if it would solve my problem
Well now, To be honest. I am not sure how. But I got it to work.
Whew!
Now I have a question. on the version 3 number.
The PDF works but only has my company name. Where does it take the address Phone etc from???
Oh also the emails are coming in with PO_FROM_EMAIL_NAME
as the sender, I don't see where to change that.
milobloom -- V5 supports text file attachments which would allow you to create and customize your own text file packing lists -- this does take a little work on your part as you would have to design the text file attachment whereas the PDF packing list is pre-designed and unchangeable.
PO_FROM_EMAIL_NAME is an option you define in Admin->Configuration->Purchase Orders. You need to setup all the options here as well. It does strike me as odd though that you have PO_FROM_EMAIL_NAME....this is the what the value you set up in Zen Cart Admin is defined as. Are you sure you ran the SQL patch? If you did, you will find Purchase Orders under Admin->Configuration.
The PDF will include your address if you set it up with Zen Cart. Check your Contact Us page -- the same information will be on the purchase order. You can set this up under Admin->Configuration->My Store->Store Address and Phone.
Dont get me wrong...
I understand how someones works hard on a mod and
wants to market it and make some hard earned money from it.
That being said. I thought I was coming to this thread for support for the only download available off of this site. In a couple of weeks I will be purchasing the $$ version because of some limitations.
But till then. Is there a way to change PO_FROM_EMAIL_NAME
to my name?
I ran the phrase through Developers Tool Kit.
and I got:
Furthermore.. The reason i HAVE to get the $$ version... Figure this one out. If there are 2 different items the PO only sends 1 out on the drop ship order. Not good....Quote:
/home/nothingb/public_html/admin/send_pos.php
Line #105 : zen_mail($_POST[eaddress],$_POST[eaddress],$_POST[etitle],$_POST[ebody],PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS, $html_msg, NULL ,PO_PACKINGLIST_FILENAME, 'application/pdf');
Line #107 : zen_mail($_POST[eaddress],$_POST[eaddress],$_POST[etitle],$_POST[ebody],PO_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS, $html_msg, NULL);
Line #487 : echo "<br>DEBUG--><br>From :".PO_FROM_EMAIL_NAME." <".PO_FROM_EMAIL_ADDRESS."><br>To :".$adresdo."<br>Subject:".$tematk."<br>Content:<br>".str_replace("\n","<br>",$n ewzawartosc);
Line #506 : zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAI L_ADDRESS, $html_msg, NULL, PO_PACKINGLIST_FILENAME, 'application/pdf');
Line #508 : zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAI L_ADDRESS, $html_msg, NULL);
/home/nothingb/public_html/admin/send_pos_nc.php
Line #304 : zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAI L_ADDRESS,$html_msg, NULL, PO_PACKINGLIST_FILENAME, 'application/pdf');
Line #306 : zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAI L_ADDRESS,$html_msg, NULL);
Oh btw I have to ask because there is no Admin_>Configuration>PO Orders or whatever in V3
milobloom-Yes, you are correct. This thread is for support of the free version. But, you asked about something, so I was trying to give you the best answer I could, which is that v3 doesn't do this.
You haven't installed the SQL patch. That's why the menus aren't there.
Not true. Check the box for both items and they will combine on one PO if they go to the same subcontractor. All versions have this feature back to the original v1.Quote:
If there are 2 different items the PO only sends 1 out on the drop ship order. Not good....
I just installed this module. I was wondering if I could put my cost of each item on the purchase order that gets emailed to my vendor. Obviously I do not want it on the packing slip. I did not see anywhere on the instruction manual that you could do that. Thank you
I think the problem is that I had this module allready installed. However when I upgraded it took away the config options.
I tried to install the sql patch (Probably for a 2nd time) and got this error:
Should I drop the table and re-do the dump. If so what is the command to drop it?Quote:
1060 Duplicate column name 'po_sent'
in:
[ALTER TABLE orders_products ADD po_sent char(1) NOT NULL default '0', ADD po_number int(20), ADD po_sent_to_subcontractor int(10), ADD po_date DATE, ADD item_shipped CHAR(1) NOT NULL default '0';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Hi,
I just installed the module and am currently testing it. I'm curious how the emails are being handled for orders with ownstock & subcontractor product.
Example, A customer purchases a product X (ownstock) and product Y (subcontractor). Using TY tracker, I add the tracking number for product X and change status to DELIVERED. Then a couple of days AFTER subcontractor enters tracking number on product Y which would change the status to PROCESSING.
The way I see it, the subcontractor has to first ship out their product first before we do from our ownstock to prevent multiple emails otherwise, customer gets 3 emails, one from us when we first ship it, one from the subcon when they ship it and one from us again saying the order has completed. Or is the last email going out automatic upon completion of the whole order?
just installed V3.12 of this mod (NICE!!!!!!!!!) but have no CUSTOMER-> SEND POs menu item. Have "PO's Send for Unknown customer" and "POs - Enter tracking #s" but not the other?
Also - did we ever get to "automatic PO emails" in the free version. Will defintely purchase at some stage but need to do lots more testing
Thanks in Advance
Stux
Man I am at wits end... Send PO's is not showing up in configuration
Tried the upgrade SQL and everything...
I need somehow to edit the data in PO_FROM_EMAIL_NAME
Looked in phpmyadmin but dont see where it is...
:frusty:
milobloom -- Something obviously went wrong when you installed the SQL patch. I would drop all the tables it installed and then re-install the SQL patch. However, if you don't know much about this, save yourself the trouble and hire someone who knows more. You could easily bork your whole store, and the small amount of money it will cost to get this installed is well worth it! Check out one of the websites where you can hire a coder to install this for you -- it will make your life a lot easier!
decostyle -- Not sure whether its in the free version or not, but you should check your admin config options. At some point I added the ability for you to choose which order status is used for each step of the process. The default should be Pending - > Processing when you send the order to subcontractor. Then from Processing -> Shipped when EVERY item in the order ships. If half the order ships, it shouldn't change the order status. Only once the entire order ships does it changed from Processing to Shipped. As for emails, the customer will get one email whenever anything ships. Thats it. So if an order gets split up between three subcontractors, the customer will get one email when each subcontractor ships. When the order is complete, there is no extra email sent in addition to the shipping email. However, the text of the last email will be slightly different so that you can let them know there order is complete. The email text for partial ship and full ship can be edited in Admin->Config.
stux - You are missing a file in the admin area. Perhaps you copied it to the wrong directory. I forget which one it is, but if you go through every file and check to see that it is in the right spot you will find your problem.
milobloom - Its in the configuration table. Again, do yourself a favor and hire someone to clean up this mess -- its not worth the headache! The other option is to restore your backup (you did backup right?) and then try installing it again. Read the instructions carefully if you do!
Please! Can anyone tell me how to reverse the order of the drop shiplist so the newest comes first.. Using v3 on the download section!
This is driving me nuts!
I re-ran the sql but took out the defines.. That worked out good for me...Quote:
milobloom -- Something obviously went wrong when you installed the SQL patch. I would drop all the tables it installed and then re-install the SQL patch. However, if you don't know much about this, save yourself the trouble and hire someone who knows more. You could easily bork your whole store, and the small amount of money it will cost to get this installed is well worth it! Check out one of the websites where you can hire a coder to install this for you -- it will make your life a lot easier!
srturner47 - Thanks for your reply. After much checking and grinding of teeth I eventually worked out that the line in "send_po_customers_dhtml" in "extra_boxes" was commented out. I un commented it and hey presto. Realised it was a menu preblem as all admin files present and if I manually navigated to admin/send_pos.php it worked
Think I'm good now! - testing to follow
Stux
People, I have a problem and I need your help. The problem is that PO subcontractor does not get email about the order. The email system itself and everything else is working:
- No email errors are thrown(is checked in object/variable level)
- Customer and store owner get the appropriate emails. So the email function and mail server is working correctly.
- The mod is installed correctly(without tracking).
- Other functions of the mod seem to be working correctly. No errors, etc.
More information:
- Zen Cart v.1.3.8
- Purchase Orders 5
I tried everything! I even checked email parameters and the $mail object and they seem to be correct. Please help to fix the problem!
:frusty:
UPDATE: Just tried and I get the following errors in admin when trying to send POs manually:
Warning: Division by zero in /mounted-storage/home66c/sub008/sc39995-KWDQ/www/projects/wpr/herbanpharmer.com/store/administrator/pdfpack.php on line 77
and then:
ERROR: Failed sending email to: "[my email. removed]" with subject: "[my subject. removed]" Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.
But I am sure that it's not fault of the Email Transport. As I already mentioned in my previous post all other emails from ZenCart are working. It happens for this module only.
zura.ge -- see page 19 of this thread for help
Thanks for your reply. Read the page 19 fully and found a solution there for the sizeOfText function. After applying the solution the "Division by zero" error went away, but the email was not sent anyway....
I will adjust that I don't care about admin side errors and manual send of the emails. It was just for your information to help discover the problem. What I need is to send an email to subcontractor when the order is made. So I think the problem can be narrowed down to the code that is added to tpl_checkout_success_default.php file.
IMPORTANT UPDATE: I changed value of body variable($newzawartosc) in the code to something simple(like "abc") before passing to zen_mail() function and the email has been sent! So there is something in the email body that prevents sending the emails. What it can be?
Found the reason of malfunction: It was "TO" at the beginning of the email. Probably it confused the mailserver while sending. I removed the whole line that started with the "TO" and it fixed the problem.
Now the email is sending, but I get the email without the PDF attachment. So what can be wrong there now?
Some things that might be helpful:
- The 'yes' is set in admin.
- admin/packinglist.pdf has permission of 777
- admin/fpdf folder(and the inner content) has permission of 755
I hope this is an easier issue to fix. Please help me ASAP as I already passed my deadline. :(
This mod will not send POs on checkout success. Version 5 does this, but its not free. You will need to manually send each PO with v3.
Are you using ZC 1.3.8? Before 1.3.8 ZC didn't have mail functions that support attachments, hence they don't work.
Not sure why the TO line would cause a problem...Strange.... Anyway, glad you figured that out.
As I already posted I have V5 and ZC 1.3.8
Solved the issue with the PDF attachments: I tried different things, but I think it was permissions of admin folder...
Now the PDF is sent, but it's not quite proper: For an unknown reason product names are missing there...
Oh-sorry. Didn't realize you were using v5. Send me an email through the website in my signature and I will help you out. This thread is only for v3 or below.
how do i add custom fields to this like the product weight .. order delivery date ?
Thank you. I already fixed the problem myself. I will contact you directly if I will have problems again.Quote:
Oh-sorry. Didn't realize you were using v5. Send me an email through the website in my signature and I will help you out. This thread is only for v3 or below.
Getting it to go to the pdf is not a big deal. Change admin/send_pos.php (inserting the code in Red)
Around line 189:
Then again, around line 279:Code:$query=mysql_query("SELECT p.orders_products_id, p.products_model, p.products_name, p.final_price, p.products_quantity,
o.customers_name, o.customers_street_address, o.customers_city, o.customers_postcode, o.customers_state, o.customers_country, o.customers_telephone, o.customers_email_address,
o.delivery_name, o.delivery_company, o.delivery_street_address, o.delivery_city, o.delivery_state, o.delivery_postcode, o.delivery_country,
o.billing_name, o.billing_company, o.billing_street_address, o.billing_city, o.billing_state, o.billing_postcode, o.billing_country,
o.payment_method, o.date_purchased, o.currency, o.customers_id, o.orders_id, o.shipping_method, o.orders_status, o.customers_suburb, o.delivery_suburb, o.billing_suburb, o.customers_company
FROM ".TABLE_ORDERS_PRODUCTS." as p, ".TABLE_ORDERS." as o
WHERE
p.orders_id=o.orders_id
AND
p.orders_products_id='$idk[$i]'")
or die('Failed to connect database: 3');
// $shipway = '';
while($row4=mysql_fetch_array($query, MYSQL_NUM))
{
$strCustomerTelephone = $row4[11] . "\n";
if ($row4[37] != '' && $row4[37] != NULL)
$adres = $row4[37]."\n";
else
Keep in mind that much of this code is written in Polish, with Polish comments, so you may have to do a little translation if you want to understand variable names and comments.Code:$wielowymiar[$i][0]=$subk[$i]; //id_subcontractors
$wielowymiar[$i][1]=$row4[30]; //id_customers
$wielowymiar[$i][2]=$idk[$i]; //id_produktu zamowionego
$wielowymiar[$i][3]=$zawartosc2[$i]; //zawartosc
$wielowymiar[$i][4]=$row4[31]; //id_orders
$wielowymiar[$i][5]=$row4[13]."\n".$adres_deliver . "\n" . $strCustomerTelephone;
$wielowymiar[$i][6]=$row4[20]."\n".$adres_biling;
$wielowymiar[$i][7]=$row4[32]; //shipping
Brad Scott
ClermontSoftware.com
Hey Guys,
First off, I'd like to thank everyone who has contributed to this addon, it will save me a lot of time manually copying and pasting into an email.
I think something may be wrong with how i'm doing this. I already have TY Package Tracker installed and have been using it for awhile with no problem. First time using Purchase orders.
I think i've tracked down where the problem is occuring in the SQL patch:
I get this error:
1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1 in:
[INSERT INTO zen_configuration_group VALUES ('', 'Purchase Orders', 'Purchase Order Settings', '1', '1');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
When inserting
INSERT INTO configuration_group VALUES ('', 'Purchase Orders', 'Purchase Order Settings', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @poid=9999;
SELECT (@poid:=configuration_group_id) as poid
FROM configuration_group
WHERE configuration_group_title= 'Purchase Orders';
I got everything else to go, and I was able to email purchase orders but couldnt get a PDF to attach (probably permissions problem) but I'm more concerned about the fact that in the readme it says to go to ADMIN>Configuration>Purchase Orders and there is such area to go to.
Any ideas? Should I be concerned that there is no area under Configuration for Purchase orders?
Any help would be greatly appreciated!
Matt
UPDATE: I was able to get it to show up in the admin area, but its empty. I suspect its something to do with this error:
1366 Incorrect integer value: '' for column 'configuration_id' at row 1
in:
[INSERT INTO zen_configuration VALUES ('','PO - send packing lists', 'PO_SEND_PACKING_LISTS', '1', '0 - never, 1 - always, 2 - sometimes (default yes), 3 - sometimes (default no)', @poid, 101, now(), now(), NULL, NULL), ('','PO - notify customer', 'PO_NOTIFY', '1', '0 - no customer notification of PO updates, 1 - notify customer', @poid, 102, now(), now(), NULL, NULL), ('','PO - subject', 'PO_SUBJECT', '{contact_person}: New order (#{po_number}) for {full_name}', 'Subject of PO emails, {po_number} will be replaced with the actual number', @poid, 103, now(), now(), NULL, NULL), ('','PO - from email name', 'PO_FROM_EMAIL_NAME', 'PurchaseOrderManager', 'The FROM email NAME for sent Purchase Orders', @poid, 104, now(), now(), NULL, NULL), ('','PO - from email address', 'PO_FROM_EMAIL_ADDRESS', '[email protected]', 'The FROM email ADDRESS for sent Purchase Orders', @poid, 105, now(), now(), NULL, NULL), ('','PO - sent comments', 'PO_SENT_COMMENTS', 'Order Submitted to Shipping Department for Fulfillment', 'Comments added to the account when submitted to subcontractor', @poid, 106, now(), now(), NULL, NULL), ('','PO - full ship comments', 'PO_FULLSHIP_COMMENTS', 'Thanks for your order!', 'Comments added to the account when the order has shipped in full', @poid, 107, now(), now(), NULL, NULL), ('','PO - partial ship comments', 'PO_PARTIALSHIP_COMMENTS', 'Part of your order has shipped! The rest of your order will ship soon. You will be notified by email when your order is complete.', 'Comments added to the account when part of the order has shipped', @poid, 108, now(), now(), NULL, NULL), ('','PO - full ship packinglist', 'PO_FULLSHIP_PACKINGLIST', 'Thanks for your order!', 'Comments added to the packing list when the order has shipped in full', @poid, 109, now(), now(), NULL, NULL), ('','PO - partial ship packinglist', 'PO_PARTIALSHIP_PACKINGLIST', 'This is a partial shipment. The rest of your order has shipped or will ship separately.', 'Comments added to the packing list when part of the order has shipped', @poid, 110, now(), now(), NULL, NULL), ('','PO - packinglist filename', 'PO_PACKINGLIST_FILENAME', 'packinglist.pdf', 'packing list filename', @poid, 111, now(), now(), NULL, NULL), ('','PO - omit from unknown email 1', 'PO_UNKNOWN_OMIT1', '\nIf you would prefer to enter tracking information for this order\ndirectly, please visit:\n', 'Text to omit from emails sent for unknown customers 1 of 3', @poid, 112, now(), now(), NULL, NULL), ('','PO - omit from unknown email 2', 'PO_UNKNOWN_OMIT2', '{delivery_name}\n', 'Text to omit from emails sent for unknown customers 2 of 3', @poid, 113, now(), now(), NULL, NULL), ('','PO - omit from unknown email 3', 'PO_UNKNOWN_OMIT3', '', 'Text to omit from emails sent for unknown customers 3 of 3', @poid, 114, now(), now(), NULL, NULL), ('','PO - change shipping from', 'PO_CHANGE_SHIPPING_FROM', '', 'Change this shipping option to something else on POs and Packing Lists', @poid, 115, now(), now(), NULL, NULL), ('','PO - change shipping to', 'PO_CHANGE_SHIPPING_TO', 'Cheapest', 'Value to change shipping option to on POs and Packing Lists', @poid, 116, now(), now(), NULL, NULL);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Just searched around and it appears your MYSQL is set to strict mode. See this thread here:
http://www.zen-cart.com/forum/showthread.php?t=63993
Turn strict mode off by editing your my.ini file like the poster in this thread did. That should fix the problem.
Having a heck of a time getting this pmod to work, but I think Im close....
Use 1.3.8a on a windows server.
When I go to Extras->PO Edit Subcontractors, I see some strange things happening...
Below "Edit Subcontractors" and immediately above "ID Short name" you see what looks like some garbage code on two lines like this:
' . "\n"; } else{ echo '
' . "\n"; } for($i=0; $i
in addition, on the right, there are nine text boxes and they have the following... each line is what each text box has a syou move downward:
<? echo $row2[1]; ?>
<? echo $row2[2]; ?>
<? echo $row2[3]; ?>
<? echo $row2[4]; ?>
<? echo $row2[5]; ?>
<? echo $row2[6]; ?>
<? echo $row2[7]; ?>
<? echo $row2[8]; ?>
<? echo $row2[9]; ?>
Anyone?....
Thanks in advance.
Just by what I see I have to guess your php server is not handling short tags.
Short tags have the beginning of a php block as <? instead of <?php
If this is the case the php.ini or the file will need to be edited.
I just looked at edit_subcontrac.php and they have mixed the tags with some short and some long.
You need the following line in your php.ini
short_open_tag = On
please send installation details about dropshipping/supplier interface for the zencart version 1.3.8.:(
Installation details are included with the module. If you have a problem or question after that, come back and we can try and help you.
That did the trick!! I modified my my.ini file, it didnt work, but using the SET command it did.
Open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode".
Find:
Code:
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"Replace with:
Code:
# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"Or, you can run an SQL query within your database management tool, such as phpMyAdmin:
Code:
SET @@global.sql_mode= '';
THANKS!
Hi everyone, I'm testing Customers>POs - Send/Resend. I just sent out a PO to one SC (myself for testing). Then I hit the button "View old POs and resend them". The order I just sent out doesn't show on the page. Should it list all the POs I sent out to SCs?
In other words, how does this button "View old POs and resend them" work?
Thanks.
You need to search for the order you just sent. See the top of the page. There are search options. Enter them, and click the search button.
I want to switch the location of the billing address and the shipping address. How do I switch their location? Thanks!
Find this in admin/send_pos.php. Flip [5] and [6].
Then open admin/pdfpack.php. Find this and change the text from Billing to Shipping.Code:$pdf->addClientShipAdresse($tmpt[0][5]);
$pdf->addClientBillAdresse($tmpt[0][6]);
Then do the opposite with this in admin/pdfpack.php.Code:$length = $this->GetStringWidth("Billing Address");
$this->Cell( $length, 2, "Billing Address");
Should do the trick! Enjoy!Code:$length = $this->GetStringWidth("Shipping Address");
$this->Cell( $length, 2, "Shipping Address");
I also need to add
CALL ON ARRIVAL (Customer's phone number)
after the shipping address. I sell baby chicks so the Post office calls the customer to pick them up instead of getting delivered to their door.
Also can we turn off the country?
Is there any way to force the states to be the 2 letter abbreviation? Mine shows up
LAKE CITY, South Carolina 29560
United States
I would like it to be
LAKE CITY, SC 29560
Call on Arrival 999-999-1234
with 999-999-1234 being the customer's phone number.
Also I am required to put "Hatched 10am Date shown on postage" and NPIP 48-236 . I would put NPIP 48-236 right next to my business name. Where does that pull from?
I was just thinking about the flipping the addresses. Now the email text will still say the ship to address correct?
purelypoultry -- All I did was give you a way to flip the shipping and billing address location on the packing list. Shouldn't affect anything else.
What you want done can be done and is not really that hard to do. But, its more work than could be simply explained in a post here. If you need all that on your packing list you'll either need to learn to code or hire a coder. Here's a tip that should help you isolate where all the action occurs -- all calls to the pdf packing list begin with $pdf->.
As for changing the state to the two digit code, this can easily be done with the database, as both the state name and code is stored for all states.
Good luck! Fun business!
A few questions:
I want my subcontractor to enter ship dates not tracking info. It is very important that customer's know their ship date and get it back to them quickly. the SC submitting this directly to the customer via an app would be wonderful. Can this be done? With current mods?
Would it be too much to give me how to put the Call on Arrival and Phone number?
I'm sorta new to zen cart. I have installed the newest version of purchase orders. I was wondering how to set it to automatically send POs as well as be able to send a .csv along with. Thank you very much for the help.
-Chris
You can do that with the 5.0 version offered at zencartmod.com
Okay thanks, also I just wondering can i do an upgrade from the newest free version to version 5.0? Also in your experience is there any large features for drop shipping missing in the 5.0 release that i will need to find another mod to add in?
chronofreak -- I can't support v5 through this thread. Email me if you have questions.
As for large features missing from drop ship mod, this is a rather broad question. It really depends on your needs. I encourage you backup your install, install v3, and find out for yourself. Or read the manual, it should pretty much tell you what this mod can do.
srturner47, I don't know how the notifications work so i'm just letting u know that I sent you a private message Since I don't know your email.
Hi,
I am new to Zen Cart and have installed it after considering many things. I am in love with the ease at which I am able to install and run things. One of my requirement is DropShipping and Supplier Interface.
There are various stores out there who would be the part of the main online shopping mall store. They should be able to manage their own products through there interface.
I have two questions:
1) Is the Drop Shipping/Supplier Interface (http://www.zen-cart.com/index.php?ma...roducts_id=327) uploaded in the year 2006 works secure with the current version ?
2) I have installed it in one of my website for testing purpose but getting the Internal Server error as I am not able to understand the changes that I need to make in the 4thstep to change the directory location.
define('DIR_WS_SUPPLIERINTERFACE', '/zencart1352/supplierinterface/');
define('DIR_FS_SUPPLIERINTERFACE', '/usr/local/apache2/htdocs/zencart1352/supplierinterface/');
Here is my website URL:
http://ghaziabadshoppingmalls.com/st...lierinterface/
Many thanks in advance,
Chris
This thread is for a different drop ship mod. You'll need to find the thread for the supplier interface/drop shipper mod. This thread is for the drop ship PO mod.
Could I put the quantity column on the purchases orders as the left most column? How would I do that?
There's no easy way to do it.
Well, I suppose you could just swap out the variables fed into the functions that create the PDF file and change column headers, but even then, the right most column would be the one that is centered. It would sure look awkward to have quantity left justified. Furthermore, the size of the columns is more suited to work as presented. Changing the width of the columns would also be more work. You'd need a working knowledge of fpdf and how it works to make these changes look good.
hello, i try this module (and i get this err:
Warning: fopen(packinglist.pdf) [function.fopen]: failed to open stream: Permission denied in /var/www/web4/web/admin/fpdf/fpdf.php on line 1044
FPDF error: Unable to create output file: packinglist.pdf
please tell me, where this module write packinglist.pdf (full path or relative path)?
or where is problem? Many thx.
The path is your admin folder. This mod requires that the packlist can be created here. Try changing your admin folder to 755 permissions. That should fix your problem.
I thought that I would share that I use this module to fax purchase orders in. I use Faxaway.com service so the system actually emails to a server that then faxes it to my sub contractors that drop ship for me. It is really wonderful set up for me and my suppliers.
Latest test upgrade from 1.3.8a to 1.3.9b, on admin when you click on "P.Os send and recieve" and "P.Os send to unknown customer", "Edit subcontractors" the page goes blank.
I realize this module was written for 1.3.8a and may not be compatible.
Just checking if:
-Anyone has tried the upgrade to 1.3.9b and have this module working right (which means I may not have done a good job at upgrading)
-If this module is not compatible with 1.3.9b, is there any chance a new version will come out any soon?
Thanks!
Haven't tried it yet, although I don't see an obvious reason why it wouldn't work. As soon as I have more experience with 1.3.9b I'll post my results.
OK. I can confirm that this mod is not compatible with ZC 1.3.9. However, the edit subcontractor page seems to be working fine. Can you try it again to verify that it has problems?
As for the Send PO and Send PO for unknown customers page, you need to add this line of text before where the function zen_get_products_manufacfturers_name is defined:
Just search for "function zen_get_products_manufacturers_name" and add this before that line.Code:if (!function_exists('zen_get_products_manufacturers_name')) {
At the end of the function zen_get_products_manufacturers_name you will see a "}". After that "}" add another "}".
This needs to be done in admin/send_pos.php and admin/send_pos_nc.php
Can you check the edit_subcontractor page and confirm if there is a problem or not one more time?