Price Updates – How to Mass Update Prices Using a CSV File

database-updatepriceproduct-attribute

I am updating around 2500 product prices and I thought I can simply use the import/export function from Magento.

What I´ve done is an export of all products, updated the .csv file and now I want to import all the products again, in small batches of 200-300 products.
For the export I only used the "SKU" and "price" and thats all what I want to import again also.

I´ve used my dev instance to do a test and it worked fine for all 2500 products, besides the fact that it took really long.

Now before I want to use it on my live instance I was wondering if there is anything missing or if anything could go wrong the way i do it.
I´m thinking about Flat Catalog data or will this be ok?

Best Answer

I uploaded the .csv file and after that re-indexed all Indexes and then it was working as expected and the prices were updated so all good. So I recommend

1) Make sure your .csv file is consistent

2) Make a test run on your development site with re-indexing after the upload

3) Do the same steps on the live system, shouldn´t take too long for a few products, and I have split up my 3000 products in 3 parts so 1k products each time.

Related Solutions

Magento – Import Tier prices using CSV

How about Magmi Tier Price Import?

Custom Product Listing Page Filters Not Working – Magento

My suggestion is to look into the Mage_Catalog_Block_Product_List class. I think the problem with the filters not being applied is caused by how you initialize the product collection in the brand helper getProductCollection function.

Maybe you could try doing something like this in your helper:

public function getLayer()
{
    $layer = Mage::registry('current_layer');
    if ($layer) {
        return $layer;
    }
    return Mage::getSingleton('catalog/layer');
}

public function getProductCollection()
{
    $layer = $this->getLayer();

    $brandId = Mage::app()->getRequest()->getParam('brand-id');
    $brand = Mage::getModel('brands/brands')->load($brandId);

    $collection = $layer->getProductCollection()
        ->addAttributeToFilter('supplier_code', $brand->getBrandCode());

    return $collection;
}

Best Answer

Related Solutions

Magento – Import Tier prices using CSV

Custom Product Listing Page Filters Not Working – Magento

Related Topic