Welcome to WebmasterWorld Guest from 54.147.44.93

Forum Moderators: buckworks

Message Too Old, No Replies

Automatic printing of shipping labels

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

     

philbish

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

10+ Year Member



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

philbish

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

10+ Year Member



bump

jpjones

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

10+ Year Member



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?

TallTroll

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

WebmasterWorld Senior Member 10+ Year Member



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

agile

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

10+ Year Member



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]

graywolf

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

WebmasterWorld Senior Member 10+ Year Member



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.

philbish

2:59 am on May 31, 2003 (gmt 0)

10+ Year Member



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.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month