From Data to Shelf Locations: How BigSeller Helped Tools R Us Reorganize a Warehouse with 2,000+ SKUs

In Biñan, Philippines, Tools R Us Hardware Enterprises OPC operates one physical store, one warehouse, and six online stores across Shopee and Lazada.

With INGCO as its core brand, Tools R Us sells power tools, hand tools, and other mainstream hardware products. Its wide product range serves both professionals and everyday consumers, but it also creates a demanding warehouse operation. By 2025, the company’s online sales had exceeded PHP 3 million, while its catalog had grown to more than 2,000 SKUs.

At that scale, the main challenge was not confusing product models or specifications. It was keeping track of stock quantities, product locations, and sales changes across a large and varied catalog.

After using BigSeller for two months, Tools R Us could complete a full warehouse stocktake and reconcile physical inventory with system records in just 1 to 2 hours. The same work previously took 1 to 2 days.

This improvement came from both centralized order and inventory management and one day of on-site implementation support from BigSeller’s Philippine team. Together, they connected system data with the warehouse’s actual shelves and daily operations.
 

From One Physical Store to Six Online Stores

Tools R Us began with traditional hardware retail, supplying local customers with power tools, hand tools, and industrial products. As more Philippine consumers began buying tools through ecommerce platforms, the company expanded its business to Shopee and Lazada.

Online expansion allowed Tools R Us to reach customers beyond its physical store. However, as the business grew to six online stores, orders, product records, and inventory movements from different channels also increased.

The warehouse had to support more frequent stock confirmation, picking, and shipping. At the same time, new products continued to enter the catalog. The team was no longer dealing with a small selection that could be managed through memory and manual records. It was managing more than 2,000 SKUs within a limited physical space.

As order and product data increased, the existing warehouse workflow began to struggle to keep pace with the online business.
 

When 2,000+ SKUs Make Shelf and Inventory Control Harder

Tools R Us did not have a product-identification problem. The challenge came from the overall size and variety of its hardware catalog.

Previously, products were placed mainly according to available space and staff experience. The team lacked a clear data basis for deciding which fast-moving SKUs should be easier to reach, which products required frequent picking, and which items could be placed in less accessible locations.

That approach could work with a smaller catalog. Once the warehouse contained more than 2,000 SKUs, staff had to repeatedly search, confirm, and cross-check products across many shelves.

Inventory information was also spread across online stores and manual records. The team had to spend substantial time checking whether platform stock, system records, physical quantities, and product locations matched.

A full warehouse stocktake and book-to-physical inventory reconciliation normally took 1 to 2 days. For a warehouse also fulfilling orders from six online stores, this work consumed manpower and interrupted daily operations.
 

The Initial Concern: Would a New System Add More Complexity?

When Tools R Us decided to use BigSeller, the team still had concerns. A hardware warehouse already has many SKUs and a complex product distribution. If a new system were difficult to operate or failed to match the physical warehouse, it could add another layer of work instead of solving the problem.

“Before using BigSeller, we were worried that the system would be complicated and make an already difficult warehouse operation even harder to manage. But with the support of the BigSeller team, the final result far exceeded our expectations.”

— Founder, Tools R Us Hardware Enterprises OPC

The implementation therefore needed to do more than activate software features. BigSeller’s Philippine team had to understand how the warehouse actually operated and help translate system settings into a workable shelf and inventory structure.
 

One Day to Connect Six Stores, One Warehouse, and 2,000+ SKUs

BigSeller’s Philippine implementation team spent one day helping Tools R Us establish the foundation of its new workflow.

The implementation covered four key areas:

1. Store authorization: connecting all six Shopee and Lazada stores to BigSeller.
2. SKU binding: linking marketplace products with the corresponding inventory SKUs.
3. Inventory push rules: defining how available inventory should be shared with the connected online stores.
4. Shelf-location planning: arranging SKU positions according to the warehouse layout and actual sales activity.

The system centralized orders, products, and inventory data. The local implementation team then helped connect that data to the warehouse’s physical shelves and operating habits.

Instead of treating every SKU in the same way, the team used sales activity to decide which products should be placed in more convenient locations. This gave warehouse staff a clearer basis for finding, picking, replenishing, and checking products.
 

Starting with Marketplace Data, Then Optimizing with BigSeller Reports

Tools R Us had only been using BigSeller for two months. At the beginning of the project, the account did not yet contain enough historical sales data to support shelf-location planning.

Rather than wait for months of new data to accumulate, BigSeller’s implementation team reviewed historical sales information from the customer’s marketplace seller centers. This data helped the team identify sales patterns and arrange SKU locations within the available warehouse space.

Once store authorization, SKU binding, inventory rules, and shelf locations were in place, BigSeller began building a more consistent operating data history.

Going forward, Tools R Us can use BigSeller’s Product Sales Report and Inventory In/Out Report to review SKU performance and adjust shelf locations or inventory arrangements as sales patterns change. Warehouse planning is no longer a one-time cleanup based only on experience. It can become an ongoing, data-supported process.
 

Full Warehouse Stocktaking Cut from 1-2 Days to 1-2 Hours

The clearest measurable result appeared in warehouse stocktaking.

Before BigSeller, completing a full warehouse count and reconciling physical inventory with records took 1 to 2 days. After two months of using BigSeller, Tools R Us could complete the same work in 1 to 2 hours.

The improvement was not simply the result of installing software. It came from combining centralized data with local implementation support that translated warehouse information into practical shelf arrangements and operating rules.
 

Two Months Is Only the Beginning of Continuous Warehouse Improvement

Tools R Us has only been using BigSeller for two months. The most immediate change is not a sudden expansion in business size, but a clearer understanding of what is in the warehouse, where products are located, and how inventory relates to six online stores.

BigSeller brings the company’s order, product, and inventory data into a more centralized workflow. The Philippine implementation team helped apply that data to the physical warehouse by planning shelf locations around sales activity and available space.

The most visible result is the reduction in stocktaking and reconciliation time from 1 to 2 days to 1 to 2 hours. Beyond that metric, warehouse staff now have a clearer location basis for daily product searches, picking, replenishment, and inventory checks. Managers can also use BigSeller reports to keep adjusting SKU locations as sales patterns change.

For Tools R Us, this means warehouse management no longer depends on periodic manual reorganization alone. It is gradually becoming a continuous process supported by operational data.

The change started with one day of local implementation. Two months later, a hardware warehouse with more than 2,000 SKUs and orders from six online stores has a stronger foundation for daily operations, future product growth, and continued ecommerce expansion.