Create a Stock Import Process
£20-250 GBP
Оплачується при отриманні
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.
ID Проекту: #6280635
Про проект
Доручено:
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 Більше
13 фрілансерів(-и) готові виконати цю роботу у середньому за £222
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.
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 Більше
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 Більше