Product Link 2



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:

Or (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.


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


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.

Skills: MySQL

See more: www toysrus com, www petco com, www officedepot com, www meijer com, www macys com, www kw com, www homedepot com, walmart apply, petco . com, petco com, officedepot com, officedepot, meijer, macys com, levels 2, kmart auto, create a free sports website, black wireless, at kmart, sports direct, abhi, product printer, product listings, new product name

Project ID: #5365161

Awarded to:


Hired by the Employer

$85 USD in 4 days
(54 Reviews)