Software to automate file grabbing via ftp, detailed manipulation and uploading result

Closed

As a small business that retails on several online marketplaces (ebay, [url removed, login to view], .[url removed, login to view], .de etc) through one portal who sends modified csv, txt files to all these venues in the appropriate format for the items to arrive at that marketplace with the correct price and description etc.

I have to manually create these files and upload them to this portal. I use excel saved as .txt files. I have to download the stocklist of warehouses via ftp, of which can be upto 10 million rows in length so I have to split them before even using them. This allows me to see what is still in stock and what is no longer in stock.

I then download my active inventory from the portal and I have to then use Microsoft Access to compare the active inventory of my own to the inventory in the warehouses. I do this twice - once to find out what products have run out of stock and need to be removed from my inventory and once to find out what has come into stock that I do not have listed online - adds and deletes.

Next I have to extract and format the information correctly to be uploaded to my online portal in the appropriate templates. Once the files are ready the deletes are manually uploaded. However I need to first filter the adds as I am not allowed to list specific content on sites like ebay so adult material and other similar items are removed by me searching the titles on excel for a selection of key words. Those items are then removed from the add list - this would need to be done also. The adds file is then manually uploaded.

It is not a complicated process only boring and beyond my skill to automate - I do not even know the relevant skills to request for this project.

Notes:

I use ISBN numbers as keys for comparison

Accuracy and a foolproof nature would be necessary as the result would ALWAYS need to be correct - any mistakes on sites like ebay can cost tens of thousands of pounds so this cannot make mistakes. Pricing etc has to always be accurate.

Fluent English would be necessary due to my lack of knowledge on this subject and I would need to explain and show many parts of my business that are difficult to explain in broad terms

Any questions beforehand please let me know and I will do my best to clear any problems up.

Skills: Data Processing, Database Administration, eBay, Excel

See more: templates de sites, online business through amazon, microsoft excel software, list my business online, foolproof, excel templates for small business, ebay skill, data processing co, best business to do online, amazon de english, who is searching for me online, price comparison online, online price comparison, microsoft words online, microsoft small business, microsoft excel price, ftp online, fluent software, beyond compare excel, small business templates, microsoft access online, uploading products, pricing excel, need to download adult

About the Employer:
( 0 reviews ) Beijing, Indonesia

Project ID: #4088058

10 freelancers are bidding on average £385 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

£250 GBP in 5 days
(21 Reviews)
5.7
srinichal

I have delivered many automation scripts and can deliver the project to your specs

£620 GBP in 5 days
(13 Reviews)
5.2
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

£250 GBP in 5 days
(31 Reviews)
5.0
softwarevamp

Hello, i can do this in a timely, accurate and professional manner look to work with you At your disposal for any query. Regards softwarevamp

£600 GBP in 30 days
(4 Reviews)
4.5
mike25

Some remarks via inbox. Mike

£600 GBP in 30 days
(10 Reviews)
3.7
lokeshk9936

Hi, I have expertise in automation of tasks. Specifically, I am excellent in automating data analysis, comparison and manipulation tasks. I would be happy to do this for you. Please see PM.

£400 GBP in 4 days
(3 Reviews)
2.8
bachosl

Hello, I have big experience with many integrations, to ebay, amazon, paypal etc... i used their API, export and import tools for that. Please contact me, i will write professional app with will folow your instructi More

£300 GBP in 15 days
(2 Reviews)
1.8
Daniell84

Hi, i'm interested.

£250 GBP in 1 day
(0 Reviews)
0.0
ksharpvw

Can you elaborate it more what you want us to do. I can split a large table into a couple of small table soon.

£300 GBP in 7 days
(0 Reviews)
0.0
guptakaran

I am a Computer Engineer with 6+ years of experience in the IT industry. Looking forward to work with you.

£280 GBP in 7 days
(0 Reviews)
0.0