[FREE TUTORIAL] Filtering by country on the order list

[NemoPS]

Hi everybody!

I just finished writing a tutorial on how to add a 'country' column in the orders list, so that you can then filter orders using it, and know from where they came from without having to inspect them one by one.

 

Here it is:

 

http://nemops.com/filter-by-country-prestashop-order-list/

 

Hope you find it useful!

Cheers!

[karthiiiiiiiiiik]

hi nemo how can i do the filtering of the order page for COD payment automatically...

[NemoPS]

you can try adding a column like a.module, then you can filter the table using "cashondelivery"

[karthiiiiiiiiiik]

Hi nemo,

 

If i am adding a column like module and then i can do the filter , but i want to show only the cash on delivery with out using the filter click event. I want to do the filtering of cash on delivery payment automatically ..?

[NemoPS]

ah well in that case just use WHERE a.module = 'cashondelivery' in the where clause (you probably won't need WHERE)

[karthiiiiiiiiiik]

where i need to apply a.module = 'cash on delivery' in the select statemt are in the left join statement.

[karthiiiiiiiiiik]

how to do select wiht where in prestashop $this->_select  statement in prestashop

[NemoPS]

Try adding something like 

 

$this->_where = 'a.module = "cashondelivery"';

 

after the join

[karthiiiiiiiiiik]

i have put after the join statement but it show bad sql query : 

 

• Bad SQL query
  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a.payment = "Cash on delivery" ORDER BY a.id_order DESC LIMIT 0,300' at line 20

if i put for a.module also i am getting the bad sql query error message

 

Nemo can you please check and tell me.. i have tried a lot but shows mysql syntax error.

Edited September 2, 2014 by karthiiiiiiiiiik (see edit history)

[NemoPS]

Can you show us the whole query?

[karthiiiiiiiiiik]

Hi nemo,

 

Thank you for your suggestion, i have done sql query to work correctly...

[nikmagnus]

Hi Nemo,

 

Could you tell me the areas to change to display the email address of the order.

Thanks in advance

 

Nik 

[NemoPS]

You should try to get c.email from the query, then display it as with countries, like mentioned in the  tutorial