Drop Shipping Purchase Orders Module for v1.3.8

[SandyNZ]

Im having problems assigning the subcontractors. I can add a new subcontractor but when I go into the 'set contracors' area and change from the default to a new one, then hit save, it does not save the change.

I hope this hasnt been covered earlier in the thread, I just havnt been able to read through all the pages.

[srturner47]

SandyNZ -- I can't seem to recreate the problem. Does everything else work ok? Can you still change the subcontractor you send a PO to manually when sending a PO? What version of Zen Cart and what version of the Drop Shipping Module are you using? Also, go into cPanel, then run phpMyAdmin. Click on your database and find the table "zen_products". The last entry should be default_subcontractor. If you don't have that entry something went wrong when you installed the SQL patch. If you do have that entry, try changing a product's default subcontractor and seeing if it changes this value in your SQL database.

[cowboyfred]

how can I add customer phone number in the PO email and on pdf slip. My shippers would like that info to ship. Just in case there is a problem with the shipping the shippers can call the customer.

also, thanks for the mod, it has worked AWESOME.

[cowboyfred]

how can I add customer phone number in the PO email and on pdf slip. My shippers would like that info to ship. Just in case there is a problem with the shipping the shippers can call the customer.

also, thanks for the mod, it has worked AWESOME.

Got it to work in the email.

Here is how i did it:
go to:
email_header.txt
insert:
Telephone: {customers_phone}
E-mail: {customers_email}

[srturner47]

I've been working really hard at getting this out, and I'm happy to announce that version 4.0 of this mod is here. This version is packed full of new features including customizable text-file attachments, addition and subtraction tags that allow you to customize emails and text-file attachments for individual subcontractors, and an easier page for entering tracking that features a GreyBox pop-up to enter tracking numbers for individual purchase orders. There's a lot more -- so checkout the changelog below.

The text-file attachments are particularly exciting as they will allow you to create custom files in a word processor (using .rtf) or in a spreadsheet (using .csv format) and attach them to your orders. You can also create tab-delimited files for subcontractors that require them. Another possibility is to create a text file packing list that is more customized than the PDF one I included. New addition and subtraction tags allow you to have different text file attachments for each subcontractor. And, now you can define which subcontractors get PDF attachments and which subcontractors get text attachments from admin.

The bad news is, this version is not free. The good news is, I will continue to provide support in this thread for the old version. For the time being, I'll provide support for the paid version via email, although I may switch to a message board format on my website if that becomes necessary at some point.

I've written a proper manual for this version, so if you'd like to check that out, please click on my signature link and then click on the user manual link in the product description. This mod is packed full of features that are difficult to describe, so I think writing a manual was important.

Here is the changelog:

V4.0 CHANGELOG
*****************************
1) The enter tracking information page now uses GreyBox to place a nifty javascript pop-up in your browser when entering tracking information. Then, once you enter this info, the original window is refreshed. This reduces the steps that were required to enter tracking info, eliminates the pop-up, and immediately updates the enter tracking page by removing the order you entered tracking info for from the page.
2) Added optional text file attachments that can be customized just like the emails by editing a new text file template. These can be reviewed and edited for each PO from the review PO before sending page, just like the email. This will allow users to design tons of different attachments at will for their subcontractors, include tab-delimited files, custom text packing lists, and even rich-text format files that will open in word processors.
3) Added tags for both the email and the text file attachment that allow the user to add or remove sections from their purchase order for different subcontractors. This allows you to customize emails and text file attachments for different subcontractors.
4) Added tags for both the email and the text file attachment that allow the user to add or remove sections from their purchase order when sending a purchase order for an unknown customer.
5) Removed admin configuration for removing three sections from the purchase order when sending for an unknown customer. This was a redundant feature, as the change above allows the user to do this and more.
6) Changed tag replacement behavior so that all tags in the header now work in the footer and vice-a-versa. This allows a lot more flexibility in how you design your email or text file attachment. For example, in the last version, you couldn't put the shipping address after the products because the shipping address was restricted to the header alone. In this version, this is no longer an issue.
7) Added the ability to change the way the order status is updated as orders work their way from new, to po sent, to shipped. Also added the ability to prevent any changes in order status.
8) Added the ability to specify subcontractors that should have packing lists attached, and/or text files attached to their purchase orders. Users can still use the old options for always sending these, never sending these, or having a checkbox for each PO sent to determine if these should be sent if they prefer.
9) Now compatible with Google Checkout in the following ways: a) PO tracking link will be replaced with a message that this feature is not available for Google Checkout orders and instructing the subcontractor to email tracking info. b) The admin enter tracking for PO page now links the user to the edit orders page, where you can change the order status to Google Processing, and then enter the tracking information to complete the order with Google Checkout. Google Shipped orders will be treated as shipped orders. c) On the enter tracking info for POs page, a “GC” is placed before Google Checkout orders to alert the user that these orders are from Google Checkout, and hence they will link to a different page for entering tracking info. d) Not a new feature, but still important for Google Checkout – POs sent that were Google Checkout orders will not change the order status from Google New.
10) With the old version, it was difficult to tell which items were from a single order on the send PO page. This version alternates text colors (black, blue, black, blue, etc...) for each order to make it easier to distinguish between different orders while still preserving the background color alternation that makes it easy to distinguish between different products ordered.
11) Reviewing a PO no longer automatically updates the database before you send the PO. So, you can abort the process up until you click the final send button, and nothing will be affected.
12) When you try to review more than one PO at a time, you will now get an error message instead of an undesired behavior.
13) Refreshing the page or using the back button will no longer resend the PO on the send PO page, resend PO page, and review before sending PO page. This was not implemented for the send PO for unknown customer, as it would have required an additional database entry that would serve no other purpose, and this just didn't seem worth it. So, you still need to be careful on the send PO for unknown customer page. This is an important new feature, because it greatly reduces the likelihood of accidentally sending a PO twice.
14) Meta information is included for attachments.
15) Added the ability to change the way orders are listed on the send PO page and the resend PO page – either oldest orders first or newest orders first.
16) Added message stack to confirm that POs have been sent.
17) Added the ability to enter a custom customer comment on the packing list. This is useful when a customer has a comment that is partially for you and partially for the recipient of the package; you can enter a customer comment manually that only includes the part that should be on the packing list.
18) Reconfigured resend PO page. Now includes shipping address and quantity of item ordered.
19) When orders change from new to po sent status, your preferences dictate what, if anything, happens. If there is no po sent message to be included in the order notes, and no po sent status change is specified, nothing happens. If one of these is specified, it happens, but not the other. If both of them are specified, they both happen.
20) Fixed spelling of address on tags. This means that your old email templates may need to be adjusted to reflect the correct spelling on these tags.
21) Upgraded to newest version of fpdf for PDF creation.
22) Wrote a proper user manual.
23) Various code improvements and tweaks.
24) Whatever else I've forgotten about and changed! :)

Hope you like it!

[SandyNZ]

SandyNZ -- I can't seem to recreate the problem. Does everything else work ok? Can you still change the subcontractor you send a PO to manually when sending a PO? What version of Zen Cart and what version of the Drop Shipping Module are you using? Also, go into cPanel, then run phpMyAdmin. Click on your database and find the table "zen_products". The last entry should be default_subcontractor. If you don't have that entry something went wrong when you installed the SQL patch. If you do have that entry, try changing a product's default subcontractor and seeing if it changes this value in your SQL database.

Sorry for taking so long to get back here, just been up to my ears in stuff. I can go into the database and make the change there and it changes it in the admin side. I just cant change it in admin.

I have made a test account and a test order. That side seems to be working ok, however, when clicking on the tracking link it goes to this link
http://www.bestplacebythefire.com:80...b.php?x=0&y=12
which only displays

Table 'bestplac_zc1.orders_products' doesn't exist

the table should be zc2 so Im not sure why it is trying to find the other database (I have more than one database on the domain name) and it is also adding another slash after shop.

One last thing, when I go and search for old PO's and find the one Im testing it says the last PO was sent to the default dropshipper (Own Stock - which it wasnt) and the dropdown box is also showing as Own Stock and not the one it was assigned to.

Any ideas??

Oh, and Im using the latest versions of both

[srturner47]

SandyNZ -- It sounds like somewhere or another you have the wrong SQL database configured. This is usually done in /admin/includes/configure.php and /includes/configure.php. Check there and make sure your database is configured correctly. If everything looks ok -- you see zc2, then go to your admin at Tools -> Developers Toolkit. In the last entry under "Look up in all files" enter "zc1" and then set the pull down next to it to "All Files Catalog/Admin". Then click the search next to it. This should find where the incorrect zc1 database definition is coming from. If for some reason this doesn't work, search for "DB_DATABASE". This is the define that confirm_track_sub.php uses for your database.

The double slash is normal. It shouldn't affect your link and was intentionally added. Try any other link and add a double slash and you will see that this doesn't affect a url.

I suspect all your problems are related and have something to do with the wrong database being accessed.

[SandyNZ]

Ok, done all you suggested and found no mention of zc1, only zc2 in the configure.php's and in the search. I found DB_DATABASE in several places but Im not sure what Im looking for as far as an error.

[srturner47]

SandyNZ -- Very strange. I don't understand how your server is looking for zc1 since it clearly isn't defined anywhere in Zen Cart files. Do you have zc1 as a database? Is it a Zen Cart install? Perhaps somehow two installs of Zen Cart are getting mixed up. Did you make sure that all the instances of "admin" in /confirm_track_sub.php are changed to the admin directory name that you use with your Zen Cart install that uses database zc2? Maybe the directory in this file is pointing to another Zen Cart install directory that uses database zc1.

If this doesn't lead you to the solution, then you can try this to test my theory further: If you have a second Zen Cart install, change the two configure.php files from zc1 to somename. Then, see if the error changes from zc1 to somename. If it does, you know that somehow the configure.php being used is the one for your other zen cart install.

The line of code that is probably pointing to the wrong directory in confirm_track_sub.php is:

require ('includes/configure.php');

By the way, what directory is the confirm_track_sub in? What directory is the root directory of the store using this mod? What directory is the root directory of the other store (if you have 2 zen cart installs). Confirm_track_sub.php should be in the root of the zen cart store you are using this mod with.

Hope that helps!

[activityshopper]

Hi I had a quick question regarding either the old version or the new one that you have currently released.

When we do POs, we run into problems where we would like to remove the PO after we set the status to REFUNDED and add the notes. However, when we do that, it doesnt end up removing it from the page where you enter the tracking information. The only status that it does remove it is when we change it to OUT FOR DELIVERY.

Is there a way to add additional status's to the completion of order which will remove it from the package tracking system?

Thanks

Regards,

Matthew
ActivityShopper.com