*1. Overview* Netsuite is a cloud business software suite, which includes business accounting, ERP and CRM.
*2. Benefits of Netsuite* • It is a fully fledged CRM, ERP and accounting system. • Provides visibility of information across all areas. • Efficiency across daily operations such as order management, fulfillment and invoicing. • Facilitates in accommodating value-added solutions by integrating external applications. *3. Netsuite Business Scenario* <http://wso2-oxygen-tank.10903.n7.nabble.com/file/n128085/netsuite_main.png> *3.1 Marketing * <http://wso2-oxygen-tank.10903.n7.nabble.com/file/n128085/marketing.png> Pre-requisite: A custom field should be created to indicate if a particular product requires eMarketing or not. • Retrieve products from the Netsuite API which are tagged as ‘eMarketing’ and create those products in the Shopify API. • Retrieve fulfilled orders from the Shopify API and create them as sales orders in the Netsuite API. Also create the customer in the Netsuite API if they do not exist. Advantages of integrating with Shopify API: • Shopify is a complete e-commerce solution that allows to set up an online store with a variety of products and variants to sell. *3.2 Case Management* <http://wso2-oxygen-tank.10903.n7.nabble.com/file/n128085/casemanagment.png> • Retrieve tickets which are tagged as a ‘Ticket/Incident’ from the LiveChat API and create them as cases in Netsuite API. Note: The case solution, time tracking and etc will be handled within Netsuite. • Retrieve flagged submissions from the Jotform API and create them as cases in the Netsuite API. • While creating the cases in Netsuite, create the company (type) as a customer if they do not exist. • Retrieve solution (s) of closed cases on a daily basis from the Netsuite API and notify the client/customer via the Mandrill API. Advantages of integrating with Livechat API: • A fast way for clients to communicate directly with clients and report any incident. Advantages of integrating with Jotform API: • Jotform is an online platform that enables you to create and design custom forms. *3.3 Notification Handling* <http://wso2-oxygen-tank.10903.n7.nabble.com/file/n128085/notification.png> • Retrieve cases from the Netsuite API on a daily basis and check for its due date, if its tomorrow then notify the assignee via an SMS through the Nexmo API. • Retrieve work orders from the Netsuite API periodically and check for the promise date, if it’s due in a period of one week’s time, then notify the person in-charge of inspection for quality control by an email via the Mandrill API. Advantages of integrating with Nexmo API: • Nexmo API can be used for communication, which facilitates SMSs and Calls. Advantages of integrating with Madrill API: • Mandrill is an email infrastructure service, which also facilitates marketing. *3.4 Report Handling* <http://wso2-oxygen-tank.10903.n7.nabble.com/file/n128085/reports.jpg> Sales by item report: • Retrieve required sales order details of past month. • Process sales orders to find total sales per item • Send item name and total sales of items to PowerBI Sales by customer summary report: • Retrieve required sales order details of past month. • Process sales orders to find total sales per customer • Send customer and total sales of customer to PowerBI Sales by sales representative report: • Retrieve required sales order details of past month. • Process sales orders to find total sales per sales representative • Send sales representative name and total sales of sales representative to PowerBI Sales revenue report: • Retrieve invoices list of invoices per month. • Process invoices and calculate profit from each customer • Send customer, profit amount to PowerBI Prerequisites: Configurations to display sales by item and sales by sales representative should already available in PowerBI API. Advantages of integrating with PowerBI: • PowerBI is a business intelligent tool, which helps to visualize your data as a whole and provide better understanding of your data. It also helps to access data from anywhere. Thank you, Sajitha -- View this message in context: http://wso2-oxygen-tank.10903.n7.nabble.com/Proposed-ESB-connector-scenario-Integrate-NetSuite-with-Shopify-LiveChat-JotForm-Mandrill-Nexmo-and-I-tp128085.html Sent from the WSO2 Architecture mailing list archive at Nabble.com. _______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
