Automating drop-ship inventory feeds into Zen-Cart (1369021)

We need someone to help us in automating updating our Zen-Cart 1.3.8 inventory when we receive updates from our various vendors. Each vendor has a different way and format of reporting this inventory so we need it to be scaleable to meet all types of updates. ## Deliverables Hello. Thanks for reviewing our bid request. Currently we run an ecommerce site that utilizes Zen-Cart version 1.3.8. We sell mostly drop-ship items that are supplied by several different vendors. Each vendor has a different way of reporting stock to us (some email us a .csv or .txt, some provide us an FTP site we can download their .csv, others just send us an email of items out of stock) and as of now we manually have to review their files and update out tables via scripts. The goal of this project would be to have a solution created that we could use to automate the manual process of updating our inventory to match our suppliers. Below is an example of what we manually do today: Vendor 1: This vendor updates their inventory every 30 minutes and makes it available to us on an FTP server. 1.? ? ? ? Download the .csv file from the FTP site 2.? ? ? ? Open the file and sort the file ascending by Date (Column E) 3.? ? ? ? Select the Item Code (Column A) and the Qty Availability (Column C) for all the records with today’s date 4.? ? ? ? We then take this and paste this into an excel file that has 4 columns a.? ? ? ? Column A is Vendor Model Number (Column A) in the case with this vendor b.? ? ? ? Column B is the Our Model Number, typically we add like LCC- to the beginning of Vendor Model Number c.? ? ? ? Quantity which is Column C in this vendors file d.? ? ? ? The last column is a script we have created that creates a series of update statements for each item code like below. We then run this query in a SQL tool like phpMyAdmin update products set products_quantity = 49 where products_model = 'LCC-TP10-99'; update products set products_quantity = 58 where products_model = 'LCC-TP10G-99'; Vendor 2: This vendor emails us 2-3 times a day a .txt file 1.? ? ? ? Save the .txt file from the email 2.? ? ? ? Open the .txt file in Excel 3.? ? ? ? Select/Copy all items in Column A and B 4.? ? ? ? We then take this and paste this into the excel file that has 4 columns a.? ? ? ? Column A is Vendor Model Number (Column A) in the case with this vendor b.? ? ? ? Column B is the Our Model Number, typically we add like GAP- to the beginning of Vendor Model Number c.? ? ? ? Quantity which is Column B in this vendors file d.? ? ? ? The last column is a script we have created that creates a series of update statements for each item code like below. We then run this query in a SQL tool like phpMyAdmin update products set products_quantity = 10 where products_model = ’GAP-ABS2002-14’; update products set products_quantity = 8 where products_model = 'GAP-ABS2022-14'; As you can see, each vendor has a different means of getting us the file, but ultimately we need two columns from them, Model and Stock. By no means are we stating that this has to be done this way, this just happens to be how we have started doing it and it seems to work other than the fact it is extremely manual. We are looking for someone to work with us on this, and future projects to streamline our business processes so we can focus on selling our products. Please let us know if you are interested in working with us on this project.