We have a thriving online business, but do not want to ship to certain UK postal codes with our main courier (due to high costs of these outlying areas). We need to be able to process CSV files automatically without our staff needing to manipulate the data manually.
Ideally, the workflow will be as follows:
- Drag-and-drop CSV file into Windows folder (CSV IN, for instance)
- Script reads postal code data field and compares against a separate file (we have a list of postcodes in outlying areas). If match found, it appends postal code of source file to force error.
- Processed data is written to a new CSV file that is automatically placed in a different Windows folder location (where the shipping software will automatically pick it up and process)
Obviously I can provide greater detail as required. The only thing I'm unsure of is that the dataset to compare against may sometimes require only a partial match, but not always - see the attached file for an example of the dataset to check against.
Anyway, that's what I'm thinking! I'm sure it's possible with some kind of script that runs in the background, but am unsure of how to do this.
51 freelancers are bidding on average £160 for this job
Hi I have gone through the requirements. Will do this script using PHP and the cron job which runs automatically. I'm available to start now. Please share additional details. Regards, Mohan
hey, I understand your project details as I have read them and seen the attached file. I can make you a script to do this task automatically. Would love to discus a few details with you in chat.
Hello, I have csv processing experience and I am thinking of using Python with Pandas library. I would like to see a sample file and more details on what you want. Please contact me for further discussion.
Dear Sir am excellent in web development I can do this csv of postal code compare application perfectly and fastly very much interested in this project please reply Thank You