Customize odoo 17 Module Supplier Price List Upload (CSV/XLSX)

Odoo 17 – Supplier Price List Uploader (CSV/XLSX)

Built a production-ready Odoo 17 module to bulk import and update vendor price lists into product.supplierinfo. Supports CSV/XLSX, product match by internal reference / barcode / name, dry-run preview, variant vs. template handling, multi-currency, and Windows deployment. Delivered with in-app sample CSVs and documented install steps.

Case Study

Overview

I developed a custom Odoo 17 module—Supplier ProductInfo Upload—that lets purchasing teams bulk upload and update vendor price information into product.supplierinfo from CSV/XLSX files. The module includes a user-friendly wizard, a dry-run (preview) mode, and ships with sample CSVs that can be downloaded directly from the UI.

Business Problem

Purchasing needed a fast, reliable way to load or refresh vendor price lists without manual data entry, while avoiding data loss or mismatched products—especially for products with variants and multi-currency scenarios.

Solution

A modal wizard under Purchase → Configuration → Supplier Product Upload:

•File types: CSV (built-in) and XLSX (via openpyxl if installed).

•Product matching: Internal Reference (default_code), Barcode, or Product Name.

•Create/Update policy: Create only, Update only, or Upsert.

•Variant aware: Writes to the variant when variants exist; otherwise to the template.

•Currencies: Resolves by ISO code (e.g., USD, EUR, EGP).

•Dry-run preview: Summarizes created/updated/skipped/missing before applying.

•Samples included: Three CSV samples bundled and linked in the wizard for quick testing.