HomeModulesOther ToolseCommerce Quick Order | Order Pad, Paste & CSV Upload by SKU
eCommerce Quick Order | Order Pad, Paste & CSV Upload by SKU
Other ToolsAuraOdoo Verified

eCommerce Quick Order | Order Pad, Paste & CSV Upload by SKU

A trade counter for your webshop: type codes with autocomplete, paste a

Technical Specifications & Compatibility

Technical Module Name
Supported Odoo Versions
v19.0
License
Odoo
Deployment Support
Odoo OnlineOdoo.shOn Premise
Lines of Code
826 lines (Python / XML / JS)

Overview & Description

Odoo 19 Odoo 20 Community and Enterprise OPL-1 Version 19.0.1.0.0 eCommerce Quick Order A trade counter for your webshop: type codes with autocomplete, paste a column out of a spreadsheet, or upload a CSV. Every line is checked before anything goes anywhere. Fill the cart in one action, then save the list and reorder it next week. Module Overview What this module solves. A trade buyer does not shop They have a list already, in a spreadsheet, on a printout or in their head, and they want it in the cart. Browsing a catalogue and clicking forty product pages is not how that order gets placed, and a shop that insists on it loses the order. Reorder is not the same thing Odoo 19 added a quick reorder panel that replays a past order. Useful, but it can only offer what has already been bought. It cannot take a list that has never been ordered before, which is most lists. Nothing is added until you press the button. Every line is resolved and priced on the pad first, in green, amber or red with the reason, so a wrong code is obvious before it becomes an order rather than after. Key Features Everything included in the module. Four Ways In Type a code and a quantity, row by row, with autocomplete Paste a column straight out of a spreadsheet Upload a CSV Load a list you saved before Rows can be added and removed freely Blank rows are ignored rather than complained about What It Will Read Comma, semicolon, pipe, space, and the tab Excel actually pastes A bare code on its own, meaning one A code containing a space: only the trailing number is the quantity A decimal comma, so one and a half is understood A CSV with or without a header, detected rather than demanded A CSV with extra columns, a byte-order mark, or no UTF-8 at all Finding The Product By internal reference, case-insensitively By barcode By name Most specific wins, stopping at the first kind that matches Two matches is reported as ambiguous, with the candidates listed Only products actually purchasable on this website What The Pad Tells You The product name it matched, so a wrong code is obvious The unit price and the line total, at the customer's own price list Green for ready, amber for a caveat, red for a problem The reason on every red line, named rather than implied A running count of lines ready, and the total Add to cart stays disabled until at least one line is usable Filling The Cart Nothing is added until Add to cart is pressed Only the usable lines go in The rest stay on the pad with their reasons, to be fixed The same code twice accumulates rather than making two lines Straight to the cart when every line went in Added through Odoo's own cart method, so all cart logic applies Saved Lists Save the pad under a name, load it back with one click Saving under an existing name replaces it Only resolvable lines are saved Stored as products, not codes, so renaming does not break a list A back-office view, so a salesperson can build a standing order The last time a list was used is recorded Business Benefits Why it matters. Forty Lines In One Paste A weekly order that took forty product pages takes one paste and one button, which is the difference between ordering online and phoning. Wrong Codes Caught Early The pad shows the matched product name and the price before anything is ordered, so mistakes are found by the buyer, not by your warehouse. Standing Orders Customers save their usual list and reload it weekly, and your salespeople can build one for them from the back office. Fewer Phoned Orders Trade buyers self-serve instead of emailing a spreadsheet somebody has to key in, with the transcription errors that brings. Screenshots A tour of the order pad. The Order Pad Screenshot Placeholder Rows of codes and quantities, with names, prices and line totals. A Paste With A Bad Line Screenshot Placeholder Green, amber and red lines, each red one carrying its reason. Autocomplete Screenshot Placeholder Suggestions on reference, barcode and name as the buyer types. Saved Lists Screenshot Placeholder Naming a list, loading it back, and the back-office view. Workflow From a spreadsheet to a cart. Open the quick order page. A trade counter alongside the shop, reachable by anybody who can see the webshop. Get the list in. Type it with autocomplete, paste a column from a spreadsheet, upload a CSV, or load a list saved earlier. Read the pad. Each line shows the matched product, the unit price and the line total, in green, amber or red with a reason. Fix what needs fixing. An unknown code, an ambiguous one with candidates listed, something not orderable, or a quantity of zero. Add to cart. Only the usable lines go in, through Odoo's own cart method, so price lists, taxes and stock rules apply exactly as from a product page. Save the list. Under a name, to load again next week. Stored as products rather than codes, so renaming a product does not break it. Line Status On The Pad Status Means Added to cart Green Matched, orderable, priced and ready Yes Amber Usable, with something worth knowing about it Yes Red, unknown code Nothing on this website matches it No, stays on the pad Red, ambiguous More than one match, with the candidates listed No, never guessed Red, not orderable Found, but not purchasable on this website No Red, zero quantity The quantity was blank or unreadable No Configuration Almost nothing to set up. Where Things Live Place What it is The quick order page on the shop The order pad itself, for customers and guests Website, Catalog, Quick Order Lists Saved lists in the back office The pad works as soon as the module is installed. Product codes and barcodes are the ones already on your products, so there is nothing to import or map. Who Can Do What Action Guest Customer Salesperson Use the pad and fill a cart Yes Yes Yes Save and load a list No Yes, their own Yes See another customer's list No No Yes Guard Rails Rule Why A paste is capped at 500 lines Somebody pastes their whole catalogue by accident exactly once Nonsense in a quantity becomes zero The line is refused with a reason rather than raising an error A saved list belongs to one customer Enforced by a record rule and by the controller, both Saving requires a login The pad itself still works perfectly well for a guest Only what this website sells. Resolution honours publication, company and eCommerce access, so a customer can never order something through the pad that they could not have found in the shop. Technical Details Models, dependencies and design. Module Information Technical Name website_sale_quick_order_aura Version 19.0.1.0.0 Category Website License OPL-1 Dependencies website_sale only External Libraries None beyond a standard Odoo installation External Service None. Everything runs inside your own Odoo instance. Automated Tests 44 tests, including a browser tour of the pad Models Model Description website.quick.order Parsing and resolution, as testable model methods website.quick.order.list A saved list belonging to one customer website.quick.order.list.line A saved line, stored as a product rather than a code Adding to the cart goes through Odoo's own cart method rather than writing order lines directly. Design Notes Resolution is most-specific-first. Reference, then barcode, then name, stopping at the first kind that matches, and reporting ambiguity rather than guessing. Parsing is a model method. Every clipboard and CSV format is testable without HTTP, which is why there is a test for each of them. Lists store products, not codes. A code that matched last week might not match next week; a product reference survives a rename. Tested as a shopper. An admin can order unpublished products by design, so testing as admin would assert the opposite of what a customer sees. It composes with minimum-order rules. Where a minimum order quantity module is installed, the adjustments it makes are shown on the pad line, so the buyer sees the corrected quantity before adding rather than discovering it in the cart. Compatibility Where the module runs, and what it reads. Item Supported Odoo Version 19.0 Current Hosting Odoo.sh, On-Premise and any self-managed deployment Multi-Website Yes, resolution honours the website the buyer is on Multi-Company Yes, company access is respected when matching products Price Lists Yes, the pad prices at the customer's own price list Guests Yes for the pad and the cart; saving a list needs a login Mobile and Tablet Yes, the pad is responsive Input Formats Understood Format Notes Comma separated The obvious one Tab separated What a spreadsheet actually puts on the clipboard Semicolon or pipe separated Common exports from other systems Space separated Only the trailing number is read as the quantity A bare code Taken as a quantity of one Decimal comma Read correctly as a fraction, not as a separator CSV, header optional Detected, not demanded CSV with extra columns First column is the code, last is the quantity CSV with a byte-order mark What Excel on Windows writes CSV that is not UTF-8 Handled rather than rejected Supported Editions Both editions, one code base. Community Edition Supported Depends on website_sale alone, so it runs on any Community installation with the webshop enabled. Enterprise Edition Supported Runs unchanged on Enterprise, complementing the reorder panel rather than replacing it. Odoo.sh Supported No extra Python packages to install, so it deploys with no change to your build configuration. Installation Three steps and you have a trade counter. Copy the module. Place the website_sale_quick_order_aura folder in your Odoo addons path, then update the apps list from developer mode. Install eCommerce Quick Order. Only website_sale is required. Open the quick order page. It works immediately, matching on the references and barcodes already on your products. There is nothing to import or map. Give your trade customers the link, or add it to your shop navigation. Nothing about the existing catalogue, cart or checkout changes. Frequently Asked Questions The questions asked most often. The reorder panel replays a past order, so it can only ever offer what has already been bought. This takes a list that has never been ordered before, typed, pasted or uploaded, which is what a trade buyer usually has in front of them. A column straight out of a spreadsheet, which arrives tab separated, or anything separated by a comma, semicolon, pipe or space. A bare code on its own means one. A code containing a space works, because only the trailing number is read as the quantity, and a decimal comma is understood as a fraction rather than a separator. No. A header row is detected rather than demanded, extra columns are fine because the first is taken as the code and the last as the quantity, and the byte-order mark Excel on Windows writes is handled. A file that is not UTF-8 is read rather than rejected. The line is marked ambiguous and the candidates are listed, so the buyer picks. It is never guessed. Matching runs most specific first, internal reference then barcode then name, and stops at the first kind that matches, so a code that is an exact reference is not confused by a name that happens to contain it. They stay on the pad with their reason while the good lines go into the cart. A list of forty with one bad code becomes thirty-nine in the cart and one line to fix, rather than an error page or a silently short order. Yes. The pad prices at the customer's own price list, and adding goes through Odoo's own cart method rather than writing order lines directly, so everything that would happen from a product page happens here too, including any other module's cart logic. A guest can use the pad and fill a cart; saving a list needs a login. A saved list belongs to one customer, enforced both by a record rule and by the controller, so nobody sees anybody else's. A salesperson can see and build every customer's lists from the back office. Five hundred lines per paste, which is well past any real order and short of a whole catalogue pasted by accident. Unreadable quantities become zero and are refused with a reason rather than raising an error. Changelog Release history. Version 19.0.1.0.0 Initial Release Order pad with typed entry and autocomplete Paste support for tab, comma, semicolon, pipe and space Bare codes, codes containing spaces, and decimal commas CSV upload with optional header, extra columns and a byte-order mark Non-UTF-8 CSV files read rather than rejected Matching on reference, barcode and name, most specific first Ambiguous codes reported with candidates, never guessed Per-line product name, unit price and line total Green, amber and red lines with a reason on every problem Only usable lines added; the rest stay on the pad Repeated codes accumulated into one cart line Added through Odoo's own cart method, so all cart logic applies Saved lists stored as products, with a back-office view Per-customer record rule plus a controller check on saved lists 44 tests, including a browser tour of the pad Support We answer, and we keep our modules current. Email odooaura@gmail.com Website www.auraodoo.tech YouTube youtube.com/@Auraodoo Free support for bug fixes on the Odoo version you downloaded. Customisation and installation help available on request. Aura Odoo Tech Odoo modules built to be understood, not just installed. Odoo 19 OPL-1 website_sale_quick_order_aura www.auraodoo.tech | odooaura@gmail.com | youtube.com/@Auraodoo

