Drop Shipping Purchase Order Module

Have installed this module and it works great !!! needed some heavy modifying, but thanks to all in this thread who helped, also had to add a few more fields (qnty, payment method and publisher) we sell books, now here comes the fun part!!!! we are trying to get an api built that goes to the book distributor, this module has 90% of the code already created, and works great !!

what we are trying to do, is

bypass email and send a .dat file to server

accept a return and process/update zen customer and shipping information

i have all the specs from the distributor and think this may be a bit out of my realm!!! has anyone tried this w/ this mod?? and if not, would anyone be interested in trying this ?? or have any information on who would accept a job like this !!!

thanks again all who have designed and helped w/ mod so far !!! this is something that weve been looking for , for a bit now !!!

Chuckl

I decided to give it a try to this module... Where can I download the files?

Thanks!
Gabstero

Links to the download in the first post here

http://www.zen-cart.com/forum/showthread.php?t=29466

You'll also need the Ty package tracker module from the downloads area here.

I've installed this mod in 1.3.7 (including Ty Package tracker).

Everything works in terms of configuring subcontractors (drop shippers), and the mod seems to function when I edit and set subcontractors.

What doesn't seem to work is the actual sending of emails. Can other 1.3.7 users comment on this?

I get the default order notification as before, but no Purchase Orders are sent to any of my test addresses.

I actually work with creativearc (the guy who just posted above this). We have been trying to work out some of the bugs that we found with this module. Here's the things that we didn't like about it, or that didn't work:

- wouldn't send the emails (bug for 1.3.7?)
- when you resent a PO, it would increment the PO number (not sure why it needed to do this... but we didn't like it)
- Didn't display the PO number on the already sent list

So, I modified the send_pos.php file quite a bit to fix/add these features. The main bulk of the update is that resending POs does not increment the PO number. It keeps the PO number as was originally set. Everything seems to be working flawlessly now on 1.3.7. I even cleaned up the code so that it is correctly tabbed in it's if/while/for statements for the all the code at the top portion of the page before the HTML.

I'll attach the file to this post. You will need to edit two variables near the top of the page - I have labeled them though, so you can't miss them. They are just for the From Name, and From Email address for when POs are sent out.

Have any questions, please let me know. I'll try to do my best to answer them.

Updated File:

Here is an updated zip file. I found a bug in it that when resending multiple POs, it would get stuck on a specific PO number for all of the POs, which was incorrect.

Here is the new file:

I found another bug - minor - but if you want to fix this issue, here is how to do it:

In the Admin, when you go to the "Edit Drop Shippers" page, you'll notice that when you change different drop shippers to edit, you'll notice that the dark green background header information doesn't change. The fix is simple.

Open up this file: /admin/edit_subcontrac.php

if you haven't edited it much, head on down to line 260 or so. You'll see this code:

Code:

---

<td colspan="2" width='' class="infoBoxHeading">
<? echo "ID:$fond[0] Full name:$fond[1] "; ?>
</td>               
</tr>               
<?
       
               
$query2=mysql_query("SELECT * FROM ".TABLE_SUBCONTRACTORS." WHERE subcontractors_id='$cid'")
or die("Nie mozna sie polaczyc z baza danych");
$row2=mysql_fetch_array($query2, MYSQL_NUM);
               
// projekt szablonu do wyswietlania subcontracotow oraz wyswietlanie ich       
               
?>

---

Change that code to this: (essentially just moving the query, and editing the values for the header ID and Full name)

Code:

---

<?
$query2=mysql_query("SELECT * FROM ".TABLE_SUBCONTRACTORS." WHERE subcontractors_id='$cid'")
or die("Nie mozna sie polaczyc z baza danych");
$row2=mysql_fetch_array($query2, MYSQL_NUM);

// projekt szablonu do wyswietlania subcontracotow oraz wyswietlanie ich       
?>
<td colspan="2" width='' class="infoBoxHeading">
<? echo "ID:$row2[0] Full name:$row2[2] "; ?>
</td>               
</tr>

---

I've also found a way to take the confirm_track_sub.php out of the admin directory, making it possible for drop shippers to enter in tracking numbers without needing to login to the admin.

If anyone is interested, let me know and I will post the details.

Thanks for everyone's help. This module seems to work okay now. I would like to make a few changes. Please advise. Thank you.

1. How do I change the email subject line to "Order # for (customer's name)"?
2. How do I add supplier's name in the email? I have quite a lot of suppliers.

I've gotten a request as to how to move the confirm_track_sub.php out of the admin directory, so that the dropshippers don't have to login to zencart.

It's quite simple, yet complicated all at the same time. I'm including both send_pos.php and confirm_track_sub.php in a zip file on this message.

I'm sure there might be a better way to do what I did, but what I did seems to work fine. The only non-dynamic information in there (I think...) is the tracking links for each shipper. You'll see that I manually put those in near the top of confirm_track_sub.php.

Basically, open up send_pos.php (it is quite modified, so don't just overwrite your file with mine if you don't want the updates/fixes that I've done to it, as explained in the posts above). In it there is a line or two pointing to the confirm_track_sub.php. You'll need to change this in your file to point to the new file outside the admin directory.

Take my confirm_track_sub.php and put it in the main store directory (just outside the admin directory). Make the changes noted at the beginning of the file (should be only 3 or 4 lines to change I believe).

Once you've done that - it should work like a charm. Let me know if there are any issues or questions you have.