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.
14 freelancers are bidding on average £217 for this job
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 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
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.