homepage Welcome to WebmasterWorld Guest from 54.211.47.170
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Ecommerce
Forum Library, Charter, Moderators: buckworks

Ecommerce Forum

    
Automatic printing of shipping labels
How to automatically print UPS labels, etc as orders come in.
philbish




msg:626361
 3:52 am on May 27, 2003 (gmt 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

 

philbish




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

bump

jpjones




msg:626363
 7:34 am on May 29, 2003 (gmt 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?

TallTroll




msg:626364
 3:09 pm on May 29, 2003 (gmt 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

agile




msg:626365
 11:47 pm on May 29, 2003 (gmt 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]

graywolf




msg:626366
 2:44 pm on May 30, 2003 (gmt 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.

philbish




msg:626367
 2:59 am on May 31, 2003 (gmt 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / Ecommerce
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved