Get Inventory item id from Shopify used in the Celigo flow NetSuite inventory to Shopify inventory.

Inventory item is a combination of a variant and a location.   If you want to find quicky an inventory_item_id without using API, you can check that url (variant edit url + .json)   /admin/products/[ID_PRODUCT]/variants/[ID_VARIANT].json   the result can be: { variant: { id: XXXX, product_id: XXXX, title: “Small”, price: “50.00”, sku: “”, position: 1,… Continue reading Get Inventory item id from Shopify used in the Celigo flow NetSuite inventory to Shopify inventory.

Check integrator.io status

You can easily check system status at any time on the status.celigo.com website. If there are no reported service disruptions, yet you are experiencing problems with multiple flows processing as usual, please determine which of the following applies. All problematic flows use connections to the same application If all flows that are not processing as… Continue reading Check integrator.io status

Handlebar – Add function

Adds all numeric values (integers, floats, or decimals). Parameters can either be a field that returns a number value or a hard-coded number value. {{add number1 number2 ….}} number1: Numeric field or hard-coded integer, float, or decimal. number2: Numeric field or hard-coded integer, float, or decimal. Examples: Template: {{add “2” “5” “2”}} output: 9 Template:… Continue reading Handlebar – Add function

Display Line Number for the Item Sublist on Transaction Records

Scenario The Item Sublist on the transaction records do not show the line numbers by default. To track the line number, create a Custom Transaction Line field to display its value. Solution   Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields > New Label: Enter Field Name Example: Item Numbering Type: Select Free-form Text Store Value: Remove Checkmark Click Applies to  Preferred… Continue reading Display Line Number for the Item Sublist on Transaction Records

Convert Date format in Mapping

Scenario: The date created value obtained form saved search is like 30 MAY, 2024 3:52:10 PM. However the value is being set to a system where the required date format is 30-05-2024. Solution: Apply the dateFormat handlebars in the mapping as follows to convert the format: {{dateFormat o/pformat date i/pformat timezone}} Here the o/p format… Continue reading Convert Date format in Mapping

Fields missing in the NetSuite real time listener

Scenario: Few fields are missing in the real time export of NetSuite record. Solution: Edit the NetSuite listener. Check the field “Reload record before export”. When a record is saved in NetSuite there are certain fields that are not available until after the save completes, and the only way to export those fields in real-time… Continue reading Fields missing in the NetSuite real time listener

The ‘To Be Emailed’ Field Blanks Out After Saving Sales Order

Scenario When the Sales Order is created To Be Emailed checkbox is marked, however upon saving the To Be Emailed checkbox is unmarked. Solution This is the default NetSuite behavior. The reason why this happens is because the email has already been sent out. If you would like to send another email or make modifications… Continue reading The ‘To Be Emailed’ Field Blanks Out After Saving Sales Order

Proposal For New Quote PDF Template

Proposal Summary  This proposal covers the scope of creating a new advanced PDF template for Quote. Requirement  All Craft would like to create a new advanced PDF template for their Quote. This Quote template would also allow the customer to accept the Quote.   Deliverables    A new Advanced PDF Template will be developed exclusively for… Continue reading Proposal For New Quote PDF Template