The Reconciliation Tool (RECI)
This tool is required because we sell Online and over third party retail stores. When we supply a retail store with our product the product is set to Queued (Not Live). After a retail store sells a product we are supplied with the information from the retail store as to what product was sold and we then set order to complete (Live).
The Automatic Reconciliation Tool (RECI). (Functionality required)
1. Download Sold Stock file from Third Party Retailers
a. FTP GET function, with scheduled run (days and times) return successful or failed on completion of task. (Outgoing FTP connection will be set up from a configuration file).
b. For phase 1 Configure the FTP server where the tool is to pick the files from set the time file format and indicate how often it is to run
2. Process File
a. Set live (‘Complete’) all orders which have been received from the third party.
b. Capture the product type and value of the order in MySql database for reconciliation.
c. Look up Third Party sales price for the order product type.
d. Post Sale to global sales file for invoicing and reconciliation.
i. Exact information to be posted to this file is required.
e. Backup all files on a nightly basis.
3. Tool Functionality Required
a. Configuration file, which allows a user to configure additional third parties retailers as they come online.
b. Email Problem Notifications.
c. Log File for every task Completed and Failed Tasks.
d. Manual Override. Allow a user to manually override where it is possible to manually pass commands to the tool in order to complete certain tasks again.
Architecture and Design Requirement
There is just one thing I want to establish from the start, build as you mean to go forward.
That is the tool should be as configurable as possible.
This should be implemented using PHP HTML and
Comments in the Code and a Manual for the tool will also be needed.
3 freelancers are bidding on average $749 for this job
Hello, 10+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.