Drop Shipping Purchase Orders Module for v1.3.8

Daddio53 - Are you sure you are using v2.0 of this mod that I released? I fixed the US address problem in this version. The old version displayed the address differently.

cropinstop - See post #67 on page 7 of this thread.

srturner47:

Daddio53 - Are you sure you are using v2.0 of this mod that I released? I fixed the US address problem in this version. The old version displayed the address differently.

It appears I am NOT running the latest version. However, before I blindly update, the new install instructions tell me to run the included dbscript.sql. The first statement there is to drop the existing table. Does that mean I will lose my existing subcontractors entered with the old version? If so, how can I avoid that?

TIA for your assistance. I hope I am not the only person who will benefit from my simplistic questions and your valued answers.

Please make sure you read the instructions carefully. You DO NOT need to run the SQL script to update -- this is only for new installs. And don't forget to backup -- you can't always revert back by simply copying over the changed files.

Again, make sure you are installing the version found here:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=981

Whoops! That should read:

you CAN always revert back by simply copying over the changed files.

Lesson: Backup, backup, backup! :)

I've looked all through this thread and can't find my problem. Everything works great except that on the send_pos.php page right below the "View Old POs and Resend Them" button it says failed to connect to database:8. Then the title bar is printed on the screen but nothing is coming through from the database to the send_pos.php page. Anyone have this problem? It seems like something simple, but I can't see anything I did wrong during installation.

Thanks for any help,

Tim

Great mod btw!!

Check two things first:

1. Did you install version 2.0 with the PDF packing lists?

2. Are you using V1.3.8 or 1.3.8a?

3. Try deleting send_pos.php and copying it in again.

If these simple ideas don't fix it, you'll need to get your hands dirty. Your problem can be found on one of the following lines of send_pos.php:

835, 840, or 676

You'll need to go in and change the number eight to something else so you can troubleshoot where the problem lies. This will isolate the code that is giving you trouble. Sorry, I should have done this myself to make troubleshooting easier.

Once you figure out where the problem lies, post the code on that line, it should start with $query. I'll take a look and see if anything looks wrong.

1. Yes I installed version 2 (the only version on the zen cart download page). Is there another version?

2. Zen Cart v1.3.8a database v1.3.8

3. Tried it....no go.

So.. I began tooling around in send_pos.php around the lines you suggested (I thought it was very neat how you gave all the queries different error messages so you could tell where to look:)) and everything looked right. I uncommented the drop table line in the sql update file so I could rerun it. Redoing the database FIXED the problem I was having, but now the error is different.

Fatal error: Call to undefined function pasek() on line **894

**Is there really a function called pasek?

Anyway that's where I'm at now
Thanks for the help,

Tim

Oh...Ha Ha

I put the wrong purchaseorders.php file in admin/includes/functions/extra_functions. It works perfectly if the database takes the sql file and the operator actually manages to follow the instructions:no:.

Great mod thank you,

Tim

Glad you figured it out! :D

I am a new zenner. Kept looking and finally found answer to question I posted earlier with drop ship products with this thread. Glad I found it!

I am setting up products and site. Website is https://www.burnerbooks.com. I have Zencart version 1.3.8a, php version 4.3.11 and MySQL 5.0.45. I loaded this file to my site. Can not find Extras/Edit subcontractors in drop drop box in Admin to enter dropshippers information.? Is there anyone download I am missing?

Thanks,
kburner

See the picture -- That's where to find it. If it is not there make sure your files are in the right place and that your SQL patch has been installed.

This is the second website I'm installing this. First time wenst smooth but this time I'm getting this error while trying to send orders to my contractor:

Warning: fopen(packinglist.pdf) [function.fopen]: failed to open stream: Permission denied in /home/bachelor/public_html/admin/fpdf/fpdf.php on line 1046
**FPDF error: **Unable to create output file: packinglist.pdf

Someone can help please?

