s08e02 - Per Product FAQs SUPPORT / QUESTIONS / CHAT

[heatherbell]

can you answer the customer from the admin,

No, it is all by email.

[Omar_one]

is there any way to get notifications if the customers send a question,
I know there is admin page to see questions, but some notifications will be perfect

Thank you
Omar

[Omar_one]

@ecartz if some customer ask question in English (on Multilanguage site - English, Finnish language ) , the question not shown admin side (Finnish language)..
I am not sure if this right

[ecartz]

It may not be right, but it's how it has always worked:

Code: Select all

            $faqs_query_raw = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id WHERE cfi.language_id = " . (int)$languages_id . " ORDER BY cf.faq_id DESC";

You could try changing (in admin/includes/actions/faq/views/default.php line 12)

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id WHERE cfi.language_id = " . (int)$_SESSION['languages_id'] . " ORDER BY cf.faq_id DESC";

to

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id AND cfi.language_id = " . (int)$_SESSION['languages_id'] . " ORDER BY cf.faq_id DESC";

I.e. change WHERE to AND.

Of course, that might break other stuff.

Or maybe

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf INNER JOIN (SELECT * FROM clubosc_faq_info ORDER BY language_id = " . (int)$_SESSION['languages_id'] . " DESC LIMIT 1) cfi ON cf.faq_id = cfi.faq_id ORDER BY cf.faq_id DESC";

But again, I haven't tried it.

[Omar_one]

It may not be right, but it's how it has always worked:

Code: Select all

            $faqs_query_raw = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id WHERE cfi.language_id = " . (int)$languages_id . " ORDER BY cf.faq_id DESC";

You could try changing (in admin/includes/actions/faq/views/default.php line 12)

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id WHERE cfi.language_id = " . (int)$_SESSION['languages_id'] . " ORDER BY cf.faq_id DESC";

to

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf LEFT JOIN clubosc_faq_info cfi ON cf.faq_id = cfi.faq_id AND cfi.language_id = " . (int)$_SESSION['languages_id'] . " ORDER BY cf.faq_id DESC";

I.e. change WHERE to AND.

Of course, that might break other stuff.

Or maybe

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf INNER JOIN (SELECT * FROM clubosc_faq_info ORDER BY language_id = " . (int)$_SESSION['languages_id'] . " DESC LIMIT 1) cfi ON cf.faq_id = cfi.faq_id ORDER BY cf.faq_id DESC";

But again, I haven't tried it.

now its shows all the FAQS but when I press on the English ones the side box not show

Capture.JPG

[ecartz]

If you changed the WHERE to AND, you might try the other one (with the INNER JOIN and subselect) instead.

Alternately, if you change your session language to English, it would probably work. In the sense that the English-only infoboxes would show (and the Finnish-only would not).

[Omar_one]

Or maybe

Code: Select all

  $faqs_sql = "SELECT cf.*, cfi.* FROM clubosc_faq cf INNER JOIN (SELECT * FROM clubosc_faq_info ORDER BY language_id = " . (int)$_SESSION['languages_id'] . " DESC LIMIT 1) cfi ON cf.faq_id = cfi.faq_id ORDER BY cf.faq_id DESC";

But again, I haven't tried it.

I just delete

Code: Select all

DESC LIMIT 1

and now it show the side box and the all FAQS ...

Thank you @ecartz

[radhavallabh]

Hi dear;
I am still on 1.0.8.16
When I insert a FAQ from Admin side on multilanguage site in any language;
After inserting it shows up separately in each language in admin and on selecting we get no options to delete or edit it...
Can you please help fix the issue dear;
Thank you in advance;
Warm Regds./
radhavallabh

[Pierre_P]

How to with too many questions?
Its filling up the products page - all relevant questions though.

Is there a simple way to create a view all questions page perhaps for a product and limit the displayed questions to random 5 or so on the products page?

[heatherbell]

How to with too many questions?
Its filling up the products page - all relevant questions though.

Is there a simple way to create a view all questions page perhaps for a product and limit the displayed questions to random 5 or so on the products page?

Just thoughts:
Maybe use Tabs with a Tab for Product FAQs?
Maybe create an Info Page for each Product to list all Product FAQs and show a link to that?
Maybe some questions should already be answered in Product Description?
Maybe some questions should already be answered in a Product Information PDF download?