Overstock Data Issue Is All About the SKUs

Share this content:
LAKE BUENA VISTA, FL -- Clearance retailer Overstock.com Inc. was in a pickle.

With different business lines -- Web sites for shopping; books, music and movies; auctions; and travel -- yielding a SKU count of 1.2 million and an annual growth rate of 100 percent, the company found its internal reporting system couldn't meet user demands for up-to-date, accurate data.

So the Salt Lake City-based retailer built a data warehouse that let it better communicate with and manage customers and suppliers. Overstock turned to Sunopsis' extraction, transformation and loading technology to handle that task.

"They have multiple applications, all of them having part of the information needed by executives to make decisions," John Rauscher, chief operating officer at Sunopsis, said yesterday, taking time from booth duty at the 2005 Annual Teradata Partners User Group Conference and Expo. "We're gathering all the information in a common business format and in a single place where they can query from their workstation."

Overstock looked at other database technology options that would have required it to buy a dedicated engine to handle the changes. This would have raised costs and scalability concerns. Besides, a proprietary engine would have forced the movement of data several times.

Sunopsis, which maintains offices in Burlington, MA, and Limonest near the French city of Lyon, won for its user-friendly architecture. It takes the information from Overstock's Teradata warehouse and places that content into proper data warehouse structures in real time.

For instance, when Overstock records a purchase, the data need to be formatted and populated in six to eight records. Previously, Overstock hand-wrote the code to get the information into each of the needed formats and files.

Now this transformation and movement of data are done automatically via Sunopsis. More than 300 users in Overstock's marketing, sales and financial departments can generate real-time data when they need such metrics hourly, daily or weekly. In effect, Sunopsis' architecture lets Overstock transform 25 million daily processes into useful data.

Getting the right data into many hands within an organization at the right time is an issue for most marketers and retailers that generate gobs of information daily.

"It's common for every customer," Rauscher said, "and it's more important when you acquire other companies because you have to deal with different IT systems and applications."

Mickey Alam Khan covers Internet marketing campaigns and e-commerce, agency news as well as circulation for DM News and DMNews.com. To keep up with the latest developments in these areas, subscribe to our daily and weekly e-mail newsletters by visiting www.dmnews.com/newsletters

Sign up to our newsletters

Company of the Week

Since 1985, Melissa has helped thousands of companies clean, correct and complete contact data to better target and communicate with their customers. We offer a full spectrum of data quality solutions, including global address, phone, email, and name validation, identify verification - available for batch or real-time processes, in the Cloud or on-premise. Our service bureau provides dedupe, email/phone append and geographic/demographic append services for better targeting and insight. For direct mailers, Melissa offers easy-to-use address management/postal software, list hygiene services and 100s of specialty mailing lists - all with competitive pricing and excellent customer service.

Find out more here »

Career Center

Check out hundreds of exciting professional opportunities available on DMN's Career Center.  
Explore careers in digital marketing, sales, eCommerce, marketing communications, IT, data strategies, and much more. And don't forget to update your resume so employers can contact you privately about job opportunities.

>>Click Here

Relive the 2017 Marketing Hall of Femme

Click the image above