Walker Food Group — Inventory & Order Management
Inventory, Orders and Vendors in One System.
A custom FileMaker solution that centralizes inventory, pricing, sales, purchasing and vendor coordination for a seafood distribution business.
Business challenge
Perishable stock and shifting supply
As Walker Food Group expanded its seafood distribution operations, keeping inventory accurate and coordinating weekly vendor supply became harder. Products are perishable and availability fluctuates.
The company needed a central system to maintain real-time stock visibility and streamline ordering, and to replace manual tracking and spreadsheets.
Implemented solution
A unified system for the daily operation
FM Solutions delivered a custom FileMaker solution that centralizes day-to-day processes. Internal teams manage sales and purchase orders, monitor inventory levels in real time, control pricing, and oversee vendor and customer data from a single platform.
A key part of the solution is vendor collaboration. Vendors log in securely, select the relevant supply week and submit the quantities they have available. That data connects directly to inventory and purchasing, so the team can make informed buying decisions and respond quickly to changes in supply.
Functional areas
What the system covers
The main areas, as described by the project and shown on its home screen.
Sales and purchasing
- Sales orders, purchase orders, invoices and packing lists.
Customers and delivery
- Customers, consignees and delivery addresses.
Vendors
- Vendor records and supplier coordination.
Products and inventory
- Products, an inventory list and a product list for approval.
- Archived inventory and archived sales orders.
- Real-time inventory levels and pricing control.
Workflow
The vendor availability workflow
How supply information reaches the buying team, as described by the project.
Step 1: Log in
The vendor signs in securely.
Step 2: Choose the week
The vendor selects the relevant supply week.
Step 3: Submit quantities
The vendor submits the quantities available.
Step 4: Plan
The data feeds inventory and purchasing so the team can plan orders and respond to supply changes.
Screenshots
The system in use
Screens from the application. Contact details, street addresses, prices, totals and internal user names are redacted in the image files.
Home page
The home page, with one tile for each main area: sales orders, purchase orders, invoices, packing lists, customers, consignees, vendors, delivery addresses, products, inventory and archives.
Inventory details
A vendor’s inventory by date range, with boxes remaining and used and a log of inventory transactions. The vendor address, price columns and user name are redacted.
Customer detail
A customer record with tabs for consignees, delivery addresses, sales orders, payments and notes. Contact details and addresses are redacted.
Vendor detail
A vendor record with the products the vendor supplies and a searchable product list. Contact details and the address are redacted.
Sales order
A sales order linking the customer, consignee and vendor to the products ordered. Addresses, prices, totals and the user name are redacted.
Integrations and technology
What the project connects to
No third-party integrations are listed for this project.
- Vendor access
- Vendors log in securely to submit available quantities for a supply week, which feed directly into inventory and purchasing.
Outcome
What the system changes
Inventory control, ordering, pricing and operational data now sit in one platform, replacing fragmented workflows and manual tracking. The project describes the result as fewer manual processes, better data accuracy and a scalable foundation for ongoing growth.
No order volumes or efficiency figures are published for this project.
Client feedback
What the client says
FMSolutions delivered a reliable system that simplified our operations and gave us full control over inventory and purchasing.
Thayer
Walker Food Group
About the client
Walker Food Group publishes its current products and information on its own site.
Related services
The services behind this project
Need Inventory and Ordering in One Place?
Tell us how stock, orders and suppliers connect today. We build systems that keep them in step.