Quick Order B2B Grid

Quick Order B2B Grid transforms your store into a B2B powerhouse with a professional spreadsheet-style ordering interface. Designed for wholesale buyers, sales representatives, and procurement teams, this extension lets customers browse your entire catalog in a fast, sortable, and filterable data grid - then add dozens or hundreds of products to cart in seconds. Whether your customers are reordering familiar SKUs, scanning barcodes in a warehouse, or importing order lists from spreadsheets, Quick Order B2B Grid eliminates the friction of traditional one-by-one product pages and dramatically accelerates the purchasing workflow.

Account & Pricing

No external account is required. This is a fully standalone extension — it does not integrate with any third-party service. There are no additional fees beyond the extension purchase price. All features are included in a single license. No separate signup, API key, or external registration is needed.

Features

• Spreadsheet Interface - A full-featured data grid with 14 columns: Product Name, Image, Variant Attributes, Reference/SKU, EAN, MPN, Category, Stock Level, Price excl. VAT, Price incl. VAT, Line Total excl. VAT, Line Total incl. VAT, Quantity, and Add to Cart. Columns are sortable, resizable, reorderable, and can be pinned or hidden.
   
• Configurable Product Variant Expansion - Each configurable product is automatically expanded into individual rows per variant (e.g., Size: M / Color: Blue), so buyers can see exact stock levels and prices for every combination and order precisely the variants they need.
   
• Bulk Add to Cart - Enter quantities across multiple product rows, then add everything to cart with a single click. Real-time stock validation prevents over-ordering, and detailed success/error notifications confirm exactly what was added.
   
• Hierarchical Category Filter - A tree-select dropdown displays your full category hierarchy, allowing buyers to filter products by one or multiple categories simultaneously. Selections persist in localStorage across sessions.
   
• Instant Search - Accent-insensitive search across product names, SKUs, EAN codes, and MPN numbers. Results update instantly in client-side mode or with optimized debounced AJAX calls in server-side mode.
   
• Product Badges & Tag Filters - Visual "New" and "Sale" badges appear on qualifying products. One-click tag filter pills let buyers quickly narrow the grid to only new arrivals or discounted items.
   
• CSV Import - Upload a CSV or text file to populate quantities automatically. The import wizard auto-detects delimiters (comma, semicolon, tab) and provides an intelligent column mapping interface supporting SKU, EAN, MPN, or Product Name as identifiers. A preview with match summary is shown before applying.
   
• CSV & PDF Export - Export the current grid contents (with quantities) to CSV or formatted PDF. Exports respect active filters and search terms. CSV files include UTF-8 BOM for seamless Excel compatibility.
   
• Barcode Scanner Support - Integrates with both camera-based scanning (using the device camera) and hardware barcode scanners (keyboard emulation). Scanned codes are matched against EAN fields and quantities are automatically applied. Audio feedback confirms successful scans.
   
• Quick Paste from Clipboard - Paste reference/quantity pairs directly from Excel, Google Sheets, or any text source. Supports tab-delimited, semicolon, comma, and space-separated formats. Matching products are highlighted and quantities applied instantly.
   
• Saved Order Templates - Logged-in customers can save their current grid state (products and quantities) as named templates for repeat ordering. Load, overwrite, or delete saved templates from a convenient sidebar panel. Each template is stored per customer account.
   
• Smart Performance Modes - Choose between Client-side mode (loads all products at once for instant filtering) or Server-side mode with infinite scrolling for large catalogs with 10,000+ products. Auto mode intelligently switches based on a configurable product count threshold (default: 3,000).
   
• Tax-Aware Price Calculations - Prices are displayed both excluding and including VAT, calculated using your store's tax rules. Real-time line totals and a running subtotal in the footer update as quantities change.
   
• Product Image Preview - Hover over any product image for an enlarged preview popup. Click to open a full-size lightbox modal.
   
• Fullscreen Mode - Maximize the grid to fill the entire browser window for an uninterrupted ordering experience, ideal for large monitors in warehouse or office environments.
   
• Grid Layout Persistence - Column widths, visibility, and pinning preferences are saved to localStorage and restored on return visits. A one-click reset restores the default layout.
   
• Flexible Access Control - Restrict the Quick Order page to all visitors, logged-in customers only, or specific customer groups. The navigation link automatically hides for unauthorized users.
   
• Multilingual Support - Fully translatable with 150+ translation keys covering all UI elements, grid column headers, notifications, and localization strings. Ships with English (en_US) and Slovak (sk_SK) translations.
   
• No Custom Database Tables Required for Core Grid - The product grid reads directly from native catalog, inventory, pricing, and tax index tables, ensuring compatibility with your existing data and zero migration overhead. Only saved order templates use a lightweight custom table.
   

How It Works

After installation, a "Quick Order" link appears in your store's navigation bar. Customers click through to a dedicated page featuring the full-width product grid. They can filter by category, search by keyword or code, scan barcodes, or import a CSV file. Quantities are entered directly in the grid, with running totals displayed in the footer. When ready, a single "Add All to Cart" button sends all selected items to the shopping cart with full stock validation.

For stores with large catalogs, the server-side mode loads products on demand using infinite scrolling - only fetching the rows visible on screen. Edited quantities are preserved across scroll and filter operations, so buyers never lose their work in progress.

Built for B2B

Quick Order B2B Grid addresses the core needs of B2B commerce: speed, efficiency, and bulk operations. Sales reps can prepare orders for clients using saved templates. Warehouse staff can scan products directly into the order grid. Procurement teams can paste order lists from their ERP or spreadsheet and have quantities matched automatically. Every interaction is designed to minimize clicks and maximize throughput.

Admin Configuration

All settings are accessible under Stores > Configuration > General > Quick Order:

• Enable or disable the module globally
• Set access restrictions: all visitors, logged-in customers, or specific customer groups
• Toggle features on or off: Saved Orders, CSV Import, Export, Barcode Scanner
• Choose data loading mode: Auto, Client-side, or Server-side
• Configure the server-side threshold for automatic mode switching

Compatibility

• Adobe Commerce / Magento Open Source 2.4.x
• Compatible with Luma and Blank themes
• Responsive design with cross-platform support
• Works with native Magento inventory, pricing, and tax systems
• No core file modifications - clean modular architecture

Security

• CSRF protection via form_key validation on all POST endpoints
• Server-side input validation and parameterized SQL queries
• HTML output escaping in all templates and JavaScript renderers
• Customer data isolation - saved orders are strictly per-account
• ACL-based admin configuration access control