My Deals import added a decimal or removed 0's from Deal money value

Sales_Plus_Professional_Enterprise

Summary
The value of money-type Deal Custom Fields changes upon import. For example, a CSV value of "1234" will import as "12.34" and a value of "1700" will import as "17." 

Resolution
Add two zeros to the end of any money-type Deal Custom Field value in the CSV. 

  • 1234 should be 123400
  • 1700 should be 170000

Cause

Money-type Deal Custom Fields are in cents format. 

  When updated from Zapier, the default Deal Field value is converted to cents.

Was this article helpful?
3 out of 4 found this helpful

Have more questions? Submit a request

Start free trial