NetSuite – Magento Product Sync Proposal

PROPOSAL SUMMARY 

The purpose of this proposal is to detail the integration plan between NetSuite and Magento through REST APIs, with a specific focus on synchronizing inventory items from NetSuite to Magento. 

REQUIREMENTS 

Szco Supplies, Inc is seeking to establish a seamless integration between their NetSuite system and Magento ecommerce website. The goal is to achieve a comprehensive synchronization of inventory items, related items, customer groups, images, and other relevant data. The integration will be designed to transfer data from NetSuite to Magento. 

DELIVERABLES 

Netsuite – Magento integration 

  • For implementing the product sync from NetSuite to Magento, we will develop custom functionalities using Magento’s Rest APIs. 
  • The item sync is only unidirectional, which is from Netsuite to Magento (Netsuite-Magento), and only the inventory items in NetSuite will be considered for sync. 
  • In Magento, the item will be created as ‘Simple product’. 
  • The item synchronization will be implemented in real-time, ensuring that whenever a new item is created in NetSuite, a corresponding item will be automatically generated in Magento. Likewise, any updates made to the NetSuite item will be promptly reflected in the corresponding Magento item. 
  • After the successful sync, the magento ID will be stored in a custom field in Netsuite item record. 
  • Item sync includes the following syncs: 

Attribute Sync: 

  • Attribute creation (Real time): For an item there will custom attributes like Featured product, Non-discountable, Item status . The attributes created in NetSuite side will be created at Adobe commerce side in real time.  
  • Attribute update (Real time): Any updates made in synced attribute will be updated in Adobe commerce also 
  • Attribute Deletion (Real time): When an attribute is deleted from NetSuite, it will be deleted from Adobe commerce also. 
  • There will be a custom record maintained for creating, updating and deleting the attributes.   

Item Sync: 

  • Item Creation (real time): The item created on NetSuite will be then mapped to Adobe commerce through a real-time sync. After the successful sync the Adobe commerce ID will be stored in a custom field in NetSuite. 
  • The details such as Item Name/Number, Web store display name, Web store description, Item Status, Promotion price, Base Price, Non- discountable, Magento product category, New Product, Featured Product, and etc will be mapped to magneto.  
  • Item Name/Number in Netsuite is considered as SKU in Magento. 
  • The different price levels associated with item record will also sync to Adobe commerce. The price level sync will be From NetSuite to Adobe commerce (NetSuite-Adobe commerce). 
  • Item Update (real time): Any updates made in NetSuite to the synced items will be reflected in Adobe commerce. The price level can be updated during item edit. 
  • Item Deletion (real time): When an item synced to Adobe commerce is deleted from NetSuite, it will be deleted from Adobe commerce also. 
  • Existing Item Sync (Scheduled): All existing items in NetSuite will be synced to Adobe commerce. This will be a onetime sync. 

Related Item Sync 

  • We will sync the related items linked in an inventory record during the item sync. 
  • Related Item Creation (real time): The related item linked to an inventory item on NetSuite will be then mapped to Adobe commerce through a real-time sync. 
  • Related Item Update (real time): Any updates made in a related item in a synced items will be reflected in Adobe commerce. The price level can be updated during item edit. 
  • Item Deletion (real time): When a related item in an item synced to Adobe commerce is deleted from NetSuite, it will be deleted from Adobe commerce also. 

Product Image Sync 

  • For image sync, we will take the external URL stored in NetSuite item record and map this url to Magento. 
  • We will create custom fields for storing these external URLs for images in netsuite. 
  • We will import the values to these fields, the data for import need to be provided by the szco team. We will share the import template and data need to be filled by szco team.  
  • In Magento, it is possible to display the image from the external server by converting its URL. The image can be seamlessly integrated and displayed within the Magento platform, providing a convenient way to showcase external images without the need for separate hosting or file management.   
  • External image creation (Real time): The external image URL added to an item in NetSuite side will be created at Adobe commerce side in real time.  
  • External image update (Real time): Any updates made in synced external image URL will be updated in Adobe commerce also       
  • External image Deletion (Real time): When an external image URL is deleted from NetSuite, it will be deleted from Adobe commerce also. 

Tier Price Sync 

  • The Netsuite price levels of an item will be synced  synced with Magento. 
  • Tier price creation (Real time): When product price is added in NetSuite side, the same will be added in Magento. 
  • Tier price update (Real time): When product price is updated in NetSuite side, the same update will be reflected in Magento.       
  • Tier price Deletion (Real time): If a product tier price is deleted from NetSuite, the corresponding products tier price in Magento will also be deleted. 

ASSUMPTIONS 

  • The integration is unidirectional only, from NetSuite to Magento. 
  • Only inventory items in NetSuite will be considered for Product Sync, where these items will be created as ‘Simple Product’ in Magento. 
  • We assume that when an inactive inventory item is created in NetSuite, it is synced to Magento with status ‘Disabled’. 
  • Item Name/Number in Netsuite is considered as SKU in Magento. 
  • The currency considered is ‘USD’. 
  • Related item must be synced to Magento initially. Otherwise the item sync will be failed. 
  • We will create custom fields in NetSuite item record to display the sync status. If the sync is successful, it will display a success message. If the sync was a failure, then the fields will display a failure status and the reason for the failure. 
  • For external image sync, we will create custom fields for storing these external URLs for images in netsuite. 
  • We will import the values to these fields, the data for import need to be provided by the szco team. We will share the import template and data need to be filled by szco team. 

Leave a comment

Your email address will not be published. Required fields are marked *