Get a Freelance Job

NB: BIDDERS NEED NOT BE NATIVE ENGLISH SPEAKERS, BUT PERFECT KNOWLEDGE OF THE ENGLISH LANGUAGE IS REQUIRED FOR THIS PROJECT. PLEASE DO NOT BID IF YOU ARE NOT FLUENT IN YOUR UNDERSTANDING OF THE ENGLISH LANGUAGE.

I have two programming requests:

I created an e-commerce website for a client in October last year, using WordPress and the WP e-Commerce plugin. The website sells alternative medical products and food supplements.

(A) CUSTOM IMPORTER PLUGIN

The client had a requirement that the ingredients of each product should be displayed in tabular format in a custom field with custom “sub-fields” in the product description.

I contracted a programmer on ScriptLance who created a plugin to do the job. Basically it works by: (1) specifying the headers of the “sub-fields”; (2) entering the heading of the table in which the ingredients would be sorted; (3) uploading a CSV file containing all products, but with multiple records of each product in accordance with the number of ingredients, each record containing an ingredient; (4) importing it into the database.

The result was that there was still only one record of each product in the products database, but in the extended product display on the site the ingredients for each product were displayed in tabular format under the specified heading. The heading appeared in the same way that the other field headings appear in the display, although it was technically not a field as such.

This plugin worked well for a while, but then suddenly started to malfunction, probably due to WP upgrades leaving it obsolete. I need someone to fix it so it works the way it should again (I can’t get hold of the original coder). It should be upgraded to work with WordPress 3.1 and should preferably be easy to upgrade in future.

You should also change the display of the table slightly so it displays within another table. The table containing the actual ingredients should be invisible, i.e. no borders, background or padding, but the table containing that table (in a single cell) should have a 1px #CCCCCC border with a very light gray background, and the cell containing the other table should have 10px or 15px padding.

Preferably, if it was easy to do, I would have wanted not tables but divs.

I attach the actual plugin (although the previous programmer tinkered with the plugin a bit online after it was installed, so I don’t know if the attached one is the same as the installed one anymore) as well as a CSV file. The CSV file is the one containing multiple records of each product, in accordance with the number of ingredients. This is just so you can make an informed assessment before you bid. The fields in the CSV file containing the ingredients are: “Uomwithcontains”,”Ingredient”,”UOM per UOM”,”UOM”

