OdooWiki OCA HUB

Purchase Order Product Recommendation XLSX

purchase_order_product_recommendation_xlsx folder_open OCA/purchase-workflow open_in_new
Purchases License: AGPL-3

This module extends purchase_order_product_recommendation to add a way to print the recommended products for a supplier.

auto_awesome What this module does

AI-generated from the code · Odoo 18.0

Adds an Export button to the product recommendation wizard so users can download the recommended products for a supplier as an Excel (XLSX) file.

When you use the product recommendation wizard on a purchase order, this module adds an Export button next to the Accept button. Clicking it downloads an Excel file instead of printing a PDF.

The Excel file contains one sheet named PRODUCTS. At the top it shows the supplier name, the start date and the end date of the recommendation period. Below that, each recommended product is listed with its price, quantity received, quantity delivered, average quantity delivered per day, quantity on hand, forecasted quantity and the quantity to order. The columns use the user's language date format and the currency symbol for prices.

The module also makes sure the values shown in the wizard (price, quantities on hand, received, delivered, average delivered and forecasted) are saved when you export, so the Excel file matches exactly what you see on screen.

It works together with the product recommendation wizard on purchase orders and does not change any other part of Odoo.

Models and fields (3)
  • purchase.order.recommendation · extends an existing model
  • purchase.order.recommendation.line · extends an existing modelprice_unit (Price), units_included (Qty), units_received (Qty Received), units_available (Qty On Hand), units_delivered (Qty delivered), units_avg_delivered (Qty Dlvd./day), units_virtual_available (Forecasted Qty)
  • report.purchase_order_product_recommendation_xlsx.summary · new model

Text generated by AI (DeepSeek) from reading the Odoo 18.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-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 3 confirmed, 6 with no information of 9 versions.

Sources · Odoo 13.0

Confirmed on 2026-11-03 in branch 13.0 of OCA/purchase-workflow.

terminal Installation and usage

OCA documentation · Odoo 18.0

To use this module, you need to:

  • Create a new purchase order.
  • Assign its supplier.
  • Press Recommended Products button.
  • Set or adjust hinted quantities to order.
  • Press Export.

No verified information in OCA: Installation, Configuration.

info

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.