Jewelry 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 |