# Error importing deals **URL:** \ **Category:** Marketplace Apps\ **Created:** [July 3, 2018, 6:36pm UTC](https://community.hubspot.com/t/error-importing-deals/9332 "2018-07-03T18:36:45Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![fobarros](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fobarros/32/64675_2.png) [@fobarros](https://community.hubspot.com/u/fobarros)\ **Post date:** [July 3, 2018, 6:36pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/1 "2018-07-03T18:36:45Z")
Hi, I’ve trying to import some deals with this error bellow. Any clue is appreciated 🙂 | UNKNOWN\_BAD\_REQUEST,DEAL,“Can’t create or update object (details: Property values were not valid)”,2,"Biggy Puket “,Blocked,6200,gabriela@biggy.com.br,“[Trello](https://trello.com/c/yBpiWIUC%22,%22New) Business”,” ",“Sales Pipeline” | | --- | My first 2 rows: | DealName | DealStage | Amount | DealOwner | CloseDate | DealDescription | DealType | ClosedLostReason | Pipeline | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Biggy Puket | Blocked | 6200 | gabriela@biggy.com.br | | [Trello](https://trello.com/c/yBpiWIUC) | New Business | | Sales Pipeline | Tks ---
**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\ **Post date:** [July 3, 2018, 7:33pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/2 "2018-07-03T19:33:14Z")
Removed ---
**Author:** ![fobarros](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fobarros/32/64675_2.png) [@fobarros](https://community.hubspot.com/u/fobarros)\ **Post date:** [July 3, 2018, 7:36pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/3 "2018-07-03T19:36:42Z")
Hi, Here is my file: ![Screenshot_1.png](https://d2qpr2jzcazej7.cloudfront.net/optimized/3X/5/f/5f20322624f88bf2fdd7488098be42a99ec862b9_2_690x36.png) When I try to import this I receive: UNKNOWN\_BAD\_REQUEST,DEAL,“Can’t create or update object (details: Property values were not valid)”,2,"Biggy Puket “,Blocked,6200,gabriela@biggy.com.br,“[https://trello.com/c/yBpiWIUC","New](https://trello.com/c/yBpiWIUC%22,%22New)Business”,” ",“Sales Pipeline” Tks! ---
**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\ **Post date:** [July 3, 2018, 8:01pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/4 "2018-07-03T20:01:42Z")
Removed ---
**Author:** ![fobarros](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fobarros/32/64675_2.png) [@fobarros](https://community.hubspot.com/u/fobarros)\ **Post date:** [July 4, 2018, 11:48am UTC](https://community.hubspot.com/t/error-importing-deals/9332/5 "2018-07-04T11:48:33Z")
Tks for you help 🙂 Following my aswers: Q: You’ve read and fully complied with, How do I import deals? A: yes Q: You have a Deal Stage named ‘Blocked’ in your Sales Pipeline. A: ![Screenshot_1.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/4/e4a4b94974ace0f7b3cc04c117fca6cd9228bf43.png) And I’ve tried with another deal stages Q: Dou have a valid HubSpot User with an email address of ‘gabriele@biggy.com.br’. ![Screenshot_2.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/9/6/9653046062aab6d16c9aefddfd21951e6ac34a82.png) Yes and I’ve also tried with anothers users without success Q: There are no missing REQUIRED fields in your ‘Blocked’ Deal Stage. A: I did not customize anything in the pipeline. And just as test, I created a deal with just name directly in the interface and it worked. Q: This is not a duplicate record. It’s the first! My pipeline is empty Q: What’s your Map Columns screen look like during import? ![Screenshot_3.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/d/7d2a3208536a4fe4c1d2a8ae4ac7c9874ddd461d.png) I really appreciate your help. 🙂 I would not like to create the 150 deals we have today manually. Tks ---
**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\ **Post date:** [July 4, 2018, 2:05pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/6 "2018-07-04T14:05:23Z")
Removed ---
**Author:** ![fobarros](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fobarros/32/64675_2.png) [@fobarros](https://community.hubspot.com/u/fobarros)\ **Post date:** [July 4, 2018, 3:00pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/7 "2018-07-04T15:00:11Z")
Hello, After you passed all the validations I went to do a simple test. I got the Sample\_Deal\_Import-1 template and did the import. To my surprise (or happiness) the same mistake happens. Look: ![Screenshot_1.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/d/d7b1e94d47d44483ebe18c87daffadd8bf1787bd.png) I understand that the last 3 errors are due to the modifications I made, but the UNKNOWN\_BAD\_REQUEST error (should not create or update object (property values were not valid) should not happen. I believe it’s really a platform problem. Thanks in advance and I wish you a great holiday !!! 🙂 ---
**Author:** ![fobarros](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fobarros/32/64675_2.png) [@fobarros](https://community.hubspot.com/u/fobarros)\ **Post date:** [July 6, 2018, 11:01am UTC](https://community.hubspot.com/t/error-importing-deals/9332/8 "2018-07-06T11:01:09Z")
Does anyone know how I can get this message to support HubSpot? I would like to use the tool, but if I can not import I will use another CRM. Tks ---
**Author:** ![markkofman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/markkofman/32/24823_2.png) [@markkofman](https://community.hubspot.com/u/markkofman)\ **Post date:** [July 8, 2018, 6:36pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/9 "2018-07-08T18:36:56Z")
@fobarros can you try importing your deals using 3rd party import tool - [https://wizard.import2.com](https://wizard.import2.com)? It might give you the different result as this uses API instead of native import tool. ---
**Author:** ![MFrankJohnson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfrankjohnson/32/22490_2.png) [@MFrankJohnson](https://community.hubspot.com/u/MFrankJohnson)\ **Post date:** [July 9, 2018, 8:17pm UTC](https://community.hubspot.com/t/error-importing-deals/9332/10 "2018-07-09T20:17:24Z")
Removed #nlmtt