rainbowsheep Posted July 12, 2003 Share Posted July 12, 2003 How are you guys handling shipping stuff in your sites? I'm currently trying to make my site as automated as possible. It would be great for when an order comes in, a tracking number gets automatically assigned, UPS is notified, the customer is automatically notified of the tracking number, a shipping label is printed out automatically and all the store operator has to do is pack the box, put the label on the box and let UPS come pick it up. Anyone doing anything similar to this? Quote Link to comment Share on other sites More sharing options...
pvallen Posted July 13, 2003 Share Posted July 13, 2003 I am in the process of setting up a new site and doing some of what you mention but it is not totally seamless. Basically, I added the UPS XML Rates contribution. This does real time rate quotes from UPS servers during on the order shipping page. We use the UPS WorldShip PC program to assign tracking numbers and laser print the labels. This is a client/server program provided by UPS. This program puts the tracking number on the clipboard. I modified the UPS XML tracking contribution. It allows you to enter up to 10 (comma separated) tracking numbers to the order database when you change the order to mark as shipped. The customer email sent when the order status changes includes a link to the order history detail. On this page appears the tracking number with a "View" button. When the customer clicks this button it redisplays the order history page with the UPS tracking info retrieved using the UPS tracking XML APIs. Our biggest redundancies in data entry are entering customer name and address into both QuickBooks and UPS WorldShip, and moving the tracking number from WorldShip to OSC. But we are fairly low volume shipper so this is not a big burden. Good luck, Paul Quote Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2003 Share Posted July 13, 2003 There is a quickbooks mod that will create new customer record in IIF as well as the orders. YOu can also from OSC create the datafile to export to WOrldship format. THis way you do not have to acutally enter the info all the time. Quote Link to comment Share on other sites More sharing options...
Chris_C Posted July 14, 2003 Share Posted July 14, 2003 We use worldship to connect to our osc database. I type in the order number, then world ship pulls the customer, order, and email info off the database. All I have to do is type in the order number and weight. Everything else is automated. UPS even emails the shipment notification to the customer when we do an end-of-day. It even assigns the person's order number as a reference number to use on the website tracking link. Makes for very easy shipping. Quote Link to comment Share on other sites More sharing options...
racelance Posted July 18, 2003 Share Posted July 18, 2003 Chris~ What type of process is it to have UPS Worldship connect to my OSC database? I'm trying to set a clients site up to do exactly what you already have done. Any help would be greatly appreciated! Lance PS Feel free sending me a private message. Quote Link to comment Share on other sites More sharing options...
cgchris99 Posted July 19, 2003 Share Posted July 19, 2003 I too would like more information on how to connect UPS world ship to connect to osc Quote Link to comment Share on other sites More sharing options...
Guest Posted September 2, 2003 Share Posted September 2, 2003 We use worldship to connect to our osc database. I type in the order number, then world ship pulls the customer, order, and email info off the database. All I have to do is type in the order number and weight. Everything else is automated. UPS even emails the shipment notification to the customer when we do an end-of-day. It even assigns the person's order number as a reference number to use on the website tracking link. Makes for very easy shipping. Chris, This sounds truly AWESOME! I would like to know how you have done this and see your code if possible. This would be save us hours... Thanks, Zac Quote Link to comment Share on other sites More sharing options...
mistmov Posted September 16, 2003 Share Posted September 16, 2003 it has been a long time since chris last posted that massage! Does anyone else know how to do this? Quote Link to comment Share on other sites More sharing options...
jello1 Posted September 16, 2003 Share Posted September 16, 2003 I 2 would kill to have this.... i'm fat fingering 300 orders a day and it's killing me... Quote <span style='font-family:Courier'>If you can't fix it Perl it!!!...</span> ****************************** Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.