1 ) DAILY IMPORT SCRIPT
daily php driven, cron script that:
a) pulls datafeed from different url, unzipping from gzip or zip in process
b) deletes previous data in table
c) imports todays data to mysql
e) emails an alert if it couldn't access feed, or feed empty, or import failed.
Feed sample attached. I'd like all the columns imported, incase I want more cols used later.
A url that can trigger the script manually too, in case no-cron available.
2) WORDPRESS DISPLAY RELATED ITEMS WIDGET
This script would pull items from the imported data table, to a Wordpress detail page, based on search criteria of key words in the article title.
The script would prepare an intelligent search of the imported data, that excludes certain generic words, that would be configurable.
Order items by price, limiting to X items.
If no trigger terms found related to article, would pull items based on a default search criteria, that is configurable.
It would display items elegantly in wordpress detail page below the Body text. Displays:
Product Image | Product name, description | manufacturer | Merchant | Price RRP | Today Price | link
IF RRP is empty don't display. Trim description.
You would be responsible for html/css of the item displaying.
Configurable elements don't necessarily have to be in Wordpress they could simply be in a config file.
6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön