Version 1.3.0

In This version we improved the product even more. here is complete changelog and update guide.

v1.3.0 (07-Oct-2024)

QR Menu Ordering: Customers can now place orders directly from the QR Menu.
Table-wise QR Downloads: Easily download QR codes organized by table.
Customer Search: Enhanced search functionality with suggestions and auto-complete for quicker access.
Add Customer from POS: Directly add new customers from the POS system if they are not found in the database.
Bug Fixes and General Code Enhancements: Various bug fixes and improvements for a more stable and efficient experience.

Update guide

Step 1: Update DB

Add a new column is_qr_order_enabled in the store_details table to toggle the QR order feature.

ALTER TABLE store_details
ADD COLUMN is_qr_order_enabled TINYINT(1) DEFAULT 0;

Create a new table qr_orders to manage the qr orders independently by running the following SQL query.

CREATE TABLE `qr_orders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT CURRENT_TIMESTAMP,
  `delivery_type` varchar(90) DEFAULT NULL,
  `customer_type` enum('WALKIN','CUSTOMER') DEFAULT 'WALKIN',
  `customer_id` varchar(20) DEFAULT NULL,
  `table_id` int DEFAULT NULL,
  `status` enum('created','completed','cancelled') DEFAULT 'created',
  `payment_status` enum('pending','paid') DEFAULT 'pending',
  `tenant_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tenant_id` (`tenant_id`),
  CONSTRAINT `tenantId` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`)
);

Create another table qr_order_items to store individual items related to QR orders by following the same procedure.

CREATE TABLE `qr_order_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int DEFAULT NULL,
  `item_id` int DEFAULT NULL,
  `variant_id` int DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `status` enum('created','preparing','completed','cancelled','delivered') DEFAULT 'created',
  `date` datetime DEFAULT CURRENT_TIMESTAMP,
  `notes` varchar(255) DEFAULT NULL,
  `addons` mediumtext,
  `tenant_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tenant_id` (`tenant_id`),
  CONSTRAINT `tenant_id` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`)
);

Step 2: Update Backend Code

Replace the existing backend files with the latest version.
Follow the same steps as the initial setup of RestroPRO to configure the new features.

Step 3: Update Frontend Code

Similarly, replace and configure the frontend code, following the standard setup process for RestroPRO.

Quick Guide to Activating QR Ordering :

To start using QR Ordering in your system 👇

Enable QR Ordering: Simply toggle the feature in Settings → Details to activate QR ordering for your digital menu.

Table-Specific QR Codes: If you need QR codes for individual tables, download them from Settings → Tables. These codes allow customers to place orders directly from their assigned table.

General-Purpose QR Code: For non-table-specific orders, continue using your existing QR code as before.

With these settings, you can now effortlessly accept orders via the digital menu, fully integrated with your POS system for a seamless experience.

v1_3_2 v1_2_0