In Progress

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

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, ebay.de in english, data processing co, best business to do online, amazon de english, file grabbing software, 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

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #4087941

Awarded to:

HeatherSpence

Hello, I understand that you have a large amount of data that you need to download, match, filter, and then upload to online marketplaces to manage your inventory and sales. I specialize in data extraction, filteri More

£380 GBP in 7 days
(1 Review)
0.0

6 freelancers are bidding on average £630 for this job

cheapexcell

Hello, I am an expert in data automation with over 5 years of experience. Please provide the details. Note: My bid price is not final. Thanks, Alex

£250 GBP in 0 days
(59 Reviews)
4.9
NiceDeveloper

Hi, I fully understand what you want and I have an offer for you. A windows desktop app will multiple features. Please check your inbox for some SAMPLES and details. Thanks

£750 GBP in 10 days
(15 Reviews)
4.5
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

£1500 GBP in 7 days
(349 Reviews)
3.8
cosconeaionut

Hi! I can help you .

£400 GBP in 8 days
(0 Reviews)
3.6
onlineupdatebd

Hi, I have worked in similar projects and delivered successfully. Kindly grant me this effort. Thanks & Regards, Onlineupdatebd

£500 GBP in 10 days
(0 Reviews)
0.0