Automate daily File Management (from FTP) and Update Shopify CSV
Budget: €30 – €250 EUR
Automate Daily File Management and Update for Shopify CSV
Project Description: We require an automation solution to streamline our daily operations related to our Shopify store's inventory. The task involves interacting with FileZilla, processing CSV files, and updating our Shopify inventory accordingly.
Detailed Requirements:
1.File Retrieval: Automatically download a CSV file once a day from FTP. This CSV is provided by our supplier (Supplier – example.csv attached) and contains item information. This file has different format than Shopify template (Shopify – product_template.csv attached). It contains thousands of items but we are only interested in less than 100.
2.CSV Processing: Use the newly downloaded CSV in tandem with our master file (which represents the active articles on our website) to make the following adjustments:
2.1 Existing Articles: For articles that already exist in our master file, update their stock and price based on the new CSV.
2.2 New Articles: If an article from the new CSV doesn't exist in our master file, add it with all the necessary information. To do this, you need to create a piece of code to map the information from Supplier’s file to Shopify Template (Conversion.xlsx file attached).
2.3 Inactive Articles: If an article from our master file isn't found in the new CSV, mark it as inactive.
3.File Upload: After processing, upload the new CSV to Shopify. This automated process need to be run on daily basis. If other 3rd party software are required (like Mesa and Matrixify), we are open to consider it but free solutions are preference.
Lastly, one page with a diagram of the process flow and what software is used for future reference and handover.
Key Skills Required: Familiarity with FTP and its API or relevant functions Strong understanding of CSV file manipulation Experience with Shopify (especially its CSV format and inventory management), Mesa and Matrixify (u other automation software).
Additional Notes: Please ensure the solution is robust and allows for potential error handling, ensuring minimal manual intervention once set up. We appreciate a brief overview or proposal of your approach to tackling this task in your application.
Important. If you are interested, you must reply with a brief description of the three steps process flow and what software you will use.
Thanks
Project Description: We require an automation solution to streamline our daily operations related to our Shopify store's inventory. The task involves interacting with FileZilla, processing CSV files, and updating our Shopify inventory accordingly.
Detailed Requirements:
1.File Retrieval: Automatically download a CSV file once a day from FTP. This CSV is provided by our supplier (Supplier – example.csv attached) and contains item information. This file has different format than Shopify template (Shopify – product_template.csv attached). It contains thousands of items but we are only interested in less than 100.
2.CSV Processing: Use the newly downloaded CSV in tandem with our master file (which represents the active articles on our website) to make the following adjustments:
2.1 Existing Articles: For articles that already exist in our master file, update their stock and price based on the new CSV.
2.2 New Articles: If an article from the new CSV doesn't exist in our master file, add it with all the necessary information. To do this, you need to create a piece of code to map the information from Supplier’s file to Shopify Template (Conversion.xlsx file attached).
2.3 Inactive Articles: If an article from our master file isn't found in the new CSV, mark it as inactive.
3.File Upload: After processing, upload the new CSV to Shopify. This automated process need to be run on daily basis. If other 3rd party software are required (like Mesa and Matrixify), we are open to consider it but free solutions are preference.
Lastly, one page with a diagram of the process flow and what software is used for future reference and handover.
Key Skills Required: Familiarity with FTP and its API or relevant functions Strong understanding of CSV file manipulation Experience with Shopify (especially its CSV format and inventory management), Mesa and Matrixify (u other automation software).
Additional Notes: Please ensure the solution is robust and allows for potential error handling, ensuring minimal manual intervention once set up. We appreciate a brief overview or proposal of your approach to tackling this task in your application.
Important. If you are interested, you must reply with a brief description of the three steps process flow and what software you will use.
Thanks