Project brief:
This project will involve developing a LAMP website that imports data from a URL hosting a CSV data feed file. The objective is to run daily updates on this file for the purposes of generating a store for cycling products on the fly. The phased approach is defined as follows:
Phase 1
1) Export products from a given URL (provided below)
2) Import into a MySQL table
Phase 2
1) PHP script to publish content under the following structure:
Category > Sub Category > Product Listing Page
The product listing page should display:
> Product image
> Product name (product_name)
> RRP Price (rrp_price)
> Price (base_price)
> Product description (product_short_description)
> Product link (aw_deep_link) – displayed as a “Buy Now” button, opens link in new window
> Brand (brand_name)
> Retailer (mechant_name)
> Category (category_name)
Conditions needed:
- If image is not present, do not display the product
- if price is not available, do not display the product
2) Category & Sub Category Mappings:
Brand (brand_name)
Retailer (merchant_name)
Category (category_name) – for this we will need to map duplicates under the following core structure: Road Bikes, Mountain Bikes
Sub Category: Bikes, Clothes, Components, Wheels & Tyres, Nutrition, Accessories (these can be reviewed)
3) > Provided a drop down navigation menu to all categories made in section 2 from the homepage
> Provide a search form for free text search of the product name and product description
Export feed url (this file is attached):
[login to view URL],2698,3361,16305/columns/aw_deep_link,product_name,aw_product_id,merchant_product_id,merchant_image_url,description,merchant_category,search_price,merchant_name,merchant_id,category_name,category_id,aw_image_url,currency,store_price,delivery_cost,merchant_deep_link,language,last_updated,display_price,data_feed_id,brand_id,colour,product_short_description,specifications,condition,product_model,model_number,dimensions,keywords,promotional_text,product_type,brand_name,commission_group,merchant_product_category_path,merchant_product_second_category,merchant_product_third_category,rrp_price,saving,savings_percent,base_price,base_price_amount,base_price_text,product_price_old,delivery_restrictions,delivery_weight,warranty,terms_of_contract,delivery_time,in_stock,stock_quantity,valid_from,valid_to,is_for_sale,web_offer,pre_order,stock_status,size_stock_status,size_stock_amount,merchant_thumb_url,large_image,alternate_image,aw_thumb_url,alternate_image_two,alternate_image_three,reviews,average_rating,rating,number_stars,number_available,custom_1,custom_2,custom_3,custom_4,custom_5,custom_6,custom_7,custom_8,custom_9,ean,isbn,upc,mpn,parent_product_id,product_GTIN/format/csv/delimiter/%7C/compression/gzip/adultcontent/1/
Format: CSV
Compression Type: Gzip (can be changed to Zip)
Delimiter: |