Contact person: Vizzion Chemicals - Dynamic Web Ordering App

Phone:Show

Email:Show

Location: Lahore, Pakistan

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Project Title

Vizzion Chemicals — Web Ordering App (Branding + Dynamic Pricing + Inventory + Invoicing & Reports)

Project Type

Web application, Full-stack (backend + frontend) — small fixed budget

Budget

$10 – $20 (firm). Please bid only if you accept this budget.

Short Description

Build a responsive, mobile-friendly web-based ordering app called Vizzion Chemicals that allows consumers, retailers, wholesalers, distributors and bulk vendors (hospitals, restaurants, marriage halls) to register/login and place orders. Pricing must be dynamic and configurable by admin based on customer type and quantity categories. Include inventory control, invoicing, basic reports, payment integration points, delivery tracking and easy data export/backups for accounting. I will provide logo and product images (placeholders acceptable). Deliver a working codebase, database schema, admin panel, and deployment instructions.


---

Detailed Requirements / Scope

Branding

App name: Vizzion Chemicals visible in header and admin panel.

Include placeholder for company logo (I will supply the actual logo).

Product image placeholders for the product catalog.


User Roles & Authentication

Client signup / login (email + password). Passwords stored hashed.

Admin login.

Admin can assign or change a client’s client_type (consumer, retailer, wholesaler, distributor, bulk vendor).


Dynamic Pricing (Core feature)

Pricing depends on both:

Client type (consumer / retailer / wholesaler / distributor / bulk vendor)

Quantity category (Small, Medium, Bulk — admin adjustable ranges)


Pricing logic should be based on COGS (base_cost) + configurable margin per client type and per quantity category (admin sets margins/prices).

Admin must be able to update pricing and quantity thresholds easily from admin panel.


Product Management

CRUD for products: name, description, packaging_details, image_url placeholder, base_cost (COGS).

Allow multiple price tiers per product (for combinations of client_type + quantity_category) OR provide a COGS+margin engine with override prices.


Inventory Management (NEW)

Admin can add/update inventory levels per product/packaging (e.g., 25g / 180g / 1kg).

Cart/order placement should validate available inventory and prevent ordering quantities beyond stock.

Admin can receive stock additions (stock-in) and reduce stock on order approval (stock-out).

Inventory adjustments must be visible in admin panel and included in exportable reports.


Order Management

Customers add products to cart and place orders.

Save orders with: user_id, order_date, status (pending/approved/rejected/delivered), total_amount.

Order items stored with quantity, applied_price, subtotal.

Admin can view, approve, reject orders; approving reduces inventory.


Invoicing, Reports, Payment Integration, Delivery Tracking & Backup (NEW)

Invoicing: Generate simple invoices (PDF/printable) per approved order with line items, prices, tax (if any), totals, company name/logo, and invoice number.

Reports: Basic reports in admin panel (sales by product, sales by client type, inventory levels, pending orders) with ability to export CSV/Excel.

Payment Integration: Provide integration points for common payment gateways (e.g., Stripe, PayPal, local gateways) — initial implementation can be sandbox/test mode with documentation on how to enable live keys.

Delivery Tracking: Allow admin to update delivery status and add tracking/reference numbers; customers can view order status and tracking info.

Backup & Transfer: Provide easy data export (CSV/Excel) for all core tables (users, orders, products, inventory, pricing) and a documented import/export process so data can be transferred to main accounting software (e.g., QuickBooks/Excel). Provide instructions for scheduled DB dumps or manual backup.


Admin Panel

Secure admin login.

Manage users (assign client_type).

Manage products, inventory, and pricing by client type + quantity category.

Manage quantity thresholds.

View/approve/reject orders and generate invoices.

View & export reports.


Database (expected)

Models/schema equivalent to the suggested layout:

Users: user_id, name, email, password (hashed), role, client_type, created_at
Quantity_Categories: id, name, min_qty, max_qty
Products: id, name, description, packaging_details, image_url, base_cost, created_at
Pricing: id, product_id, client_type, quantity_cat_id, price
Inventory: id, product_id, packaging_variant, quantity_on_hand, last_updated
Orders: id, user_id, order_date, status, total_amount
Order_Items: id, order_id, product_id, quantity, applied_price, subtotal

(Developers may use equivalent ORM models and migration files.)

Sample Product Data (to seed)

