Navigate to Lists > Search > Saved Searches > New Click Item Enter the Title Click Criteria Click Standard Filter: Select Pricing Fields… Pricing Filter: Select Price Level Price Level: Select any of desired Price LevelExample: Base Price Click Set Click Results Click Columns Field: Select Name Summary Type: Select Group Select Pricing Fields… Pricing Fields: Select Price Level Summary Type: Select Group Select Formula (Numeric) Summary Type: Select Maximum Formula: Enter Case when {pricing.pricelevel} = ‘Base Price’ and {pricing.quantityrange} = ‘1-19’ then {pricing.unitprice} else null end… Continue reading Saved Search to Show Quantity-Based Item Pricing
Category: Celigo
NetSuite-Shipbob integration | Instant Case Study
How fast a 3PL can integrate with NetSuite? This is a well-executed integration that syncs NetSuite with Ship Bob through Celigo flow. We transfer NetSuite all types of items, Orders, fulfillment, and so on, which are commonly regarded as 3PL necessities. Road to Celigo Celigo’s integrator.io iPaaS platform empowers both business and IT users to… Continue reading NetSuite-Shipbob integration | Instant Case Study
How to get credentials from BigCommerce account.
Open BigCcommerce account. Click on ‘settings’ and choose ‘API Accounts’ as shown. Click on ‘create API Account’ API path will be displayed .Give name and other required fields and save. Then the API Credentials will be displayed as shown. This credentials are necessary to create connection in Netsuite-BigCommerce integration.
Fix error “Invalid login attempt.”
Scenario: The error “Invalid login attempt.” is encountered in the NetSuite Import step. The error occurred after the NetSuite User with which the NetSuite Connection is created is either inactivated or the access permission is removed. Soultion: Log in to integrator.io account. Go to Next to the NetSuite connection, below the Actions column, click on the three-dot icon.… Continue reading Fix error “Invalid login attempt.”
Sync Orderful purchase order change request (860) to NetSuite sales order
In the Orderful purchase order change request to NetSuite sales order (update) flow, the Get change requests from Orderful purchase order export gets the purchase order change request transactions from Orderful from the polling bucket ID 860. The Update NetSuite sales order import updates the NetSuite SO and Update order status in Orderful import updates the PO status to “Delivered” in Orderful. The… Continue reading Sync Orderful purchase order change request (860) to NetSuite sales order
Change the default status of SO created in NetSuite
When sync Orderful purchase order (850) to NetSuite sales order , by default, the sales order is created in Pending Approval status in NetSuite. You can change the default status of the sales order created in NetSuite by adding the following mapping: Source record field (Orderful) Destination record field (NetSuite) <Add a hard-coded value> Valid values… Continue reading Change the default status of SO created in NetSuite
How to writeback the product id of a product in shopify to a custom field in Netsuite- Response Mapping
This can be done by using response mapping. 1.Create response mapping as shown below. 2.Add New import 3.Perform mapping Then run the flow and refresh the created saved search of items.Then we can see that the product id is updated in the created custom field. To update the product id of kit type item we… Continue reading How to writeback the product id of a product in shopify to a custom field in Netsuite- Response Mapping
Sync NetSuite invoice to Orderful invoice (810)
The NetSuite invoice to Orderful invoice (810) (add) flow syncs the invoice from NetSuite as an invoice to Orderful. This is a scheduled flow that gets the invoices that are created since the last flow run. The individual sales orders must be billed for the NetSuite invoices to be qualified by the export. If a purchase order… Continue reading Sync NetSuite invoice to Orderful invoice (810)
Export Order Cancellations, Refunds from NetSuite to BigCommerce
Export Order Cancellations from NetSuite to BigCommerce This flow exports the canceled order from NetSuite into BigCommerce. Once an order is marked as canceled or closed in NetSuite and you run this flow, the status of the same orders in BigCommerce is updated as canceled by the Integration App. Export Refunds from NetSuite to BigCommerce… Continue reading Export Order Cancellations, Refunds from NetSuite to BigCommerce
Export Fulfilments, Billing Information from NetSuite to BigCommerce
Export Fulfillments from NetSuite to BigCommerce The Fulfillment Export flow exports shipping and fulfillment data from NetSuite to BigCommerce on a scheduled basis. The Integration App supports complete and partial shipments and exports all tracking number data regardless of the shipping carrier you use (USPS, UPS, FedEx, etc.). BigCommerce Order status is not changed to… Continue reading Export Fulfilments, Billing Information from NetSuite to BigCommerce