How do I bulk import or export cost rules from a spreadsheet?
Last updated: August 28, 2026
Bulk importing cost rules
If you have supplier quotations or a large set of pricing rules to load, you can create or update cost rules in bulk from a spreadsheet rather than building each one individually in the Cost Rules screen.
Where to find it
Go to Tools → Imports, select the Costs & Finance section, and choose Cost Rules.
How the import works
One row = one rule. Each row creates a new rule or, if the Name (and Vendor, when shared) matches an existing rule, updates that rule in place.
Simple rules only. The import supports a single pricing tier with a single effect per row. For multi-tier or complex graduated rules, build them in the Cost Rules screen.
Rows are validated before any records are written. Errors are reported per row so you can fix and re-upload.
Column reference
Column | Required | Notes |
|---|---|---|
NAME | Yes | Rule name. Also used as the match key when updating an existing rule. |
DESCRIPTION | No | Optional notes. |
VENDOR | Varies | Required for |
DOCUMENT_TYPE | Yes |
|
OUTPUT_KIND | No |
|
PRIORITY | No | 1–1000. Default is 100. Lower numbers win when multiple rules match. |
STATUS | No |
|
EFFECTIVE_FROM / EFFECTIVE_TO | No | Date range in |
MIN_QUANTITY / MAX_QUANTITY | No | Unit Cost rules only. The quantity band this tier covers. |
EFFECT_TYPE | No | Unit Cost rules only. |
EFFECT_AMOUNT | No | Unit Cost rules only. The numeric amount for the effect. |
COST_BASIS | No | Extra Cost rules only. |
COST_BASIS_AMOUNT | No | Extra Cost rules only. The percentage value or flat amount. |
EXTRA_COST_ITEM_NAME | No | Extra Cost rules only. Label for the generated charge line. Defaults to the rule name. |
FILTERS | No | Pipe-separated line filters that scope which products the rule covers. Format: |
CONDITIONS | No | Extra Cost rules only. Pipe-separated document-level conditions, e.g. |
AUTO_APPLY | No | Extra Cost rules only. |
ADD_AS_ADDITIONAL_FEE | No | Purchase Order + Extra Cost rules only. |
MOQ | No | Minimum order quantity for the rule. |
ORDER_MULTIPLE | No | Order rounding increment. |
TIER_MODE | No |
|
TIER_QUANTITY_BASIS | No |
|
COST_ALLOCATION_TYPE | No | Extra Cost rules only. |
SHIPMENT_TYPE | No | For |
Exporting existing rules
You can download your current cost rules as a spreadsheet directly from the Cost Rules list. This is useful for doing a bulk price update: export, edit the amounts in your spreadsheet application, then re-import — any row whose name matches an existing rule will update it in place.
Good to know
Updating via re-import is safe. A row that matches an existing rule by name patches only the fields you provide; blank cells preserve the current values.
Multi-tier rules cannot be created via import. Build rules with graduated tiers or multiple effects in the Cost Rules screen, then export if you need a record of them.
Import progress and any row-level errors are shown in the import job log after upload.