This proposal covers the details of Maze – stock feed integration. This proposal also covers the engagement scope of Jobin and Jismi It Services LLP, as official implementation partner Of Oracle NetSuite.
Proposal summary
This proposal details how the integration between Maze-Stock Feed is handled and also the proposed plan of the integration.
Requirement
The requirement is to handle Maze – Stock feed integration. The integration will be done using the SFTP since Maze file transfer will be done through the SFTP server. A CSV file need to be created for the Drop Ship orders in NetSuite. This will be sent to SFTP and will be processed by Maze. The stock List will be added by maze to SFTP and that need to be imported to NetSuite.
Our Solution
There will be 2 scenarios for the file transfer between NetSuite and Maze Warehouse software systems. Following are the two scenarios:
- Export the files into an SFTP server to the predefined location
When a drop ship purchase order is created in NetSuite for Maze warehouse, a CSV file need to be created for the order as per the given template. A user Event script needs to be developed for the process. This CSV file will be stored in the file cabinet in the folder “Netsuite-Maze Dropship Orders”. So the order details will be posted to SFTP in the real time creation of dropship PO.
CSV File Template for drop ship orders:
The script will send the CSV file to the SFTP server to the location: : \Order Waiting to Import The CSV file should be in the correct format and format is already shared. The file will be fetched by the Maze Warehouse software system from the SFTP.
SFTP Access Settings:
* Sever Address/Host Address: ******
* SFTP Port: ******
* USERNAME: ******
* PASSWORD: *******
* SFTP Private Key: Leave Empty
* FTP File Path :
1) Inventory File: \Stock Feed\Stock List Export 2022 with RRP.csv
2) where to drop CSV order files: \Order Waiting to Import
- Import stock feed file from SFTP server to the predefined location in NetSuite.
Maze ware house software system will post stock feed file “Stock List Export 2022 with RRP.csv” to the SFTP server in location: \Stock Feed\Stock List Export 2022 with RRP.csv.
CSV template for Stock list:
The data in the file will overwrite itself every hour. A map-reduce script needs to be developed for fetching the file from the SFTP server every hour and will be stored in the folder ‘Stock Feed From Maze’ in file cabinet in NetSuite.
Assumptions
Proposal is prepared based on following assumptions:
- All the CSV files must be formatted as per the template shared.
- Map-reduce script can be scheduled to run every hour to fetch the stock feed from SFTP to Netsuite.
- Files sent and received will be stored in respective folders in File cabinet.
- SFTP Access Settings:
* Sever Address/Host Address: ******
* SFTP Port: ******
* USERNAME: ******
* PASSWORD: *******
* SFTP Private Key: Leave Empty
* FTP File Path :
1) Inventory File: \Stock Feed\Stock List Export 2022 with RRP.csv
2) where to drop CSV order files: \Order Waiting to Import
Risks
- SFTP server doesn’t have IP Whitelisting , so the script can establish the SFTP connection. If the SFTP server has IP Whitelisting, the proposal is not applicable.
Time
| Description | Time |
| Analysis | 2h |
| Exporting CSV file from NetSuite to SFTP | 7h |
| Importing CSV file from SFTP to NetSuite | 6h |
| Production Deployment & Testing | 4h |
| Documentation | 1h |
Total 20h