Rent A Coder - CRE Loaded: Upload Inventory via Product Data Feed, Update Inventory via PHP Scraping(repost)

Show Bid Request

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

Bookmark in my 'To Do' list

Posted by:	malakai015 (0 ratings)
Non-action Ratio:	Very Good - 0.00%
Buyer Security Verifications:	Good
Approved on:	Nov 9, 2009 5:46:35 PM EDT
Bidding Closes:	Nov 24, 2009 5:46:35 PM EDT
Viewed (by coders):	257 times
Deadline:	5 days.

Phase:

Cancelled

Buyer cancelled on 11/9/2009 11:39:22 AM because: "The buyer reposted this project".
Reposted as: 1289466

Pay Type:

Pay for deliverables

Max Accepted Bid:

Bidding is closed

Project Type:

Small Business Project: $100(USD) and above

Bidding Type:

Open Auction

Accepted Bidder Economy Type(s):

All

Accepted English fluency(ies):

All

ExpertRating Requirement:

None

Shortcuts

Communication Messages summary Post first reply Chat log	During project work Status reports Escrow Log Work acceptance Assembla Tools Mediation / Arbitration	Other Contact info / receipts Bid request phase log Ratings
(Note:options without links are not enabled for this phase.)

Enter chat room for this bid request
(0 active users at Dec 5, 2009 12:50:17 AM EDT)

Brief Summary:

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.

Requirements Interview Answers:
To help you bid more accurately, the buyer was interviewed about the requirements for this project. Below are their answers. Untitled Page

Project Type:

What kind of work do you need done?
Software related (Includes desktop applications and internet websites)

Project Parts:

What do you want the seller to do on this project?

Requirements:	The seller will analyze the problem and propose a software-based solution to the problem.
Programming:	The programmer will take the requirements and translate them into the language of the computer (and test it).
User installation:	The installer will move the software from the place it was created (which is called the development or QC environment) to where you will use it (which is called the production environment). The installer then tests the software to make sure that the installation was done properly and completely.

Req. Doc. Type:

What kind of documentation do you want for this project?
Formal documentation - After talking back and forth, the seller creates a formal document and/or prototype, as follows:

Requirements Document: The analyst will create a document describing everything the final software will do (other than what is documented in the prototype...if the buyer required one).

Program Type:

What kind of software should the seller create (and/or install)?

An internet web-site: This software runs on a web server and users will access it using their internet browser.

Internet web-site info

Design and functionality:

What does the programming of this project involve?

Program Functionality: Making the website "work".

Modeling another site:

Do you wish to model another site? No

Size of website:

How many pages need to be created/edited in this website?
Approximately 5.

Programming Language:

What programming language(s) do you want your website written in?
I do know the language(s).
Languages(s):

Misc. details: 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

Database:

Will this project include a database?
Yes, it does include a database.
Details:

MySQL -- version(s): 4

Browser Type(s)/Version(s):

Which browser/version combinations must this website support?

IE 7.0
IE 6.0
Firefox 3.0
Firefox 2.0-2.x
Firefox 1.5
Safari 41

Server Hosting Environment:

What is your server hosting environment?
I have a server at a 3rd party hosting company.
The name of the hosting company is: siteground
The server's shared/dedicated status is: Shared with other people.

Component Compatibility Protection:
Sometimes a programmer may create features on the website that rely on componentswhich work fine on their own server, but won't work with your 3rd party hosting company's server. There are many reasons for this including version incompatibility, restricted permissions, etc... Rent A Coder normally requires that the programmer verify in advance that your 3rd party hosting provider will support the components. If they do not, then they are responsible for any incompatibilities, rather than you. Do you want this protection on your project?
Yes, I require the programmer to query my hosting company in advance, to ensure that they support all components which the coder uses in the final solution (including supporting the anticipated version #s, allowing components to run under their potentially restricted security model, etc.)

Server Hosting Environment:

Will the coder develop "live" on your server?
Yes. The programmer may develop live on my production server.

Physical installation:

Who will perform the physical installation?
The programmer will perform the physical installation, and will be given all necessary permissions to do so.

Legal:

1) I require complete and fully-functional working program(s) in executable form as well as complete source code of all work done (so that I may modify it in the future).
2) Deliverables must be in ready-to-run condition as follows (depending on the nature of the deliverables):
2a) Any website server-side deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
2b) All other software (including but not limited to any desktop software or software the buyer intends to distribute) must include a software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request (unless specified elsewhere by the Buyer).
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased.
3b) No part of the deliverable may contain any copyright restricted 3rd party components (including GPL, GNU, Copyleft, etc.) unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the seller's Seller Legal Agreement.

Other Requirements:

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.

All deliverables must be uploaded to Rent A Coder before the deadline(s) for this project...with no exceptions. If this contract makes it impossible for a competent person to do this, then do not start this project...but instead alert Rent A Coder of an un-arbitratable, illegal project.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. Rent A Coder monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.

Categories:
(Note: Like everything else on this page, these categories are part of the original contract for this bid request.)
Web, Database, Language Specific, Requirements, PHP, Misc (software related), MySQL, Software Related (Includes Websites)

Additional Files:

This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.

0.53 kb

Messages summary

(

Back to shortcuts

)

All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

	Bidding Closes At:	Nov 24, 2009 5:46:35 PM EDT
	Max accepted bid:	$105.00 (USD)

No bids have been posted yet.
Bidding/comment cannot be viewed until you are logged in.

No bidding allowed, because this bid request was cancelled.
Cancelled Date:	11/9/2009 11:39:22 AM
Cancelled Reason:	The buyer reposted this project
Cancelled By:	Person id: 6687993

Ratings

(

Back to shortcuts

)

This bid request has no ratings yet

Bid Request Search

Highest ranked
'All Coders'.

What is this list?

1)	Gravity Jack, Inc. 9.8 avg. over 60 jobs.
2)	Lisa_G 9.89 avg. over 1728 jobs.
3)	cricava 10 avg. over 339 jobs.
4)	calciustec h 9.81 avg. over 1164 jobs.
5)	PSE - on vacation 10 avg. over 165 jobs.
6)	PSergei 9.87 avg. over 467 jobs.
7)	Dali Studio 9.83 avg. over 171 jobs.
8)	DX Silverligh t Team 9.8 avg. over 286 jobs.
9)	AtiX 9.75 avg. over 221 jobs.
10)	Small Software Consultant 9.95 avg. over 482 jobs.

...See ALL coders by ranking

Latest News | About Us | Kudos | Feedback/Contact Affiliates | Privacy | Legal

Copyright © 2001-2009 Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm), "Expert Guarantee" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.. The Expert Guarantee is patent pending.
IISPROD11 at 12/5/2009 12:50:17 AM