John Nichel

@Jervin Nicholas Teopengco-Oracle I do not have a support case because every time we try to submit our support case, the form tells us, "Case Not Created We're sorry, but a technical issue occurred while submitting your case and we weren't able to preserve your data. Please try resubmitting your case later or if it is…

in createdFrom field not being set via the Rest API Comment by John Nichel Jan 23, 2025 5:38PM

Thank you for the reply @Angela Bayliss Unfortunately when I go the route that you outline, it brings me to the same form to report an issue that is throwing the error and I can't call in because when I call the only number I have for Netsuite, 1-877-NETSUITE, I get a recording the the call can not be completed and to try…

in Cannot contact support Comment by John Nichel Jan 13, 2025 8:31PM

Success; just had to 'study' the SOAP request to figure out how to build the code. Much easier than it used to be. In case anyone else needs this: [CODE]$updateItem = new inventoryItem(); $updateItem->internalId = $internalID; $updateItem->storeDisplayName = $product['product']; $updateRequest = new UpdateRequest();…

in Update Inventory Item with PHPToolkit 2013.1 Comment by John Nichel Jun 20, 2013 12:22PM

Getting somewhere. When I fix the quantity missing, and try to only set base price, it works for all price points. Can I set multiple price levels in one call though? Like base price, online price and wholesale price? If $pricingmatrix isn't an array with each element of that array representing a different price level…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 3:55PM

Nevermind, it is working now. Haven't made any changes to the role in 2 hours, but for some reason it just started working. Any idea why it could take so long for permission changes to take effect (this is not the first time we've run into this, but it's never taken this long)?

in Permission error when trying to retrieve a list of pricing groups Comment by John Nichel Mar 21, 2012 3:36PM

I get the unknown error when I try to set just one price level (with multiple price points): <?xml version="1.0" encoding="UTF-8"?> <Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:accounting_2011_2.lists.webservices.netsuite.com"…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 3:25PM

When I try to set just one price level, the script errors out with an "Unknown Error". The matrix for that looks like this: [pricingMatrix] => Array ( [pricing] => Array ( [currency] => nsRecordRef Object ( [nsComplexObject_type] => RecordRef [nsComplexObject_namespace] =>…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 12:45PM

Thank you Lorne, but I'm still having some issues. When I try to add all three price levels, the script runs fine, new inventory item is created, but it has no pricing. For this, my pricing matrix is constructed as such: Array ( [0] => Array ( [pricing] => Array ( [currency] => nsRecordRef Object (…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 12:43PM

That did the trick Lorne. With your above example, I was able to modify my code to set multiple price levels with multiple price points per level in one call. Thank you! In case anyone is interested, the code that did the trick: [PHP]$pricing = array(); foreach ( $pl_array as $k => $v ) { $temp_array = array(); foreach (…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 4:28PM

[PHP]$newItem = array ( "itemId" => $itemId, "upcCode" => $_POST['upc'], "displayName" => $_POST['displayname'], "vendorName" => $_POST['productcode'], "unitsType" => new nsRecordRef ( array ( "internalId" => $_POST['unitstype'] ) ), "stockUnit" => new nsRecordRef ( array ( "internalId" => $_POST['stockunit'] ) ),…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 1:49PM

This is the add request. For whatever reason, pricingMatrix is empty. <?xml version="1.0" encoding="UTF-8"?> <Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:accounting_2011_2.lists.webservices.netsuite.com" xmlns:ns2="urn:core_2011_2.platform.webservices.netsuite.com"…

in Setting multiple prices with one call Comment by John Nichel Mar 28, 2012 3:19PM

Works like a champ, Lorne. Thank you very much.

in PHP create new item set SiteCategory Comment by John Nichel Mar 19, 2012 2:15PM

Thank you for the response, Lorne. Your above code will pull the sub-list with the internal id of 1, but I'm trying to pull the parent list of that one. When navigating to it in Netsuite, it is under: Lists -> Accounting -> Units Of Measure Which brings me to the following URL:…

in Using PHP to get values of "Units Of Measure" Comment by John Nichel Mar 5, 2012 10:19AM

Thank you again Lorne. In case anyone is as confused as me in the future: [PHP]$cet_fields = array ( "recordType" => "inventoryItem", "field" => "costestimatetype" ); $cet_search = new nsComplexObject("GetSelectValueFieldDescription"); $cet_search->setFields($cet_fields); $cet_response =…

in Where to find certain lists Comment by John Nichel Mar 20, 2012 2:59PM

Thanks Lorne. Worked better than I was hoping for.

in Using PHP to get values of "Units Of Measure" Comment by John Nichel Mar 6, 2012 12:56PM

Support case #1441493

in Creating a new inventory item with pricing via PHP Comment by John Nichel Feb 15, 2012 9:26AM

Dumb error on my part. "pricingLevel" is supposed to be "priceLevel". Starred at the code for an hour before I saw that. Anyway, when I try to execute the above code (with the correct name), I get the following: An unexpected error occurred. Error ID: gyne7ohctxodrbweodzh Not sure what to do here.

in Creating a new inventory item with pricing via PHP Comment by John Nichel Feb 14, 2012 3:45PM

Worked like a charm Lorne. Is there a way I can set multiple different custom fields in one call? I added another custom field, and the add works, but only the last custom field that I setFields for is populate (custitem_shipping_days_max in this case). [PHP]$customFieldList = new nsComplexObject("StringCustomFieldRef");…

in Set custom field on new inventory item creation Comment by John Nichel Mar 14, 2012 12:32PM

Case solved. Needed to quote the quantity: "quantity" => "0". Thanks to James.

in Creating a new inventory item with pricing via PHP Comment by John Nichel Feb 15, 2012 10:07AM

Thank you for the response. I had read in the forums that it may take some time to update, so I decided to wait until this morning to give it another show. Now, when I run my script, instead of the (wrong - outdated) data it was returning yesterday, it returns an error (Fatal error: SOAP-ERROR: Encoding: Error calling…

in Saved Searches not updating with web services Comment by John Nichel Feb 23, 2011 10:44AM

John Nichel Blue Ribbon

Comments