Đang Thực Hiện

150759 product import script

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.

Thanks

Jim

Kỹ năng: Bất kì công việc gì, MySQL, PHP

Xem thêm: name product description, mysql database models, description product development, product feed, match product, jim, import mysql, import access database php, duplicate table, csv product import, php import project, script warning, upc php, column already exists, need product name, granted code, mysql stuff, php mysql import script, attribute import, mysql attributes, product table, check table mysql script, script clean list, product match, code import csv access

Về Bên Thuê:
( 1 nhận xét ) NYC,

Mã Dự Án: #1896938

Đã trao cho:

syberlan

We can write such script for you.

$50 USD trong 3 ngày
(9 Đánh Giá)
2.7