Website Sale Cart Add Product Xlsx Csv
This module adds a button in the website cart that let users import a xlsx or csv file with the products and quantities that he wants to add.
This button is only shown on empty carts, and the file must contain the product's internal reference and the quantity to buy.
auto_awesome What this module does
AI-generated from the code · Odoo 17.0Lets shoppers fill an empty website cart by uploading a CSV or XLSX file listing product references and quantities, instead of adding products one by one.
On the website shop, when the cart is empty and the feature is enabled, a form appears above the cart lines where a visitor can upload a .csv or .xlsx file. The file must have exactly two columns: default_code (the product's internal reference) and product_uom_qty (the quantity). A link to download an example file is provided.
After upload, the module checks the file size against a limit (default 2 MB, configurable) and the file format. Each line is validated: the quantity must be a positive number, the product must exist, be active, be sellable (sale_ok), be published on the website, and, when out-of-stock ordering is not allowed, the requested quantity cannot exceed the free quantity available in the order's warehouse. Valid lines are added to the cart; invalid lines are reported.
Results are shown as coloured messages on the cart page: green for full success, orange for partial import with a list of failed lines and reasons, and red for a global error (wrong format, wrong columns, or file too large).
Administrators can enable or disable the button and set the file size limit in Website settings, under the shop checkout section. The file size limit must be a positive number.
Depends on
Models and fields (2)
- website · extends an existing modelcart_import_button (Is the cart import button enabled?), cart_import_button_file_limit (Cart import button file size limit (MB))
- res.config.settings · extends an existing modelcart_import_button (Is the cart import button enabled?), cart_import_button_file_limit (Cart import button file size limit (MB))
Text generated by AI (DeepSeek) from reading the Odoo 17.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 17.0
Confirmed on 2026-11-03 in branch 17.0 of OCA/e-commerce.
terminal Installation and usage
OCA documentation · Odoo 17.0Configuration
Source · Odoo 17.0To configure this module, you need to:
- To enable the cart import button, go to Website / Configuration / Settings. Then search the "Cart Import Button" and set its value.
- To edit the maximum file size, go to Website / Configuration / Settings. Then search the "Cart import button file size limit" and edit its value.
Usage
Source · Odoo 17.0To use this module, you need to:
- Go to the "/shop/cart" path of your server website. Example: "http://localhost:8069/shop/cart"
- You will see your cart. Empty it if it has products.
- Click on "Download example file". Fill the xlsx file rows: 3.1. The "default_code" column is the internal reference of the product that you are going to add to your cart 3.2. The "product_uom_qty" is the qty of the product that you are going to add to your cart
- Select the filled file, and click the "Import" button
- You will see the cart with the imported products. If some error hapened or there are products that could not be imported, the system will show a message
No verified information in OCA: Installation.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.