Skip to main content

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.

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.

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)

  • Links must be public and meet the image link requirements below. Rows with an unsafe link are skipped.

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.

Image link requirements


For security, PandaDoc checks every image link in your CSV during import. If a row contains an image link that doesn’t meet the requirements below, that row is skipped and the rest of the import continues.
​

Accepted links

  • Start with https://. Links that start with http:// also work when PandaDoc can download and re-host the image, because the stored link must end up as https://.

  • Point to a public website or image host on the standard web port.

  • Images already hosted on PandaDoc’s own image host are always accepted.

  • Redirects are fine as long as every step of the redirect is public.

Rows that are skipped

A row is skipped if any link in it:

  1. Isn’t a web link, for example ftp:// or file://.

  2. Uses a non-standard port, for example https://example.com:8080/a.jpg.

  3. Contains a username or password.

  4. Points to a private or internal address (such as localhost, 127.0.0.1, 10.x, 192.168.x, 169.254.169.254), or to a name that resolves to one.

  5. Redirects to any of the above.

What you’ll see

The import still completes. Affected rows are listed in the import’s error report by line number.
​

Existing links that may stop working

  • Images on a non-standard port, for example a self-hosted server on :8080.

  • http:// links that can’t be downloaded and re-hosted, for example a dead link, a link that isn’t an image, or one that needs a login.

  • Links with a username and password.

  • Links to internal or test servers, for example *.local or *.internal.


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.

  • If the import completes but some products are missing, open the error report and look for rows skipped because of an unsafe image link. See Image link requirements.

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

Sample CSV file for volume-based products

Did this answer your question?