Points to be Noted for NetSuite- Shopify Integration

• Field mapping should be defined in the initial stage of development

• Integration will be active for new records created in NetSuite or updates happen in NetSuite. The migration of existing/historical data will be out of the scope of this development

• We assume that the data will be imported in the Shopify and NetSuite already if there is any historical data migration required 

• It is possible to have a real-time integration from NetSuite to Shopify for most cases, but the integration from Shopify to NetSuite side will be a scheduled one 

• All the sales orders will be created as status “Pending fulfilment” in NetSuite 

• If there is a customer with the given details in the NetSuite but it is inactive, a new customer will not be created before creating the sales order.

• We will not consider tracking details for item fulfilment records from Shopify to NetSuite and NetSuite to Shopify.

• Applicable only to inventory, Matrix item in NetSuite. Not applicable to special order, drop ship, kit, service, item group, other charges items

• Not applicable for a lot or serialized items

• Expired or damaged items stock quantity should be updated accurately in the NetSuite as we will be considering Items in good condition.

• No tax details will be considered while creating the sales order. The tax details should be automatically sourced by NetSuite, and we won’t override any Tax information.

• The deletion of the cash refund, credit memo and customer deposit will not be considered.

• Shipping methods are not considered in order sync since no methods are available in the Shopify.

• Payment types will be predefined in Shopify website and the corresponding payment methods and their accounts will be already set up in both systems

• Phone field format will not be considered and in NetSuite, the phone field value should have at least five digits and we expect a minimum of five digits in the phone field value entered in the Shopify website .

• There are limits for the fields like a city with a maximum word length of 50 characters in NetSuite and this will be limited while sending data from NetSuite to Shopify website 

• Class or department classifications in transactions are out of the scope of this development

• We assume that while receiving items of the purchase order or transfer order, the receiving quantity will not be more than the quantity specified in the purchase or transfer order

• We assume that while fulfilling a sales order, the fulfilled quantity will be always less than or equal to the quantity in the sales order.

• No more additional line items can be received or fulfilled in Shopify or NetSuite system while receiving a purchase order or fulfilling a sales order 

• Sending any emails from the script are out of the scope of this development. For example, if the send email to customers after fulfillment feature is enabled in the NetSuite account, the emails will be sent from NetSuite.

• We assume that the item fulfillments will be created based on the committed quantities in NetSuite

• Warehouse locations will not include any bin management 

• Single master data can only be sent at a time

• We are not considering the exchange rate of transactions in NetSuite

• We are not considering the unit of measure specified in any records

• We will not be considering multiple currencies and assume that there is only one base currency

• Date format of the data sent to Shopify API Should be UTC format and the date format in NetSuite will be followed according to the global preference set up in the account

• Intercompany transactions are out of the scope of this development

• If there is an approval (standard approval) in NetSuite, only the approved transactions will be sent to Shopify website 

• Inbound shipment records are out of the scope of this development

• The performance of the integrations has dependence on the number of processors in the account. The scheduled actions will be processed based on the processing queues. So even if the script can be execute as scheduled, it may get even more delay if there is no available queue to process. So please let us know the processor’s availability in the account. Or we can check the same once the account is available 

• Automatic application of customer deposit to invoice with fulfilled orders will take place in NetSuite 

• The integration will consider only one Shopify integration instance and one location in the Shopify

• Price levels in customer records in NetSuite are not reflected in the Shopify and price list for items are not considered

Leave a comment

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