Drop Shipping Purchase Orders Module for v1.3.8

[srturner47]

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:

$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');

The resend page already has this behavior by default.

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->

[srturner47]

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?

[kburner]

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?

[kburner]

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?

[srturner47]

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!

[kburner]

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...

[kburner]

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...

[JimmyV]

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.



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.

[srturner47]

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!

[gabstero]

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!

Thanks so much!

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