product description with no full stops issue

Quote

Post by ianhaney » Fri Apr 21, 2017 5:27 am

Hi

The product description is being pulled in from a excel spreadsheet from a supplier but in the excel spreadsheet the description does not have any full stops so was seeing if there could be a way using php or javascript could automatically add full stops in and after each full stop add a new line, an example of the issue is on the following URL, The site is built using opencart 2.0.3.1

https://www.onestopappliances.co.uk/DOM ... hine-white

Thank you in advance
ianhaney
Active Member
Posts
749
Joined
Sun Jun 24, 2012 2:30 am
Location - GB
Top

Re: product description with no full stops issue

Quote

Post by uksitebuilder » Fri Apr 21, 2017 3:07 pm

https://www.google.co.uk/search?q=excel ... ce+newline
User avatar
uksitebuilder
Guru Member
Posts
7716
Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom
Top

Re: product description with no full stops issue

Quote

Post by ianhaney » Fri Apr 21, 2017 4:50 pm

Is there any other way apart from doing it in the Excel spreadsheet as have altered products since and would overwrite the amendments if had to import the excel spreadsheet again
ianhaney
Active Member
Posts
749
Joined
Sun Jun 24, 2012 2:30 am
Location - GB
Top

Re: product description with no full stops issue

Quote

Post by artcore » Fri Apr 21, 2017 5:17 pm

http://php.net/manual/en/function.nl2br.php

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!

User avatar
artcore
Active Member
Posts
1349
Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands
Top

Re: product description with no full stops issue

Quote

Post by ianhaney » Fri Apr 21, 2017 5:26 pm

Hi artcore

I looked at that link last night but I was unsure what file to modify, I thought it might be the catalog/controller/product/product.php file but in that file I am unsure where to add the coding?
ianhaney
Active Member
Posts
749
Joined
Sun Jun 24, 2012 2:30 am
Location - GB
Top

Re: product description with no full stops issue

Quote

Post by artcore » Fri Apr 21, 2017 7:10 pm

Try the controller:

Code: Select all

$data['description'] = html_entity_decode(nl2br($product_info['description']), ENT_QUOTES, 'UTF-8');
If the description contains no newlines it wouldn't work and you have to change the excel.

Attn: I no longer provide OpenCart extensions, nor future support - this includes forum posts.
Reason: OpenCart version 3+ ;D

Thanks!

User avatar
artcore
Active Member
Posts
1349
Joined
Tue Jul 09, 2013 4:13 am
Location - The Netherlands
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 98 guests