Closed

Magento Import Script

This project received 12 bids from talented freelancers with an average bid price of $450 AUD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 AUD
Total Bids
12
Project Description

I need a PHP script written that will do the following:

1) grab a CSV file from a remote http location
- CSV file will contain the following fields:
- product_url, product_id, product_name, price, sale_price, description, category, image

2) Create new table named: "product_import" .
- script should set the status of all product records to disabled
- update all records based on product_id
- set status to "enabled" if product from csv exists in table
- insert any new records

3) script should create a standard Magento csv import file from all records in product_import table
- product_url should be a new product attribute: product_url
- product_id = sku
- product_name is product name
- price = price
- sale_price = special_price
- category = category (not using category_ids, I have a modified import process)
- image = image, small_image, thumbnail
- include status from table in Magento import file

the following extension will be used to enable category names instead of id's
[url removed, login to view]

4) Magento import file to be placed in var/import

5) file must be tested to import successfully

6) script must contain variables for all valid Magento csv fields in order to allow easy modification of values being inserted

7) script must be well commented with clean & easy to understand code

8) script must send an email summary of the following data:
- current server time
- number of records in remote file
- number records updated
- number of records inserted
- number of records added to Magento import file

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online