Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sort Customers


sergetaran

Recommended Posts

http://freebible.us/admin/customers.php?se...d_box=customers

 

I'm checking always new customers, if their info is proper and complete.

 

It is gettring impossible to do, as the number grows.

 

Is it possible to add Sorting capabilities by the Date joined ?

 

Any suggestion for a quick-fix ?

 

Any feedback?

 

 

 

Thank you!

Link to comment
Share on other sites

try customer list improved, it sorts by:

- date registered

- last name

- first name

- last login

- # of logins

- state / province

 

http://www.oscommerce.com/community/contri...eaner+customers

 

 

i would also advise to delete your admin url ;) you're asking for a cracker to try and get into your site :)

 

 

and i'm not sure if they fixed it yet, but if you do not currently use the "admin notes" contribution, you will have to do some minor editing to get THIS contribution to work properly :)

Link to comment
Share on other sites

try customer list improved, it sorts by:

- date registered

- last name

- first name

- last login

- # of logins

- state / province

 

http://www.oscommerce.com/community/contri...eaner+customers

i would also advise to delete your admin url ;) you're asking for a cracker to try and get into your site :)

and i'm not sure if they fixed it yet, but if you do not currently use the "admin notes" contribution, you will have to do some minor editing to get THIS contribution to work properly :)

 

Thanks a lot!

Link to comment
Share on other sites

Thanks a lot!

After installation of this mode I got this:

 

Customers Search:

 

Actions Last Name First Name Created Last Login Logins Phone D.O.B. State/Province Notes Action

1054 - Unknown column 'c.customers_notes' in 'field list'

 

select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_notes as notes, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, z.zone_name as state, ctry.countries_iso_code_2 as country, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_info ci on c.customers_id = ci.customers_info_id left join countries ctry on a.entry_country_id = ctry.countries_id left join zones z on a.entry_zone_id = z.zone_id order by c.customers_lastname ASC, c.customers_firstname ASC limit 0, 20

 

[TEP STOP]

 

===

 

Any suggestions?

 

Thank you!

Link to comment
Share on other sites

you don't have the admin notes installed (see my warning above :P )

 

i found it to be easier to simply install it rather than hack the contribution: http://www.oscommerce.com/community/contri...rch,admin+notes (a very quick install)

 

 

it's actually a rather useful contribution! you can use it for other things instead of just notes about customers (how nasty they were with your support team, warnings or schedules about the customers' next order, etc.)

 

you can use it as basically "post-its" for other important infos, etc that relate to your shop

 

 

i use it myself to keep a record of all advertising expenses, any losses/chargebacks, etc

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...