
Pricing System Development for Importer & Distribution Business (Web App + Linnworks Integration)
Upwork
Remoto
•6 hours ago
•No application
About
Project Overview We are an importer & distributor (wholesale + ecommerce, B2B & B2C) looking to replace our manual Excel pricing spreadsheets with a user-friendly web-based pricing system. The goal is to create a tool that calculates product pricing more reliably, integrates with our systems, and allows us to scale without relying on spreadsheets. We already have a prototype (however it has issues and we need someone to either rebuild or start from scratch). You will take ownership of the project, review the current files, and deliver a stable, production-ready version. ________________________________________ Functional Requirements The system must: 1. Allow users to set currency and update exchange rates (manual or automatic). 2. Enable input of multiple products with SKU, name, and cost. 3. Capture additional costs (transport, documentation, customs) in multiple currencies. 4. Support reusable cost templates. 5. Calculate landed cost per SKU based on unit cost and % of import, transport costs. 6. Apply margin presets or custom margins to calculate sale price ( B2B, B2C) TO DISCLOSE IN PRIVATE PHASE 2 (marketplace(taking in to consideration marketplaces fees) . 7. Store and display price history per product. 8. Store and Compare prices with competitors. TO DISCLOSE IN PRIVATE 9. Provide visual analysis of market position and pricing statistics. 10. Manage supplier information and track performance. 11. Export data (CSV/Excel). 12. Use its own internal database (preferably cloud-hosted, e.g., Azure). 13. Connect to Linnworks via API to synchronize cost and retail prices. ________________________________________ Non-Functional Requirements • Web-based, responsive, and user-friendly UI. • Visualizations using Chart.js (or similar). • Secure input validation & error handling. • Optional: Currency API integration. • Optional: User login with role-based access. ________________________________________ Phase 2 (Future Work) 14. Add fields for packaging cost, packing time, and marketplace fees. • Enhanced margin insights with these additional factors. • Pricing simulation with full cost stack. ________________________________________ Deliverables & Project Structure We want to work on a fixed-cost basis with stage gates, e.g.: Stage 1 – Review current files, design system architecture, confirm tech stack and present plan. Stage 2 – Build MVP (basic cost calculation, SKU handling, margin presets). Stage 3 – Add advanced features (templates, supplier management, visualizations, history). Stage 4 – Integrate with Linnworks API & testing. Stage 5 – Final deployment, documentation, and handover. ________________________________________ Skills Required • Web application development (React / Angular / Vue preferred). • Backend (Node.js / .NET / Python with database experience). • API integration (Linnworks experience a big plus). • Data visualization libraries (Chart.js, D3.js, or similar). • Azure (or other cloud hosting) setup. • Strong attention to detail and secure coding practices. ________________________________________ What We Provide • Current Excel prototype (v3) with logic already defined. • Access to our team for business/functional clarification. • Linnworks API documentation. ________________________________________ Application Instructions Please apply with: 1. A brief overview of your relevant experience (similar projects, pricing systems, ERP tools, inventory APIs, etc.). 2. Suggested tech stack you would use and why. 3. An estimated timeline + cost breakdown by stage. 4. Examples of past work (screenshots or links). ________________________________________ This project is business critical. We want someone who can take ownership, deliver quickly, and leave us with a robust, easy-to-use system.