Skip to content

Purchase Order Line Import

purchase_order_line_import_sheet_file · OCA/purchase-workflow

Follow
    Health
    60/100
    fair
    • Security25/25
      No findings
    • Activity25/25
      Human commit this month
    • Required by5/25
      0 modules depend on it
    • Maturity5/25
      In 1 Odoo series since 17.0

    Heuristic over the facts below, not an audit · How it's computed

    Security findings
    Grave / minor (static analysis)
    Required by
    0
    Modules depending on it
    External deps
    0 pip · 0 bin
    Python packages / system binaries
    License
    AGPL-3
    No conflicts with its dependencies
    Folder size
    0.09 MB
    Module directory on disk
    Code analysis 0 migration notes 3 models 2 views 0 HTTP endpoints

    Description

    This module adds an Import Lines button to requests for quotation. It opens a wizard that reads a spreadsheet (XLSX, XLS, ODS or CSV) and adds one purchase order line per row to the current request for quotation.

    The spreadsheet supports these columns:

    ColumnRequiredPurchase order line field
    Internal ReferenceYesproduct_id, by the product internal reference
    QuantityYesproduct_qty
    DescriptionNoname
    Unit PriceNoprice_unit
    Analytic AccountNoanalytic_distribution, 100% to the account

    An empty optional cell keeps the value Odoo computes for the line: the default description of the product and the vendor price. The analytic account is searched by code or by name.

    All the rows are checked before any line is created: if any of them has an error, nothing is imported and every error is reported with its row number.

    Dependencies

    Odoo dependencies
    odoo/odoo:
    - purchase
    - account
    - base_setup
    - base
    - web
    - onboarding
    - product
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
    - base_import
    Python dependencies
    None
    System dependencies
    None
    Required by
    None

    Code analysis

    Extracted from the source by best-effort static analysis (no code is executed); details may be incomplete.

    Views touched 2

    XML IDNameModelTypeStatus
    purchase_order_form purchase.order.form - purchase_order_line_import_sheet_file purchase.order form Inherits purchase.purchase_order_form
    purchase_order_line_import_view_form purchase.order.line.import.form purchase.order.line.import form New

    HTTP endpoints 0

    No HTTP endpoints found for this module.

    Models touched 3

    New fields (0)

    No new fields.

    Public methods (1)
    • action_open_line_import(self)

    New fields (0)

    No new fields.

    Public methods (1)
    • action_open_line_import(self)

    New fields (4)
    • file Binary
      attachment=False
    • file_name Char
    • order_id Many2one → purchase.order
      comodel_name='purchase.order' ondelete='cascade' required=True
    • template_file Binary
      attachment=False readonly=True
    Public methods (2)
    • action_download_template(self)
    • action_import(self)

    Loading…