Create a Stock Import Process

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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.

PHP Архітектура ПЗ

ID Проекту: #6280635

Про проект

13 заявок(-ки) Дистанційний проект Остання активність Aug 18, 2014

Доручено:

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 Більше

£175 GBP за 7 дні(-в)
(42 відгуків(-и))
6.4

13 фрілансерів(-и) готові виконати цю роботу у середньому за £222

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 за 0 дні(-в)
(47 відгуків(и))
7.2
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 Більше

£247 GBP за 7 дні(-в)
(31 відгуків(и))
5.5
anuyadav1

A proposal has not yet been provided

£250 GBP за 5 дні(-в)
(49 відгуків(и))
5.7
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 Більше

£200 GBP за 7 дні(-в)
(7 відгуків(и))
5.0
ldmarv256

Good Day. I'm an experienced web developer. I've worked with PHP, Java and C++. I've done several projects here at Freelancer.com (mostly PHP projects). I'm familiar with file transfer protocol too. If you requir Більше

£230 GBP за 20 дні(-в)
(16 відгуків(и))
4.0
grigiq

A proposal has not yet been provided

£150 GBP за 7 дні(-в)
(8 відгуків(и))
3.5
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 Більше

£166 GBP за 3 дні(-в)
(1 відгук)
0.8