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.
Here is what I have tried and working --

1) First copy and paste `en_US.csv` fie from `vendor/magento/module-catalog/i18n` to your theme directory `app/design/frontend/YourVendor/theme/Magento_Catalog/i18n/en_US.csv`.

2) and then find below lines in above csv file --

```
 Buy %1 for %2 each and <strong class=""benefit"">save<span class=""percent tier-%3"">&nbsp;%4</span>%</strong>","Buy %1 for %2 each and <strong class=""benefit"">save<span class=""percent tier-%3"">&nbsp;%4</span>%</strong>

```

and in this line you can translate `buy` and `save` word.

**don't forget** to clear cache and reindexing via command line.

check below image for what I have tried --

**en\_US.csv file --**

[![enter image description here](https://i.stack.imgur.com/iPWo5.png)](https://i.stack.imgur.com/iPWo5.png)

**product page (frontend) --**

[![enter image description here](https://i.stack.imgur.com/9XQjL.png)](https://i.stack.imgur.com/9XQjL.png)