Import and export your catalog via CSV

Avatar
Eugenia Brown
  • Updated

You can use a CSV (comma-separated values) file to import and export a large number of products at a time. This can be helpful if you want to migrate your product catalog from another platform to PandaDoc or if you need to apply bulk edits to your products. Learn more about CSV file format. 

Skip to:

Create new products via import

To import new products, first, you need to prepare a CSV file.

Note:

We only support UTF-8 encoded CSV files. You can import up to 100,000 products at a time. The maximum file size is 30 MB.

Download our Sample CSV file to see the required format and fill it out according to the instructions below.

Field

Format

Example

Name
  • This field is required for the import
  • Alphabet letters
  • The maximum number of symbols is 255

Website development services

SKU
  • This field is unique and required for the import
  • Alphabet letters
  • Up to 255 symbols can be used

Q23-321T

Category
  • Required for the import
  • Text fields must be separated with a slash to display category and subcategory
  • Max category depth = 8

Services/Website development

Price
  • Required for import
  • Numbers only
  • Only two decimals are allowed.
  • The decimal separator is a period (.)

99.99

Cost
  • Required for import
  • Numbers only
  • Only two decimals are allowed.
  • The decimal separator is a period (.)

599.99

Currency
  • Required for import
  • ISO currency code

USD

Description
  • Required for the import
  • contains alphabet letters
  • You can use HTML formatting to style text in the Description section

Friendly description of your products

Images
  • HTTPS URLs delimited by commas
  • Only .JPEG, .JPG, and .PNG files are supported
  • There is a maximum of 10 images per item
  • The maximum image size by link is 10 MB
 https://images.unsplash.com/photo-1504972090022-6edb81e4e534

Note:

For the images to be imported, they can be hosted on your own website as long as the URL is HTTPS. You can also use another image hosting website such as ImgBB, Imgur, Flickr, etc. Get the direct URL to the image and add it to the CSV.

How to import CSV to PandaDoc

In PandaDoc, go to the Catalog and click Import. Next, select your CSV file from your computer, then click on Start import.

It takes several seconds for the system to process a file and import your products. You’ll receive a notification when the import has started, and you’ll receive an email when it's finished.

mceclip0.png mceclip1.png mceclip2.png

After you receive the email notification, go back to PandaDoc to verify that all of your products have been added.

Imported products will be located under All items and in the categories you specified in the CSV.

mceclip9.png

Troubleshooting

If CSV import failed, you’ll receive an email notification. In this case, open your CSV file and check the following:

  1. Make sure your CSV has column headers.
  2. For default columns, make sure you’re using the exact names as in catalog item fields. (e.g. Name, not Names). See the table above for the correct column names.
  3. Make sure your CSV doesn’t have empty rows across the product list.

Update catalog products via import

The easiest way to mass update your catalog is to export the PandaDoc product catalog as a CSV. Then update the CSV file and import it back. SKU numbers serve as a unique identifier of a product item, so when you re-upload your CSV with the same SKUs, the system will recognize them and map the products with the existing ones. 

Follow the steps:

  1. Open your Catalog and choose Export. 
  2. Go to your email inbox, and open the PandaDoc email to download your CSV file.
  3. Update your CSV and go through the import process as described above.

Note:

If you change SKUs in the exported CSV and re-upload it back, the system will create a new product for every SKU it doesn’t recognize.

mceclip5.png

Note:

Once you re-upload the edited CSV file, all products in pricing tables/quote builder blocks in your templates and content library items will be automatically updated. 

Export your products

To export products, go to your Catalog, click on three vertical ellipses in the top right and select  Export.

mceclip4.png

Note:

You need to have at least one Catalog item in the root folder of the Catalog to do the export.

Once the export has been completed, PandaDoc will send you an email to download the file. 

mceclip3.png

Export format:  The file will be exported in a CSV (Comma Separated Value) file. Your export will include all default PandaDoc Catalog fields and any custom fields you have for your items. Some description fields may contain HTML tags, e.g. <p> or <div>. PandaDoc can export up to 100,000 records at one time.

Time to process the export:  the export might take some time if there is a number of export requests from PandaDoc users.

CSV file format details

  • A CSV file is a delimited text file that uses a comma to separate values. Since CSV files use the comma character "," to separate columns, values that contain commas must be handled as a special case. These fields are wrapped within double quotation marks. The first double quote signifies the beginning of the column data, and the last double quote marks the end.
  • All lines contain the same number of values.
  • Fields that contain commas must begin and end with double quotes.
  • Fields that contain line breaks must begin and end with double quotes.
  • Rows are separated by line breaks (newline characters)

Sample CSV for importing your products

Was this article helpful?
82 out of 106 found this helpful

Related articles