Need to add the product import functionality to our ecommerce platform.
The script must import csv product list into the database (proper handling of csv quoting is required), the column names are in the first line of the csv feed.
The feed is required to contain products_name field, it may contain a number of other product fields (description, UPC code etc) and attribute fields (see below).
Each product is uniquely identified by name (need case-insensitive match).
Each product may have multiple models with different attributes (color, size etc), the attribute set is arbitrary. The model is uniquely identified by product name and values of all its attributes. The attributes are passed in csv fields called attr_xxxxx e.g. attr_color etc, the csv feed may contain arbitrary number of different attribute fields or may contain no attributes at all.
The lists of attribute names and values are stored in separate database tables, the script must check whether the attribute already exists and add it to the table if it doesn't. The attribute names/values are case-insensitive.
The existing and/or duplicate products/models must NOT be overwritten, a warning should be issued on each duplicate.
FTP access to the development server will be granted.
P.S. We've got a lot more development to be done - if you complete this project clean and fast we'll offer you a lot of other stuff to do.