Recent searches
No recent searches
Excel/CVS import
Answered
Posted Mar 04, 2021
Hi,
We get a daily email into zendesk support with an Excel of the status of all our current orders. At the moment we open the excel and copy the status and tracking numbers to the tickets by matching the PO number on the excel which is the same as the ticket number.
I am looking for a way to import that excel into Zendesk so that it can update the tickets that it relates by putting the tracking number and status on the ticket fields.
Can someone please point me in the right direction I would really like to automate this as much as possible
0
1
1 comment
Romona
Hi Shane,
The Import function would not work for this use case. May I recommend building your own script using our API :
https://developer.zendesk.com/rest_api/docs/support/tickets#update-many-tickets
For multiple Tickets or https://developer.zendesk.com/rest_api/docs/support/tickets#update-ticket
For a single Ticket.
Romona | Technical Support Engineer
0