Issue Overview: After Shopify released the Fulfillment Orders API update (v2025-07), users noticed delays or missing fulfillments syncing from Shopify to NetSuite through Celigo. Orders that previously synced instantly now appear to wait for hours, or only partially sync. This happens mainly for merchants using: Multi-location Shopify fulfillment 3PL or app-based fulfillment services Auto-location assignment… Continue reading Resolving Shopify Fulfillment Sync Delays Caused by New Fulfillment Orders API Changes (v2025-07)
Month: November 2025
Creating an online customer form
If you enable both the CRM and Sales Force Automation features, you can create online forms based on the NetSuite default template. You can also use your own HTML template for your forms. HTML templates let you customize your online forms to match your website’s look. To create an online customer form: Go to Setup… Continue reading Creating an online customer form
Scripted Records Transformation in NetSuite
Scripted Records Transformation in NetSuite is achieved through SuiteScript 2.x APIs, specifically the record.transform() method. This function allows developers to programmatically convert one record type into another while preserving relationships between fields. For example, you can transform a Sales Order into an Invoice or a Quote into a Sales Order. The transformation process automatically maps… Continue reading Scripted Records Transformation in NetSuite
Shopify Tax Lines Not Imported After Shopify Enabled “Pinned Prices”
Issue Overview After Shopify rolled out the “Pinned Prices” feature (2025 update), many merchants noticed that tax lines stopped importing into NetSuite when orders synced through Celigo. Even though the order in Shopify shows correct tax details, the tax fields arrive empty or incorrect in NetSuite. Root Cause When “Pinned Prices” is enabled, Shopify sends… Continue reading Shopify Tax Lines Not Imported After Shopify Enabled “Pinned Prices”
How to sort the item lines based on any specific column in the advance PDF template?
In Advanced PDF/HTML templates, item lines normally appear in the same order as they do in the item sublist. However, by using FreeMarker, we have the option to sort the item lines based on any specific column from the sublist. Sample code: This sorts the item lines based on the location. <#list record.item?sort_by(“location”) as item>… Continue reading How to sort the item lines based on any specific column in the advance PDF template?
Exclude a Field from Saved Search Detailed Results
In certain scenarios, it is necessary to display a field’s summary (such as Group, Count, Sum, Minimum, Maximum, or Average) in a saved search while ensuring that the detailed drill-down view does not reveal the underlying data. This approach is commonly used for confidential information, such as payroll amounts or sensitive journal entries, where only… Continue reading Exclude a Field from Saved Search Detailed Results
Store Form with Record for item and Entity records
When working with item and entity records, NetSuite automatically switches the record to the preferred form, even if you initially create it using another form. However, if you need the record to retain a specific non-preferred form, you can use the “Store Form with Record” checkbox available on the form. When this box is checked… Continue reading Store Form with Record for item and Entity records
NetSuite’s Multi-Subsidiary Architecture: Beyond Consolidation to Strategic Business Segmentation
While NetSuite’s multi-subsidiary functionality is commonly understood as a consolidation tool for financial reporting across multiple legal entities, its strategic potential extends far beyond basic accounting requirements. Organizations can leverage this architecture to create distinct operational segments within a single legal entity, enabling differentiated pricing strategies, separate inventory management, and autonomous workflow processes for different… Continue reading NetSuite’s Multi-Subsidiary Architecture: Beyond Consolidation to Strategic Business Segmentation
Old Shopify Orders Being Re-Imported Due to New Shopify Webhook Retry Logic
What It Is: Shopify introduced an updated Webhook Retry Logic that retries delivery of failed or delayed webhooks for up to 72 hours. Because of this change, older order webhooks may be sent again if Shopify considers a previous attempt as “not acknowledged.” This can cause: Duplicate order imports in the Shopify → NetSuite Order… Continue reading Old Shopify Orders Being Re-Imported Due to New Shopify Webhook Retry Logic