Create a Stock Import Process

Completed

Description

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

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