Light ERP for a small cross-border retail business
One order status from Canadian purchase to Philippine delivery
A small business buys retail products in Canada and sells them to customers in the Philippines. RosaAI built a focused operations system that connects inventory, orders, deposits, international boxes, balances, invoices, accounting, and customer tracking.
- System type
- Light ERP and customer tracking
- Operational area
- Inventory, orders, shipping, payments, and accounting
- Status
- Built and tested system
- Evidence
- Verified capabilities with synthetic visuals
Real workflows
Built around operating processes rather than generic demonstrations.
Visible exceptions
Missing information and unfamiliar cases remain clear.
Human control
People retain responsibility for decisions, permissions, and unusual cases.
A workflow that did not fit a generic store
One customer order can involve several stages. Products are bought on sale in Canada, priced in Philippine pesos, grouped into a selling period, packed into an international box, shipped to the Philippines, paid in stages, and delivered locally.
The owner needs purchase costs and profit information. A coordinator in the Philippines needs fulfilment details without access to margins. Customers need a clear order update without seeing internal records.
The system had to follow these rules rather than force the business into a standard online-store process.
Inventory tied to real purchase costs
Products use purchase lots so the quantity, Canadian cost, exchange rate, Philippine peso cost, and selling price remain tied to the relevant purchase. Historical values do not change when the exchange rate changes later.
When an order requires more stock, the business can still record the sale. The shortage appears in the shopping list instead of blocking the order.
Orders and staged payments
Orders connect customers, products, deposits, balances, selling periods, box assignments, invoices, and fulfilment status. Local shipment cannot move forward until the balance has been paid.
International box tracking
Orders can be assigned to consolidated shipping boxes. The system tracks packing, international transit, arrival in the Philippines, local shipment, and delivery.
Different views for different people
The owner can access purchasing, selling, accounting, and profit information. The Philippine coordinator can update fulfilment without seeing private financial details. Customers receive a mobile tracking page for their own order.
Accounting connected to operations
The system records customer payments, product costs, box shipping, expenses, and profit views in Philippine pesos. Canadian costs keep the exchange rate used for that transaction.
How the workflow runs
Main workflow
- Product purchase
- Inventory lot
- Customer order
- Deposit
- Selling period
- International box
- Philippine arrival
- Balance
- Local delivery
Customer view
- Order placed
- Deposit received
- Packed
- Shipped internationally
- Arrived
- Out for local delivery
- Delivered
Guardrails
- Financial information is separated by role.
- Customers can access only their own order status.
- Exchange rates are stored with the transaction instead of changing historical costs.
- Local shipment is blocked until the balance is paid.
- Inventory shortages remain visible through the shopping list.
- The owner controls pricing, product lots, payments, and operating decisions.
Synthetic example
The panel below illustrates the workflow with fictional data. No real customer, member, or order information is shown.
Order status
Synthetic example order moving through inventory, deposit, box, balance, and delivery stages. The balance stage is currently in progress.
Inventory
Complete
Deposit
Complete
Box
Complete
Balance
In progress
Delivery
Upcoming
Verified capabilities
- Manages products, purchase lots, stock, and shopping needs.
- Connects customers, orders, deposits, balances, and selling periods.
- Tracks consolidated boxes and the international fulfilment journey.
- Supports invoices and customer-safe tracking links.
- Separates owner, coordinator, and customer access.
- Records expenses, cash movement, and profit views.
- Stores transaction-specific currency conversion information.
Designed to support
The application is designed to make order status easier to understand, reduce spreadsheet handoffs, protect private financial information, and give customers a clearer view of delivery progress. These benefits have not been published as measured results.
This may fit if
- Orders move through several stages over weeks or months.
- Inventory, payments, shipping, and customer updates affect the same order.
- Different people need different views of the same information.
- The business uses rules that standard retail software does not represent well.
- Currency conversion or transaction history matters.
- Customers regularly ask for order status.
Frequently asked questions
Why build a light ERP instead of buying a larger system?
- A focused system can be appropriate when the workflow is specialized and the business needs only a defined set of connected functions. The decision should follow a workflow review, not an assumption that custom software is always better.
Can the customer see internal financial information?
- No. The customer tracking view is separate from the owner's operational and accounting information.
Could this approach work for a different type of retailer?
- Possibly. The useful pattern is the connected order lifecycle. The exact inventory, payment, fulfilment, and access rules would need to match the business.
More selected work
- From purchase order email to QuickBooks invoice
A local cleaning company in Alberta needed completed purchase orders turned into invoices without hiding missing customers or unfamiliar service information. The automation creates routine invoices and reports exceptions for review.
- Member programs and board work in one connected hub
A membership association connected public submissions, member verification, feature scheduling, discounts, weekly updates, events, and action items without replacing its existing website or member list.
Has your spreadsheet become the place where the whole business runs?
Apply for a complimentary 20-minute Workflow Fit Check. RosaAI will help determine whether the process should be simplified, automated, or supported by a focused internal application.