Magento Netsuite Integration – knowledgebase JJ

State code to update the customer address from API

Here we are mentioning to set the state code from the country code and state id from the Netsuite API. We are getting the state and country through the response/params from the API

Proposal for Magento to NetSuite API Integration

Proposal SummaryThis proposal covers the scope of Magento to NetSuite Integration. RequirementAffinity Tool would like to sync integrate the Magento websites with NetSuite such that the data fromboth applications are synced. Both the websites of Affinity Tool and Bora tool need to be synced withNetSuite. DeliverablesThe Magento – NetSuite integration can be achieved via the… Continue reading Proposal for Magento to NetSuite API Integration

Billing sync (NetSuite-Magento)

The Billing flow “NetSuite Billing to Magento Invoice Add” data flow exports Invoices from NetSuite to Magento. The data flow exports fully/partially billed orders in NetSuite as invoices in Magento. STEPS 1.Generate cash sale from Item Fulfillment in NetSuite. 2.Restrict the saved search criteria with ‘eTail Order Billing exported’ 3. Perform mapping in the flow… Continue reading Billing sync (NetSuite-Magento)

How to update the Related Products in Magento using NetSuite-Magento Integration

To update the related products field in Magento using a custom flow ‘NetSuite Related Item to Magento Linked Product’, need to add a new import step in the flow. STEPS 1.Create a new import 2.In the new import step, add the API Name, Operation, SKU as it is for updation. 3.Then the mapping is performed… Continue reading How to update the Related Products in Magento using NetSuite-Magento Integration

How to fetch multiple Item Records in a custom flow for syncing related items.

To fetch multiple item records in a custom flow which is created to sync related items of an item record in NetSuite as Linked Product in Magento, we can use handlebar expression in the import steps as shown below. In this way we can fetch multiple item records in the flow.

Custom flow to sync related items from NetSuite as Magento related Products.

STEPS 1.Create Export Connection 2.Create Source (NetSuite) 3.Create connection for Magento. 4.Create import for Magento and give all required information such as API Name, Operation, SKU etc. 5.Perform Mapping 6.Then on running the flow we can see that the related item from the item record in NetSuite is successfully synced to Magento as Related Product.

Error in “NetSuite fulfillment to Magento Shipment Add” flow

While running the ‘NetSuite fulfillment to Magento Shipment Add’ flow an error is raised as shown below: “Could not find value for static lookup: shipmethodLookup {Lookup Key: Shiphawk Shipping} {Extractor Field: [Shipping Method]}” Solution: To resolve this flow perform lookup mapping for shipping method as shown. Then we can run the flow successfully.

Sync Inventory from NetSuite to a specific Source in Magento

To sync inventory from NetSuite to a specific source in Magento , we need to update the settings tab in Celigo as shown below. STEPS 1.Log in to Celigo. 2.Navigate to Settings > General > Multi Source Inventory > Map NetSuite locations to Magento 2 Sources 3.To sync inventory from NetSuite location “Main Warehouse” to… Continue reading Sync Inventory from NetSuite to a specific Source in Magento

Sync Inventory from a specific location in NetSuite to Magento

To sync inventory from a specific location in NetSuite to Magento , we need to update the settings tab in Celigo as shown below. STEPS 1.Log in to Celigo. 2.Navigate to Settings > Inventory 3.If the customer wants to get the quantity from specific locations, then choose the locations in the field “NetSuite locations to… Continue reading Sync Inventory from a specific location in NetSuite to Magento

Enable/Disable a product in Magento using Celigo Integration.

A product in Magento Catalog can be enabled or disabled using “NetSuite Item to Magento Product” Add/Update flow. To enable a product in Magento, set the mapping field of Celigo as shown. Then on running the flow and checking the product in Magento we can see that the product is enabled. To disable the product… Continue reading Enable/Disable a product in Magento using Celigo Integration.