Drop Shipping Purchase Orders Module for v1.3.8

http://www.zen-cart.com/index.php?ma...roducts_id=981

Very hot, released right now. It's a surprisingly popular :) contribution and thank you to all those who use it - you guys give me a way to pay back to the ZC community for making ZC happen in the first place!

If you search this forum for "Drop shipping" or "Purchase orders" you will find some past threads showing the feedback this module had, this should help you decide if you need it (if the users manual at the bottom doesn't help there).

Tia.

Maciek

*****************************
V1.3B UPGRADES
*****************************
1) Incorporated updates and fixes made by Prattski to make this ZenCart v1.3.x compliant. TESTED ON 1.3.8.
2) General code maintenance, moved all necessary information to configuration variables
3) Updated list of available mail template tagnames both in subject and in contents of sent messages
4) Added debug mode for sending POs (admin/includes/extra_configures/purchaseorders DEBUGMODE set to Yes if needed)

*****************************
USER'S MANUAL (CRUDE FOR NOW)
*****************************
All of the options are available in the admin, of course.

EXTRAS/EDIT SUBCONTRACTORS
1) You can enter a list of subcontractors/dropshippers (SCs from now on) you work with (all their contact info, emails, phone, etc.)

EXTRAS/SET SUBCONTRACTORS
2) You can set a default SC for each product

CUSTOMERS/SEND POS
3) Using admin you can send POs to SCs

3.1) For each order in Processing you will see a list of all ordered products along with customer info in a simple table. For any 1+ -> all of such order items, you can send POs to their default SCs, or select another SC from a drop-down list (separate for each ordered item and customer). One of the SCs is called "Own stock" which means you commit to ship the item from your stock. Useful if you happen to do that. :)

3.2) For each product item selected, they will be grouped by customer into respective POs and emails will be sent to those SCs. Each PO would be dated and numbered. All the info for drop-shipping is in the email: what was ordered and where does it have to be shipped to.

*****************************
Example:

- John ordered 5 items. 2 of them from SC#1, 2 of them from SC#2, the last one normally sent from your stock
- Mary ordered 3 items. 1 from SC#1, 1 from SC#2, 1 from your stock

Say you have a returned item identical to one of John`s normally sent to SC#1 on your own stock and you want to move it.

Hit the Send POs screen. You`ll see 8 rows in the table. One for each ordered product. Each product would have a check box (send PO yes/no) and a drop-down menu (choosing the recipient of the PO, already prefilled upon default product SC).

You`d flip all the Send PO checkboxes to yes. You would change the John`s product you happen to have from SC#1 to `Own stock`. You`d hit SEND POs.

SC#1 will get 2 emails. One for each order and with one product on each one.
SC#2 will get 2 emails. One for each order, with two products on each one.
You will get 2 emails. One for each order, first with 2 products (John) and the other with 1 product (Mary).
*****************************

3.3) You would be able to re-send POs. You`d be able to search past POs by number, date range and recipient. Say SC#2 cannot process Mary`s order, but SC#1 can (although he wouldn`t be the default recipient). Look up that old PO by number, change the recipient to SC#1 and hit SEND. It`s renumbered and re-dated and emailed to SC#1.

CUSTOMERS/ENTER TRACKING

