CreLoaded: Upload Inventory via Product Data Feed, Update Inventory via PHP Scraping

Cancelled Posted Oct 1, 2009 Paid on delivery
Cancelled Paid on delivery

In need of a CreLoaded Inventory Updater script. I have a CreLoaded store that is based off of drop shipped products from other stores. Drop shipping - My store sells an item, send the order to the distributor, and they ship it out. One of our distributor's offers a Product data feed as a Excel file or a .txt data feed. I usually have to convert to an easy populate file and upload it. It takes a long time to manually create the easy populate file. (Moving fields around, changing filed names, Dividing Category fields, etc.) Part of this project is to create a script that will automatically convert the Manufacturer's Provided Data Feed to either a Easy Populate file, or automatically upload the provided data feed into my CreLoaded store to update the inventory.

Everything to be done:

1. Take URLs from mySQL Inventory database (4 different tables, probably around 1000-1500 items), check URLs (probably by PHP Scraping) to see if item is still in stock. Products that are not in stock, delete those products from mySQL database and the CreLoaded Store. Inventory database has the SKU matching the URL's product and my CreLoaded Store's product.

2. Create a script that will allow me to upload a Product Data Feed (from manufacturer), upload the products to a CreLoaded store, convert it to a Easy populate file, check the Distributor URLs in the Product data feed (by PHP scraping) and check to see if Product is in stock. If product is in stock then properly add the Product to the CreLoaded store. If Product is not in stock, delete from CreLoaded store (or do not upload the product).

3. Fix easy_populate on my CreLoaded store so it works properly. Update Easy_populate to latest version.

4. Unfortunately the Product data feed does not say how many items come per product. The distributor page (the URLs from the data feed) has these items per product. While checking URLs, scrape the items per order and change the product name to from 'Product Name' to 'Product Name - Set of 3' for example. Not all products will have multiple items in a set. If no items then do nothing.

## Deliverables

In need of a CreLoaded Inventory Updater script. I have a CreLoaded store that is based off of drop shipped products from other stores. Drop shipping - My store sells an item, send the order to the distributor, and they ship it out. One of our distributor's offers a Product data feed as a Excel file or a .txt data feed. I usually have to convert to an easy populate file and upload it. It takes a long time to manually create the easy populate file. (Moving fields around, changing filed names, Dividing Category fields, etc.) Part of this project is to create a script that will automatically convert the Manufacturer's Provided Data Feed to either a Easy Populate file, or automatically upload the provided data feed into my CreLoaded store to update the inventory.

Everything to be done:

1. Take URLs from mySQL Inventory database (4 different tables, probably around 1000-1500 items), check URLs (probably by PHP Scraping) to see if item is still in stock. Products that are not in stock, delete those products from mySQL database and the CreLoaded Store. Inventory database has the SKU matching the URL's product and my CreLoaded Store's product.

2. Create a script that will allow me to upload a Product Data Feed (from manufacturer), upload the products to a CreLoaded store, convert it to a Easy populate file, check the Distributor URLs in the Product data feed (by PHP scraping) and check to see if Product is in stock. If product is in stock then properly add the Product to the CreLoaded store. If Product is not in stock, delete from CreLoaded store (or do not upload the product).

3. Fix easy_populate on my CreLoaded store so it works properly. Update Easy_populate to latest version.

4. Unfortunately the Product data feed does not say how many items come per product. The distributor page (the URLs from the data feed) has these items per product. While checking URLs, scrape the items per order and change the product name to from 'Product Name' to 'Product Name - Set of 3' for example. Not all products will have multiple items in a set. If no items then do nothing.

Things to know:

- Data feed files have about 3000-4000 products. Should just be able to upload file, let it run, and it convert, scrape, and update CreLoaded store w/ products in stock.

- Product Data Feed categories must be altered. Should be divided into separated categories.

For expample feeds that look like this should be changed:

EX. root > Gifts of Faith > Baby / Children > Children's Jewelry

root > Gifts of Faith > Baby / Children > Children's Rosaries

Should be altered to:

Category1 | Category2 | Category3 | Category4

Gifts of Faith | Baby / Children | Children's Jewelry

Gifts of Faith | Baby / Children | Children's Rosaries

Engineering MySQL PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #2901190

About the project

2 proposals Remote project Active Oct 1, 2009

2 freelancers are bidding on average $98 for this job

engmalaa

See private message.

$97.75 USD in 7 days
(22 Reviews)
4.4
melhorvw

See private message.

$97.75 USD in 7 days
(3 Reviews)
0.0