Automate Daily File Management and Update for Shopify CSV
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.
Automatically download a CSV file once a day from FileZilla. This CSV is provided by our supplier and contains item information.
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.
2.3 Inactive Articles: If an article from our master file isn't found in the new CSV, mark it as inactive.
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, we are open to consider it but free solutions are preference.
Key Skills Required:
Familiarity with FileZilla and its API or relevant functions
Strong understanding of CSV file manipulation
Experience with Shopify (especially its CSV format and inventory management)
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.
Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!
Hi, I checked and understood your requirements. I am ready to start Right now. 100% accuracy will be delivered with a time frame and suitable budget. I am fast and dedicated. Let's discuss the job. Thanks.
Hi, I am Rahima, Expertise in Excel Automation, Excel Reporting, Excel Macros. I have 3+ years of experince in excel working. I am interested to work with you. Please message me to discuss more. Regards, Rahima
I am an expert Swift programmer with skills including Zapier, Excel, API Integration, Shopify and Data Processing. Please contact me to discuss more about this project. Thanks