Shopify Common Errors

Error: error getting risk data: SyntaxError: Unexpected token < in JSON at position 0

Shopify API issue with return on Rick data

Try a reprocess of request

A contact record with this name already exists. Every contact record must have a unique name.

The Payload being processed, the customer Array First_name & Last Name being updated to contact is already the First and Last Name on an Existing Contact and NetSuite does not allow Contacts with Same Name

Confirm Shopify and Payload Last Name to be unique and then re-process the Request Payload

Error: error getting risk data: Error: Order cannot be created due to Order Risk score higher than the setting MAX score <score set in Shopify Setting> ; score 1

Settings are set to Not create order with High Risk Score

You can mark these Completed if not needed, otherwise the Score in Shopify will need to be adjusted in Shopify to process again, to be below the set score in settings

Code: INVALID_FLD_VALUE
Details: You have entered an Invalid Field Value MYR for the following field: currency

Multi-Currency support is enabled but cannot Find the currency to set

Make sure the Currency is in the Currencies listing in NetSuite

"The transaction date you specified is not within the date range of your accounting period.

The Accounting Period for the Transaction Date trying to be set is not open.
Either a Record order being created in NetSuite and Someone already closed the accounting Period

OR

The New Year Accounting Period is not open yet but there are NEW records trying to be created in that period

Open the Accounting Period

Setup > Accounting > Manage accounting Periods

Code: USER_ERROR
Details: Please choose a shipping method to account for the shipping cost.

No Shipping Method Mapped to account For the Cost over 0.00 on NetSuite

Get the Shipping Title Mapped so integration can set the Shipping method needed for the Order.

under Setup Tab > In8Sync Shopify > Shipping Methods

Error: POS Non-Exchange Refund: Unable to find related Invoice or Cash Sale.

Original order not Completed and Billed

Make sure the Original Order Is fulfilled and Billed then re-process
IF not a BIN, Lot or Serial Item, and inventory Status is enabled then QTY Must be available in NetSuite to Fulfill POS orders Or in cases where integration is creating Fulfillment on NON-POS order as well.

code":"INVALID_FLD_VALUE","details":"You have entered an Invalid Field Value 141792 for the following field: entity

Customer that Was found is Inactive

Make sure the Customers with the Shopify ID is not inactive

A_TAX_LINE_WITHOUT_AN_ACCOUNT_CANNOT_CONTAIN_THE_TAX_AMOUNT_1

The Tax Agency Vendor Record is not in the correct Subsidiary for the Site Subsidiary

Main issue is no Address Validation on the Shopify Shipping Address and the ZIP code is not correct for the Order address

Update the Primary and Sublist to only list the subsidiary needed.
Cannot use multiple (NetSuite Support to push them to add Vendor Tax Agencies to support multiple subsidiaries)

Correct the Zip code to be correct in the Request Payload and re-process

"The record type [CUSTOMRECORD_IN8_SHP2_SETTINGS] is invalid."

Shopify Settings Has enabled the “Enable Return Suitelet” Which Requires the In8Sync Shopify Return Portal in Shopify

Disable the “Enabled Return Suitelet” Unless the In8Suite Team Has installed the Return Portal in Shopify

name":"INVALID_TRANS_TYP","message":"Transaction type specified is incorrect."

POS Orders not able to Completely BILL to cash sale or Invoice, so returns fail to be able to process

Find original Order Payloads and re-process and correct whatever was not allowing fulfill and bill to make sure they are completed and BILLED

Unexpected Error

Unexpected Error can actually be caused by a Few things.

Main reason seen is the Integration is trying to set Shipping Cost, but the Field does not exist when Shipping is not enabled. Causing an Unexpected error for us trying to set a field not currently enabled to show on Sales Order

Under Setup Tab > Accounting > Shipping:

Check to enable Shipping if needed in the account. Will also require any Shipping Items to have Accounts and Tax Schedules set on them to work properly.

Error: Private app may need the following access scopes: read_assigned_fulfillment_orders,read_merchant_managed_fulfillment_orders, read_third_party_fulfillment_orders; in order to fulfill Gift Card

New Enhancement for Fulfilling Gift Card Lines when order is processing From NetSuite, from the Correct Location needed from the Orders “Fulfillment_order” Assigned location

In Shopify > Apps > Manage Private Apps link at bottom of screen > Click on the Private App for In8Sync (or NetSuite) Private APP

Confirm/Add the Read/Write Permissions for

• Assigned fulfillment orders

• Fulfillment services

• Merchant-managed fulfillment orders

• Third-party fulfillment orders

Then the Requests in the NetSuite Queue can be put back into Pending Status to re-process

"name":"INVALID_FLD_VALUE","message":"You have entered an Invalid Field Value <so internal id> for the following field: salesorder"

Customer Deposit and Billing Happening at the same time, when the Setting “Enable Customer Deposit” is enabled.

