Closed

Automating drop-ship inventory feeds into Zen-Cart

This project received 12 bids from talented freelancers with an average bid price of $324 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
12
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online