Skip to main content
All CollectionsQuoting & paymentsCatalog
Import and export volume-based products via CSV
Import and export volume-based products via CSV

Use a CSV file to manage the import, export, and update of volume-based products in bulk for PandaDoc’s Catalog.

Updated over a month ago

Note: As we’re gradually releasing this functionality to our customers, you might not see it within your account right away. If you’d like early access, please contact your Account Manager or our Support team.

Volume-based products use pricing tiers that vary by purchase quantity, supporting both flat and percentage-based discount pricing. You’ll need to import these products separately from single items to ensure accurate data handling.

Skip to:

Create and import CSV with volume-based products

Download our Sample CSV for Volume-Based Products to use as your template for catalog import.

If your catalog already includes volume-based products and you want to quickly update them in bulk, you can export the catalog as outlined below, make the necessary changes in the CSV file, and re-import it. Volume-based products with matching SKUs in your catalog, templates, and CLIs will be automatically updated.

Each SKU requires multiple rows to define the pricing tiers for volume-based products. The Tier Quantity Min column establishes the minimum purchase quantity, with additional fields for discount type and percentage discount, as detailed below.

Required fields and rules

Column Name

Format

Example

SKU

  • Required for import, value cannot be blank

YR-1234579-black

Name

  • Required for import, value cannot be blank

Website development services

Description

  • Required for import

Friendly description of your products

Discount type

  • Required for import, value cannot be blank.

  • Supported values: "flat", "percentage"; case-insensitive

percentage

Tier Quantity Min

  • Required for import, value cannot be blank.

  • Numeric, whole numbers > 0

1, 11, 51, 101, 501, 1001, 101

Price

  • Required for import, value cannot be blank

  • Numeric, up to 5 decimals, "." as separator

200.5

Percentage discount

Between 0-100, up to 5 decimals

35.5

Billing_frequency

  • Required for import,

  • Supported values: weekly, monthly, quarterly, semiannually, annually

quarterly

Cost

  • Required for import

  • Numeric, up to 5 decimals

25

Images

  • Required for import

  • HTTPS URLs (.JPEG, .JPG, .WebP, .PNG)

Category

  • Required for import

  • Max 8 nested subcategories

Coffee/Brand/PandaDoc

Currency

  • Required for import

  • Supported ISO codes (USD, EUR, etc.)

USD

Custom Field Name

  • Alphabet letters

  • Custom field columns named "Category" or "Folder" will be automatically renamed to "Group"

Custom field value

Notes:

  • Flat vs. Percentage discount – If the Discount type is “percentage,” the Percentage discount column requires a value. If the Discount type is “flat,” the percentage column is ignored.

  • Source row – Each SKU must have a row where Price Tier Min = 1 to establish the baseline price.

  • Consistent descriptions – Only the first instance of the Product Description, Name, and other SKU-specific fields is imported.

Import process

  1. In PandaDoc, go to Catalog.

  2. Select the small arrow next to Product button > Import > Volume-based products.

  3. Upload the prepared CSV file and click Start import.

An import notification will be sent to your email once processing is complete. Confirm your volume-based products are listed correctly in the Catalog.

How to update existing volume-based products

Note: Currently, volume-based products auto-update in the Quote Builder only, not in pricing tables.

To update volume-based products in your templates or Content library items:

  1. Export the current catalog of volume-based products (see steps below).

  2. Edit the exported CSV, ensuring any modified fields retain the correct SKU for mapping.

  3. Import the updated CSV with the same process as above.
    Tip: Always use consistent SKUs for accurate mapping.

An import notification will be sent to your email once processing is complete. Confirm your volume-based products are updated correctly in the templates and content library items they’ve been added.

Export volume-based products

Volume-based products are exported separately from flat-priced items:

  1. Navigate to Catalog.

  2. Select Export at the top right.

  3. When exporting, CSV files for single and volume-based products are compressed into a single downloadable archive.

Troubleshooting

If an import fails:

  • Ensure all required fields (e.g., Price Tier Min, Discount Type) are populated.

  • Validate field formats, especially for Percentage Discount and Price Tier Min.

  • Check for consistent descriptions and unique SKUs.

Error messages will appear under the uploaded file if issues are detected.

Sample CSV file for volume-based products

Did this answer your question?