Drop Shipping Purchase Orders Module for v1.3.8

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.

jderrers:

**When I click on Send/Resend POs (/admin/send_pos.php):

Warning**: main(fpdf/fpdf.php) [function.main]: failed to open stream: No such file or directory in /home/wolf/public_html/vitamindesignshop/admin/pdfpack.php on line 2

Warning: main(fpdf/fpdf.php) [function.main]: failed to open stream: No such file or directory in /home/wolf/public_html/vitamindesignshop/admin/pdfpack.php on line 2

Warning: main(fpdf/fpdf.php) [function.main]: failed to open stream: No such file or directory in /home/wolf/public_html/vitamindesignshop/admin/pdfpack.php on line 2

Fatal error: main() [function.require]: Failed opening required 'fpdf/fpdf.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/wolf/public_html/vitamindesignshop/admin/pdfpack.php on line 2

I am also getting this error - can you tell me how you fixed it? Thanks!

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

if ($tmpt[0][7] != 'Cheapest Shipping Method') {

$newzawartosc = str_replace("{shipping_method}",$tmpt[0][7],$newzawartosc);
} else {
$newzawartosc = str_replace("{shipping_method}",'Cheapest',$newzawartosc);
}

to

if ($subcontractor['subcontractors_id'] == 2)
    $newzawartosc = str_replace("{shipping_method}","Ship This Via MyWay Express",$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.

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.

srturner47:

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

if ($tmpt[0][7] != 'Cheapest Shipping Method') {

$newzawartosc = str_replace("{shipping_method}",$tmpt[0][7],$newzawartosc);
} else {
$newzawartosc = str_replace("{shipping_method}",'Cheapest',$newzawartosc);
}

> 
> to
> 
> ```
if ($subcontractor['subcontractors_id'] == 2)
    $newzawartosc = str_replace("{shipping_method}","Ship This Via MyWay Express",$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.

Thanks a ton!!!

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.

srturner47:

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!

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

https://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:

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

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!