The Reconciliation Tool (RECI)

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.

Skills: Linux, PHP, XML

See more: xml tool online, what was the, what is the design process, sale the design online, post tool design, html design tool online, design tool online, d&b supply, database design tool online, database design tool, architecture design tool online, architecture and design online, all product design tool, reconciliation reci, reconciliation tool php, value stores, online architecture design tool, format xml online, the time, the party, reconciliation, file backup tool, xml format online, tool store, server configuration problem

About the Employer:
( 2 reviews ) Greystones, Ireland

Project ID: #1098556

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.

$1800 USD in 45 days
(45 Reviews)

Hello. Please check PMB. Thanks.

$246 USD in 8 days
(0 Reviews)

We are group of PHP developer. We shall do our best to satisfy you.

$200 USD in 14 days
(0 Reviews)