It seems it has something to do with the permissions of your admin directory. This mod will create a packing slip and then email it. The file is first created in your admin directory. After it emails it, the mod deletes this file. The script's packing list creation is being denied by your server. Try changing the permissions of your admin folder to 777. See if that fixes your problem. If it does, you know this is a permission problem. DO NOT leave your permissions as 777, as this is dangerous. Find a more secure setting that works for you. Hope that helps.

By the way, this is a questions for anyone who would be interested: I added an extra feature to this mod. It is extremely useful for me, but I am not sure if it would be valuable for others. It takes a lot of work to package up a mod for general consumption by Zen Cart users, so I wanted to see if anyone was interested in the changes. If not, I won't bother releasing it. Basically, this new version has a page where you can send POs for customers who did not buy through Zen Cart. So, for example, if you have a customer who places a phone order, buys through ebay, etc.... you can fill in a few details about them, choose the products from your database you want to send, and then it will email a PO with a Packing List attachment to a subcontractor of your choice. Nothing is recorded to the database for these customers, so tracking would still have to be handled by hand for these customers. This was extremely difficult to write, and I use it all the time, but I wasn't sure if there was the demand from anyone else for something like this. Let me know if you are interested. If people are, it will probably take a few weeks for me to get around to packaging it up, but I can do it. The only negative of this approach is that I didn't include all of the possible fields on this page, so fields like phone number are ignored. It would be quite cluttered to make a page with all these fields, and I don't use most of them anyway. It just uses the basics: Ship address, bill address, shipping method, PO Number, comments for PO and packing list, and all the products stuff: quantity, model, description, and attributes.

Ok, I have it up and working like a charm. My drop shipper gets the orders thru cUrl and I need to modify the send_pos.php to send the cUrl statement.

Allot of the notes are in a foreign language. Any thoughts where I should include the code?

Steve

It's funny -- I know the code back and forth for this mod and I still have no idea what the notes mean! :) Is that Polish?

Anyway, the email and packing list get sent on line 475, so if want to change the way they are sent, just replace the zen_mail function with whatever you like.

$addressdo = email address of subcontractor
$tematk = Email Title
$newzawartosc = Email Body

The rest is in English, so I think you'll figure it out. Good luck!

I have it partially working now, Thanks... What other variables are open at that point? I need to load the order to send out. If the order# is loaded I could use that for the query??

Steve

Thanks srturner47

Changing admin's premissions to 777 did the work. But I don't want to leave it like that.

Where can I change the destintion where the e-mail is being created? I couldn't find it in the files...

Thank you for this great module!

fotofx - As the order is being sent, the orderid is $tm1. All the variables are already queried, so I wouldn't bother redoing that. Just find them and use them how you like. The main query happens early on, and it immediately uses some of the variables, and then passes a few of the variables on through the script using two arrays: first is $wielowymiar the second is $tmpt. Handling variables can be a little complicated because the script will only send one PO if it is the same order sent to the same subcontractor, no matter how many items are picked. Just follow the pattern with the $wielowymiar array and the $tmpt array, and it will work ok.

YairOz - It is on line 473. Just change it to:

$pdf->Output("../packinglist.pdf", "F");

This will put it in your root directory. You can figure it out from there if you want to put it somewhere else. By the way, you shouldn't need to do 777 to make this work. Try 755 for your admin directory. That should fix your problem and it is much safer.

Any reason why this plug would slow the checkout process down?

I am now having serious hesitation during checkout steps 1 and again after 3 "confirm order" and am at a loss as to what is involved in this plug that has anything to do with this flow. Could be my host but they seem to be OK

Any advise would be great.

OK, I have everything working properly but need to make 1 change. I modified the send_pos to send my order thru cURL to the drop shipper. We only use 1 drop shipper for everthing and the way I have it set up the order goes out once with all the items. I do not need a seperate PO for each item. Is there a way to make it so if I check send PO on any item within an order it will mark all items in that order as sent? Or not generate multiple PO's for each item on an order?

It has to be sent out as I did it on 1 PO becase the drop shippers sytem will generate multiple orders (and multiple shipping) if sent on a per item basis.

Again, it is functioning perfect, except I will always have unsent PO's on any multiple item order unless I can figure out how to group them or at least make all sent.

Thanks
Steve