Skip to Content
Excel Sheet
excel_sheet

Excel Sheet

Tag products with item numbers, units and goods templates that flow to invoices

v19.0.1.0.0 Abdelfatah Mohammad (AlshayebCo) Products & Inventory

Defines one new model, goods template (name/code/note, inheriting chatter and activities), and extends product template with items (Item Number), unit, and a product_template Many2one to goods template. product product and journal item each carry a stored related product_template field. Views add the fields to the product and variant forms, add an Item Number filter to the product search view, replace the sales-order search to match on order-line item numbers, and register a Goods Template list/form action under the Sales configuration menu. Security is a single ir.model.access.csv line opening goods template to all users. No controllers, wizards, or data files; depends on sale, stock and account.

Overview

Spreadsheet-driven catalogs often carry an external item number, a unit reference, and a goods classification code that core Odoo products have no place to store. This module adds those fields to product templates, propagates a shared Goods Template classification down to product variants and invoice lines, and makes products and quotations searchable by item number. It also provides a small Goods Template master-data model with chatter so each classification code is tracked and auditable.

Key Features

  • Adds Item Number and Unit fields to product templates for mapping spreadsheet data onto Odoo products.
  • Provides a Goods Template master-data model with name, code and notes for classifying products.
  • Links each product template to a goods template, with change tracking on the field.
  • Propagates the goods template classification automatically to product variants (stored related field).
  • Propagates the goods template classification automatically to invoice lines for downstream reporting.
  • Tracks every goods template with chatter and scheduled activities (mail.thread / mail.activity.mixin).
  • Adds an Item Number filter to the product search view so products can be found by their external code.
  • Lets sales quotations be searched by order-line product item number as well as product name.
  • Surfaces the goods template, item number and unit fields directly on the product and variant forms.

Technical Details

Technical Name excel_sheet
Version 19.0.1.0.0
License AGPL-3
Domain PRO · Products & Inventory

Menu Structure

Goods Template

Security

A single access rule grants full read, write, create and delete rights on the Goods Template model to all users, with no dedicated security group defined by the module.

Dependencies

sale stock account