Download stock file from supplier's FTP server work it out and upload it on another FTP server
4502
$$
- Posted:
- Proposals: 4
- Remote
- #107446
- Archived
Description
Experience Level: Intermediate
General
1. I am operating an ecommerce website that is trading fashion.
2. The stock I am using is stored and managed at a distant location from mine.
3. The stock file is continuously updated and posted on the server of my supplier/ fulfillment center.
4. The stock file is posted in xml, csv and xls format.
5. At present I download the file manually on my pc in xls format.
6. I enter the data of that file in the IMPORT FILES (Sheet: Stock File)
7. From the Sheet: Stock File and the two files CATEGORIES TABLE and SUBCATEGORIES TABLE I pick/filter data and create sheets ‘Import Products’ and ‘Import Product Options’
8. I convert the sheets ‘Import Products’ and ‘Import Product Options’ to two separate excel files and then convert them to csv.
9. Then I manually upload the csv files on my ftp server.
Requirement
I need a script that will automate the above process and will not need me to do anything manually:
1. Access the remote server with the Stock File every half-hour
2. Pick the supplier’s stock file
3. Work it out automatically and create the new files required
4. Convert the new files to csv format
5. Upload the files on my ftp server
NOTE:
1. IMPORT FILES, CATEGORIES TABLE, SUBCATEGORIES TABLE must be opened simultaneously in the same folder for the whole thing to work.
Please let me know if the above is possible and the cost.
1. I am operating an ecommerce website that is trading fashion.
2. The stock I am using is stored and managed at a distant location from mine.
3. The stock file is continuously updated and posted on the server of my supplier/ fulfillment center.
4. The stock file is posted in xml, csv and xls format.
5. At present I download the file manually on my pc in xls format.
6. I enter the data of that file in the IMPORT FILES (Sheet: Stock File)
7. From the Sheet: Stock File and the two files CATEGORIES TABLE and SUBCATEGORIES TABLE I pick/filter data and create sheets ‘Import Products’ and ‘Import Product Options’
8. I convert the sheets ‘Import Products’ and ‘Import Product Options’ to two separate excel files and then convert them to csv.
9. Then I manually upload the csv files on my ftp server.
Requirement
I need a script that will automate the above process and will not need me to do anything manually:
1. Access the remote server with the Stock File every half-hour
2. Pick the supplier’s stock file
3. Work it out automatically and create the new files required
4. Convert the new files to csv format
5. Upload the files on my ftp server
NOTE:
1. IMPORT FILES, CATEGORIES TABLE, SUBCATEGORIES TABLE must be opened simultaneously in the same folder for the whole thing to work.
Please let me know if the above is possible and the cost.
Charis K.
100% (9)Projects Completed
10
Freelancers worked with
7
Projects awarded
92%
Last project
30 Dec 2023
Cyprus
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies