Drop Shipping Purchase Orders Module for v1.3.8

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

cropinstop - See post #67 on page 7 of this thread.

[Daddio53]

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.

[srturner47]

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

[srturner47]

Whoops! That should read:

you CAN always revert back by simply copying over the changed files.

Lesson: Backup, backup, backup! :)

[nyderrn]

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

[srturner47]

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.

[nyderrn]

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

[nyderrn]

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.

Great mod thank you,

Tim

[srturner47]

Glad you figured it out!

[kburner]

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