Are you doing it in the multi file format? By doing it this way, you save each customer record once rather than each item on each customer record once which can be over a hundred times faster, depending on how many items you're uploading. Here are the files and mappings. Key Customer file, you only need internal id or…

Changing from Update to Add/Update has solved this. My assumption was that I was just updating customer records, but I am actually adding records to the customer record. As usual, pretty terrible error response codes from the CSV report didn't help either. lol

I dunno if this is possible natively, as I also don't have a way to map it on my CSV import. In mine, it looks as though the implementation partner created a custom field, mapped it to a script and then had the script update the native field with the value of the custom field. The green C notes it is a custom field. Here…

It could be the employees subsidiary, though I think that would have caused a fair number of other problems before already. Perhaps check the folder, if you edit the folder you'll see the restrictions, do any of those apply to the particular user? Otherwise, even a simple Ctrl + F5 could fix it, but otherwise I'm not too…

Sorry, is this when they try to drop the file into the cabinet, onto a particular record or anywhere? Could you also clarify what the error message they're seeing is please, perhaps with a screenshot if you can. In the meantime, you could maybe ask them to try using a different role or you try using their role to see if…

I've not done this before, but at a glance I would assume the line is for specifying if you're trying to overwrite existing Item Fulfilments, is that what you're doing? If you're creating new ones, maybe try not mapping the item line, I would think NetSuite could work that out itself. You also appear to be trying to map…

I don't know if this is possible if your main expectation is for the item to be the same as the component. If you try to create a BoM for an Assembly and the BoM contains the assembly you get the error 'BoM contains an item loop'. You could simply inventory adjust the status of the items from broken to good (you would also…

Oh, that's interesting. For most of us it's not an issue at all. It's just the Customer Service team, a team of 20, who are largely working out of the 1 shared inbox. Our admin has said that we are at a block with how many emails are going out of this account, and has immediately suggested we look for a solution elsewhere.…

That's right. I'm wondering if users have any other suggestions, or of systems that work within NetSuite.

Thanks Pratik, I'll try to set this up and confirm if I can get it working.

No, I've tried making the Phone mandatory but that of course gives me an error at checkout because I don't have the Phone field to fill in on the front end. I'm struggling to figure out how to put the Phone field back onto the address form instead of the Custom one so I'm waiting for the SCA partner to do it. I thought it…

I'm still not sure why this was behaving differently for different roles. I have since redone the script and appear to have fixed it. Though again, what fixed it, I'm not sure. I removed the check for (if sublistID === 'item') because a validate line will always be on an item. But other than a few other lines to make sure…

NetSuite is too unique to each company and has far too many features to make a catch all presentation. Make it yourself for how your business operates NetSuite. 😄

Ah, that's unfortunate. I'll go cast my vote. Thanks for doing the digging, Bry. Very helpful~

Hi @Bry Cabria-Oracle I think those get set up automatically for me after creating the groups and commerce categories. But yes, they're all set up. In the below screenshot I have all 4 of the categories, most with different groups containing the different customers. I can only log in as a contact of TEV2079, yet because My…

Yea, I just change the value of createpo field on the Sales Order record before the record gets saved and NetSuite takes care of the rest as it normally does.

I have created User Event and Client scripts to automatically generate the Drop Ship orders if the quantity of the item is greater than a Drop Ship Qty field on the item record. This takes into consideration creating an SO, copying an SO from an Estimate and creating an SO via the Webstore. Reach out to me for anyone that…

For now, I have partially solved this by having one Email use the Created From Raised By when the context is anything but Web And another that uses a Static from email when the context is Web.

It appears to work if I change the Sender to a static employee rather than the Raised By of the Created From record. This workflow is for Drop Ship orders, so the Created From is the related Sales Order which does have a value in Raised By. This functionality works for manual and automatically created orders but is…

I had my deployment set to only log error level logs.🤦‍♂️

It's good to have a parent/holding company incase you get bought out. Makes the transition a lot smoother as you can't add in a new parent at the top of the tree. I would do this and operate your child subsidiary as the primary. But that's just my opinion. ☺️ You can do this without One World. One World is for companies…

I think this helps, thank you. So now I just need to build a simple script that if when the item quantity is over a certain amount, the record saves the line as a Drop Ship order. Again though, is there no built in automation in NetSuite that can cover this step?

Hi Bry, Yes, most of the addresses have phone numbers saved, especially the new ones being used in the webstore as the phone field is already made mandatory. It's made mandatory on the webstore though, not the address form. Though, this field appears to be a custom phone field set up by our partner who is setting up the…

Thank you @Bry Cabria-Oracle , that fixed it.

If Trixie's response doesn't help answer your question, I would also suggest checking to make sure your items are available and in bins, you can't pick an item if it isn't in a bin to be picked from. Try checking your bin putaway worksheet.

Ah, never mind. I just had to Insert it into the correct place to begin with rather than using the Add Row button. But, it would still be useful to know if I can move these, rather than changing existing ones, deleting them and/or adding new ones.

Some how uploaded my file without it named .js 🤦 Thanks for pushing me to keep testing @Francesca Nicole Mendoza-Oracle

Thanks Bry. As you hinted at, checking the Store Item checkbox on the Applies To subtab of the custom fields has fixed this and web orders are now pulling through the data. The Product Segment is actually a custom segment, so I was able to edit this in a similar way.

It can be a little tricky. But essentially what I'm trying to and have ended up doing is that the lead gets created with a copy of the login as a contact. Then we merge the lead into the primary customer, the lead not having access or a login which allows the merge to happen. The contact then gets merged into the primary…