Question: We load the following code to show the payment method inside the Sales/Order grid.

But this displays the payment code and we want to display the payment title.

How can we change our current code to show the title?

CODE:

```
$select->joinLeft(array('payment' => $collection->getTable('sales/order_payment')), 'payment.parent_id=main_table.entity_id', array('payment_method' => 'method'));

```

CODE filterPaymentMethod:

```
public function filterPaymentMethod($collection, $column)
{
    if (!$value = $column->getFilter()->getValue()) {
        return $this;
    }

    $collection->getSelect()->having(
        "group_concat(`sales_flat_order_item`.sku SEPARATOR ', ') like ?", "%$value%");

    return;
}

```

Answer: 
Create a directory app/i18n/Vendorname/en\_US(If not there presently)

**Run command:**

```
bin/magento i18n:collect-phrases --output "app/i18n/Vendorname/en_US/en_US.csv" --magento

```

Now this command actually collect all the translatable phrases in csv file and place it in the specified path. Make changes to the csv file as per your requirement and when ready issue command:

```
bin/magento i18n:pack app/i18n/Vendorname/en_US/en_US.csv -d en_US

```

This will deploy the translations from your file.

clear the cache etc and you can see your changes.
**"Buy %1 for %2 each and","Koop %1 voor %2 elk en"**

save and cache clean check