Proposal Summary
This proposal summarizes the functionality for creating sales order scv files and uploading them to an external SFTP server
Requirement
Create a daily CSV (Flat) File to push approved sales orders to an external SFTP site where an integration partner (MNP) will pick the file up and process it into their system. Retail orders are excluded from the creation of csv files.
Deliverables
• We will develop a map reduce script for creating csv files of sales orders
• We will schedule the script to run daily once, so that the script will push the sales order csv files to SFTP server in a daily basis
• We will create a connection with the SFTP server by using the script
• We will use a saved search to get the sales orders from NetSuite
• We will consider the sales orders that are wholesale and approved regardless of if they had sent before
• The following NetSuite fields will be mapped in the csv file
| BODY FIELDS | ITEM LINE FIELDS |
| External ID | Item |
| Date | Quantity |
| Customer | Rate |
| Memo | Original price |
| External document number | Discount Amount |
| Territories | Discount Code |
| Channel | |
| Location | |
| Discount code | |
| Discount amount | |
| Shipping Method | |
| Shipping cost | |
| Address Label | |
| Address Country | |
| Address Addressee | |
| Address Phone | |
| Address 1 | |
| Address 2 | |
| City | |
| State | |
| ZIP |
Assumptions
• MNP will provide the format of the CSV file that they expect.
• MNP will provide the details of the SFTP site where the file needs to be dropped, as well as the authentication details
• The file will be created and pushed once a day.
• MNP needs to provide the criteria of what sales orders are to be sent. For now we are assuming that it is all wholesale, approved sales orders, regardless of if they have been sent before.
Questions
• Could you please confirm that sales orders in which statuses will be considered for creating the CSV files?