Magento – Export Product CSV with Tier Price

dataflowexportproducttierprice

I would like to create a CSV with product default data and also tier price.

Is it possible to use DataFlow ?

In alternative I would like to use a custom script with direct query to DB, can you help me create this query ?

Best Answer

Here is the script I use:

    //Magento export tier price of all product to csv
require_once 'app/Mage.php';
umask(0);
Mage::app('default');

header("Content-type:text/octect-stream");
header("Content-Disposition:attachment;filename=data.csv");

$tableName = Mage::getSingleton('core/resource')
 ->getTableName('catalog_product_entity_tier_price');
$storeId    = Mage::app()->getStore()->getId();
$product    = Mage::getModel('catalog/product');
$products   = $product->getCollection()->addStoreFilter($storeId)->getAllIds();

$fieldname = array("store","websites","attribute_set","type","sku","name","tier_price_website","tier_price_customer_group","tier_price_qty","tier_price_price");
print stripslashes(implode(',',$fieldname)) . "\n";
foreach($products as $productid)
{
$existingTierPrice = $product ->load($productid)->tier_price;
$sku = $product->getSku();
$name = $product->getName();
foreach($existingTierPrice as $key=>$value)
{
$tierarray = array("admin","base","Default","simple",$sku,$name,"all","all",$value['price_qty'],$value['price']);
print stripslashes(implode(',',$tierarray)) . "\n";
}
}

Courtesy of http://developerafroz.blogspot.com/2011/05/magento-export-tier-price.html

Related Solutions

Magento – Saving product deletes tier price and group price

you should never call save without calling load first on a product instance.
A save without a load (on a product from a collection for example) will lead to loss of data.
If you only want to update a single attribute value for a product do this:

Mage::getSingleton('catalog/product_action')->updateAttributes(
    array($attributeId),
    array('attribute_code' => 'attribute_value'),
    $storeId
);

$storeId is the storeview for which you want to update the value. For default values use 0.

Magento 2.1 – How to Show Tier Price in Catalog Page

You can add tier prices from admin panel.

Navigate to Admin Panel > Catalog > Product > Add/Edit Product > Advance Pricing (below price input box) > Tier Price > Add

Magento shows tier price in product view page by default. If you want to show tier price in product list page then put below code in your list.phtml file where you want to show tier price.

if($_product->getTierPrice()){
    $tier_price = $_product->getTierPrice();
    foreach ($tier_price as $key => $value) {
        $qty = (int)$value['price_qty'];
        $price = $value['price'];
        $formattedPrice = $this->helper('Magento\Framework\Pricing\Helper\Data')->currency(number_format($price, 2), true, false);
        $savePercentageFormat = ceil(100 - ( (100 / $_product->getPrice())* $value['price']) ) ."%";

        echo "Buy $qty for ".$formattedPrice." each and save ".$savePercentageFormat;
        echo "<br>";
    }
}

Best Answer

Related Solutions

Magento – Saving product deletes tier price and group price

Magento 2.1 – How to Show Tier Price in Catalog Page

Related Topic