Drop Shipping Purchase Orders Module for v1.3.8

[Keepsake]

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

[russmann]

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

[Keepsake]

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

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

Maciek

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

[Keepsake]

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.

[cowboyfred]

How do i re-generate the PO's?

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

[cowboyfred]

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.

[Keepsake]

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.

[gabstero]

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

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