The Watches Inc: A Sales, Inventory and Customer Management System for a Watch Business

The Watches Inc buys and sells watches. Like many growing resellers, it sources stock from different suppliers, sells to customers through social media and direct sales, and needs to know exactly what each watch cost, what it sold for and what profit it made.

Some of the stock is bought through investment groups, where money is pooled to buy watches, so profit also has to be tracked per group. That gets complicated quickly in spreadsheets.

The challenge

The Watches Inc needed one system to:

• keep track of every watch in stock, where it came from and what it cost
• record sales with the real profit on each one, after expenses
• see sales and profit per investment group
• track expenses, including advertising spend
• keep a record of customers, suppliers and day-to-day tasks

What we built

A private admin web app with everything in one place.

Dashboard and analysis

A dashboard with sales trends and sales by group, plus a business analysis view showing revenue and profit trends, order volume and a monthly sales history with new customers and profit.

Investment groups

Each investment group shows its watches, total sales and profit, so everyone knows how their money is performing.

Inventory

Every watch is recorded with its investment group, brand, source, cost price, list price and condition, plus whether it has been posted on Instagram yet. Stock can be added one item at a time, imported in bulk or pasted in from a spreadsheet.

Sales records

Each sale records the cost, selling price, any expenses and the resulting profit, along with the customer, city, payment status and whether the order has been shipped and delivered. Totals for revenue, profit and number of transactions are always visible, and sales can be imported in bulk.

Expenses, customers and suppliers

• An expense tracker with categories and a monthly trend, including advertising spend
• A customer directory with each customer's sale history
• Sources and suppliers, with totals for what has been bought and sold through each
• A simple to-do list for day-to-day tasks

Technology

• React for the admin interface
• Node.js for the API and business logic
• MongoDB for stock, sales, customers and groups

The result

• Sales, stock and customers are managed in one system instead of scattered spreadsheets
• The business can see the real profit on every watch, and for every investment group
• Bulk import and paste make it quick to bring existing records in

Building something similar?

If you're running a reselling or retail business on spreadsheets and starting to lose track of stock, costs and profit, a simple custom system can give you a clear picture. Tell us about your project and we'll get back to you with a free design.