Industry · Oil and gas

Managing pipes, valves, and field inventory in Odoo: a guide for oil and gas distributors

Distributing pipes, valves, fittings, and specialty equipment strains a standard ERP setup. This guide covers how to configure Odoo for a catalog and a customer base this specific.

By Octagotech Team6 min read

What this guide covers

  • Product variants instead of a flat SKU catalog.
  • Field stocking locations as warehouses, replenished by reorder rules.
  • Customer pricelists with validity dates and traceable overrides.
  • Vendor lead times, RFQ comparison, and light kitting for engineered orders.

Oil and gas equipment distribution is not a clean inventory problem. When your catalog covers carbon steel pipe across many pressure classes, valves in several bore sizes and material grades, and fittings with ASME and API certifications, standard ERP logic starts breaking down fast. A typical distributor in this space supplies pipes, valves, fittings, and specialty equipment to upstream and midstream operators.

The usual pain points are familiar: spreadsheets and a legacy inventory system, tribal knowledge held by a handful of senior staff, slow quotes on non-standard orders, unreliable cycle counts at field warehouse locations, and a manual export whenever a customer asks for a contract price review.

This guide covers how to approach an Odoo implementation for a business this specific.

The SKU problem: attribute-based variants instead of a flat catalog

The first thing to solve is the product structure. A distributor selling API 5L pipe doesn't have one SKU per product. They have a matrix. A single pipe product might vary across nominal pipe size (NPS), wall thickness (schedule), material grade (X42, X52, X65, X70), end finish (plain end, beveled, threaded), and length. Maintained as separate flat SKUs, that is a very large number of line items for one pipe family alone. Maintained poorly, it becomes a catalog where the same product exists under three different codes depending on who entered it.

Odoo's product variants handle this cleanly. Set up a product template for each major product family (line pipe, OCTG casing, gate valves, ball valves, flanges) and define attributes at the template level: material grade, pressure class, size, end connection. Each combination becomes a variant. Duplicate and near-duplicate entries get consolidated into one coherent structure.

The more important win is search. When a salesperson quotes 6-inch Class 900 ball valves in 316 stainless, the search returns exactly the right variants, instead of sending them to a spreadsheet to cross-reference part numbers.

Multi-warehouse management: central stock and field locations

A common structure is one central distribution warehouse and several field stocking locations near active job sites, essentially staging areas where frequently used items are held close to the operator. Field locations are stocked from the central warehouse via internal transfers, and replenishment is supposed to happen on a schedule. In practice it often happens reactively, which means field locations run short or accumulate dead stock depending on which project manager is paying attention.

In Odoo, set up each field location as a separate warehouse under the same company. This gives the central warehouse full visibility into what is at each field location, enables proper stock valuation across the network, and lets procurement see consolidated demand. Reorder rules at the field warehouse level can then trigger internal transfer requests automatically when stock drops below a defined minimum: the same procurement logic that handles external vendor orders, applied internally.

A system that records every movement, including partial picks and internal transfers, means discrepancies are caught early rather than discovered at year-end.

Customer-specific pricing and contract management

In industrial distribution, large customers often have a negotiated price. Some have tiered volume discounts. Some have fixed contract pricing on specific product families for the duration of a project. Managing this in spreadsheets means pricing errors are routine: the wrong rate gets applied, a contract renewal gets missed, or a salesperson manually overrides a price without a record of why.

Odoo's pricelist system handles this with enough flexibility to cover most scenarios. Set up a pricelist per major customer account, with product-specific fixed prices where contracts dictate them and percentage-off-list rules where discounts are category-wide. Pricelists are assigned to the customer record, so when a salesperson creates a quote, the right pricing loads automatically. Overrides are still possible, so keep them traceable, for example with a required reason field (a small customization).

For customers with expiring contract pricing, use Odoo's pricelist validity dates. When a contract rate expires, pricing falls back to the standard rule rather than silently applying a stale rate. A scheduled report of expiring pricelists helps the sales team stay ahead of contract renewals.

Key takeaway. In industries where every major customer has a different price, pricelist management is a core operational control. If your ERP can't enforce customer-specific pricing automatically, you're relying on people to remember, and people forget.

Procurement and vendor RFQ workflow

Oil and gas equipment procurement is complicated by lead times. Mill lead times for certain grades of pipe can be long, and specialty valve manufacturers often have similar windows. This means procurement decisions need to happen well ahead of project demand, and when they don't, expediting is expensive.

Configure Odoo's procurement rules with vendor-specific lead times on each product variant. Replenishment planning then generates purchase orders with timing that accounts for vendor lead time plus an internal receiving and inspection buffer. Buyer workload shifts from reactive firefighting to reviewing and releasing system-generated purchase suggestions.

For items requiring competitive sourcing, use the RFQ workflow. When a non-stock item or a large-volume purchase is needed, procurement sends RFQs to multiple approved vendors directly from Odoo. Vendor responses are compared side by side (price, lead time, minimum order quantity), and the winning bid converts to a PO. Without this, the process tends to live in email threads and a shared spreadsheet, with no audit trail on why a particular vendor was chosen.

Custom assemblies and kitting for engineered orders

Some distributors also sell engineered valve assemblies and custom pipe spool packages: orders where the deliverable is not a stocked item but a configured assembly of components. If these are handled outside the inventory system, components are pulled from stock with no formal record, assembled in the yard, and shipped, and inventory accuracy suffers every time.

Odoo's manufacturing app, configured for light-touch kitting rather than full production orders, gives these assemblies visibility. Define each assembly type as a bill of materials. When an assembly order is created, Odoo reserves the component stock, records the consumption when the kit is built, and creates the finished goods record for shipment. The process becomes a recorded transaction instead of an informal offline one.

For fully custom fabrication work, where an engineer specifies a unique configuration, use manufactured product BOMs with optional components, allowing the assembler to include or exclude items as needed while keeping the core structure consistent.

What to plan for

The goal is a single source of truth across the business. A salesperson in the office can see the stock position at a field site, and a buyer can see open POs, expected receipts, and current stock in one view. That kind of visibility sounds basic, but it needs the catalog, warehouse, and pricing structure above to be set up carefully.

Oil and gas supply chains need careful configuration. The implementation work includes data migration of product catalogs, mapping of existing customer pricelists, and training field warehouse staff on mobile receiving workflows. That work is substantial, so scope it early.

If you're running industrial distribution, Odoo can usually handle your product and pricing complexity, but the configuration decisions matter a great deal. Talk to our team about what a scoping conversation would look like for your operation. You can also read how Odoo fits oil and gas, manufacturing, and other industries.

Octagotech Team

Certified Odoo Ready partner · San Francisco, New York, Ahmedabad and Rajkot

We write from live Odoo engagements: 20+ implementations over 5+ years. About Octagotech.

Can Odoo handle your catalog and pricing?

The first call takes 30 minutes.

Or email sales@octagotech.com