One thing that's not mentioned here specifically but that is important is the summary type. Without setting the Formula (Currency) column summary type to "Maximum" or "Minimum" and setting the others to "Group", the search will add a row for each one of your price levels.

Fixed it used the method described here: https://usergroup.netsuite.com/users/showthread.php?t=11902&highlight=nlprocessonce All I had to do was add the <NLPROCESSONCE> tag around the table containing the <%=getCurrentAttribute('item','addtocartoptionshtml')%> tag so it looks like this: &lt;NLPROCESSONCE&gt; &lt;TABLE…

OK, so I'm just dumb and can't read directions. It's under Setup>Setup Web Site under the "Search" tab

OK, that's kind of what I figured. Let me ask this, then. Is there any risk in me using an unused existing field (like brief description) as if it were a custom field and using it to establish JavaScript variables via an attribute tag inserted into the head of the information item template?

Not sure if this is still an issue, but for anyone who stumbles upon this thread looking for the answer, you can import Commerce Categories by setting the Import Type as "Custom Records" and setting the record type as "Commerce Category Import". You should be able to import from there. My mistake. This isn't actually…

Not sure if this is still an issue, but for anyone who stumbles upon this thread looking for the answer, you can import Commerce Categories by setting the Import Type as "Custom Records" and setting the record type as "Commerce Category Import". You should be able to import from there.

Oh, sorry. I meant programmatically, like pulling an item attribute tag into JavaScript so that I could execute a function in the web store if an item had related items or not.

Thanks for the guidance, Raymond. That solved my problem...sort of. It is now pulling in the field that I'm looking to get. However, it is pulling a field that can only be explicitly stated in the tag using this syntax: <%= getRecordAttribute('56','1','custrecord_video_id')%> Where "1" is the ID of a specific record in the…

So, it's a total hack job, but I actually did figure this out. I noticed that all the Info Items in the category that I needed to work with had table cells with a column span of 8. I did a little research and found out that you can use jQuery to manipulate objects based on their attributes, so if a table cell has a column…

Interesting. I didn't even know NetSuite had a developer network. I really wish I would have known that for the past 3 years... I'll give it a shot. Thanks!

No, I never ended up doing it. The client decided to do a smaller Wordpress site and manually manage their inventory through a combination of NetSuite and PayPal. I did sign up for a NetSuite developer account and I highly recommend it as a way to test out and play with NetSuite functions:…

I actually ended up figuring out why it was doing this. Under the advisement of one of the fine folks in these forums (@david.smith), I’ve been executing the script as a custom role called “External Scripts Only” which has a bare minimum of user permissions (some access to custom records and items > View under Permissions…

Thanks, David. Your plugin is exactly what I used to get my filters and columns setup. In all cases, the itemid doesn't return the full string.

And even when I create a saved search and edit all the parameters through the saved search, the itemid doesn't return correctly. results = nlapiSearchRecord('item', 'customsearch_searchid, null, null);

OK, after talking with some other NetSuite folks, RESTlet definitely seems like to go. However, I'm still having trouble understanding how to set one up, especially using token-based authentication. I've setup the integration, and received the consumer key and consumer secret, but the documentation says I need the…

Yep. No JSON support. Gotta be XML...

I've looked into Restlets a bit, but I can't stop getting authentication errors. The affiliate only accepts datafeeds according to Google’s Product Feed Specifications, which are XML. I haven't approached them about the idea of just the JSON yet. That might be an idea... nlapiSearchRecord was what I had originally done and…

Thanks, David. That makes sense for the most part. Like I said, though, I have older external scripts that execute just fine with "Current Role" or "Full Access" selected. Is this a new restriction? In either case, I can try to create a new role. I'm unfamiliar with creating roles, unfortunately. Do I just go through under…

Ugh. OK, in classic fashion, I was not opening the external URL in an incognito window and receiving an error regardless. Opened it in an incognito and worked immediately. Looks like you've saved my bacon again. I definitely owe you a drink or to. That other extension looks promising as well... Thanks for your help!

The error in my Sandbox account is at least a little more descriptive: "Permission Violation: You need the 'Lists -> Items' permission to access this page. Please contact your account administrator."

Well, as near as I can tell, the code doesn't seem to be the issue, since I can execute the search from the internal URL, return items in the correct format and don't get any errors when I do. Trying to access the script from the external URL is what produces the error.

Thanks for the suggestions, guys. In classic "Dad, the lawnmower won't start" fashion, it started working on its own, though. I think it might have been because I switched the kind of search that the script was doing halfway through. Maybe a cache issue? In either case, thanks for the guidance!

Wow, Brett. Thanks a bunch for the information! I haven't started playing with it yet, but I'm sure I'll return when I try to implement something and take down my entire site :)

OK, I actually figured this out randomly today. The default way is to use the pipe character (|) between the values in the field you want to assign (no spaces, just the pipe). So in my Intended Use case above, the column in the CSV would have the values Use 1|Use 2|Use 3 It's actually listed under Advanced Options on the…

OK, I've figured this out. As with most things in NetSuite, this section is badly named (and not the same as it says in the documentation). For anyone else who has this same problem (and because I can't find this information anywhere), here's what worked for me: [LIST=1] [*]Create your CSV file in Excel, give the columns…

Yeah, I've read that thread, but I don't even see "Items Items" anywhere. Where is it?

I have found a solution that may or may not work for you. 1. Create a search that returns the records you want to delete 2. Turn on list editing 3. On the first record, click into a editable field 4. Scroll to the last record and shift + click into the same field 5. A box will appear over that field for all rows 6. Use one…

Short answer? Yes. Long answer...? Kinda. Basically, what we had to do was this (on an SCA site). I know it does not work in all situations, however: [LIST=1] [*]Create a new price level under Setup > Accounting > Accounting Items that we would use as the sales price for affected items and make sure it has "Online Price…

Thanks for the reply. We ended up just rebuilding the item we were having trouble with, but I'll definitely check out that article for reference.

Is there at least a suggested workaround or does anyone have any bright ideas on how this could be accomplished?