Retries / Errors
Open Celigo Shopify Orders to NetSuite Sales orders Flow
(https://integrator.io/integrations/5f400afa2aeb686432f1e12c/flowBuilder/5f400afe2aeb686432f1e19e)
Hover over the ERRORS number in red, then click VIEW.
Cannot Find Customer ID
If a customer on an order is tagged with NSID-XXXXX, the flow will skip searching NetSuite and just assume that is the correct ID number for internal NetSuite. Typically if the user has been deactivated or deleted, the flow will fail.
- Lookup the customer ID (in screenshot 15270) in Netsuite and see if that customer record exists
- Most Common Issues:
- Customer INACTIVE - Edit customer on Netsuite to remove the inactive checkbox
- Customer ID has been deleted - find new updated ID or delete NSID in code (See code below for help) - Click the Retry Data Icon on the line you need to edit to update the code sent to NS.
- Close the Error View
- Click the 3 dots under actions on the failed run line and hit Retry All
- Let the flow re-run
Order Retry Data Example
Line 328 - customer tags, remove the , NSID-XXXXX number from the data if you want the customer to generate a new record in NS
Line 328 - customer tags, change NSID-1234 to NSID-4321 if the customer ID has changed. This must be the NUMERIC NS ID, not the one that starts with a C. You can grab this number from the NetSuite URL.
{
"id": 3033472073882,
"email": "[email protected]",
"closed_at": null,
"created_at": "2021-02-10T20:53:12-05:00",
"updated_at": "2021-02-10T20:53:27-05:00",
"number": 1617,
"note": null,
"token": "ce4c98a318e2238839a35fcd0c85a96d",
"gateway": "firstdata_e4",
"test": false,
"total_price": "43.56",
"subtotal_price": "33.84",
"total_weight": 190,
"total_tax": "2.54",
"taxes_included": false,
"currency": "USD",
"financial_status": "authorized",
"confirmed": true,
"total_discounts": "0.00",
"total_line_items_price": "33.84",
"cart_token": "85b55ab6f97d23ad78964f1640286557",
"buyer_accepts_marketing": false,
"name": "#2617",
"referring_site": "https://www.google.com/",
"landing_site": "/?gclid=EAIaIQobChMIyZy9-djg7gIVgqGGCh2U6wxnEAAYASAAEgKJEvD_BwE",
"cancelled_at": null,
"cancel_reason": null,
"total_price_usd": "43.56",
"checkout_token": "f39981e80a19343edda14733173b8f04",
"reference": null,
"user_id": null,
"location_id": null,
"source_identifier": null,
"source_url": null,
"processed_at": "2021-02-10T20:53:11-05:00",
"device_id": null,
"phone": null,
"customer_locale": "en",
"app_id": 580111,
"browser_ip": "1.2.3.4",
"client_details": {
"accept_language": "en-US,en;q=0.9",
"browser_height": 647,
"browser_ip": "98.249.224.231",
"browser_width": 996,
"session_hash": null,
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36"
},
"landing_site_ref": null,
"order_number": 2617,
"discount_applications": [],
"discount_codes": [],
"note_attributes": [],
"payment_details": {
"credit_card_bin": "XXXXXXXX",
"avs_result_code": "Y",
"cvv_result_code": "M",
"credit_card_number": "XXXXXXXX",
"credit_card_company": "Visa"
},
"payment_gateway_names": [
"firstdata_e4"
],
"processing_method": "direct",
"checkout_id": 16205887897754,
"source_name": "web",
"fulfillment_status": null,
"tax_lines": [
{
"price": "2.54",
"rate": 0.075,
"title": "State Tax",
"price_set": {
"shop_money": {
"amount": "2.54",
"currency_code": "USD"
},
"presentment_money": {
"amount": "2.54",
"currency_code": "USD"
}
}
}
],
"tags": "ready-for-netsuite",
"contact_email": "[email protected]",
"order_status_url": "https://gemlux.com/41655599258/orders/ce4c98a318e2238839a35fcd0c85a96d/authenticate?key=437f0cdbde11246b9be0e6d4477a352b",
"presentment_currency": "USD",
"total_line_items_price_set": {
"shop_money": {
"amount": "33.84",
"currency_code": "USD"
},
"presentment_money": {
"amount": "33.84",
"currency_code": "USD"
}
},
"total_discounts_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"total_shipping_price_set": {
"shop_money": {
"amount": "7.18",
"currency_code": "USD"
},
"presentment_money": {
"amount": "7.18",
"currency_code": "USD"
}
},
"subtotal_price_set": {
"shop_money": {
"amount": "33.84",
"currency_code": "USD"
},
"presentment_money": {
"amount": "33.84",
"currency_code": "USD"
}
},
"total_price_set": {
"shop_money": {
"amount": "43.56",
"currency_code": "USD"
},
"presentment_money": {
"amount": "43.56",
"currency_code": "USD"
}
},
"total_tax_set": {
"shop_money": {
"amount": "2.54",
"currency_code": "USD"
},
"presentment_money": {
"amount": "2.54",
"currency_code": "USD"
}
},
"line_items": [
{
"id": 6499843834010,
"variant_id": 36698947092634,
"title": "Hinge 2-3/4\"x1-1/2\" FM",
"quantity": 6,
"sku": "2190",
"variant_title": "",
"vendor": "Gemlux",
"fulfillment_service": "manual",
"product_id": 5786742423706,
"requires_shipping": true,
"taxable": true,
"gift_card": false,
"name": "Hinge 2-3/4\"x1-1/2\" FM",
"variant_inventory_management": "shopify",
"properties": [],
"product_exists": true,
"fulfillable_quantity": 6,
"grams": 32,
"price": "5.64",
"total_discount": "0.00",
"fulfillment_status": null,
"price_set": {
"shop_money": {
"amount": "5.64",
"currency_code": "USD"
},
"presentment_money": {
"amount": "5.64",
"currency_code": "USD"
}
},
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"discount_allocations": [],
"duties": [],
"admin_graphql_api_id": "gid://shopify/LineItem/6499843834010",
"tax_lines": [
{
"title": "State Tax",
"price": "2.54",
"rate": 0.075,
"price_set": {
"shop_money": {
"amount": "2.54",
"currency_code": "USD"
},
"presentment_money": {
"amount": "2.54",
"currency_code": "USD"
}
}
}
],
"origin_location": {
"id": 2309793710234,
"country_code": "US",
"province_code": "FL",
"name": "Gemlux",
"address1": "12770 Flagler Center Blvd",
"address2": "",
"city": "Jacksonville",
"zip": "32258"
},
"destination_location": {
"id": 2696551923866,
"country_code": "US",
"province_code": "FL",
"name": "XXXXXXXX",
"address1": "XXXXXXX",
"address2": "",
"city": "XXXXXX",
"zip": "XXXXX"
}
}
],
"fulfillments": [],
"refunds": [],
"total_tip_received": "0.0",
"original_total_duties_set": null,
"current_total_duties_set": null,
"admin_graphql_api_id": "gid://shopify/Order/3033472073882",
"shipping_lines": [
{
"id": 2516656095386,
"title": "First Class",
"price": "7.18",
"code": "9136",
"source": "GEMLUX PACEJET",
"phone": null,
"requested_fulfillment_service_id": null,
"delivery_category": null,
"carrier_identifier": "0e44981e8557b29c3126f7ec75d59ab4",
"discounted_price": "7.18",
"price_set": {
"shop_money": {
"amount": "7.18",
"currency_code": "USD"
},
"presentment_money": {
"amount": "7.18",
"currency_code": "USD"
}
},
"discounted_price_set": {
"shop_money": {
"amount": "7.18",
"currency_code": "USD"
},
"presentment_money": {
"amount": "7.18",
"currency_code": "USD"
}
},
"discount_allocations": [],
"tax_lines": []
}
],
"billing_address": {
"first_name": "Ron",
"address1": "XXXXXXXX",
"phone": "XXXXXXXX",
"city": "XXXXXXXX",
"zip": "XXXXXXXX",
"province": "XXXXXXXX",
"country": "United States",
"last_name": "XXXXXXXX",
"address2": "",
"company": null,
"latitude": XXXXXXXX,
"longitude": XXXXXXXX,
"name": "XXXXXXXX",
"country_code": "US",
"province_code": "FL"
},
"shipping_address": {
"first_name": "Ron",
"address1": "XXXXXXXX",
"phone": "XXXXXXXX",
"city": "XXXXXXXX",
"zip": "XXXXXXXX",
"province": "Florida",
"country": "United States",
"last_name": "XXXXXXXX",
"address2": "",
"company": null,
"latitude": XXXXXXXX,
"longitude": XXXXXXXX,
"name": "XXXXXXXX",
"country_code": "US",
"province_code": "FL"
},
"customer": {
"id": 4249478594714,
"email": "[email protected]",
"accepts_marketing": false,
"created_at": "2020-11-01T20:18:14-05:00",
"updated_at": "2021-02-10T20:53:12-05:00",
"first_name": "Ron",
"last_name": "XXXXXXXX",
"orders_count": 1,
"state": "invited",
"total_spent": "43.56",
"last_order_id": 3033472073882,
"note": null,
"verified_email": true,
"multipass_identifier": null,
"tax_exempt": false,
"phone": null,
"tags": "GEM Customer Center (Prepaid), NSID-15270, R2 - Online Price, REP:Jerry Gutzke",
"last_order_name": "#2617",
"currency": "USD",
"accepts_marketing_updated_at": "2020-11-01T20:18:14-05:00",
"marketing_opt_in_level": null,
"tax_exemptions": [],
"admin_graphql_api_id": "gid://shopify/Customer/4249478594714",
"default_address": {
"id": 5272672403610,
"customer_id": 4249478594714,
"first_name": "Ron",
"last_name": "XXXXXXXX",
"company": null,
"address1": "XXXXXXXX",
"address2": "",
"city": "XXXXXXXX",
"province": "Florida",
"country": "United States",
"zip": "XXXXXXXX",
"phone": "XXXXXXXX",
"name": "XXXXXXXX",
"province_code": "FL",
"country_code": "US",
"country_name": "United States",
"default": true
}
}
}