4) For items sent to your own stock, you`d be able to enter tracking numbers. THIS WOULD WORK THANKS TO THE TY_PACKAGE_TRACKER Contribution. YOU NEED TO HAVE IT INSTALLED IN ORDER FOR TRACKING TO WORK!

5) Each PO email will have a link to a simple form that would allow the recipient to choose which items were shipped and enter tracking info (carrier and number) for each (or all if he did it right and bundled them in a package). Thus you, the store owner, know all tracking info for each package that was shipped for that order.

6) The comments for the order would be updated with tracking info (with a link to the carrier's tracking page already prefilled with the tracking number) and a designation which item(s) were shipped in each package.

Wow, I look forward to testing this mod. Is this still in "beta" or is it ok for live sites?

Quote:

---

Originally Posted by Coop1979

Wow, I look forward to testing this mod. Is this still in "beta" or is it ok for live sites?

---

It's OK for live sites. I'm using it.

So here's a question - how hard would it be to have the system hold the orders and send them out once in a batch (in one email) at a pre-specified time? We send all of our orders at 2pm everyday.

Quote:

---

Originally Posted by Coop1979

So here's a question - how hard would it be to have the system hold the orders and send them out once in a batch (in one email) at a pre-specified time? We send all of our orders at 2pm everyday.

---

You would have to write your own version of send_pos.php. It's doable, but not easy.

Run into a problem when I installed it. Actually, let me back up. This is BRILLIANT and the timing couldn't be better!

I'm getting this error when i send a PO (just one) and when I re-send an old PO (all 3 together) - the PO is still sent.

Code:

---

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 457

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 460

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 465

---

Quote:

---

Originally Posted by Keepsake

It's OK for live sites. I'm using it.

---

It's not an error, as you see, it's a warning. It's got something to do with your MySQL version. Which one are you running? Does anybody else have this?

Thanks for the reply. Here are my details.

PHP Version: 4.4.4 (Zend: 1.3.0) PHP Memory Limit: 40M
Database: MySQL 4.1.22-standard

Quote:

---

Originally Posted by Keepsake

It's not an error, as you see, it's a warning. It's got something to do with your MySQL version. Which one are you running? Does anybody else have this?

---

If I install this can I set it up so that orders that are always fulfilled by a single place are automatically sent as soon as the credit card charge is approved?

Maybe that is the default behavior?

-jeff

Quote:

---

Originally Posted by jgarvas

If I install this can I set it up so that orders that are always fulfilled by a single place are automatically sent as soon as the credit card charge is approved?

Maybe that is the default behavior?

-jeff

---

No, the module doesn't have that behavior implemented at all.

Maciek

Quote:

---

Originally Posted by solarflare

Run into a problem when I installed it. Actually, let me back up. This is BRILLIANT and the timing couldn't be better!

I'm getting this error when i send a PO (just one) and when I re-send an old PO (all 3 together) - the PO is still sent.

Code:

---

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 457

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 460

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 465

---

---

When I send a NEW PO, I get this error

Code:

---

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tanningb/public_html/z/admin/send_pos.php on line 367

---

But the email shows up in my inbox (as a test, I have my own personal email address as a Supplier that the PO needs to be sent to), and it looks correct.

If I go back and try to resend the PO, I get the errors as above.
When I send the PO Again, the email shows up in my inbox, but everything except for the template is empty. so I see something like this.

Code:

---

TO: , , ,  ()

Dear ,

PO #12
Our order # (timestamp: )

---

I'm eager to launch my zencart site with this module, is there any resolution for this problem?

my details...
PHP version is: 5.2.5
mySQL version is: 5.0.45


Thank you!

I installed in a 1.3.7 installation. Setup a fake SC for myself. Ordered an item I had associated with me as the SC.

I went into Customers -> P/O's Send receiver -> Picked the third order and checked the box, saw that it had my SC. I hit submit and leave the first two orders alone.

I get this text back:

Nie mo¿na otworzyc pliku

...and the item remains as a new PO not sent. Did I do something wrong on the install?

Ok I peeked at the code and I wasn't loading the templates. Turns out I didn't copy the email/ directory over. Didn't realize that from the directions.

Now I submitted one PO to my fake SC and it is no longer in the list, but I get this on the redrawn page:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in .../admin/send_pos.php on line 367

Line 367 is the second of these two:

$check_if_po_sent = mysql_query("SELECT * FROM orders_products WHERE orders_products_id = '$tm'");
$if_po_sent = mysql_fetch_assoc($check_if_po_sent);


Thoughts?

Keepsake:

I'm having another issue that is confusing me. I received the email as a SC and there was a link to go to confirm_track_sub.php in that email. I can't get that to work for anything.

First, the confirm_track_sub is full of references to zarzad/includes -- I tried changing all occurrences of this to admin but I'm still getting all types of session errors and such.

Quote:

---

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at .../devel/confirm_track_sub.php:10) in .../devel/includes/functions/sessions.php on line 108

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at .../devel/confirm_track_sub.php:10) in .../devel/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at .../devel/confirm_track_sub.php:10) in .../devel/includes/init_includes/init_templates.php on line 78

Warning: main(admin/includes/extra_datafiles/po_database_names.php) [function.main]: failed to open stream: No such file or directory in .../devel/confirm_track_sub.php on line 39

Fatal error: main() [function.require]: Failed opening required 'admin/includes/extra_datafiles/po_database_names.php' (include_path='.:/home/myuser/php4/lib/php') in .../devel/confirm_track_sub.php on line 39

---

I did some digging around to see if I could figure something out, and I noticed that this doesn't exist, nor does it appear to be added by the Ty package manager or this mod:

admin/includes/extra_datafiles/po_database_names.php

ping to this thread...
does anyone have any suggestions on the MYSQL warnings that I've been getting?

When I send a PO, I get these MYSQL warnings.
The Email is sent, but I get one warning..
Code:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tanningb/public_html/z/admin/send_pos.php on line 367

But when I send it for a 2nd time, I get a blank email that only has the template text in it, and I get 3 mysql warnings.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 457

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 460

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/****/public_html/admin/send_pos.php on line 465

Any thoughts?

I believe I've fixed the problem for my issues on line 367. I tried running the SELECT query from 366 myself and it failed. No such table -- but when I installed I made all of my tables prefixed by zen_

So I took this code:

Quote:

---

$check_if_po_sent = mysql_query("SELECT * FROM orders_products WHERE orders_products_id = '$tm'");

---

and I changed the 'orders_products' like so:

Quote:

---

$check_if_po_sent = mysql_query("SELECT * FROM ".TABLE_ORDERS_PRODUCTS." WHERE orders_products_id = '$tm'");

---

I think that this might help you as well duran.goodyear.. I looked at line 456:

$orders_table_query = mysql_query("SELECT * FROM orders WHERE orders_id = $orderid");

and 459:

$orders_products_query = mysql_query("SELECT * FROM orders_products WHERE (orders_id = $orderid) AND (products_name = '$product_name')");

and 464:

$subcontractor_query = mysql_query("SELECT * FROM subcontractors WHERE subcontractors_id = $subcontractor_id");

In each of these cases your SQL query may be failing because you have a prefix on each of your tables and the code is looking for the tables without that prefix.

Despite my success here I still can't get the confirm_tracking number for suppliers to use to work. I'm not too sure why yet. Keepsake? :-)

Guys,

I'm sorry that the sloppy code caused so many problems for you.

I've just uploaded an updated version to www.bumpernut.com/purchaseorders.zip

1) DATABASE PROBLEMS

There were a few lines in the code that had hardcoded references to database table names and they wouldn't work if your table name prefix was not empty.

I have replaced them with dynamic references as it was done in all other places of this module (and is required by ZenCart, in fact)

2) CONFIRM_TRACK_SUB PROBLEMS

That code references some of the files in the admin directory: stylesheets, language files, etc. In my installation the admin directory was relocated and so were the references to it.

The uploaded version has references to admin again, however please remember that when you install it, if you have changed admin to something else (as is strongly suggested by the ZenCart team) you need to fix all the references in that file - line numbers are marked in a large comment at the beginning of the file.

Hope that helps everyone!
Maciek

Quote:

---

Originally Posted by jgarvas

admin/includes/extra_datafiles/po_database_names.php

---

I've fixed that as well, it's called purchaseorders.php now. I didn't catch it because I still had the old file in my test filesystem. :)

I *THINK* the headers already sent by errors are resulting from a failed require, please upload the new version of the file and tell me if you still get it.

Yep, I have a prefix on my table names.
I'll give your code fixes a shot tomorrow or over the weekend and see where they take me.

Thanks for the response guys!

Gang,

I seem to be having slightly different error messages upon a click on the link at the bottom of a PO email (although everything seems to be working fine otherwise):

Code:

---


Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/admin/confirm_track_sub.php:10) in /home/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/admin/confirm_track_sub.php:10) in /home/admin/includes/init_includes/init_templates.php on line 36

---

Any clues where would be the problem?

thanks.

Me too. Even with the updated version. Here is how I fixed it for myself.

1. Cut, but copy, all of the text before the <? character that is right above the text that explains which lines to edit for admin.

2. Paste that text immediately after the line that says //echo TRACKING_CUSTOMER_DATA (basically, you're moving all of the header HTML beneath all of the require statements so that it doesn't get sent until the session data can be sent.

3. Enclose that text within these characters:

<? and ?> -- The <? goes before all of the HTML you're pasting in and the ?> goes after the HTML. If you're not familiar with php this turns off PHP processing so that regular HTML can be sent to the browser, and then turns it back on.

This is what it ends up looking like:

Code:

---

//echo TRACKING_CUSTOMER_DATA;

?>

<html>
<head>
<html>
<head>
<TITLE>Confirm tracking</TITLE>
<link rel="STYLESHEET" type="text/css" href="admin/includes/style_tracking.css">

</head>

<body>

<?

if($_POST['save']=='save')

---

Keepsake: I'm not sure if this is what you intended to do but if you send anything before a session cookie you'll get the errors shown below, and apparently when you require something here it tries to do session cookie stuff. I'm by no means a guru of PHP but I know this much from tinkering.

Quote:

---

Originally Posted by gabstero

Gang,

I seem to be having slightly different error messages upon a click on the link at the bottom of a PO email (although everything seems to be working fine otherwise):

Code:

---


Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/admin/confirm_track_sub.php:10) in /home/includes/functions/sessions.php on line 108

---

---

Quote:

---

Originally Posted by jgarvas

Keepsake: I'm not sure if this is what you intended to do but if you send anything before a session cookie you'll get the errors shown below, and apparently when you require something here it tries to do session cookie stuff. I'm by no means a guru of PHP but I know this much from tinkering.

---

I did know that much. :) I just didn't realize that the session cookie is sent from the files that are required in the script... To be honest I never even had that problem at all, I never saw that message on my setup, not sure why.

Did the solution you outlined work for you?

I've updated the code again with your suggestions.

Keepsake & Ggarvas -

YES! it worked for me! The only minor thing was that apparently the css formatting was not applied any more but everything else worked as a whiz!

Side question. Since the confirm_track_sub.php form submits user info, shouldn't that be using the https? Any tweaks for that?

Thanks a lot for the tips!!!

Gabstero

Dumb question #1:

SCs (Sub Contractors) are hitting the zencart ADMIN login page when clicking on the email footer link to enter tracking. Should I create an admin login for them??


Dumb quesiton #2:
Shouldn't the buyer receive a notification email with the tracking number?

Thanks!
Gabstero

Good point on the CSS. I was just happy to see it working so I forgot about fancy looks.

With #1 - I think the idea is to allow SCs to update the tracking number without giving them access to your store. Thats definitely how I'd like it to work. (Heck, I'd like to either automate send_pos.php or allow it to be manipulated without admin access to the entire store).

The only way the confirm script appears it will do anything is if a proper order is supplied, and once that order is updated it can't be updated again. (or so it looks), so brute forcing it wouldn't be that big of a risk. You could probably put it into a directory like /tracking/ and put an .htaccess on that if you wanted to be safe.

#2 - I am getting emails from my test environment:

Quote:

---

From: Test Store

Test Store
------------------------------------------------------
Order Number: 5

Detailed Invoice:
{URL Redacted}/index.php?main_page=account_history_info&order_id=5

Date Ordered: 2008-02-14 20:20:00

The comments for your order are: Completed shipping this order.

Your FedEx Tracking ID is 4532432432
You can track your package at
http://www.fedex.com/Tracking?action...ers=4532432432

Your order has been updated to the following status:
New status: Delivered

Please reply to this email if you have any questions.

---

Quote:

---

Good point on the CSS. I was just happy to see it working so I forgot about fancy looks.

---

Me too. I just went in and turned on the table borders to have some sort of a layout.

Quote:

---

With #1 - I think the idea is to allow SCs to update the tracking number without giving them access to your store. Thats definitely how I'd like it to work. (Heck, I'd like to either automate send_pos.php or allow it to be manipulated without admin access to the entire store).

---

Agreed. It would be also nice to have a SC login of some sort of limited access to their previous orders, etc.

Quote:

---

The only way the confirm script appears it will do anything is if a proper order is supplied, and once that order is updated it can't be updated again. (or so it looks), so brute forcing it wouldn't be that big of a risk. You could probably put it into a directory like /tracking/ and put an .htaccess on that if you wanted to be safe.

#2 - I am getting emails from my test environment:

---

MAkes sense. And yes, the user recives the email but only when I go into the order, and do an update of some sort like change the Status to Update, or by adding something in the Comments box. Or even adding a new tracking to the existent one.

But hey - it works so far! Thanks a lot!

G

Quote:

---

Originally Posted by gabstero

Side question. Since the confirm_track_sub.php form submits user info, shouldn't that be using the https? Any tweaks for that?

---

It doesn't submit user info it pulls user info from the database. I don't think https here makes any sense.

Maciek

Quote:

---

Originally Posted by gabstero

Me too. I just went in and turned on the table borders to have some sort of a layout.

---

For me, the CSS works just fine in confirm_track_sub - which CSS doesn't work for you, ie. in which file? Because in this one it works... Unless you redirected your admin which means you have to change the link href.

Code:

---

<html>
<head>
<html>
<head>
<TITLE>Confirm tracking</TITLE>
<link rel="STYLESHEET" type="text/css" href="admin/includes/style_tracking.css">
</head>

---

Quote:

---

Originally Posted by gabstero

Agreed. It would be also nice to have a SC login of some sort of limited access to their previous orders, etc.

---

Well this module was a simple one in it's design assumptions, what you're talking about here is a whole new functionality that would be really complex to create. SCs should copy all emails to another folder for future reference and this would work as their order history.

Quote:

---

Originally Posted by gabstero

MAkes sense. And yes, the user recives the email but only when I go into the order, and do an update of some sort like change the Status to Update, or by adding something in the Comments box. Or even adding a new tracking to the existent one.

---

That's how Ty_Tracker is designed it only emails the user if you change something in the order AND check "Notify user" - it allows you to perform order changes without notifying the user also.

My code turns on the notify user function and updates the comment and I also get emails to my test user account so it works just fine.

Quote:

---

Originally Posted by Keepsake

For me, the CSS works just fine in confirm_track_sub - which CSS doesn't work for you, ie. in which file? Because in this one it works... Unless you redirected your admin which means you have to change the link href.

---

Is the CSS just drawing a box around the fields or does it bring in other theme related colors? If its just a box then mine is working.

Quote:

---

Well this module was a simple one in it's design assumptions, what you're talking about here is a whole new functionality that would be really complex to create. SCs should copy all emails to another folder for future reference and this would work as their order history.

That's how Ty_Tracker is designed it only emails the user if you change something in the order AND check "Notify user" - it allows you to perform order changes without notifying the user also.

My code turns on the notify user function and updates the comment and I also get emails to my test user account so it works just fine.

---

Did you write most of send_pos.php or did you inherit that? The different language throws me off from variable names to comments in the code. I'd like to try to identify the query that shows all the un-sent POs and the code that sends them when they're checked.

I'd like to write an alternative to send_pos.php that generates a list of non-processed PO's and processes them along with their default SC as if all of the check boxes were marked. For the store I run the suppliers are fairly static and this simple hack would automate my store. (Everything is drop shipped)

Can you help me figure out what code I need in send_pos.php?

I updated with the latest code release, and everything is working fine so far!

Thanks for the help!

Quote:

---

Originally Posted by jgarvas

Did you write most of send_pos.php or did you inherit that? The different language throws me off from variable names to comments in the code. I'd like to try to identify the query that shows all the un-sent POs and the code that sends them when they're checked.

---

I had it written actually.

I can probably still contact the original programmer to write this automated version for you, I'm sure we'll then be able to plug it into cron or after an order is placed for automation.

PM me to let me know what it's worth to you. I still have his ICQ and he's active so I can ask him if he'd do it.

Maciek

Does this module calculate shipping on a per-item zip code basis?

Quote:

---

Originally Posted by russmann

Does this module calculate shipping on a per-item zip code basis?

---

No, it has nothing to do with shipping cost calculation whatsoever.

Maciek

wow, this mod roks. thanks. i just installed and everything seems to be working.
except: i need to resend a po to the "real" S/C. I originally set up the emails to come to me for testing. Worked great, so I changed to the company's order emails, but they still come to me with the fake/testing info.

how do i resend the po's to the new email address?

Quote:

---

Originally Posted by cowboyfred

wow, this mod roks. thanks. i just installed and everything seems to be working.
except: i need to resend a po to the "real" S/C. I originally set up the emails to come to me for testing. Worked great, so I changed to the company's order emails, but they still come to me with the fake/testing info.

how do i resend the po's to the new email address?

---

I'm afraid you'll need to re-generate the purchase orders from scratch.

How do i re-generate the PO's?

also, is this mod listed in the downloads, if so where?

I had another idea for this mod. when i email my dropshippers, i send them an email and attach a pdf packing slip generated by viewing "packing slip" then save as .pdf, then attach it to the email. i don't have a lot of orders, so this works. but, with this mod it would be awesome to somehow generate the .pdf packing slip and then attach it to the email that is sent to the drop shippers along with the email PO that is already sent. then they just put the packing slip in with the order. Just an idea for the future.

Quote:

---

Originally Posted by cowboyfred

How do i re-generate the PO's?

also, is this mod listed in the downloads, if so where?

---

You need to see in the database install file (db_script) which columns are added to the orders_products table in your system and clear those for the products you'd like to re-generate.

Something like

update orders_products set po_sent='0', po_number=null, po_sent_to_subcontractor=null, po_date=null where po_number=XX

where XX is the number of the PO you want to re-generate.

Sorry, there's no online form/link to do it without programmatic access to the DB. You can run this query from your admin/db tools.

Gang -

An idea popped up for a way of managing shipping for different manufacturers as a drop shipper:

I have a FedEx acct, that I could pass along to my manufacturers (subcontractors) and let them use it for whatever items they ship.
This way the shipping charges are calculated precisely from wherever the package is shipped and applied to my account.

Pro? Cons?

thanks,
gabstero

Thanks for all the work on this! This is a fantastic contribution.

One small problem -- The tracking seems to work fine from the email link. But, I can't seem to get it to work from Admin - Customers - POs-Enter Tracking Number. All I get is a blank page when I click this.

I can always enter them using the TY Tracker interface in my admin, but this makes it hard to deal with multiple shipments as it won't show what products shipped with each shipment.

Is anyone else able to get this to work?

Quote:

---

Originally Posted by srturner47

Thanks for all the work on this! This is a fantastic contribution.

One small problem -- The tracking seems to work fine from the email link. But, I can't seem to get it to work from Admin - Customers - POs-Enter Tracking Number. All I get is a blank page when I click this.

I can always enter them using the TY Tracker interface in my admin, but this makes it hard to deal with multiple shipments as it won't show what products shipped with each shipment.

Is anyone else able to get this to work?

---

I have, everything seems to be working good. although i am still testing with orders,shippers and customers to make sure everything is working good.

Well, I think the newest version of this must have some problems in admin/confirm_track.php -- I went through the file and found some small issues, but it still didn't work. I must be missing something. Here's what I found:

A couple of %2 are in there instead of a space.

A couple <? are in there instead of <?php


Could you post or PM me the copy of admin/confirm_track.php that you are using successfully? I bet this will fix my problem.

Thanks!

I found a little bug. If you split an order in two between two suppliers/drop shippers only the first tracking information will be sent to them. To fix this, I changed the following in confirm_track_sub.php

Around line 170 change $customer_notified=1; to this:

if($order_shipping_complete==1) {
$customer_notified=1;
} else {
$customer_notified=0; }

I found a few other little bugs, but they only seem to affect the resending of old P.O.s:

1. Old POs will only resend to the original dropshipper no matter what you choose.
2. Old POs won't combine items onto one PO like New POs does for the same orders.
3. Old POs won't include product attributes.

I tried to fix the third one, but wasn't able to figure it out.

By the way, I've gone ahead and made some changes to make this contribution easier to use. I realized that I was going to need more information to decide who I would drop ship with. So, I added Customer Comments, State, and Shipping Choice to the New Orders page. This way I can evaluate what the cheapest method to ship something is. I can also see if there are any special requests in the comments that I need to accomodate before blindly sending a PO out. If people are interested I'd be happy to share the changes to do this.

If anyone figures out how to fix the Old PO resend problems please let me know.

Can someone post an old copy of confirm_track.php that is working for them. I still get nothing on Admin-Customers-PO Enter Tracking #. :( I'd really like to try an older version and see if something is up with the newest one.

I've made some serious changes to this mod, and I am considering re-releasing it. First, I'd just like to ask if that is ok with anyone who has worked on this. I know I have the right to do so as there is no restrictive license on this code, but I'd hate to step on anyone's toes.

Here's what I've done so far:

1) Implemented PDF packing lists that automatically attach to the email purchase orders. These have customer comments, and only include the products that ship with each purchase order. If the purchase order is a partial shipment, this is indicated on the PDF packing list.
2) Reworked confirm_track.php. As stated in my previous post, this was badly broken. I fixed a lot of bugs and cut a lot of code. I also added who the purchase order was sent to. It seems to work fine now.
3)As noted in my last post, I added a ton of extra information to the send PO page.
4)Emails to customers now include all products shipped regardless of whether or not the shipment was a partial shipment or not. The old one only listed the products if it was a partial shipment
5)I simplified the PO # and Order # system. Now, PO #'s are what used to be Order #-PO #. So for example, if the PO # is 5 and the order # is 10 the new PO# would be 10-5. This way, there is only one number that your subcontractor needs to know, but you have all the information you might need in this number.
6)Changed the tracking input page so that all products are checked by default. The most common scenario is that all products shipped at once, so this is the easiest way to handle this. If not, you can still easily uncheck products.


Here are two things that I still have not addressed that I would like to address before re-releasing this:

1) The Resend PO page has a ton of problems. In addition to the problems I have already posted, the PO is always resent to the same subcontractor! Yikes!! Big problems... I have not worked on the resend page at all.

2) I'd like to remove one of the two "own stock" selections. Why do we need two of them?

That sounds amazing. Most of those mods you have planned are very good. Keepsake I think originally did this mod and has been excellent for support on it as it grew. Perhaps they can weigh in on your question.

I figure if I don't hear from anyone before this is ready, I'll just release it. I may not be able to tackle the resend POs; I keep finding more and more problems with it. I'll certainly give it a try, but I'm not going to kill myself trying to fix it.

By the way, if you are using this module, please be aware that there is a bug with the shipping when sending new POs. When sending multiple orders, it will only use one type of shipping for all of your orders! So, be careful, and send orders out one at a time. Otherwise, you may end up with an expensive shipping bill from your subcontractors! :) I've fixed this problem, and when I can pull everything together, my new release will include this fix.

If I don't end up fixing the resend problems, all I really need to do is take out the code that is specific to my site. I've been using the modified system for a little over a week now, and the only problem I had was with the shipping. (Luckily, I stocked the product that led me to discover this error!!)

i noticed an issue recently with the email that gets sent in the OLD version (which I am still using). Where it says {delivery adress} in the email, it is not sending the ENTIRE shipping address. Instead, if an address has more than one line, for example:

John Doe
1234 Street
Apt. #4
City, State 12345

it only sends:

John Doe
1234 Street
City, State 12345

It is missing the other line. This is a serious issue. Does anyone else have this problem? How can I fix this?

Thank you!
Jaime

I already fixed that problem for sending new POs. When I release my changes, it should work with the second address line.

With old POs, I haven't bothered. The resend function has too many other serious problems to even begin tackling the little problems like this one.

If you want to fix it yourself, the variables you need to call from the database for address line 2 are customer_suburb, delivery_suburb, and shipping_suburb. You'll have to create a simple function to check if there is any data, otherwise you will end up with a blank line for all the addresses without a second line.

Hope that helps!

Quote:

---

Originally Posted by srturner47

I figure if I don't hear from anyone before this is ready, I'll just release it. I may not be able to tackle the resend POs; I keep finding more and more problems with it. I'll certainly give it a try, but I'm not going to kill myself trying to fix it.

By the way, if you are using this module, please be aware that there is a bug with the shipping when sending new POs. When sending multiple orders, it will only use one type of shipping for all of your orders! So, be careful, and send orders out one at a time. Otherwise, you may end up with an expensive shipping bill from your subcontractors! :) I've fixed this problem, and when I can pull everything together, my new release will include this fix.

If I don't end up fixing the resend problems, all I really need to do is take out the code that is specific to my site. I've been using the modified system for a little over a week now, and the only problem I had was with the shipping. (Luckily, I stocked the product that led me to discover this error!!)

---

srturner47
did you release the new version? also, did you place it in the downloads section?

That is way beyond my scope of expertise since I am not a programmer. Can anyone help me? If you can tell me what code to replace that would be easiest for me since I do now know how to write code. Thank you again for your help!

Just upgrade to the version I just released. I uploaded it to Zen Cart's contributions, so it should be up soon.

Here are the release notes for this upgrade:

1) Implemented PDF packing lists that automatically attach to the email purchase orders. These have customer comments, and only include the products that ship with each purchase order. If the purchase order is a partial shipment, this is indicated on the PDF packing list.
2) Reworked confirm_track.php. This was badly broken. I fixed a lot of bugs and cut a lot of code. I also added who the purchase order was sent to. It seems to work fine now.
3) Added a ton of extra information to the send PO page.
4) Emails to customers now include all products shipped regardless of whether or not the shipment was a partial shipment or not. The old one only listed the products if it was a partial shipment
5) Simplified the PO # and Order # system. Now, PO #'s are what used to be Order #-PO #. So for example, if the PO # is 5 and the order # is 10 the new PO# would be 10-5. This way, there is only one number that your subcontractor needs to know, but you have all the information you might need in this number.
6) Changed the tracking input page so that all products are checked by default. The most common scenario is that all products shipped at once, so this is the easiest way to handle this. If not, you can still easily uncheck products.
7) Fixed many problems with the PO resend page. Basically, I just reused the code for PO sending with a few modifications. It seems to have fixed all the bugs.
8) Got rid of duplicate Own stock entry in drop-down menus.
9) Added search capability for Order Numbers in PO Resend page.
10) Fixed problems with incorrect shipping when sending multiple POs at once.
11) Fixed problems with 2nd line of address and company not showing up in addresses.
12) Added the ability to add comments to packing lists and POs.
13) Changed the default behavior so that orders are not listed on the Send PO or Resend PO page if they have been marked "Delivered" in Zen Cart.
14) Added the ability to reinsert "Delivered" products on the Resend PO pages with a checkbox.
15) Added the ability to remove customer comments from packing lists.
16) Changed the default behavior so that when an order is sent to subcontractor, the order is changed from "Pending" to "Processing." The customer IS NOT notified when this happens, but they can see this in their account if they log on. After the first part of the order is sent to a subcontractor, it will no longer do this for future POs.
17) Changed the wording and date format to reflect the changes made and the U.S. date system of MM-DD-YYYY. The exception was on the Resend PO page, where for logistical reasons, changing the date format would have been more difficult to do.
18) Added a warning about refreshing the page.
19) Changed default number of POs to show on one page to 100.
20) If you split an order in two between two suppliers/drop shippers only the first tracking information was sent to the customer. This has been fixed.
21) Change mailing addresses to reflect the format used in the United States.
22) Added a way for you to convert one type of shipping to "Cheapest" on the PO.
23) I've probably forgot something! But, this seems like everything I can remember doing. :)


Enjoy!

I'm still using 1.3.7 - will it work with that ok?

I honestly don't know for sure. I don't see why it wouldn't work, but you never know!

More likely than not, it will work fine. You don't have to make any SQL changes because you have previously installed this, so just make sure you back up your store and your SQL database before you install over them. Then, if it doesn't work, you can always revert back.

Thank you! Can you please post a link when it is up?

Linked:

http://www.zen-cart.com/index.php?ma...roducts_id=981

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 also don't have: Admin->Configuration->Purchase Orders

nevermind about the admin--->configuration and the errors :) i seem to have fixed most of these issues. am now testing.

OK So I am one of the ones who is upgrading, not installing fresh. So, here are my questions:
1) When the email comes to me, the FROM line is: PO_FROM_EMAIL_NAME
2) There is no PDF attachment at all.
3) I have nowhere to configure anything - where is this located? Did I need to change something?

Other than these things, its great!

Thank you!
Jaime

Unfortunately, that probably means that this is not compatible with Zen Cart 1.3.7. The attachment part of the zen_mail function was listed as an experimental feature in the Zen Cart code, which probably means it was added in 1.3.8.

What you'll need to do to make this work with 1.3.7 (without the attached PDF slip, you need 1.3.8 for that) is to find the zen_mail function and then rewrite one line of code to fix this. The line of code you will need to rewrite is on line 475 of send_pos.php. It looks like this:

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,PO_FROM_EMAIL_NAME,PO_FROM_EMAI L_ADDRESS,NULL,NULL,$pdffilename);

You'll need to search for where this function is defined. Do that by going to Admin-Tools-Developer's Toolkit and searching for "function zen_mail" without the quotes. Check that file out and see the variables that are defined in this function. That will help you rewrite the code on line 475 of send_pos.php. If you can't figure it out, post the code you find by searching with the developer's toolkit and I will tell you how to change line 475 of send_pos.php.

By the way, the configuration stuff wasn't added by me. All of the configuration stuff was in the SQL update you installed originally. You can find it under the Extras and Configuration menus in Zen Cart Admin.

By the way, I highly recommend you update to 1.3.8. There are tons of bug fixes and new features. Well worth the time and effort!

Thanks so much for your help - the PDF function isn't necessary for me right now so that is ok.

I can't upgrade at the moment since I have so many mods, but I am working on a test site right now where I have already installed 1.3.8.

In the meantime, here are the lines of code:

/includes/functions/functions_email.php

Line #35 : function zen_mail($to_name, $to_address, $email_subject, $email_text, $from_email_name, $from_email_address, $block=array(), $module='default', $attachments_list='' ) {

Line #239 : function zen_mail_archive_write($to_name, $to_email_address, $from_email_name, $from_email_address, $email_subject, $email_html, $email_text, $module) {

Thanks for your help!
Jaime

Look like it should be working just fine. So, most likely, this variable doesn't exist with 1.3.7. So, just change the following on line 475:

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,"[email protected]",PO_FRO M_EMAIL_ADDRESS,NULL,NULL, $pdffilename);

That should fix the problem.

By the way, the function seems like it should work fine with the attachments. This got me thinking......I bet the attachment feature of the zen_mail function only works with certain email transport methods. Try switching your email transport method to PHP in Admin-Configuration-EMail Options, that may fix the attachment problems. I only tested this with PHP transport method, as this is what I use.

One last note: My site is HEAVILY modded, but I was still able to upgrade. It does take more work, but I was able to do it in about 5 hours. Just make sure to follow the instructions on upgrading. The key is to create an exact copy of your site and database that IS NOT LIVE and then compare and merge files manually. It takes awhile, but it is worth the effort.

That worked!! Thank you!
I already have my email set as PHP so maybe that isn't the PDF issue...

Oh well. Your PDF creation is working fine, or the whole php script would fail. It has something to do with how it sends it. It may be that this doesn't work with 1.3.7. Another possibility is that your web hosting service works differently than mine with emails.

Anyway, glad the rest worked. Enjoy!

First I just wanted to say thanks a lot for putting this mod out, it is greatly appreciated!

I am running ZEN v1.3.8, I just installed “drop shipping purchase orders” v2 and am having a few issues.

1.The app is sending out duplicate emails. For example if I place a test order and then go to Adom:Customers:POS – Send/Resend, check the boxes under “send PO yes/no” that corspond to the new order and click the “send” button, I receive two identical email with the all the order info.

2.The second issue is that I have no need for pdf attachments and would like to disable this feature.

3.The third issue I am running into is on the order emails that get sent out under the PRODUCTS ORDERED section all of the products are showing up on the same line and I would like them to each appear on their own line.

Thanks!



---------------------------------


iRebounders.com

I'm glad your enjoying the mod!

1) Hmmm. Don't know about this one. I had this problem as well, but I thought I had fixed this bug. I'll take a look at the code I published, which is slightly different than the one I use. Perhaps I forgot to fix this bug for the released version. Quick question that will help me solve this: Does the number of emails you get correspond to the number of products you ordered? (NOT the quantity -- the number of ITEMS.)

2) To get rid of PDF attachments, find this line in send_pos.php on line 475:

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);

and replace it with:

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS);

3) The emails are controlled by the three email files in the "emails" directory. I believe your problem is in the emails_products.txt file. Add a couple of enters to the end of this file and it should fix this problem.

I went ahead and tried the mod I released, and it is not sending two emails for me. Is it possible that you setup zen cart to senda copy of emails to you? You might want to try a different email address. Or is it possible that you have two different orders your are sending at once? That is what the mod is supposed to do with two different orders.

If that doesn't fix it, try redownloading and copying over send_pos.php.

Can someone kindly tell me what code needs to be modified in order to CC each of the drop ship emails to my address? This was mentioned in a thread for the 'other version of this module' , but was not answered. A little help for those of us not proficient in PHP would be very helpful.

http://www.zen-cart.com/forum/showth...purchase+order

Specificially, I need to have the send_pos.php code modifications necessary to CC all purchase orders to the site owner's email address. TIA

Sorry, I don't monitor that thread. Just recopy the line of code that sends the email and change it to your email address. Then, it will send the email twice. So, here is how you do it:

Change line 475 from

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);

to 3 different lines:

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);
$myownemail="[email protected]";
zen_mail($myownemail,$myownemail,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);

Of course, if you were using an older version of the mod this line would look slightly different. Same idea applies.

Wow.. this looks pretty amazing.

If I'm understanding this correctly, this mod allows you to automatically submit the orders to the drop shipper as well as an email confirmation sent to the customer? (thereby, avoiding manually submitting orders to the dropshipper?)

Is that correct?

Would like to be able to add custom fields on a per-supplier basis, such as credit card info, tax id, retailer account number. Have you looked at any of this, or would it be easy to do? I AM NOT A PHP PROGRAMMER, but have dabbled in html

Quote:

---

Originally Posted by srturner47

Sorry, I don't monitor that thread. Just recopy the line of code that sends the email and change it to your email address. Then, it will send the email twice. So, here is how you do it:

Change line 475 from

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);

to 3 different lines:

zen_mail($adresdo,$adresdo,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);
$myownemail="[email protected]";
zen_mail($myownemail,$myownemail,$tematk,$newzawartosc,P O_FROM_EMAIL_NAME,PO_FROM_EMAIL_ADDRESS,NULL,NULL, $pdffilename);

---

BRILLIANT! Works like a charm. Many thanks!

Hi

I have installed this mod on a test shop using xampp test server on my computer. I thought everything looked ok until I went to the payment modules in the admin interface. I haven't set up any payment modules yet.

I am getting these errors:

Edit Subcontractors (title appearing on the payment module page)


Warning: include(C:/xampp/htdocs/shop/includes/languages/english/modules/payment/authorizenet1.3.8.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\shop\admin\modules.php on line 173

Warning: include() [function.include]: Failed opening 'C:/xampp/htdocs/shop/includes/languages/english/modules/payment/authorizenet1.3.8.php' for inclusion (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\shop\admin\modules.php on line 173

Fatal error: Cannot redeclare class authorizenet in C:\xampp\htdocs\shop\includes\modules\payment\authorizenet1.3.8.php on line 589

I don't really know how to interpret these errors. Can anyone offer solutions to these errors please?

I am also using the Apple Zen template if that makes any difference!

Many thanks

Greg


As an aside I also have the Edit Subcontractors title showing on the Image Handler page as well.

I should add that I have not installed the Ty_Package_Tracker as I was not wanting to use this feature!

Quote:

---

If I'm understanding this correctly, this mod allows you to automatically submit the orders to the drop shipper as well as an email confirmation sent to the customer? (thereby, avoiding manually submitting orders to the dropshipper?)

Is that correct?

---

Can anyone answer this question, please? I'd rather not spend hours trying to install and modify this if it's not what I think this mod is supposed to do.

Quote:

---

Originally Posted by OzNet

Edit Subcontractors (title appearing on the payment module page)


Warning: include(C:/xampp/htdocs/shop/includes/languages/english/modules/payment/authorizenet1.3.8.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\shop\admin\modules.php on line 173

Warning: include() [function.include]: Failed opening 'C:/xampp/htdocs/shop/includes/languages/english/modules/payment/authorizenet1.3.8.php' for inclusion (include_path='.;C:\xampp\php\pear\') in C:\xampp\htdocs\shop\admin\modules.php on line 173

Fatal error: Cannot redeclare class authorizenet in C:\xampp\htdocs\shop\includes\modules\payment\authorizenet1.3.8.php on line 589

As an aside I also have the Edit Subcontractors title showing on the Image Handler page as well.

---

I think I may have fixed the error problem. At one stage I was replacing the payment files and did not want to over write the originals, so I changed the names slightly. However, ZC was still trying to read the files with new names as if they were new modules. So, in effect it is nothing to do with the drop shipping mod

I still have the Edit Subcontractors showing in the title of the payment page and the Image Handler page. This must be some slight conflict but if it is only cosmetic, I can live with that - will wait to see if there is a conflict in performance.

PattyGale - I think it does what you want. Here is a description of how this all works. I tried to make it as seamless as possible so that I don't have to do much! :)

1) Customer Orders. Order is marked pending.
2) I submit PO to subcontractor by checking a box and clicking submit -- doesn't get much easier than this.. When this is done, order is automatically marked processing and a note is added to the order that says "Order Submitted to Shipping Department for Fulfillment." <-- Something like that... I think that is what is says, but you get the idea! Easy to change if you don't like the wording. -- I figured that most customers would not want an email until it shipped, so this change is only reflected if they view their account online. No email is sent here.
3) Either I receive tracking number and input it or my subcontractor enters the tracking number. If the order is shipping from several subcontractors and has not shipped from all subcontractors, the order is still marked processing. If the order is complete, it is marked delivered. Either way, an email is sent to the customer with a link for their shipment tracking. This email includes all products included in this shipment and a brief note.

So yeah, it is pretty easy! It has cut my work time to almost nothing when it comes to order processing, which has freed time for actually shipping products and marketing our website.


OzNet - Glad you figured it out! Unfortunately, I have image handler as well, and I am not seeing the Edit Subcontractors there. I also use Authorize, and I don't see any problems on any payment page in admin like you reported. I really don't know what to tell you. It is quite possible that some modification you are using uses the same variable names as this mod uses. You might want to poke around and see if this is the case. By the way, I have never used this mod without TY package tracker. Even though it was originally intended to be used with or without TY, I can't guarantee that with my changes it will work well without TY. It don't see why you couldn't use it without TY, but some small changes may be necessary. The documentation has some information about this.

Daddio53 - Glad to hear that! Enjoy!

cropinstop - Sorry, I don't intend to add this feature. The good news is, I added an easy way for you to add anything you want to a PO or a Packing List. Of course, this requires a little manual input. It wouldn't be too hard to implement this with a checkbox to turn it on or off, but to add this on a per supplier basis would require messing around with SQL, and I am really not comfortable doing that. I just don't know enough about SQL. If you don't mind getting your hands dirty, you could always define your subcontractors and then add a simple if statement for them to add this info. Of course, this would hardcode these changes, so it would be difficult to undo. It is an interesting idea though. I'll keep it in mind.

Quote:

---

cropinstop - Sorry, I don't intend to add this feature. The good news is, I added an easy way for you to add anything you want to a PO or a Packing List. Of course, this requires a little manual input. It wouldn't be too hard to implement this with a checkbox to turn it on or off, but to add this on a per supplier basis would require messing around with SQL, and I am really not comfortable doing that. I just don't know enough about SQL. If you don't mind getting your hands dirty, you could always define your subcontractors and then add a simple if statement for them to add this info. Of course, this would hardcode these changes, so it would be difficult to undo. It is an interesting idea though. I'll keep it in mind.

---

I did a quick but dirty workaround by changing the "city" label to "city state zip" and used old "state" and "zip" fields to store the (one-time) credit card # and account # respectively.

New question - how do I disable sending the packing slip pdf with the email? My dropshippers have their own packing slips and do not want to be bothered with the added paperwork...

Quote:

---

Originally Posted by srturner47

Daddio53 - Glad to hear that! Enjoy!

---

Copies going out like clockwork.

However, here is a problem for me. I am in the US and the PO emails are going out with an incorrect shipping address. That is the postcode is placed in the address line ahead of the State. E.g.

City, Postal Code, State/Province

where it should be

City, State/Province, Postal Code.

Can you tell me what code changes in send_pos.php are required to fix this?

Also, it would also be helpful to remove the comma :,: between the state and postal code.

Thanks in advance for helping those of us who are PHP illiterate.

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.

Quote:

---

Originally Posted by 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?ma...roducts_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 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