Skip to Content
Pro-A-Motors / Purchasing & Pricing

Purchasing spreadsheet exchange

Keep supplier costs, packaging details and update dates connected to the purchase lines buyers are working on.

See the real screens ↓
Choose the purchase linesPrepare the worksheetMatch the returning rowsSee when data changed
The working interface

See it in use.

Explore 1 real view of this workflow. Select a task, show every screen, or enlarge an image to read the original controls.

Review the purchase-line handoff / Actual Odoo screenEnlarge screenshot ↗
Actual Purchase Order Lines workspace showing SKUs, locations, OEM and Partslink references, quantities and unit prices. Supplier names alone are covered.
01 / Purchasing coordinator

Review the purchase-line handoff

  • Identify the purchase order and product reference for each line.
  • Compare quantity, reserved quantity, container quantity and received quantity.
  • Select the lines that belong in the spreadsheet handoff.

Actual Pro-A-Motors interface captures. Private identities and contact details are covered or outside the crop; screen data has not been replaced.

What improved

Bring supplier data back to the right purchase lines.

The business problem

A vendor spreadsheet can contain part codes, package sizes, costs, cube and notes that have to return to the right supplier-product record. A generic record-edit timestamp does not identify an actual supplier-data refresh.

What we changed

Supplier exchange supports structured purchase data and a timestamp that identifies the supplier refresh itself.

What the team can do now

Buyers can review structured supplier information in the purchasing workflow and distinguish an import update from unrelated edits.

Workflow example

A supplier’s price changes through the import workflow.

A buyer receives updated supplier costs and packaging details in a spreadsheet. The import keeps those changes connected to the purchase lines and records when the supplier details were refreshed.

Working file
Supplier worksheet
Details
Cost and packaging
Traceability
Last Updated date
Next owner
Purchasing team

What the screen shows

The worksheet carries the product and purchasing references needed to match each update.

What the team does next

Review the source file and mappings before applying it to the supplier record.

What the next team receives

The buyer has updated supplier data with a date that corresponds to the import event.

How the work moves

Follow the work from one decision to the next.

01

Choose the purchase lines

Start with the products and supplier details the buyer needs to update.

02

Prepare the worksheet

Include costs, quantities, packaging, product references and notes.

03

Match the returning rows

Keep supplier updates tied to the correct purchase lines and products.

04

See when data changed

Record an update date when supplier information is imported.

Built, used, refined

How the workflow improved over time.

  1. Make Last Updated describe the import

    Refined supplier updates so the import writes its date and carries the location field back to the purchase line.

About these dates

Dates identify recorded implementation changes, not claimed rollout dates or measured results. Reviewed revisions: c22e478.

Build notes and background
Data integrationWorkflow automation

The boundaries we made explicit.

Missing rows need review

The current importer skips unknown purchase-line IDs; it is not an all-or-nothing reconciliation report.

An import is a write

Review files before running the action because imported fields update supplier data.

No exchange was executed

The captured list and setup controls do not imply an actual export or import.

Existing records are shown as captured. Private identities are covered or outside the crop. No business records were changed for this collection. Implementation history supports behavior beyond the visible screen; a still image is not an end-to-end test or a measured productivity result.

Built on Captivea CAP modules and Odoo. This case describes the subsequent Pro-A-Motors extensions and refinements recorded in the reviewed repository; it does not attribute the original CAP implementation to Toro.

Which handoff is slowing your team down?

Talk through your workflow →