Skip to main content

Search

What is the new version of the CSV (merchant portal export of transactions and orders)?

What is the new version of the CSV? 

The Zip merchant team is continuously working to improve the experiences of our partners. As part of this ongoing effort, we have released a new and updated version of the CSV (V2). 

Why are we rolling out V2? 

We are aware that V1 has some limitations, which has caused confusion for some of our merchant partners. V2 of the merchant portal export will help resolve some legacy reconciliation issues and create more consistency with reporting. Moving forward, our merchant partners will have access to both versions. 

Who will have access to V2? 

All US based merchants for now. We will be rolling out the updated CSV to additional regions shortly. 

Where can this new version of the merchant export be found? 

V2 of the CSV can be found in the ‘Transactions’ tab of the merchant portal. To download the updated CSV, click the ‘Download CSV’ button and select ‘Updated CSV’ (please see the example below). 


csv.png

What are the differences between V1 and V2? 

Multiples captures 

In version 1, all transactions that have occurred on a given day (regardless of their type), are combined into one row. For example, 

  • A customer submits an order today worth $100. 
  • They also decide to make a partial return worth $25. 
  • The amount captured on version 1 of the export would be $75. 

In version 2, all transaction types (Confirm, Void, Capture, Refund) and any relevant fees, will be reflected on their own row. In other words,  

  1. If multiple captures occur on the same day, each capture will have its own row (including all the related fees). 
  2. If multiple voids occur on the same day, each void will have its own row (including all the related fees). 
  3. If multiple refunds occur on the same day, each refund will have its own row (including related fee rebates). 
Transaction types 

In version 1, some transactions will appear as blank: 

  • Merchant Fee Capture
  • Merchant Fee
  • Transaction Fee 
  • Merchant Fee For Payment Plan
  • Fee Rebate 
  • Return Fee 
  • Merchant Fee Payment Plan Rebate

In version 2, these transaction types will be populated. 

 

Related articles