Alibris, a company that deals in rare and out-of-print
books over the Internet, wanted to streamline the interface between
their shipping and order/entry department. As orders are received,
books are sent from their warehouse or gathered from around the
world and sent to their state-of-the-art fulfillment center. The
orders are then processed and shipped same or next day using UPS,
FedEx or the United States Postal Service®.
Alibris
uses a host system running Windows over an Ethernet network to
manage the order fulfillment process. They wanted to quickly transfer
data from six shipping workstations to a Great Plains (accounting
software) database on two host computers using a SQL Server driver
while processing thousands of orders a day.
Harvey
Software determined ODBC was the fastest method of transferring
data between the Windows-based shipping PCs and the host computers.
The company took advantage of Harvey Software's on-site computer
set up and training service. Alibris also had special programming
so that their importing and exporting of data specifications matched
their current needs, including a date and time stamp for auditing
purposes. A customized message of "Order Not Found" was also
added to be displayed when an entry could not be found on the external
lookup table to make seamless link with their ERP system.
Now,
orders are passed from the host computer to the workstations and
shipping data is returned to the host in "real time," as the orders
are filled. At end of day, the data is merged from the workstations
and passed back to the main CPS shipping server, where it is uploaded
electronically to UPS. Alibris customers enjoy their books
only a day or two after they've placed their order!
Just three weeks after deploying their CPS system,
Alibris was named by US News as one of the best shopping sites on
the internet! Even though we know this was due to the outstanding
work by the people at Alibris, we like to think that we helped.
Learn
more about Alibris and all their products at their web site,
click here..
Contact
the Harvey Software Sales department if you need a solution to help
you with your shipping, 800-231-0296 or
send an e-mail today. We
can create a seamless solution for you in no time too!
<Previous
|