Student Project GuideJewelry Franchise – Custom Inventory Management & POS System is to develop an end-to-end solution for my jewelry business.
The main pieces for the system would include:
??? Inventory Management
??? Order Management
??? Inventory Alerts
??? Point of Sale
??? Barcode Capabilities (creation, scanning, etc.)
??? Receipt Generation
??? Employee payment including hourly, monthly, and custom commissions,
??? Employee Clock-in/clock-out system
??? Multiple store profiles
??? Layaways
??? Custom Orders
??? Refunds/Exchanges
??? Web-Based Service
??? User Roles with Various Access
??? Detailed & Flexible Reporting (sales, profit, etc.)
Details of Jewelry Franchise – Custom Inventory Management & POS System:
| Category | Name |
| Web | Protected URL to be allowale to be used in certain instances |
| Web | Security enabled within URL |
| Multi-Store Profiles | Users Per Store |
| Multi-Store Profiles | Admin User Access to All Stores |
| Database | Self-Owned/Controlled DataBase |
| Database | Security Permissions Set within Database |
| Products | Ability to log over 500K SKUs of inventory |
| Products | Ability to uniquly categorize individual products based on certain categories |
| Products | Barcode creation for individual products |
| Products | Barcode managment @ inventory recieved |
| Products | Barcode managment @ purchase |
| Products | Ability to Coordinate Custom Product Orders |
| Products | Unit Price Availble for Each Product |
| Products | Unit Price of Each Product can be variable by margin |
| Products | Search ability of products |
| Inventory Management | Ability to track a purchase of inventory of multiple products |
| Inventory Management | Ability to add inventory into the system in bulk |
| Inventory Management | Ability to distribute certain amounts of inventory to certain stores |
| Inventory Management | Ability for Stores to Request Inventory with Multiple Products or New Products |
| Inventory Management | Reporting of Inventory in Hand – All Stores |
| Inventory Management | Reporting of Inventory in Hand – Each Store |
| Inventory Management | Reporting of Inventory in Sold – All Stores |
| Inventory Management | Reporting of Inventory in Sold – Each Store |
| Inventory Management | Moving Inventory from One Store to Another on the fly |
| Inventory Management | Inventory Visibility Per Store at All Stores |
| Sales | Inputting Product Sales using Barcode, Search, or Lookup |
| Sales | Ability to easily modify price of each product sold |
| Sales | Ability to include or not include tax for a product |
| Sales | Determination of Cash/Credit/Debit payments |
| Sales | Reciept Generation & Printability |
| Sales | Email Reciepts |
| Sales | Ability to void a Sales Reciept or Customer Payment |
| Sales | Split Sales between Sales Rep |
| Sales | Financing – Type, Amount Paid, Amount Financed, Amount Recieved |
| Customer Profile | Creation of customer profile on Email Reciepts |
| Customer Profile | Creation of customer profile on Repair/Custom Order |
| Customer Profile | Record of each sale per customer on customer profile |
| Repair/Custom Order | Details of Repair/Custom Order can be created |
| Repair/Custom Order | Ability to record a sale as a repair or custom order |
| Repair/Custom Order | Ability to record a payment on a Repair/Custom Order |
| Repair/Custom Order | Ability to status track each order (Ordered, Completed, Picked-up) |
| Repair/Custom Order | Emailing information after every status update to customer |
| Repair/Custom Order | Order can include multiple products |
| Repair/Custom Order | Ability to Search Order based on customer information |
| Layaway | Ability to mark a sale as a layway |
| Layaway | Ability to records customers information on the layway |
| Layaway | Ability to record customer payments on the layway |
| Layaway | Emailing Customer Layaway information after every payment |
| Layaway | Ability to Search Layaway based on customer information |
| Layaway | Layaway can include multiple products |
| Layaway | Once Layaway is paid off, lawaway is be closed out |
| Layaway | Ability to add products to layaway |
| Layaway | Ability to update products within layaway |
| Layaway | Remider Email for Unpayed Lawaways |
| Costing | Able to cost certain SKUs based on Weight |
| Costing | Able to cost certain SKUs based on Unit Price |
| Employee | Employees Ability to Work @ Different Stores |
| Employee | Commission Per Employee Per Sale |
| Employee | Recording Employee Payments (Cash/Check) |
| Employee | Employee Payment as an aggregate of Commisson + Hourly + Monthly |
| Employee | Employee Hour Inputs per Store (Clock-In, Clock-Out) |
| Employee | Calculation of Amount Due to Employee |
| Employee | Calculation of Amount Paid to Employee |
| Employee | Commission Calculations based on Sale Amount or Profit Amount per Employee |
| Expenses | Ability to include expense payments per store (i.e. Rent, Refunds, Taxes, Jeweler) |
| Reporting | Sales Reporting – Overall, Per Store, Per Sale Rep |
| Reporting | Profitability Reporting – Overall, Per Store, Per Sale Rep |
| Reporting | Employee Expenses Reporting – Overall, Per Store, Per Sale Rep |
| Reporting | Reporting Flexibility – Stores, Products, Sales Reps, Timeframe |
| Refunds/Exchanges | Ability to Refund a Sale |
| Refunds/Exchanges | Ability to Exchange a Sale |
| Refunds/Exchanges | Ability to Refund a Layaway |
| Refunds/Exchanges | Ability to Exchage a Layaway |
