Placing a URL in the product descriptions

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.6
-- PHP version -- : 5.6.34
-- Browser(s) name and version -- : opera 51.0.2830.55

Hi,
we have 2 licenced Hikashop sites and would like to include a standard clickable URL in the description field of one of the sites to the other. This so we only have to have one working checkout (we also have 2 separate physical shops).

We'd prefer to do this as a mass action and would like to know how to format the string (we know how to do text only).

Many thanks,
Ian and Stu

Hi,

The mass actions system allows you to concatenate strings in the "update the values" action in operation mode, but it doesn't allow for HTML, for security reasons.
So I'm afraid you'll have to do that with a MySQL query in your PHPMyAdmin.
It's however quite easy... Something like that:
UPDATE #__hikashop_product SET product_description = CONCAT(product_description, 'MyHTML');

Hi,
I'll get someone to do this for use but would our new description with the link in it replace 'MyHTML' in your example?

Thanks,
Ian and Stu

Hi,

Since it's a concatenation, what you put instead of "MyHTML" will be added at the end of the product_description you already have in each product.

Hi,
it comes back with a syntax error when I just try the word 'test' instead of 'MyHTML'.

Regards,
Ian and Stu

Hello,

What syntax error ?
You can "concat" any content you want but you need to be sure that the content is right escaped and between quotes.
Do not hesitate to look for some MySQL documentation or tutorial to escape and quote your content correctly.

Regards,

Hi,
it's;

#1064 - 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 '' at line 1

I'll ask a friend who know a bit about sql to take a look.

Thanks,
Ian and Stu

Hello,

near '' at line 1

It means that you have quotes in your content and you need to escape it.
Generally, we recommend you use backslashes.
stackoverflow.com/questions/887036/how-t...ngle-quotes-in-mysql

Regards,

Hi,
escaping the characters results in the same error. If I select 'update' from the phpadmin interface it gives me;

UPDATE `mus_hikashop_product` SET `product_description`=[value-4] WHERE 1

Can I adapt this?

Thanks,
Ian and Stu

Hi,

It's the same in PHPMyAdmin:
UPDATE `mus_hikashop_product` SET `product_description`=concat(product_description, 'MyHTML') WHERE 1

Thanks Nicolas. That worked!

Kind regards,
Ian and Stu