Magento – Import Tier prices using CSV

You can use this extension. This is a free and best among the available. If you can afford paid extensions, there are plenty of em.

So if you use the above extension:

1. modify Price.php in module Block\Catalog\Layer\Filter.
2. change setMinPrice() and setMaxPrice()

change $this->_minPrice = $this->_productCollection->getFirstItem()->getPrice();

to $this->_minPrice = $this->_productCollection->getFirstItem()->getTierPrice();

note: didn't test it. If you have problems revert back.

First, yes this can be done with Magento's Import / Export without the use of any extension.

Second, I would recommend taking one product, adding some related products to it in the Magento Admin, saving the product then exporting to CSV (System -> Import/Export -> Export).

You will notice two columns; _links_related_sku and _links_related_position

You will need to fill in those columns with the appropriate SKU. Please remember that each related product will need to be entered in a separate row (see screenshot).

This can be also done for crosssells and upsells.