Detergent Powder — 25g / 180g / 1kg loose — /images/[login to view URL]

Toilet Cleaner (Red & Blue) — 300ml — /images/[login to view URL]

Laundry Bleach — 300ml / liters — /images/[login to view URL]

White Phenyl — 3L — /images/[login to view URL]

Liquid Hand Wash — 500ml — /images/[login to view URL]

Dish Wash Liquid — 500ml — /images/[login to view URL]

Glass Cleaner — 500ml — /images/[login to view URL]

Harpic Equivalent — 500ml — /images/[login to view URL]

Floor Cleaner — 1L — /images/[login to view URL]

Rust Cleaner — 500ml — /images/[login to view URL]

Car Wash Shampoo — 1L — /images/[login to view URL]

Bluing (Neel) — 75ml — /images/[login to view URL]


Mobile & Cross-Platform Usability

The web app must be mobile-friendly and usable on iOS & Android browsers.

Preferred: responsive, mobile-first design or Progressive Web App (PWA) for near-native experience on iOS/Android.

Note: Native apps are NOT required in this scope.


Tech Stack (choose one)

Option A: Python + Django (or Flask) + SQLite/Postgres + React or server-side templates (Bootstrap/vanilla JS)

Option B: Node.js (Express) + SQLite/Postgres + React or server-side templates



---

Deliverables

1. Full source code (backend + frontend) in Git repo or zip.


2. Database schema and migration files (or SQL dump).


3. Seeded sample data for products, quantity categories, and example inventory.


4. Admin credentials for testing (default).


5. README with setup & deployment instructions (local run + optional deploy).


6. Short document describing the dynamic pricing logic, where to change margins/thresholds, and backup/export steps.


7. Invoice (PDF) generator for approved orders.


8. Basic sales/inventory reports with CSV export.


9. 7 days of bug-fix support after delivery (small fixes only).




---

Acceptance Criteria

Admin can create/update products, inventory, pricing, and quantity thresholds.

Customers see product prices that change when quantity and client_type change.

Inventory validation prevents orders beyond available stock; orders reduce stock when approved.

App generates printable invoices for approved orders.

Admin can export data (CSV/Excel) for accounting and backup.

Basic payment integration point documented and sandboxed (developer may include test gateway).

Delivery tracking/status updates are available and visible to customers.

App runs locally following provided setup steps.

Responsive UI that works well on iOS and Android mobile browsers.



---

Milestones (within $10–$20 budget)

Note: Scope increased; bidders should propose a minimal viable implementation covering the core features below within budget. Advanced integrations (live gateway setup, extensive reporting dashboards, advanced delivery APIs) can be offered as paid extras.

Milestone 1 — $4–$6: Project skeleton + authentication + DB models + sample product & inventory seed + basic admin.

Milestone 2 — $5–$10: Product CRUD + pricing model + quantity categories + admin UI + inventory validation.

Milestone 3 — $2–$4: Cart & order placement + admin order approval + invoice generation (PDF) + basic reports + README and bugfixes.


(Adjust amounts when awarding. Confirm you accept the total budget of $10–$20 before awarding.)


---

Required Skills

Full-stack web development (Django/Flask or Node.js + React/HTML/CSS/JS)

Database design (SQLite/Postgres)

Authentication & secure password storage

E-commerce/order flows, invoicing & reports

Responsive UI / mobile-first design (PWA a plus)

Basic payment gateway integration (sandbox)



---

Proposal Instructions / Screening Questions

When you bid, please include:

1. Short proposal: Stack choice and why.


2. Confirm you accept the total budget of $10–$20.


3. Delivery method: Git repo, zip, or deployment link.


4. Time to deliver (realistic in days).


5. Portfolio: 1–2 similar projects or dashboards.


6. Brief note on how inventory & dynamic pricing will be implemented in admin.




---

Preferred Extras (optional; show as paid add-ons)

Dockerfile / docker-compose for easy setup.

Hosted demo link.

Automated backups / scheduled DB dump scripts.

Integration with specific accounting software (QuickBooks, Xero) — paid add-on.



---

Important Notes for Bidders

Budget is fixed ($10–$20). Only bid if you accept this.

Given expanded scope, bidders should propose a minimal viable product (MVP) covering core features within the budget; advanced integrations can be offered separately as paid extras.

Clean code, clear README, and delivery in Git are essential." (client-provided description)