Find Jobs
Hire Freelancers

CRE Loaded: Upload Inventory via Product Data Feed, Update Inventory via PHP Scraping(repost) - Creloaded / osCommerce

$100-105 USD

Cancelled
Posted over 14 years ago

$100-105 USD

Paid on delivery
I am using CRE Loaded. It is version CRE Loaded v 6.2[13.1 (SP1)] In need of a CRE Loaded Inventory Updater script. I have a CRE Loaded 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 CRE Loaded 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 CRE Loaded 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 CRE Loaded store. If Product is not in stock, delete from CRELoaded store (or do not upload the product). 3. Fix easy_populate on my CRE Loaded 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 I am using CRE Loaded. It is version CRE Loaded v 6.2[13.1 (SP1)]. **Looking for a CRE Loaded / OsCommerce Expert. Must have worked with CRE Loaded and understand it well.** In need of a CRE Loaded Inventory Updater script. I have a CRE Loaded 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 CRE Loaded 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 CRE Loaded Store. Inventory database has the SKU matching the URL's product and my CRE Loaded Store's product. 2. Create a script that will allow me to upload a Product Data Feed (from manufacturer), upload the products to a CRE Loaded 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 CRE Loaded store. If Product is not in stock, delete from CRE Loaded store (or do not upload the product). 3. Fix easy_populate on my CRE Loaded 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 CRE Loaded 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 Here is an example of the product data feed. It is just a few lines of the data feed.
Project ID: 2901456

About the project

3 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $96 USD for this job
User Avatar
See private message.
$97.75 USD in 5 days
4.9 (56 reviews)
5.7
5.7
User Avatar
See private message.
$97.75 USD in 5 days
4.5 (50 reviews)
5.7
5.7
User Avatar
See private message.
$93.50 USD in 5 days
4.8 (40 reviews)
4.2
4.2

About the client

Flag of UNITED STATES
Ledgewood, United States
5.0
3
Payment method verified
Member since Aug 26, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.