In Progress

Create a Stock Import Process

Stock Import Process

- Collect CSV file from multiple FTP Locations (File formats may different, slightly)

- Prefix stock code with supplier name, lookup table to be provided.

- I need to be able to set-up new CSV files & locations for this to collect from without the need for more programming

- Create a standard output csv file and post to FTP location.

- This process needs to run every 15 mins

Back Order & PO Creation

- Collect Back order file from FTP location (Standard Format CSV Template, 5 columns of data)

- Split out back orders by supplier (Lookup table provided)

- By Supplier create Supplier specific POs based on a following rules:

- Group back orders by sales channel for each supplier

- Sum the number of back orders by stock code

- Check if item is sold in packs, if yes, round the value required up to pack qty - lookup table provided & required to be editable by me

- Output this file into standard PO format for our system and output into Supplier import file. (The output values can differ between our system PO & supplier PO due to packs. We will explain this in greater detail)

- this process needs to run twice a day, once at 10am and once at 4pm. We therefore need to deduct the PO’s raised at 10am from the additional requirements at 4pm. Excludes Saturday

I am looking for this to be completely automated. I need alerts or triggers for issues/failed outputs. I need a complete testing phase, to ensure this works 100% accurate.

I need to be able to turn this on/off if required.

Skills: PHP, Software Architecture

See more: template for testing software, programming process, is in a prefix, channel 5 programming, automated software testing, pos data collect, po file, data collect pos, php process csv, pos system php table, php split csv files, create sales system table, php create csv file, php split csv multiple, collect stock data, ftp supplier, php output csv, template import, software testing process, template stock php, php csv ftp, lookup table php, order stock, php split csv, php split csv multiple files

About the Employer:
( 7 reviews ) Malpas, United Kingdom

Project ID: #6280635

Awarded to:

atchayagandhi

Hi, we can have this project done, we have expertise in similar stock import applications. The application can be built either on PHP or on Java, using a PHP application will need a server system, either on the More

£175 GBP in 7 days
(34 Reviews)
6.2

14 freelancers are bidding on average £217 for this job

steven6

Hi, I have done a similar assignment before and would anticipate this would take me around 24 hours to complete. Please send me a message if interested. Thank you.

£263 GBP in 0 days
(42 Reviews)
6.8
phpdeveloper100

Hi We are very interested in this [url removed, login to view] can do that job in a normal [url removed, login to view] have great experience of preparing Complete Scope,Complete documentation,attractive design ,Webdevelopment,QA and then support for specific da More

£266 GBP in 3 days
(34 Reviews)
6.0
goswamiarpit475

Hi Sir, I am ready to work for you.I have 4 years of experience in Php/C#/sql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Plea More

£247 GBP in 7 days
(28 Reviews)
5.5
raiakanksha49

i have read your requirements of project.i have 6 yrs experienced in PHP,Software Architecture, i designed many websites and doing many big projects within timeline.. this project is very easy for me i can do it very w More

£206 GBP in 10 days
(20 Reviews)
5.2
anuyadav1

A proposal has not yet been provided

£250 GBP in 5 days
(30 Reviews)
5.2
SergeScz

Hello. I can do this job for you. I have expereince with data manipulation and PHP. What I need to know is how it will be run (As system service called by cron or as web page) ? Let me know if you are interested , I ca More

£200 GBP in 7 days
(7 Reviews)
4.8
PaulSimonk

Hi, I have gone through your project description and i would like to have a business relation with you. I could provide you a well experienced developer to assist you on this We specialize in wordpress, magento, do More

£257 GBP in 3 days
(8 Reviews)
4.6
HedgeMaster1029

Dear sir. I have interesting at your project. I have many experience of C# & Trading. I can do it via C#. I can do your project ASAP. I will good service for you. Thanks.

£150 GBP in 3 days
(13 Reviews)
4.4
alltechinfohub

Dear Sir/Madam, Greeting from Alltechinfohub, We have seen your requirements,specification and interested to work on it We are happy to inform you that We are a company consisting a team of Well Experienced. W More

£250 GBP in 10 days
(22 Reviews)
4.5
datavisionitcnsk

Datavisionitc is IT company which are working on ERP,PHP, Java, codeigniter, Wordpress, Joomla, Asp.net, Android application, Games, etc from many years. Our Works: [url removed, login to view] http: More

£230 GBP in 10 days
(14 Reviews)
4.1
ldmarv256

Good Day. I'm an experienced web developer. I've worked with PHP, Java and C++. I've done several projects here at [url removed, login to view] (mostly PHP projects). I'm familiar with file transfer protocol too. If you requir More

£230 GBP in 20 days
(15 Reviews)
3.7
grigiq

A proposal has not yet been provided

£150 GBP in 7 days
(5 Reviews)
3.4
sathishbob

Hi, I have 10 years of experience in system administration. I have worked on various organisations supporting different architecture. I have extensive knowledge on various linux/unix flavour OS in installation, fine More

£166 GBP in 3 days
(1 Review)
0.8