Billing Export
Good day,
We recently upgraded to the advanced license because we want to use PD for more than just pipeline management. I’d like to start using the CRM and export billing data from PD to process it in a different billing system.
However, when exporting to Excel, all products within a case are combined into a single line, making it impossible to use. I need a way to export them as separate line items without having to create a separate case for each billing line.
Is there a way to achieve this in Excel, or has anyone successfully done this through an API call? Any help would be appreciated.
Answers
-
Hi @Stuartzn,
When making the Product export from the Export Data section, you will be able to get a file for each row containing the product information as well as the information about the deal and the product attached to it. If a deal has more than one Product attached, it will be represented in their respective rows.
You can also customise the export by filtering it based on parameters like the Deal created date or Deal won date:
Additionally, you can also use the List products attached to a deal endpoint to retrieve the information of all Products linked to a deal by passing the Deal ID in the request. We hope this helps :)
0 -
Hey, yes, it's possible to export billing data from Pipedrive, but it depends on what exactly you need. If you're looking to get each product listed separately, exporting from the Products section should do the trick. Each line in the export will show the product and its related deal. If you're after something more custom or want to automate it, using the Pipedrive API is another way to go. And if coding’s not your thing, tools like Skyvia can handle the integration and export for you without much hassle.
0
