From 20 Spreadsheets to One View – A Multi-Site Case from ERPNext Consulting

A landscaping supply company had four yards across two states. Every yard had its own spreadsheet. Every week, the owner spent three hours trying to reconcile them. He never knew his true stock levels until something went wrong. And something always went wrong.

Spreadsheets are not a multi-site strategy

One yard would order 50 bags of mulch while another yard had 100 bags sitting idle. Wasteful and frustrating. ERPNext Consulting connected all four locations into a single system. Now the owner logs into one dashboard and sees everything instantly. No more phone calls to check stock.

  • Each yard sees its own stock but also the group’s surplus
  • Transfer orders between yards are now done in two clicks
  • Purchasing is consolidated, so they buy in bulk and save 12% on cost

The owner’s biggest surprise

He thought he was managing well. The data showed he was wrong. One yard was carrying 40% more inventory than needed. He reduced his total inventory by 18% in the first quarter. The annual savings paid for the entire project. He finally has Monday mornings back because he’s not digging through spreadsheets.

If you have more than one location and you’re using separate spreadsheets, you’re flying blind. A practical engagement with ERPNext Consulting can give you the one view you actually need.

Leave a Reply

Your email address will not be published. Required fields are marked *