Welcome to WebmasterWorld Guest from 54.144.80.75

Forum Moderators: buckworks

Message Too Old, No Replies

Automatic printing of shipping labels

How to automatically print UPS labels, etc as orders come in.

     
3:52 am on May 27, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:May 25, 2003
posts:194
votes: 0


I realize automating my online store that ships tangible goods will help my business a lot so I am making an entire database to deal with orders, products, customers, and finances.

I just started using UPS world ship and a thermal label printer. I am still trying to get it to interface with a mySQL database to pull adresses and shipment information.

Is there some way to have the computer automatically print out a label as soon as a confirmed order comes in? How would I go about doing this? I know a lot of you probably send out many items a day so I am wondering how you deal with this.

Thanks :)

Phil

6:49 am on May 29, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:May 25, 2003
posts:194
votes: 0


bump
7:34 am on May 29, 2003 (gmt 0)

Full Member

10+ Year Member

joined:Dec 9, 2002
posts:325
votes: 0


Off the top of my head, you could regularly poll the database for new confirmed orders using a script, then print off details of new orders, and then set a flag against those orders saying they've been printed.

How you would do this? Well, AFAIK, PHP & ASP do not have any output to printer facilities (unless you can output to a named device - anyone have any experience with this?). This means you'd be looking at programming in something more low level - C?

Anyone else have any ideas?

3:09 pm on May 29, 2003 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 6, 2001
posts:880
votes: 0


The way I would deal with the issue is by integrating the ecommerce site and the back end accounts / stock control systems. An order is placed on the web site, and brokered into the accounting systems as a batched order, then reviewed and approved (or not).

From there, you use the built label printing method inherent in most decent a/c packages. If thats not an option, I guess you need a script to detect a successful order, and trigger a label print. It sounds possible, but my d/base scripting skills aren't up to it

11:47 pm on May 29, 2003 (gmt 0)

New User

10+ Year Member

joined:Apr 21, 2003
posts:20
votes: 0


With <snip> e-commerce software, you can print labels directly from a web-based order management system. Basically it allows you to bypass inputting the data into the World Ship software. You can print to a UPS Eltron printer or to an 8.5 x 11 sheet of paper. The labels can be created one at a time or in batch, but they are not automatically printed as the orders comes in. UPS feeds the web-based order management system both the label and the tracking number. It uses XML and is pretty slick.

[edited by: TallTroll at 11:59 pm (utc) on May 29, 2003]
[edit reason] self promotion [/edit]

2:44 pm on May 30, 2003 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 28, 2002
posts:1324
votes: 0


If you had a dedicated printer, you could write program/script that is triggered when the order comes in but that would be pretty dependant on your programming expertise and time you had to devote, layout would be a little tricky. Might be useful as a learning experience.
2:59 am on May 31, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:May 25, 2003
posts:194
votes: 0


I figured out the World Ship software has scheduled task abilities... so I could set up like tasks every 30 minutes to query the database.

I would just have to have some way to mark those that were printed.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members