Import and export your catalog via CSV
You can import and export your products to PandaDoc catalog by using a CSV file.
Import your products
Note:
we only support UTF-8 encoded CSV files. You can import up to 100,000 products at a time.Prepare your CSV file
The easiest way to do this is to download our Sample CSV file (find attached at the bottom of the article) and fill it out according to the instructions below.
In order to populate PandaDoc catalog fields with your product data, you need to fill out the respective columns in the CSV, like this:
The default catalog item fields in PandaDoc are SKU, Name, Price, Cost (if enabled), Description, Currency, Images, and Folder. In the CSV file, these fields are shown as columns.
How to set up each column
Refer to the table below for detailed instructions on how to format each column in your CSV file.
Import your CSV file
In PandaDoc, go to the Catalog and click on the ellipses (...) next to “New Catalog Item”. Then choose Import.
On the next screen, simply select your CSV file from your computer, and click on Import.
It takes several minutes for the system to process a file and import your products. So, you’ll receive a notification that the import has started, and when it’s finished you’ll receive an email.
Verify that your items have been added.
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 in your catalog root folder or in the folder you specified in the CSV:
Expand to learn how to delete a column or add a custom one.
You can delete any column from the CSV except for Name. You can add a custom column to your CSV file, it will be saved as a custom fields in catalog items. On the pricing table, you can add it as a custom column.
Expand if you already have a CSV file or want to create one from scratch
To map CSV file columns with PandaDoc catalog item fields:
- You must have column headers in your CSV file;
- Column headers must be named exactly as catalog item fields, see the table above;
- Follow the instructions from the table above to fill out CSV columns in the correct format;
- Delimiter to separate content/columns is a comma.
Expand for mass-update catalog in PandaDoc
Provided you are not changing SKU codes, 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. This will update the information based on the new CSV.
Follow these steps:
- Open your Catalog and go to the folder your want to update. Click the three dots at the top and choose Export.
- You’ll see a popup confirming export has started.
- Go to your email inbox, and open the PandaDoc email to download your CSV file.
- 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 of product for every SKU it doesn’t recognize.Troubleshooting
If CSV import failed, you’ll receive an email notification. In this case, open your CSV file and check the following:
- Make sure your CSV has column headers.
- 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.
- Make sure your CSV doesn’t have empty rows across the product list.
Export your products
Export format: The file format will be 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.
PandaDoc can export up to 100,000 records at one time.
Note:
you need to have at least one Catalog item the root folder of the Catalog to do the export.Time to process the export: The export can take some time due to the numbers of clients requesting the export.
Perform the export
Go to your Catalog (found on the left), in the top right, click on the “Export” button.
Receive notification email and download the CSV
Once the export has been completed, PandaDoc will send you an email to download the file.