Upgrade to Latest 2.6.13 and deploy the “In8 Shopify Bill Order UE” against Customer Deposit. This will confirm the “Enable Customer Deposit” setting is enabled and trigger the Auto Bill off Customer Deposit VS Sales order to allow the Deposit to be created before Billing

"INVALID_FLD_VALUE","message":"Field must contain a value."

Shopify Customer Does not have First and Last Name
NetSuite Requires both on Individual Customer Records

• Make sure Checkout Settings in Shopify Require First and Last Name

• Make sure any APPs that create Customers are getting First and Last Name

• Make sure when manually Creating Customers to get First and Last Name

• Recommended when hitting this to possibly export all Shopify Customers, make sure they all have First and Last Name, If any do not update the CSV and Import back the Customer Who Did not and get them update to have First and Last Name

NetSuite Order Payloads need Manual adjustment to update the First or Last Name (within) quotes, to sync in. There are a few areas in the Payload to make sure they have both.

JS_EXCEPTION","message":"org.mozilla.javascript.EcmaError: TypeError: Cannot read property \"tags\" from undefined (/SuiteBundles/Bundle 289729/src/util/in8_shopify_response_util.js#14)"

Customer Record Had two Shopify Customer Ids Listed for Same site

Check Shopify Customer for the one with the same exact email. Check URL for correct Shopify ID. Then go back to NetSuite Customer record and Edit and delete the Incorrect Listing for the Shopify Customer ID listing the same Site

":"You have entered an Invalid Field Value 2550 for the following field: item"

• The Subsidiary listed on the Item does not include the Subsidiary we are setting for the order.

• The Item is Inactive in NetSuite

• The Item does not have an Income account

• The Sales order Form Under the Sublists SubTab has a Search Filtering approved Items that are allowed on the order and that one is not included

• Make sure the Subsidiary listed on the Item does not include the Subsidiary we are setting for the order.

• Make Sure the Item is Inactive in NetSuite

• Make sure the Item does not have an Income account

• Make sure the Sales order Form Under the Sublists SubTab , IF has a Search Filtering approved Items, that the items are allowed on the order

":"You have entered an Invalid Field Value * for the following field: country"

Shopify Address Forms on Front end are not showing and obtaining the Country for Shopify to list the Country and Country Code correctly

Have Shopify Developers to show and obtain this data for Shopify to have this for the addresses.

The Request Payload can be edited and proper Country or Country Code can be listed instead of the * to get the order reprocessed

"code":"USER_ERROR","details":"Please specify a tax code and tax rate for this customer

No Tax Account for the State in Shipping
OR
NetSuite cannot Set the Tax Item on the Order

Under Setup > Accounting > Tax Control Accounts

Make sure there is a Tax account for the State Nexuses,
May need to re-generate with override for Tax groups/codes

“Use State Tax Tables”

Check on Tax Setup per orders to make sure NetSuite can set the Tax Item needed

"code=SSS_MISSING_REQD_ARGUMENT, details=search.lookupFields: Missing a required argument: id"

When Erroring during Customer Sync process of Order, It is Caused by there being more than 1 ID on the Customer.

Check the In8 Shopify Customer Ids record, Remove any with Empty setting and also check customer to remove a duplicates.
Use the EDIT to the Left of the In8 Shopify Customer ID listing to delete, NOT the Remove to the Right of the Listing.

"name":"UNIQUE_CUST_ID_REQD","message":"A customer record with this ID already exists. You must enter a unique customer ID for each record you create. To correct this record

NetSuite Does not Allow Multiple Entity with the Same Customer ID.

When Auto0Generated Numbers for Entity is disabled, the customer IDs are based on First and Last Name.

Enable “Auto-Generated Numbers” and Enabled for Entity.

