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