Magento update products special price from CSV file

This project was successfully completed by ronybridge for $15 USD in a day.

Get free quotes for a project like this
Project Budget
$10 - $30 USD
Completed In
1 day
Total Bids
Project Description

I have the following script: [url removed, login to view]

This script reads a csv file and upates the products in the database. At this moment the script parses two columns, first one is the sku and the second one is the price.

I want to be able to update the special price also. The csv will have 5 columns: sku, price, special_price, special_from_date, special_to_date

I searched for a solution and I found the following paid script: [url removed, login to view] (it costs 35 dollars), but I don't need all it's functions. That's why I am searching someone to modify this script: [url removed, login to view] , to work as I described above.


special_price - Special Price, If ‘special_from_date’ & ‘special_to_date’ fields are left empty then price is special for unlimited time period

special_from_date - Special From Date, Date field should be in [YYYY-mm-dd] format. For example: 2012-06-15

special_to_date - Special To Date, Date field should be in [YYYY-mm-dd] format. For example: 2012-08-25

I'm using magento 1.9.* . I want a script that should work on magento versions greater than 1.6+. So this script should work fine on magento: 1.6.*, 1.7.*, 1.8.*, 1.9.*.

The script should work well for thousands of products. I want to be able to update many product prices on a script run, so the script should be optimized to work fast.

Completed by:
Skills Required

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