I'm having issues when importing to "opportunity products". I'm analysing the opportunities with the issue and they all have a larger number of opportunity products than the ones that succeeded and was wondering it there was a maximum number of lines?
There shouldn't be any maximum amount of lines you can associate with an opportunity. What is the exact error you are receiving?
Jason Lattimer My Blog - Follow me on Twitter - LinkedIn
Thanks for replying. The message is "Error: 400: Bad Request: Syntax error '%' at position 16". But cant see anything different with this data......
So I had an opportunity with 40 lines, I input 10 manually and fine, once I got to the 11th (51 lines) it came up with the above error. Any idea how to fix this?
I'd try a test maybe with just the one line that is failing - starting with the minimum amount of fields to create the record and that adding additional fields. Hopefully this approach will flush out the issue - I suspect it is related somehow to the data.
That is pretty much what I did, I just added 11 "test" lines, with minimal data. And when it got to 51 it came up with the error. I'm going to do a few more tests importing all the same data for various product lines, testing under 50 and over 50 to see if this is definitely the issue.
So I setup 4 test opportunities that are exactly the same. Then imported 49, 50, 51, 52 lines to the 4 ops (all lines exactly the same). The first 2 were ok (49 and 50 lines), but the 2nd 2 failed with the error message mentioned above.
I just tried a test and was able to import 74 lines to an Opportunity.
What I did was create the Opportunity and than added 1 write in product. Exported the 1 line and copied it a bunch of times, changing the write in product name for each, and added a column for the Opportunity topic. Saved as a tab delimited file and then ran the import. All items succeeded.
Are you using existing products or write in products? Do the lines beyond 50 work if you make them say lines 1 or 2?
Thanks for all your help with this.
We have bespoke elements and we dont actually use the product table. Therefore we dont have any existing products. Not sure what you mean by "write in" products.
You can add more than 50 lines to the opportunity and save it, but you cannot recalculate and every time you open you get the error message, until you delete a line
It seems to be the recalculate opportunity that is causing the issue. It doesnt like doing this for more than 50 product lines. Does your one with 74 lines recalculate?
I was able to recalculate that Opportunity. Do you have any custom plugins registered against the Opportunity entity that might be interfering?
I will check with the developers - THANKS :)
Just to update you - one of our developers has found an issue with the script. The webservice by default only gets 50 records. Thanks for your help with this :)
Glad you were able to get this sorted out.