WeDid: CSV Upload to SmartTurn
Challenges
The current business process is manual, involving re-keying of data and the opportunity to make mistakes in the process. Daily sales orders need to be automatically entered to the Customer’s warehousing system, SmartTurn. The customer can generate a CSV file containing the orders but needed an integration solution to updating their warehouse system automatically.
Solution:
Purpose | Develop an automatic integration to create sales orders in SmartTurn from the transactions contained in the CSV files. |
Applications | SmartTurn |
Versions | SmartTurn |
Tool | Disk Connector, SmartTurn Connector, Mail Connector |
Information | CSV Data > Sales Order |
Data Formats | CSV File Format |
Volumes | ~ 1000 transactions |
Process | When the CSV files are uploaded all the fields are validated and a sales order will be created in SmartTurn. |
Schedule | Hourly |
Error Handling | Email to nominated contact at the client for:
|
Complexity | Simple |