Closed

Product Link 2

This project was awarded to abhius for $85 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$85 USD
Total Bids
1
Project Description

Abhi,

hello. I have another small project for you.

I want to create a cron script that assigns a product_link2 to product listings inside our storeName_data tables.

Explanation: Inside our storeName_data tables (i.e. kmart_data) in the couponqu_parsers2 database we have products that are on sale.

An example would be: couponqu_parsers2 ┬╗Table: kmart_data

ProductName= Canon Pixma MG3520 wireless printer

This product is on sale for $[url removed, login to view]

I would like to help the user locate this product on the kmart website, we dont have direct URLS to kmart (the ones we have are wrong)

In order to help our users find products on kmart website, we are going to provide a link to kmarts site search with the product name our tables OR UPC code from our database


Here is an example of a sample site search on Kmart: http://www.kmart.com/search=Canon%20Pixma%20MG3520%20wireless%20printer?levels=Computers

Or www.kmart.com/search=8331B002 (for UPC)

We have 14 stores to apply this script to.

kmart, walmart, target, radioshack, toysrus, petco, macys, babiesrus, dickssportinggoods, homedepot, meijer, officedepot, sports uthority.



Project:
1.) Create a new field on all storeNAme_data tables inside couponqu_parsers2 and couponqu_parsers2_archive called "product_link2" (efault is varchar500, default=NULL)
1 A.) ONLY add this field to storeNAme_data tables, i.e. cvs_data, apfreshonline_data, NOT parser_categories, nobrands, register, image_data etc. ONLY storeName_data tables

2.) Create new table in couponqu_parsers called "site_search"
2 A.) 3 fields inside site_search id, storeAlias, chainID, base_search

2 B.) id is auto numeric, storeAlias = the values I provided above. kmart, walmart etc, base_search= base_Search from attached spreadsheet. i.e. [url removed, login to view]


3.) Create a script that uses base_search URL combined with:
A.) If UPC in storeName_data table IS NOT = "0" OR "NULL" OR Empty then add UPC to base URL,
B.) If NOT, then add "productName" to base_Search
C.) However, we only add a product_link2 url IF the price is equal to a qualified price.

Qualified price = $[url removed, login to view], unqualified price = 2 for $4, OR buy one get one free.

In other words, only a single price, either $[url removed, login to view], [url removed, login to view], 20, etc

Example:

Radioshack example; productName = Auvio® Cube Bluetooth Speaker - Black

step 1 = check price, in this example, price = $[url removed, login to view] - price is qaulified, move to step 2
Step 2 = check if UPC is not 0, NULL or Empty, in this example it = 2047339943
step 3 - Since we have UPC, then search = [url removed, login to view]

radioshack core search = [url removed, login to view]

combined with UPC = [url removed, login to view]

if we did not have a UPC, then we search by productName

radioshack search = [url removed, login to view]+speaker


The goal at the end is to have search links for the products.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online