cancel
Showing results for 
Search instead for 
Did you mean: 

Create a filter off remote_ip

SOLVED

Create a filter off remote_ip

Our Customer Service Dept uses the Magento back end to place phone orders, therefor sales_flat_order.remote_ip = NULL for such orders, and all other "real" orders have a logged IP Address.  Yet I can not find any way to interact with sales_flat_order.remote_ip .  Any help?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Create a filter off remote_ip

Hi Kevin,

When you say you can't find any way to interact with sales_flat_order.remote_ip, do you mean you don't have access to the remote_ip column when building reports?

If you're a Magento BI Pro subscriber, you'll most likely just need to track this column in your sales_flat_order table using your Data Warehouse manager. After tracking the column, you can add it to your metrics so that it will be available as a filter and group by in reports.

If you're a Magento BI Essentials subscriber, the remote_ip is not included with the preset selection of tables and fields that come with your subscription. Typically tracking additional tables and columns would require upgrading to Pro. However I recommend you send an email to support@rjmetrics.com to determine whether or not it is possible to include this field for your particular Essentials subscription.

Hope this helps!
Chris

Chris Schmid
Sr. Product Analyst
Adobe

View solution in original post

1 REPLY 1

Re: Create a filter off remote_ip

Hi Kevin,

When you say you can't find any way to interact with sales_flat_order.remote_ip, do you mean you don't have access to the remote_ip column when building reports?

If you're a Magento BI Pro subscriber, you'll most likely just need to track this column in your sales_flat_order table using your Data Warehouse manager. After tracking the column, you can add it to your metrics so that it will be available as a filter and group by in reports.

If you're a Magento BI Essentials subscriber, the remote_ip is not included with the preset selection of tables and fields that come with your subscription. Typically tracking additional tables and columns would require upgrading to Pro. However I recommend you send an email to support@rjmetrics.com to determine whether or not it is possible to include this field for your particular Essentials subscription.

Hope this helps!
Chris

Chris Schmid
Sr. Product Analyst
Adobe