Skip to main content
edited body
Source Link

I want to export order report in csv.

With following content

Order Date
Order Day
Order Id
Ip Address
Customer Name
Customer Group
Billing Name
Billing Address
Billing City
Billing Postcode
Billing State
Billing Country
Billing Country Code
Billing Email Address
Billing Phone No
Billing Mobile No
Shipping Name
Shipping Address
Shipping City
Shipping Postal Code
Shipping State
Shipping Country
Shipping Country Code
Shipping Email Address
Shipping Telephone No
Shipping Mobile No
Tracking Company Name
Tracking No
Tracking Url
Marketplace Type
Payment Type
Payment Transaction Id
Marketplace ID
Product Title
Category Name
Brand Name
Weight
Quantity
Product Price
Gross Total
Discount Amount
Gross Amount After Discount
Shipping Cost
Tax Amount
Tax Name
Net Amount
Order Status
Last Activities

I tried this code for Ip address in Mage_Adminhtml_Block_Widget_Grid and function _prepareCollection()

$this->addColumn('remote_ip', array(
        'header'=> Mage::helper('sales')->__('Ip address'),
        'width' => '80px',
        'type'  => 'text',
        'index' => 'remote_ip',
    ));

But it is not showing anything in Ip address field.

What to doAny help?

I want to export order report in csv.

With following content

Order Date
Order Day
Order Id
Ip Address
Customer Name
Customer Group
Billing Name
Billing Address
Billing City
Billing Postcode
Billing State
Billing Country
Billing Country Code
Billing Email Address
Billing Phone No
Billing Mobile No
Shipping Name
Shipping Address
Shipping City
Shipping Postal Code
Shipping State
Shipping Country
Shipping Country Code
Shipping Email Address
Shipping Telephone No
Shipping Mobile No
Tracking Company Name
Tracking No
Tracking Url
Marketplace Type
Payment Type
Payment Transaction Id
Marketplace ID
Product Title
Category Name
Brand Name
Weight
Quantity
Product Price
Gross Total
Discount Amount
Gross Amount After Discount
Shipping Cost
Tax Amount
Tax Name
Net Amount
Order Status
Last Activities

I tried this code for Ip address in Mage_Adminhtml_Block_Widget_Grid and function _prepareCollection()

$this->addColumn('remote_ip', array(
        'header'=> Mage::helper('sales')->__('Ip address'),
        'width' => '80px',
        'type'  => 'text',
        'index' => 'remote_ip',
    ));

But it is not showing anything in Ip address field.

What to do?

I want to export order report in csv.

With following content

Order Date
Order Day
Order Id
Ip Address
Customer Name
Customer Group
Billing Name
Billing Address
Billing City
Billing Postcode
Billing State
Billing Country
Billing Country Code
Billing Email Address
Billing Phone No
Billing Mobile No
Shipping Name
Shipping Address
Shipping City
Shipping Postal Code
Shipping State
Shipping Country
Shipping Country Code
Shipping Email Address
Shipping Telephone No
Shipping Mobile No
Tracking Company Name
Tracking No
Tracking Url
Marketplace Type
Payment Type
Payment Transaction Id
Marketplace ID
Product Title
Category Name
Brand Name
Weight
Quantity
Product Price
Gross Total
Discount Amount
Gross Amount After Discount
Shipping Cost
Tax Amount
Tax Name
Net Amount
Order Status
Last Activities

I tried this code for Ip address in Mage_Adminhtml_Block_Widget_Grid and function _prepareCollection()

$this->addColumn('remote_ip', array(
        'header'=> Mage::helper('sales')->__('Ip address'),
        'width' => '80px',
        'type'  => 'text',
        'index' => 'remote_ip',
    ));

But it is not showing anything in Ip address field.

Any help?

Source Link

Export report not showing fields

I want to export order report in csv.

With following content

Order Date
Order Day
Order Id
Ip Address
Customer Name
Customer Group
Billing Name
Billing Address
Billing City
Billing Postcode
Billing State
Billing Country
Billing Country Code
Billing Email Address
Billing Phone No
Billing Mobile No
Shipping Name
Shipping Address
Shipping City
Shipping Postal Code
Shipping State
Shipping Country
Shipping Country Code
Shipping Email Address
Shipping Telephone No
Shipping Mobile No
Tracking Company Name
Tracking No
Tracking Url
Marketplace Type
Payment Type
Payment Transaction Id
Marketplace ID
Product Title
Category Name
Brand Name
Weight
Quantity
Product Price
Gross Total
Discount Amount
Gross Amount After Discount
Shipping Cost
Tax Amount
Tax Name
Net Amount
Order Status
Last Activities

I tried this code for Ip address in Mage_Adminhtml_Block_Widget_Grid and function _prepareCollection()

$this->addColumn('remote_ip', array(
        'header'=> Mage::helper('sales')->__('Ip address'),
        'width' => '80px',
        'type'  => 'text',
        'index' => 'remote_ip',
    ));

But it is not showing anything in Ip address field.

What to do?