Details: {\"errors\":{\"inventory_policy\":[\"is not included in the list\"]}}"

The SHOPIFY CONTINUE SELLING NO STOCK Field from the bundle is empty

Mass update the Items needed to Deny or Continue

Price or inventory not Update in Sync

The Item Paremeter possible not showing the Item Form with the field for Location and price mapping

Set the Item form version to show the Location and price mapping on the form

"TRANS_UNBALNCD","message":"Transaction was not in balance

When Website applies taxes but NetSuite is not setup correctly to allow the Tax Total to be overwritten

• When the order has Gift Card redeeming as payment and the amount in the error matching the Amount of the Gift Card Payment; the Payments Sublist under Billing subtab on the Sales Order is hidden.

• Taxes Not Setup correctly for one of the following

  • Nexuses not created

  • Tax Schedules not updated

  • Tax Group/code not generated

  • Nexuses not listed under the Subsidiary

  • Customer is set to non-taxable

  • Items in NetSuite Not Taxable, or their Tax schedule not marking nexus as Taxable

• Shopify Does not have address verification

  • City, State, Zip not correct for NetSuite to find right Code

  • City, State, or Zip is missing from the Shipping address in Shopify order

• Make sure Customer is marked as taxable and customer should NOT have a tax item

  • Customer Mapping for taxable = T (client Specific Setup could vary that we would not)

• Sales order should have a mapping for istaxable = T

• Shipping address in Shopify that is Used to find a Taxable Code/Group must have correct City, State, Zip that NetSuite Uses to correct find the correct Tax Code/Group. May need to Update Payload in this case to Correct.

• Make sure Items are taxable with Tax Schedule (Some clients may be mapping to Set Items non-Taxable per Schedules to shopify item)

  • Possible that the Line item when having a checkbox of tax, that is the items in NS require to stay non-taxable, you can create a "orderitems" parameter and the line level checkbox to istaxable=T

CHECK TAX SETUP:

• Nexus → Create the Nexus for Country and State

• Subsidiary → Nexus listed under Subsidiary Nexuses (Not Needed if you do not have Subsidiaries ONE-WORLD)

• Tax Schedules → Taxable Tax schedule Marked T or taxable tax code for the Country or State

• Tax Codes/Groups Create or generated

  • US → Using Admin Role. Setup > Accounting > Use State Tax Tables

  • Non-US → Tax Codes generate with Nexus

• In the Case of the Gift Card cause, the Payment Sublist under Billing needs shown again for the Field for Gift Card Redemption to be able to be filled is shown.

  Recommended to possibly have Address Verification Tool on Shopify Front end to Make sure City, State, Zip is correct for the Address for NetSuite to Use on Tax Code/Group Matching

{“error”:”{\”errors\”:\”Not Found\”}”,”Shopify Store”:”https://<store>/myshopify.com/”}

When NetSuite item’s Shopify Ids are now invalid Sue to someone deleting the Item in shopify,

Remove the Shopify id from NetSuite item for the Shopify site and sync it again to create it again in Shopify. (should confirm there is no Shopify Item duplicate, that was just re-created in Shopify on accident)

Use the EDIT to the Left of the In8 Shopify Customer ID listing to delete, NOT the Remove to the Right of the Listing.

Error: Product not found. SKU MVBZ111ASXXL

When Syncing Items, Item was created in Shopify and not synced with Shopify from NetSuite

When NOT Syncing Items, the Id Script was not ran to find the NetSuite item to put the needed Shopify Ids on the NetSuite item

Duplicate Ids Possible, the Shopify Ids are listed Twice in the Custom Record List "In8 Shopify Ids".

When Syncing Items, Get the Ids listed to the correct NetSuite Item so the order can find the correct item to put on the order

When NOT Syncing Items, Run the Id Script and then Put the Payload Back to Pending to get processed

Duplicate Ids Possible, Searching the Custom Record List "In8 Shopify Ids" for the Ids can produce the line and find out. Remove the extra line record or the one without an Item listing

{errors: “[API] This action requires merchant approval for write-orders scope.”

Private app doesn't have sufficient permission to update the record.

Update the permission level to Read/Read & Write and try again

Posting and Non-Posting discount/markups are not allowed on the same transaction

Multiple Discount or Markup Item are trying to be applied to order and one or more are conflicting with having an account listed for Posting and the other does not.

All discounts and item should have a Posting Account aligned to let the order work correctly.

Find the Discount item, that is not aligned with an account, create new one to list with account and change the item in In8Sync Setting if needed.

code=INVALID_NUMBER, details=You entered "null" into a field where a numeric value was expected. Please go back and change this value to a number.,

Trying to Add Shipping Cost and the Shipping in NS is not enabled, therefore no Cost field to be set.

Either enable shipping to get shipping cost OR do Shipping as a line item in settings with a Other Charge for Sale type Item.

Invalid shippingtaxcode reference key <Tax Group ID>

Possible the Set Up Taxes does not have set the preferred Tax agencies

PENDING RESOLUTION AND REAL CAUSE

Get the Set Up Taxes completed with Preferred Tax Agencies needed

message: "org.mozilla.javascript.EcmaError: TypeError: Cannot read property "tags" from undefined

Setting in In8 Shopify Settings for “Enabled Return Suitelet” is enabled, but In8Suite and the Return Suitelet is does not exist, trying to get Tags to send back to Shopify Failing for this

Disable the Setting “Enabled Return Suitelet”

Item Fulfillment:

code=USER_ERROR, details=The requested service is unavailable between the selected locations,

The Ship Method on the Sales Order is Real Time Rate and the Fulfillment cannot use that for the Fulfillment location

Change the Ship Method to a Flat Rate version on the Sales Order

Item Fulfillment:

code=USER_ERROR, details=Invalid or missing sold to phone number. Valid length is 1 to 15 alphanumeric.

The Shipping Phone number on the Sales Order is missing or has invalid Characters or too long

Correct the Sales Order Shipping Address Phone

Item Fulfillment:

code=USER_ERROR, details=Invalid or missing sold to attention name. Valid value is 1 to 35 alphanumeric

The ship attention on the Sales Order Shipping address is invalid or too long

Correct the Sales Order Shipping Address Attention field