The Item images in NetSuite are synced to Shopify along with the product details using the NetSuite Item to Shopify Product Add/Update flow. By default, only one image which is selected in the field ITEM IMAGE ({custitem_atlas_item_image}) is only synced to Shopify. If we need to sync images in another field , add the new… Continue reading Sync more than one Item image to Shopify
Author: Aishwarya M J
Sync NetSuite customer refund created against the customer deposit to Shopify
When you sync a paid order as a sales order with a customer deposit, and if there is a refund request even before the order is fulfilled, a refund adjustment is required instead of item restock. In this scenario, the fulfillment and invoice records are not created in NetSuite and a customer refund is created… Continue reading Sync NetSuite customer refund created against the customer deposit to Shopify
Sales Order status set to Closed upon creation
Usually, a Sales Order can be closed manually in the following ways: Click on the CLOSE button visible in the Sales Order Mark the CLOSED checkbox true in all the item lines. Besides the above mentioned a Sales Order get closed automatically when all the Item Quantities are set as 0. The Sales Order status… Continue reading Sales Order status set to Closed upon creation
Composite Method in HTTP import
Composite method imports records depending on the existence or absence of records in the destination application. Composite requests require you to define how to create new records, identify existing records, and update existing records. Different options available in Composite method are: Create new records & update existing records: dynamically create new records or update existing… Continue reading Composite Method in HTTP import
Convert date to format YYYYMMDD
The below function can be used to convert a date value to format YYYYMMDD. function (inputDate) { // convert to YYYYMMDD var date = new Date(inputDate); var d = date.getDate(); var m = date.getMonth() + 1; var y = date.getFullYear() var dateString = (y+(m <= 9 ? ‘0’ + m : m)+(d <= 9 ?… Continue reading Convert date to format YYYYMMDD
Upgrade Integration App Edition
The editions available for pre-built Shopify-NetSuite Integration App are: Starter Standard Premium The set of flows available in each edition are different. In order to upgrade from starter to standard or premium edition of the integration app, you can click the “Request Upgrade” option available under the Subscription section on the Integration App settings page.… Continue reading Upgrade Integration App Edition
Send XML files to SFTP server
This script summarizes on creating XML files for Purchase Orders and save to an SFTP server. A saved search is used to find the Purchase Orders to be send. The passGUID and hostkey mentioned in the below code should be generated using the SFTP helper tools suitelet.
Manually Sync Amazon settlement report to NetSuite
There are chances that the Settlement report got missed to be processed by the Celigo flow. Then we have to upload the settlement report manually and run the flow which will create the settlement transactions in NetSuite. Login into the Amazon seller central account and download the settlement report in Flat file v2 format. In… Continue reading Manually Sync Amazon settlement report to NetSuite
Shipping Items for multiple subsidiaries
In NetSuite One World it is not possible to associate a shipping item with more than one subsidiary. The suggested solution is you can create multiple shipping items for the same shipping service. You can then use the shipping services across multiple subsidiaries. The shipping services respect currencies and post to the appropriate subsidiary accounts.… Continue reading Shipping Items for multiple subsidiaries
Resolve error: “Please enter a value for Tax Code”
The error “Please enter a value for Tax Code” is encountered when entering the Item lines in a transaction. The error is caused due to Tax code is auto populated in the Item lines. This can be resolved by enabling a tax preference as follows: Setup > Accounting > setup taxes >select corresponding subsidiary >… Continue reading Resolve error: “Please enter a value for Tax Code”