Case Studies (Indexed)

Lush Builds Global Inventory Management with CockroachCloud

CockroachDB Customer Case Studies

Issue link: https://resources.cockroachlabs.com/i/1210467

Contents of this Issue

Navigation

Page 0 of 2

Lush is building global inventory management with CockroachCloud Global cosmetics manufacturer and retailer Lush operates 950 stores across 49 countries and processes 165k transactions daily Lush Fresh Handmade Cosmetics is a global inventor, manufacturer and retailer of fresh handmade cosmetics founded in 1995 in Poole, Dorset and has grown to operate in 49 countries with over 950 stores. Their UK stores alone process 165,000 financial transactions daily. Lush's database architecture was made up of MySQL instances in 20 of the countries in which the Lush Group operates. While this architecture was an integral part of the company as it grew globally, it created a lot of operational complexity. In particular, the disparate MySQL instances could not talk to each other, which made it difficult to optimize inventory or evaluate the company's performance on a global scale. Lush's Challenge Efficiently managing inventory across 950 stores in 49 countries is no small task. With dozens of MySQL instances spread out all over the globe, Lush was unable to see real-time analytics on their inventory, limiting their ability to rapidly adjust strategy. Lush promises to deliver the freshest products from source to skin, so the lack of visibility into the quantity and age of each product made it hard to avoid overstocking or understocking. Closely related to the inventory challenge is the difficulty of evaluating the business on a global scale. Rob Reid, a Principal Engineer at Lush explains: Cosmetics Retailer 950 stores in 49 countries 165k financial transactions daily "In our current database configuration, there is no easy way to immediately assess the performance of Lush's products at global scale. If the data were located in the same system it would be much easier to interrogate that data." –Rob Reid, Principle Engineer Adding further challenge, is the emergence of data protection laws and data localization regulations. As an international retailer that does business all over the globe, Lush is required to domicile some user data in particular countries. This is the cost of doing business on a global scale, and it has been incredibly tricky to accomplish. For more information visit cockroachlabs.com or contact us.

Articles in this issue

Links on this page

view archives of Case Studies (Indexed) - Lush Builds Global Inventory Management with CockroachCloud