Key Capabilities & Features

  • Type a code and a quantity, row by row, with autocomplete
  • Paste a column straight out of a spreadsheet
  • Upload a CSV
  • Load a list you saved before
  • Rows can be added and removed freely
  • Blank rows are ignored rather than complained about
  • Comma, semicolon, pipe, space, and the tab Excel actually pastes
  • A bare code on its own, meaning one
  • A code containing a space: only the trailing number is the quantity
  • A decimal comma, so one and a half is understood
  • A CSV with or without a header, detected rather than demanded
  • A CSV with extra columns, a byte-order mark, or no UTF-8 at all
  • By internal reference, case-insensitively
  • By barcode
  • Most specific wins, stopping at the first kind that matches
  • Two matches is reported as ambiguous, with the candidates listed
  • Only products actually purchasable on this website
  • The product name it matched, so a wrong code is obvious
  • The unit price and the line total, at the customer's own price list
  • Green for ready, amber for a caveat, red for a problem
  • The reason on every red line, named rather than implied
  • A running count of lines ready, and the total
  • Add to cart stays disabled until at least one line is usable
  • Nothing is added until Add to cart is pressed
  • Only the usable lines go in
  • The rest stay on the pad with their reasons, to be fixed
  • The same code twice accumulates rather than making two lines
  • Straight to the cart when every line went in
  • Added through Odoo's own cart method, so all cart logic applies
  • Save the pad under a name, load it back with one click
  • Saving under an existing name replaces it
  • Only resolvable lines are saved
  • Stored as products, not codes, so renaming does not break a list
  • A back-office view, so a salesperson can build a standing order
  • The last time a list was used is recorded
  • Open the quick order page. A trade counter alongside the shop, reachable by anybody who can see the webshop.
  • Get the list in. Type it with autocomplete, paste a column from a spreadsheet, upload a CSV, or load a list saved earlier.
  • Read the pad. Each line shows the matched product, the unit price and the line total, in green, amber or red with a reason.
  • Fix what needs fixing. An unknown code, an ambiguous one with candidates listed, something not orderable, or a quantity of zero.
  • Add to cart. Only the usable lines go in, through Odoo's own cart method, so price lists, taxes and stock rules apply exactly as from a product page.
  • Save the list. Under a name, to load again next week. Stored as products rather than codes, so renaming a product does not break it.
  • Resolution is most-specific-first. Reference, then barcode, then name, stopping at the first kind that matches, and reporting ambiguity rather than guessing.
  • Parsing is a model method. Every clipboard and CSV format is testable without HTTP, which is why there is a test for each of them.
  • Lists store products, not codes. A code that matched last week might not match next week; a product reference survives a rename.
  • Tested as a shopper. An admin can order unpublished products by design, so testing as admin would assert the opposite of what a customer sees.
  • Copy the module. Place the website_sale_quick_order_aura folder in your Odoo addons path, then update the apps list from developer mode.
  • Install eCommerce Quick Order. Only website_sale is required.
  • Open the quick order page. It works immediately, matching on the references and barcodes already on your products. There is nothing to import or map.
  • Order pad with typed entry and autocomplete
  • Paste support for tab, comma, semicolon, pipe and space
  • Bare codes, codes containing spaces, and decimal commas
  • CSV upload with optional header, extra columns and a byte-order mark
  • Non-UTF-8 CSV files read rather than rejected
  • Matching on reference, barcode and name, most specific first
  • Ambiguous codes reported with candidates, never guessed
  • Per-line product name, unit price and line total
  • Green, amber and red lines with a reason on every problem
  • Only usable lines added; the rest stay on the pad
  • Repeated codes accumulated into one cart line
  • Saved lists stored as products, with a back-office view
  • Per-customer record rule plus a controller check on saved lists
  • 44 tests, including a browser tour of the pad
  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.

Screenshots & Previews

1 image available
eCommerce Quick Order | Order Pad, Paste & CSV Upload by SKU screenshot 1
Expand Preview
The AuraOdoo Quality Guarantee
100% Tested

Verified with Odoo 17, 18, and 19 test pipelines for stability and no conflicts.

Clean Architecture

Built according to official Odoo guidelines and PEP 8 standards with zero bloat.

Dedicated Support

Free installation assistance and quick bug turnaround from our team.