Awarded

Automating drop-ship inventory feeds into Zen-Cart

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.

Skills: eCommerce, Inventory Management, MySQL, PHP, Zen Cart

See more: set zen cart drop ship quantity, ecommerce inventory feeds, csv inventory ecommerce, automate inventory feeds, zen cart drop ship, automate ecommerce inventory, use case tool download, ship 3 d model, sell scripts php, selling request, selling an ecommerce business, reporting projects, download 3 d model, code review tool, updating inventory csv zen cart, drop ship inventory feeds, zen cart inventory code, inventory drop ship, inventory update script zen cart, columns zen cart, ecommerce drop ship script, zen products_quantity update, automating drop ship inventory feeds zen cart, last day projects, gap

About the Employer:
( 2 reviews ) Lakeland, United States

Project ID: #636497

11 freelancers are bidding on average $326 for this job

tamamanoj

Hi, Thanks for reviewing our bid. We are a Kolkata city based Indian company, with experience of nearly 300 international website design and development. For details bid please look into pmb. Thanks—SD

$250 USD in 6 days
(70 Reviews)
6.9
zencartin

Hi , We are interested , Please check PMB...

$600 USD in 9 days
(5 Reviews)
3.8
axeacc

Hi, Thank you for detailed description. I am giving details of the solution (which I can provide) in PM. Please check.

$250 USD in 3 days
(4 Reviews)
2.6
DiegoCS

Check PMB! I got what you need.

$250 USD in 1 day
(1 Review)
1.6
cnsamit

Hi, Let us start cnsamit

$290 USD in 6 days
(0 Reviews)
0.0
alphaes

Hi, I have worked on similar projects before. Thanks.

$300 USD in 6 days
(1 Review)
0.0
vknyazev

Please check a PMB.

$300 USD in 1 day
(0 Reviews)
0.0
ramankumar27

Hello MCane, I am intrested in this project. Please see my message in your inbox. Thank You: Raman

$250 USD in 2 days
(0 Reviews)
0.0
papanbamba

i can develop as per your requirement. u could check that out, i hope if you experience us once u need not to go for further providers any more. we can work till your satisfaction. --------------------------------- More

$300 USD in 5 days
(1 Review)
0.0
avidevphp

Dear Client, We had gone through the requirement docs of your project as we had developed similar type of store earlier that why willing to work on your project. We have more than 5 years of experience in web P More

$500 USD in 15 days
(0 Reviews)
0.0
masamad2010

Dear Sir, I am interested in this project all of your terms & conditions. I am confident to perfect delivery about his project. Regards, Masamad2010

$300 USD in 7 days
(0 Reviews)
0.0