Đang Thực Hiện

141631 PHP EXPERT Customize ZenCart

The following is a summary of what needs to be done for this ZenCart project.

Our distributor provides us with two CSV spreadsheets.

One spreadsheet (_detailed) contains a list of all the items that the distributor carries and lots of information about each item. This spreadsheet is update approx every 90 days, and is available to download.

The other spreadsheet (_inventory) contains a list of the items that we are approved to resell, along with current inventory in stock, and our cost price. This spreadsheet is updated in real time and is available to download (via cron).

_detailed CSV structure:

item_no,restricted,burst,msrp,map_price,price_note,brand,brand_logo,segment,category,content_group,headline,packing_slip_desc,bullet_points,mfg_url,upc_code,length,width,height,weight,main_image

_inventory CSV structure:

item_no,price,map_price,qty_available,qty_bo,qty_in_transit

We need you to write a script that will select products from the approved _inventory spreadsheet, match them with the _detailed spreadsheet and populate those items to the ZenCart catalog with the proper category, images, quantity in stock, price (with our retail price mark-up % applied), description, weight (for shipping purposes), etc.

This script will need to be run via cron daily, and also available to be run on demand. Also obviously we need to insert new items, as they become available, check for modified items (if inventory, price, images, description, changes).

The distributor carriers various products, but we are only selling cell phone accessories. So all non-cell phone related products can be ignored. We will help you determine which categories from the distributor spreadsheet will align with our own zencart categories.

From a previous project we have some code that was written by a developer using the same spreadsheets to achieve a similar goal, so it would be useful to review and use this code to your advantage.

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

Xem thêm: price of php developer, height and length, download mysql developer, developer in php code insert, mark catalog, php developer description, select item from, retail catalog, phone accessories, insert brand, customize items, update mysql using csv, update mysql csv php, written accessories, catalog similar item, php insert select, phone inventory php mysql, mysql spreadsheet, spreadsheet insert, php spreadsheet, insert related, php write csv daily, inventory list csv, inventory daily, mysql insert update

Về Bên Thuê:
( 4 nhận xét ) Mississauga, Canada

Mã Dự Án: #1887806

Đã trao cho:

Enayet

Thanks, Enayet

$200 USD trong 7 ngày
(651 Đánh Giá)
8.1