Tom Dalton · Owner · Silver Medal

I did the steps posted in the UG for setting up the UPS OAuth integration in NetSuite. However, I'm still getting emails from UPS saying…. Your UPS account is showing incomplete for the API OAuth update. As of 6/13, UPS will begin limiting the access key activity to 50% of normal usage, and 2 weeks later the current access…

I found it. Commerce → Websites → (our website) → email → order received

NetSuite helped me find the fix. If this happens to you, go to "list → Relationships → Bounced Emil addresses". Select all and delete. Or, just select any employees that are in that list and delete them. Doing this fixed the problem. About two weeks ago, we had some employees show up in that list. It had never happened…

The fix was to NOT attempt to import the source type as either "Phantom" or "Stock". Instead, default the items to Phantom or Stock in their item records, and then let NetSuite set those to their default when importing.

It was an item import and importing the components into assembly items. I found the answer by testing. Blank spaces don't hurt anything.

I'm importing components into a list of assembly items, and I'm having a problem with Phantom subassembly items. If I add a column in my feed file for "source" and use "Phantom" on the phantom subassembly items. They fail. If I don't enter any source for any of the component items (letting them land on their default). They…

On the NetSuite side, I had just added a column with the standard NetSuite field "Name" which is {itemID}. That column displayed our SKUs when the saved search was viewed in NetSuite. When viewed on the published saved search, that same column showed the display name or another field that holds data similar to the "display…

OK, I found the issue on that one. The list was just a little over the max for one page, but some of the items were set to "Display Online = No" and apparently that is needed to be 'Y' to make them display in a published saved search …even if drill-down into search = N. There is one more curious thing. I try to have a…

What is strange is that this happened over a weekend when we had no known NS updates coming out. The Cloudflare part isn't due to NS, but the "is=login" part in the URLs is a head scratcher.

I have to give praise to fourth wave consulting. They've done work for us for 10+ years and are always super responsive. David, at fourth wave, fixed it. In case any other Site-Builder users have this issue.. I'll post the fix. The problem was caused by the fact that we’re still using the http version of the domain in…

I also noticed no new items can be added to the shopping cart. So, the cart page doesn’t load AND attempting to add any new item to the cart gives the error message: "The item could not be added to the cart".

We figured out the first issue. NetSuite added a unit we didn't have in our item's form. Or it dropped off the form for some unknown reason. We only had these 4: base unit Primary Stock Unit Primary Purchase Unit Primary Sale Unit We did not have "Consumption Unit" in our item form. Another question. We want to mass update…

That's the problem. I don't know the NetSuite URL syntax Google says use the hypothetical syntax /checkout?item_id={id} …but they want you to alter it to whatever your platform accepts.

Yes, I have a working solution for fulfillment records. I filter to only use COGs items. I need something specifically for Sales Orders.

— Note: the Sales orders have kits, inventory items, and assembly items on them. Some inventory items are sold as "regular" inventory items and are also sold as part of a kit. When we print our sales orders, the form shows all members to each kit item …each listed right under each kit item on the order. The same is true…

That didn't talk about formatting the add to cart section of the URL. This is the section that I need proper syntax for… /checkout?item_id={id}

SiteBuilder with SCA type checkout (Ref Checkout v2.05)

The free shipping promotion does work with assembly items, which is crazy to me. Kits and Assemblies are so similar, except for how the orders are processed (assemblies needing a build). Both are virtual items comprised of individual components. Yet, somehow… Kits = No free shipping promotion. Kits = No Drop-Shipping.…

Has anyone found a workaround to give ONE kit item free shipping in NetSuite?

Failing on kit items isn't a defect. It is "by design". Enhancement # - 289344 Summary: Advanced Promotions "Item Specific Free Shipping" support all item types

It is super slow today. 7/10/24. Times out on some page changes.

That didn't do it for me.

I figured it out and man was it complicated. This was done for a dataset for Suite-Analytics. I had to make a number of formulas to flag the three proceeding months that I wanted to include with a 'Y' and also flag the right years I wanted with a 'Y'. I was doing the past three FULL months prior to today's month and…

My answer was wrong. Does anyone else have a solution?

The tracking number was generated using a Sandbox account or a Test drive account. **THIS IS NOT THE CASE. WE DO NOT HAVE A SANDBOX ACCOUNT The tracking number is a dummy number randomly assigned. Users can double check the tracking number validity by searching for it in www.ups.com. **THIS IS NOT THE CASE. I CAN COPY THE…

I found it. STEP A: Date/Relative …get records from any date BEFORE the start of this week. STEP B: Date/Relative … Date must be after 11 weeks ago.

I'm getting this same error. It is blocking my item creation. I tried "general preferences, ensure that 'Show inactive items in global search' is enabled" .... it didn't help. Any other ideas?

ok, I made the support case. Thanks, Tom

It is an assembly item with the item's location set to "location X". Location X has "Make Inventory Available in Web Store = YES". The assembly item has SPECIAL WORK ORDER ITEM = YES. It also has, MARK SUB-ASSEMBLIES PHANTOM = YES. Other items appear to be set up like this one and don't show "out of stock" in our website.…

The default is "Allow backorders with no out of stock message". We use Site Builder.