One other thing: The original coder created the plugin specifically for this site (http://fortifood.co.za)only, in spite of my request to create it as a plugin that could be used with any WordPress site using the WP e-Commerce plugin. If it won’t affect the quote too much, I would like this also to be corrected.

(B) WP E-COMMERCE THEME

Something also went wrong with the WP e-Commerce themes, making it impossible for me to display postage/delivery options in my shopping cart. I would like that to be fixed as well.

NB: BIDDERS NEED NOT BE NATIVE ENGLISH SPEAKERS, BUT PERFECT KNOWLEDGE OF THE ENGLISH LANGUAGE IS REQUIRED FOR THIS PROJECT. PLEASE DO NOT BID IF YOU ARE NOT FLUENT IN YOUR UNDERSTANDING OF THE ENGLISH LANGUAGE.

I have two programming requests:

I created an e-commerce website for a client in October last year, using WordPress and the WP e-Commerce plugin. The website sells alternative medical products and food supplements.

(A) CUSTOM IMPORTER PLUGIN

The client had a requirement that the ingredients of each product should be displayed in tabular format in a custom field with custom “sub-fields” in the product description.

I contracted a programmer on ScriptLance who created a plugin to do the job. Basically it works by: (1) specifying the headers of the “sub-fields”; (2) entering the heading of the table in which the ingredients would be sorted; (3) uploading a CSV file containing all products, but with multiple records of each product in accordance with the number of ingredients, each record containing an ingredient; (4) importing it into the database.

The result was that there was still only one record of each product in the products database, but in the extended product display on the site the ingredients for each product were displayed in tabular format under the specified heading. The heading appeared in the same way that the other field headings appear in the display, although it was technically not a field as such.

This plugin worked well for a while, but then suddenly started to malfunction, probably due to WP upgrades leaving it obsolete. I need someone to fix it so it works the way it should again (I can’t get hold of the original coder). It should be upgraded to work with WordPress 3.1 and should preferably be easy to upgrade in future.

You should also change the display of the table slightly so it displays within another table. The table containing the actual ingredients should be invisible, i.e. no borders, background or padding, but the table containing that table (in a single cell) should have a 1px #CCCCCC border with a very light gray background, and the cell containing the other table should have 10px or 15px padding.

Preferably, if it was easy to do, I would have wanted not tables but divs.

I attach the actual plugin as well as a CSV file. The CSV file is the one containing multiple records of each product, in accordance with the number of ingredients. This is just so you can make an informed assessment before you bid. The fields in the CSV file containing the ingredients are: “Uomwithcontains”,”Ingredient”,”UOM per UOM”,”UOM”

One other thing: The original coder created the plugin specifically for this site (http://fortifood.co.za)only, in spite of my request to create it as a plugin that could be used with any WordPress site using the WP e-Commerce plugin. If it won’t affect the quote too much, I would like this also to be corrected.

(B) WP E-COMMERCE THEME

Something also went wrong with the WP e-Commerce themes, making it impossible for me to display postage/delivery options in my shopping cart. I would like that to be fixed as well.

I need a logo made up of my intials “BG”.
The logo design will need to be flexible in that it will be used for two purposes…color design that will be printed on business cards and shirts, and monochrome that will be laser engraved into metal.
Colors used in the color version will be lime green, black, metallic silver. I will provide the hex values prior to your starting on the job.

Need high resolution jpg and also vector based format.

The letters should be integrated into a thoughtful design.

The attachments provide a couple of examples for inspiration but are of different initials that work well together. Design can have some sort of border outline enclosing the letters.
The file mb.jpg is a friend’s logo. You can see how the M and B letters are combined together in the logo.
The file ts.jpg has a border that I like but don’t want to duplicate exactly.
Ideas.jpg and ideas2.jpg are just some rough drawings I was trying to see how the letters would interact with each other.

Would like you to provide a rough draft concept of how the letters will be shaped prior to agreeing to authorize the job.

Introduction

The requirement is for a set of Microsoft Excel Macros to import data from proxy server log files into a Microsoft Excel Workbook and to produce reports and charts based on the imported data.

The Macros may be written in VBA and the result will be a single .XLS workbook containing the macros which would be triggered by either a hot key or a macro button.

The project will be in two stages. First developing the
Macro(s) to import the raw log file data into an Excel Workbook and secondly developing the Macro(s) to process this imported data to produce a number of charts based on the log file data.

Background

The company’s internal proxy servers produces log files which detail fetch request made by user PCs within the company network to servers on the internet via the proxy server. These proxy log files contain many lines, one for each fetch request. The log files are in plain text and each line contains the following fields prefaced by the identifier then the data and separated by a space. Records are separated by a newline character.

1 id= Proxy Server ID

Please don’t bid or contact us to let us know how great your company is and how you could do so much of a better job for more money.

The objective of this project is to rebuild and redesign Wootpro.com which is a Woot Tracking Website.

There is existing code for the site however we wish for it to be used only as reference and prefer a complete recode of the site.
The site needs to be coded in ASP and capable of running on a Windows 2003/IIS server with the utilization on a MySQL backend if needed and utilizing CSS.
The code needs to be clean and optimized to minimize server and bandwidth utilization.
The site also needs to be cross browser compatible, and search engine optimized as best as possible (We realize this is not an SEO project).

Feature requirements for the site:

- The site is primarily advertising and donation supported.
Each page/section needs to be able to display up-to 8 different ads including Google ads optimized to show ads relevant to the current product on Woot.com.
Each ad zone needs to be configurable within an admin panel to refresh as different intervals, track displays, track clicks and add/remove/enable/disable ads.
Contextual & Inline ads need to be able to display for all text located on the site including item description.

- The information displayed on the site needs to be refreshed within a certain time variable configured in an admin panel.
The page should not need to reload to refresh the information, but only sections whose information has changed should refresh (possible Ajax)

- The site needs to be able to detect a woot off and change settings dynamically in this situation.
The refresh rate of the above sections need to go into Wootoff mode and based on settings in admin panel.

- The site needs to play an audio file for 4 scenarios, each with its own audio:
New woot item.
Woot item at or below 2%.
Woot item sold out.
Bag of crap woot item (in the instance, it will also need to open a new page with the order page for item being sold on woot.com) for paying members.
Audio files should only play once for each instance except for paying members who should be able to configure when the files play, and how often.
The page should also be able to grab focus of the screen, a feature which can be enabled by paying members.

- The site will need to have multiple pages contained in navigation tabs including:
+ Main page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Description of item formatted as it is on Woot.com.
Link to discuss item on woot.com
Sale stats snapshot as shown on woot.com with ability to click and expand without leaving site/page.
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
Statistics of current item being sold during previous sales.
+ Mini tracker page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+ Text only tracker page containing:
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+past items page as seen here with full statistics:
http://www.bagsofcrap.com/past-items/past-items-100-items.html
and
http://www.bagsofcrap.com/woot-statistics.html
and
http://www.bagsofcrap.com/boc_items/
and
http://www.bagsofcrap.com/predictions.html
+ Contact us page / Advertise here page
+ Signup for membership page:
Give users the ability to signup using PayPal via either monthly or annual membership to be determined later via admin panel.
Once signed up, they will need to have a user panel where they can update their information, opt out of mailings, and customize sections of site as described within project.
+ Existing members page as described above.
*all pages will need to meet the advertising scheme described above.
*all pages need to contain a title showing the % left of current item and its name, visible to search engines.
-Each page needs to have a dynamic link to Digg optimized for current item.
-Site needs to have a common footer display load times, information, copyright and number of active users, number of members on site.
-A link needs to be available to test focus grabbing and audio alerts.

- Backend:
Dynamic .gif or .jpg banners need to be generated displaying an ad for the site and what it’s tracking, and % left to be used by members as forum signatures.
Site needs to automatically and immediately post an ad in the woot forums once a new item is available. You can see this by visiting the woot forums.
Site needs to allow all users to sign up for membership, but allow them to pay for upgrades enabling above features.
Admin Site needs to allow for e-mails sent to all users, paying users.
Site also needs to send a welcome email for each paid, and free users.
An admin panel which allows for management of site and users.
Allows for reporting of users and due payments with ability to e-mail users letting them know their membership is due for renewal and ability to suspend their account where if they log in, they are taken to a payment page.

- Anything else that may come up as fine tuning during project.

Feel free to grab inspiration from sites such as:
http://woot.wikia.com/wiki/Woot-Off_Checkers
http://www.bagsofcrap.com/
http://www.woottracking.com/

Thank you for reading about this project.
Please take note of the following:
DO NOT BID on this project of you don’t have positive feedback.
DO NOT BID on this project if you want paid without/before finishing the job.
DO NOT BID on this project if you want paid without doing good work.

We have positive feedback which shows we are serious, easy to work with and pay on the spot.

Also be advised that we run many projects and this is our step back into outsourcing.
Once we have a reliable, self managed, affordable ASP and Web designer, we will be able to outsource more projects to you.

When you bid, please include links to existing work similar to this project.

Please, Please, Please…. Read the requirements of the project in full and make sure you understand what woot, woot off, bags of crap are before bidding….then bid away and let’s start working together and growing.

We need a total of 160 PR3+ links to our websites (at least 40% of the links must be PR4 or higher). All websites are education related (safety courses) and in Dutch.

Links must come from high quality websites (preferably .NL, .BE or other European domains) that contain on topic, education related relevant content. Only genuine “white hat” SEO techniques are to be used. Please read our project guidelines below :

PROJECT GUIDELINES

- The PAGE containing our link must have a page rank of at least 3 (the page must have PR, not just site)
- links should include the target keywords on the text hyperlink
- All links must be from Dutch (preference), German or English language-based websites
- One link per domain, each link must be from a completely different class C IP address
- link pages must have been recently cached in Google (within past 30 days)
- link must not reside on a page with more than 30 outbound links
- links must be permanent, free, one way/non-reciprocal and static
- links from sites that already link to us will not be approved
- links need to be in place for a period of at least 12 months: any links that drop off over the the next twelve months will need to be replaced with equivalent PR links free of charge
- All links to be permanent clean HTML crawlable text links: they cannot include a nofollow tag, be on a links page excluded by a robots tag or use javascript, meta or redirect scripts
- links cannot be from porn, casino, pharmacy, free hosted, illegal or blacklisted websites
- No link schemes or link farms.
- ONE WAY links *only* (reciprocal links will NOT be accepted)
- links cannot be placed on framed pages, flash websites, article submission websites, forums/bulletin boards, guest books, directory sites, social bookmarks or classified ads, and links should not be posted and or participate in any (commercial) link exchange programs/ web rings/ link farms
- No text to mention the links are paid links.
- No hidden links. All links must be visible and readable.
- No links to be made using any automated techniques or black/grey hat blog comment spam, referrer spam or ANY other shady tactic.
- We reserve the right to cancel any link if not found suitable.

** these are our terms and conditions, they are not to be changed, if you cannot meet the above requirements please do not bid **

TIMEFRAME FOR DELIVERY

All links must be deployed several per day over a period of 4 weeks to avoid any penalties. (building 40 links each week)

REPORTING

We need weekly updates and a final report in an Excel spreadsheet containing this information :

* Date
* Anchor Text Used
* Type of link
* Link IP Address
* Link URL (the URL where our link is located)
* Google page rank of the link URL

PAYMENT

Funds will be put in escrow; 50% of the Payment will be made after ALL links have been placed and verified. (you must provide us with an Excel spreadsheet as outlined above). The remaining 50% of payment will be made ONLY after Google has cached the links.

OTHER INFORMATION

You will be provided with an excel sheet containing the related keywords for link building. We prefer links coming from .NL/.BE websites of course (it’s not a must !), and webmasters who are able to provide links from these TLD’s have an advantage. If possible, please provide examples of websites that you have built links for in the past and any search engine ranking/traffic success that resulted from your actions. Please note this is not a one time project, if we find the right link builder we have lots of regular work for him / her.

BIDDING

We reserve the right to terminate the contract if objectives/deliverables are not met in a timely manner.

Please submit:

-Your price to complete the entire project
-References to similar, successfully completed projects to indicate your work quality.
-A description of how you intend to obtain the links during the project time line.
-An indication that you have read and understand ALL the project requirements.

If you have any questions or comments, please contact us through the project message board.

Please don’t bid or contact us to let us know how great your company is and how you could do so much of a better job for more money.

The objective of this project is to rebuild and redesign Wootpro.com which is a Woot Tracking Website.

There is existing code for the site however we wish for it to be used only as reference and prefer a complete recode of the site.
The site needs to be coded in ASP and capable of running on a Windows 2003/IIS server with the utilization on a MySQL backend if needed and utilizing CSS.
The code needs to be clean and optimized to minimize server and bandwidth utilization.
The site also needs to be cross browser compatible, and search engine optimized as best as possible (We realize this is not an SEO project).

Feature requirements for the site:

- The site is primarily advertising and donation supported.
Each page/section needs to be able to display up-to 8 different ads including Google ads optimized to show ads relevant to the current product on Woot.com.
Each ad zone needs to be configurable within an admin panel to refresh as different intervals, track displays, track clicks and add/remove/enable/disable ads.
Contextual & Inline ads need to be able to display for all text located on the site including item description.

- The information displayed on the site needs to be refreshed within a certain time variable configured in an admin panel.
The page should not need to reload to refresh the information, but only sections whose information has changed should refresh (possible Ajax)

- The site needs to be able to detect a woot off and change settings dynamically in this situation.
The refresh rate of the above sections need to go into Wootoff mode and based on settings in admin panel.

- The site needs to play an audio file for 4 scenarios, each with its own audio:
New woot item.
Woot item at or below 2%.
Woot item sold out.
Bag of crap woot item (in the instance, it will also need to open a new page with the order page for item being sold on woot.com) for paying members.
Audio files should only play once for each instance except for paying members who should be able to configure when the files play, and how often.
The page should also be able to grab focus of the screen, a feature which can be enabled by paying members.

- The site will need to have multiple pages contained in navigation tabs including:
+ Main page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Description of item formatted as it is on Woot.com.
Link to discuss item on woot.com
Sale stats snapshot as shown on woot.com with ability to click and expand without leaving site/page.
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
Statistics of current item being sold during previous sales.
+ Mini tracker page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+ Text only tracker page containing:
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+past items page as seen here with full statistics:
http://www.bagsofcrap.com/past-items/past-items-100-items.html
and
http://www.bagsofcrap.com/woot-statistics.html
and
http://www.bagsofcrap.com/boc_items/
and
http://www.bagsofcrap.com/predictions.html
+ Contact us page / Advertise here page
+ Signup for membership page:
Give users the ability to signup using PayPal via either monthly or annual membership to be determined later via admin panel.
Once signed up, they will need to have a user panel where they can update their information, opt out of mailings, and customize sections of site as described within project.
+ Existing members page as described above.
*all pages will need to meet the advertising scheme described above.
*all pages need to contain a title showing the % left of current item and its name, visible to search engines.
-Each page needs to have a dynamic link to Digg optimized for current item.
-Site needs to have a common footer display load times, information, copyright and number of active users, number of members on site.
-A link needs to be available to test focus grabbing and audio alerts.

- Backend:
Dynamic .gif or .jpg banners need to be generated displaying an ad for the site and what it’s tracking, and % left to be used by members as forum signatures.
Site needs to automatically and immediately post an ad in the woot forums once a new item is available. You can see this by visiting the woot forums.
Site needs to allow all users to sign up for membership, but allow them to pay for upgrades enabling above features.
Admin Site needs to allow for e-mails sent to all users, paying users.
Site also needs to send a welcome email for each paid, and free users.
An admin panel which allows for management of site and users.
Allows for reporting of users and due payments with ability to e-mail users letting them know their membership is due for renewal and ability to suspend their account where if they log in, they are taken to a payment page.

- Anything else that may come up as fine tuning during project.

Feel free to grab inspiration from sites such as:
http://woot.wikia.com/wiki/Woot-Off_Checkers
http://www.bagsofcrap.com/
http://www.woottracking.com/

Thank you for reading about this project.
Please take note of the following:
DO NOT BID on this project of you don’t have positive feedback.
DO NOT BID on this project if you want paid without/before finishing the job.
DO NOT BID on this project if you want paid without doing good work.

We have positive feedback which shows we are serious, easy to work with and pay on the spot.

Also be advised that we run many projects and this is our step back into outsourcing.
Once we have a reliable, self managed, affordable ASP and Web designer, we will be able to outsource more projects to you.

When you bid, please include links to existing work similar to this project.

Please, Please, Please…. Read the requirements of the project in full and make sure you understand what woot, woot off, bags of crap are before bidding….then bid away and let’s start working together and growing.

Please don’t bid or contact us to let us know how great your company is and how you could do so much of a better job for more money.

The objective of this project is to rebuild and redesign Wootpro.com which is a Woot Tracking Website.

There is existing code for the site however we wish for it to be used only as reference and prefer a complete recode of the site.
The site needs to be coded in ASP and capable of running on a Windows 2003/IIS server with the utilization on a MySQL backend if needed and utilizing CSS.
The code needs to be clean and optimized to minimize server and bandwidth utilization.
The site also needs to be cross browser compatible, and search engine optimized as best as possible (We realize this is not an SEO project).

Feature requirements for the site:

- The site is primarily advertising and donation supported.
Each page/section needs to be able to display up-to 8 different ads including Google ads optimized to show ads relevant to the current product on Woot.com.
Each ad zone needs to be configurable within an admin panel to refresh as different intervals, track displays, track clicks and add/remove/enable/disable ads.
Contextual & Inline ads need to be able to display for all text located on the site including item description.

- The information displayed on the site needs to be refreshed within a certain time variable configured in an admin panel.
The page should not need to reload to refresh the information, but only sections whose information has changed should refresh (possible Ajax)

- The site needs to be able to detect a woot off and change settings dynamically in this situation.
The refresh rate of the above sections need to go into Wootoff mode and based on settings in admin panel.

- The site needs to play an audio file for 4 scenarios, each with its own audio:
New woot item.
Woot item at or below 2%.
Woot item sold out.
Bag of crap woot item (in the instance, it will also need to open a new page with the order page for item being sold on woot.com) for paying members.
Audio files should only play once for each instance except for paying members who should be able to configure when the files play, and how often.
The page should also be able to grab focus of the screen, a feature which can be enabled by paying members.

- The site will need to have multiple pages contained in navigation tabs including:
+ Main page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Description of item formatted as it is on Woot.com.
Link to discuss item on woot.com
Sale stats snapshot as shown on woot.com with ability to click and expand without leaving site/page.
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
Statistics of current item being sold during previous sales.
+ Mini tracker page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+ Text only tracker page containing:
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+past items page as seen here with full statistics:
http://www.bagsofcrap.com/past-items/past-items-100-items.html
and
http://www.bagsofcrap.com/woot-statistics.html
and
http://www.bagsofcrap.com/boc_items/
and
http://www.bagsofcrap.com/predictions.html
+ Contact us page / Advertise here page
+ Signup for membership page:
Give users the ability to signup using PayPal via either monthly or annual membership to be determined later via admin panel.
Once signed up, they will need to have a user panel where they can update their information, opt out of mailings, and customize sections of site as described within project.
+ Existing members page as described above.
*all pages will need to meet the advertising scheme described above.
*all pages need to contain a title showing the % left of current item and its name, visible to search engines.
-Each page needs to have a dynamic link to Digg optimized for current item.
-Site needs to have a common footer display load times, information, copyright and number of active users, number of members on site.
-A link needs to be available to test focus grabbing and audio alerts.

- Backend:
Dynamic .gif or .jpg banners need to be generated displaying an ad for the site and what it’s tracking, and % left to be used by members as forum signatures.
Site needs to automatically and immediately post an ad in the woot forums once a new item is available. You can see this by visiting the woot forums.
Site needs to allow all users to sign up for membership, but allow them to pay for upgrades enabling above features.
Admin Site needs to allow for e-mails sent to all users, paying users.
Site also needs to send a welcome email for each paid, and free users.
An admin panel which allows for management of site and users.
Allows for reporting of users and due payments with ability to e-mail users letting them know their membership is due for renewal and ability to suspend their account where if they log in, they are taken to a payment page.

- Anything else that may come up as fine tuning during project.

Feel free to grab inspiration from sites such as:
http://woot.wikia.com/wiki/Woot-Off_Checkers
http://www.bagsofcrap.com/
http://www.woottracking.com/

Thank you for reading about this project.
Please take note of the following:
DO NOT BID on this project of you don’t have positive feedback.
DO NOT BID on this project if you want paid without/before finishing the job.
DO NOT BID on this project if you want paid without doing good work.

We have positive feedback which shows we are serious, easy to work with and pay on the spot.

Also be advised that we run many projects and this is our step back into outsourcing.
Once we have a reliable, self managed, affordable ASP and Web designer, we will be able to outsource more projects to you.

When you bid, please include links to existing work similar to this project.

Please, Please, Please…. Read the requirements of the project in full and make sure you understand what woot, woot off, bags of crap are before bidding….then bid away and let’s start working together and growing.

I need a php script to parse data from results of search requests similar to this:

http://www.popshops.com/v1/0yp0rj3hqei08nztbslkxco1m/products.xml?catalog_key=8dma5bktzb9bseed24byo2z3w&keywords=ipod+16gb

The results will then be displayed on our online shopping mall website (www.ShoppingMinistry.com). It should display a list of available products and allow customer to sort by name, price etc. It should also allow them to narrow the search by available parameters.

Here are more info about available parameters etc:

Request URL

http://www.popshops.com/v1/0yp0rj3hqei08nztbslkxco1m/products.xml
Required request parameters
Field Value Description
catalog_key string Unique key identifying catalog of merchants: 8dma5bktzb9bseed24byo2z3w
keywords string

A list of keywords to search across your catalog merchants.

keywords=ipod Is a basic search for products containing the keyword ‘ipod’

keywords=ipod -case is a search for products containing the keyword ‘ipod’ and NOT containing the keyword ‘case’
Optional request parameters
Field Value Description
merchant_id integer A unique PopShops merchant_id, limiting products to a single merchant
merchant_type_id integer A unique merchant_type_id limiting products to a single merchant_type.
category_id integer A PopShops category ID, limiting products to a single merchant’s category. Category ids are currently only returned in product query responses.
brand_id integer A PopShops brand_id, limiting products to a single brand
price_min decimal
10.00,19.95, etc
Price minimum product prices should not go below
price_max decimal
10.00,19.95, etc.
Price maximum product prices should not exceed
product_sort name_asc
name_desc
price_asc
price_desc Featured (default), Name (A-Z), Name (Z-A), Lowest Price, Highest Price
product_limit 1-100 Number of products to display at a time. 100 maximum.
product_offset integer Number to offset the product results by
include_deals boolean
1 or 0
Available deals can also be included in the result set that match returned products and merchants.
url_subid string Custom subid/sid to be appended in any final affiliate product urls.
Response fields
Field Description
search_results Contains all of the query responses. Attributes:

* keywords: any keywords passed in
* product_limit: any product_limit passed in
* product_offset: any product_offset passed in
* merchant_id: any merchant_id passed in
* category_id: any category_id passed in
* brand_id: any brand_id passed in
* product_sort: any product_sort passed in
* price_min: any price_min passed in
* price_max: any price_max passed in
* merchant_type_id: any merchant_type_id passed in

products Contains products matching the query parameters. Attributes:

* total_count: Total number of products matching the query parameters

product Contains an individual product. Attributes:

* name: The name of the product
* description: The description of the product
* merchant_id: The merchant_id for the merchant the product belongs to.
* large_image_url: A url for the largest sized image available for the product.
* medium_image_url: A url for a medium sized image of the product.
* small_image_url: A url for a small sized image of the product.
* merchant_price: The price offered through the merchant. Usually corresponds to the lowest price.
* retail_price: The listed retail price of the product.

price_ranges Contains price_ranges for products matching the query parameters.
price_range Contains an individual price_range. Attributes:

* max: The max dollar value in the range
* min: The min dollar value in the range
* product_count: The number of products within this price range.

merchants Contains top merchants for products matching the query parameters. In many cases the number of merchants matching the query is too many to bring back, so this will only bring back the top 50 merchant matches by product count. You may encounter results where you get a product on a page and there is no matching merchant in the merchants node.
merchant Contains an individual merchant. Attributes:

* id: A unique id for the merchant. You can pass this in as a merchant_id to filter products to this specific merchant.
* name: The name of the merchant.
* product_count: The number of products matching the query for this specific merchant.
* logo_url: If available a logo_url will be provided which is a url to small thumbnail of a logo for the merchant.
* url: If available the url will be returned, which is a landing page for this merchant.
* merchant_type_id: If the merchant belongs to a merchant_type, this will be the id for the merchant_type. This can be used to further filter products as a merchant_type_id parameter.

merchant_types Contains top merchant_types for products matching the query parameters.
merchant_type Contains an individual merchant_type. Attributes:

* id: A unique id for the merchant_type. You can pass this in as a merchant_type_id to filter products to this specific merchant_type.
* name: The name of the merchant_type.
* product_count: The number of products matching the query for this specific merchant_type.

brands Contains top brands for products matching the query parameters.
brand Contains an individual brand. Attributes:

* id: A unique id for the brand. You can pass this in as a brand_id to filter products to this specific merchant_type.
* name: The name of the brand.
* product_count: The number of products matching the query for this specific brand.

suggested_merchants If the keywords match any merchant names, or have been tagged by PopShops as belonging to a specific merchant, this node will return any merchants that may be possible matches. This node will have child merchant nodes with attributes available on normal merchant nodes.
deals Contains deals available for products,merchants, and suggested merchants matching the query. Attributes:

* restrictions: Global restrictions that apply to any deal returned.

deal Contains an individual deal. Attributes:

* name: The name of the deal.
* description: A description of the deal.
* url: The redirect url for the deal.
* image_url: If an image is available for the deal, this will be a url for that image.
* specific: This is a boolean (true/false) indicating whether the deal is specific to a product, or applies to all products from the merchant.
* start_on: The start date the deal is valid.
* end_on: The end date the deal is no longer valid.
* code: Any associated code for the deal. This is a code that would need to be used to redeem the deal.
* deal_type_ids: The deal_type id indicating what kind of deal this is.
* restrictions: Any applicable restrictions unique to this deal or merchant.
* merchant_id: A unique id for the merchant.
* merchant_type_id: The id of the merchant_type the merchant of this deal belongs to.

The budget for this project is $100.00 USD max.
Please don’t bid or contact us to let us know how great your company is and how you could do so much of a better job for more money.

The objective of this project is to rebuild & redesign Wootpro.com which is a Woot Tracking Website.

There is existing code for the site however we wish for it to be used only as reference and prefer a complete recode of the site.
The site needs to be coded in ASP and capable of running on a Windows 2003/IIS server with the utilization on a MySQL backend if needed and utilizing CSS.
The code needs to be clean and optimized to minimize server and bandwidth utilization.
The site also needs to be cross browser compatible, and search engine optimized as best as possible (We realize this is not an SEO project).

Feature requirements for the site:

- The site is primarily advertising and donation supported.
Each page/section needs to be able to display up-to 8 different ads including Google ads optimized to show ads relevant to the current product on Woot.com.
Each ad zone needs to be configurable within an admin panel to refresh as different intervals, track displays, track clicks and add/remove/enable/disable ads.
Contextual & Inline ads need to be able to display for all text located on the site including item description.

- The information displayed on the site needs to be refreshed within a certain time variable configured in an admin panel.
The page should not need to reload to refresh the information, but only sections whose information has changed should refresh (possible Ajax)

- The site needs to be able to detect a woot off and change settings dynamically in this situation.
The refresh rate of the above sections need to go into Wootoff mode and based on settings in admin panel.

- The site needs to play an audio file for 4 scenarios, each with its own audio:
New woot item.
Woot item at or below 2%.
Woot item sold out.
Bag of crap woot item (in the instance, it will also need to open a new page with the order page for item being sold on woot.com) for paying members.
Audio files should only play once for each instance except for paying members who should be able to configure when the files play, and how often.
The page should also be able to grab focus of the screen, a feature which can be enabled by paying members.

- The site will need to have multiple pages contained in navigation tabs including:
+ Main page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Description of item formatted as it is on Woot.com.
Link to discuss item on woot.com
Sale stats snapshot as shown on woot.com with ability to click and expand without leaving site/page.
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
Statistics of current item being sold during previous sales.
+ Mini tracker page containing:
Woot off indicator.
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Picture of item (clickable to enlarge without leaving site/page).
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+ Text only tracker page containing:
Current woot item.
Price of item.
Shipping for item.
Condition of item.
Availability of item (100%….to sold out) or none listed if no woot off.
Link to discuss item on woot.com
Button to order item linking to order url.
Estimated sellout time (needs to be accurate).
+past items page as seen here with full statistics:
http://www.bagsofcrap.com/past-items/past-items-100-items.html
and
http://www.bagsofcrap.com/woot-statistics.html
and
http://www.bagsofcrap.com/boc_items/
and
http://www.bagsofcrap.com/predictions.html
+ Contact us page / Advertise here page
+ Signup for membership page:
Give users the ability to signup using PayPal via either monthly or annual membership to be determined later via admin panel.
Once signed up, they will need to have a user panel where they can update their information, opt out of mailings, and customize sections of site as described within project.
+ Existing members page as described above.
*all pages will need to meet the advertising scheme described above.
*all pages need to contain a title showing the % left of current item and its name, visible to search engines.
-Each page needs to have a dynamic link to Digg optimized for current item.
-Site needs to have a common footer display load times, information, copyright and number of active users, number of members on site.
-A link needs to be available to test focus grabbing and audio alerts.

- Backend:
Dynamic .gif or .jpg banners need to be generated displaying an ad for the site and what it’s tracking, and % left to be used by members as forum signatures.
Site needs to automatically and immediately post an ad in the woot forums once a new item is available. You can see this by visiting the woot forums.
Site needs to allow all users to sign up for membership, but allow them to pay for upgrades enabling above features.
Admin Site needs to allow for e-mails sent to all users, paying users.
Site also needs to send a welcome email for each paid, and free users.
An admin panel which allows for management of site and users.
Allows for reporting of users and due payments with ability to e-mail users letting them know their membership is due for renewal and ability to suspend their account where if they log in, they are taken to a payment page.

- Anything else that may come up as fine tuning during project.

Feel free to grab inspiration from sites such as:
http://woot.wikia.com/wiki/Woot-Off_Checkers
http://www.bagsofcrap.com/
http://www.woottracking.com/

Thank you for reading about this project.
Please take note of the following:
DO NOT BID on this project without reading full details.
DO NOT BID on this project if you are simply telling us about your company.
DO NOT BID on this project of you don’t have positive feedback.
DO NOT BID on this project if your don’t speak fluent English.
DO NOT BID on this project if you can’t deliver the final product within 30 days.
DO NOT BID on this project if you want paid without/before finishing the job.
DO NOT BID on this project if you want paid without doing good work.
DO NOT BID on this project if you expect to be paid more than the budget.

We have positive feedback which shows we are serious, easy to work with and pay on the spot.
Also be advised that we run many projects and this is our step back into outsourcing.
Once we have a reliable, self managed, affordable ASP & Web designer, we will be able to outsource more projects to you.

When you bid, please include links to existing work similar to this project.
Please, Please, Please…. Read the requirements of the project in full and make sure you understand what woot, woot off, bags of crap are before bidding….then bid away and let’s start working together and growing.

We are currently rebuilding a site currently active which searches through an SQL database of video and audio clips. The main method of searching the system is via keyword. We need to have it modified so that the results are displayed based on relevancy, similar to Google.

To clarify, currently in the system if a user searches using the entry ‘holiday toys’ the system provides results of ALL assets containing either one of the search words (holiday OR toys in this case). Instead, what SHOULD happen is first in the results should be any commercial containing BOTH words, then afterwards, spots should be listed containing just one or the other.

Essentially we want to use the Google approach, where the results are listed based on relevancy to the search.

Quick example: 3 keywords searched:

Results listing in order:
1.Results containing all 3 keywords
2.Results containing any 2 of the 3 keywords
3.Results containing any 1 of the 3 keywords

Each asset has multiple attribues in the DB (director, agency, category, etc. The system is correctly searching all of these fields. The search needs to utilize all field when doing the relevancy ranking.

Looking for a developer who can do this right away, and has experience in RELAVANCY based searching.

Note: This system is Windows 2008 server, PHP with MSSQL 2008, NOT mySQL.

Thanks, and please leave any questions in PMB

Background

For this assignment, you complete a program to play the game of “Twenty-one” (also called “Blackjack”).

The general idea of Twenty-one is as follows. There are two players, the customer and the dealer. The dealer deals a card face down to the customer, then a card face up to herself (the up-card), then another card to the customer and another card to herself, both face down. In most cases, the customer may then ask for more cards, one at a time. The dealer does the same, and the hand is resolved. The object of the game is to be dealt a set of cards whose total value is as close to 21 as possible without going over.

Cards are dealt from a deck of 52. There are four cards in the deck with value 2, four with value 3, and so on up to value 9; there are sixteen cards with value 10 (four 10′s and twelve face cards: four jacks, four queens, and four kings); and there are four cards (“aces”) whose value may be either 1 or 11 depending on the value of a player’s remaining cards. For both players, an ace counts 11 unless the hand total is more than 21, in which case it counts 1.

For our purposes, the actual play of the game proceeds as follows. Each player receives two cards as described above. If the dealer’s cards total 21