Hello everyone,,
how to add 2 Characters to all products and categories name
like wg- + product namehttps://speedtest.vet/ https://vidmate.bid/ https://123-movies.red/
want to add wg- to all products name.
While the OC version has not been posted, by simply editing your catalog/view/theme/<your_theme>/template/product/product.twig file. Then, to follow this FAQ: viewtopic.php?f=134&t=215776#p718325 .
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
If this is a permanent change, use PHPMyAdmin for this (mind the prefix):
UPDATE oc_product_description SET name = CONCAT('wg-', name)
UPDATE oc_product_description SET name = CONCAT('wg-', name)
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Also take note that updating a database table is based on the data capacity which a server is limited into. If you use a mass amount of products and you'd simply like to add a '-', better to use a replace function in your TWIG file.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
This particular query is extremely simple and will work on basically any amount of products. Usually, only complex queries fail on large number of entries.straightlight wrote: ↑Wed Feb 05, 2020 9:20 pmAlso take note that updating a database table is based on the data capacity which a server is limited into. If you use a mass amount of products and you'd simply like to add a '-', better to use a replace function in your TWIG file.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
It has also been seen despite on the small queries the limitations set by hosting providers regarding large amount of transactions on a database table that cannot be completed but rather the operation to expire before the process even completes. These events are encountered when using limited hosting packages versus the high amount of values that needs to be affected.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Hi,
My module Prodyuct Manipulator is able to mass change product names (and other product properties like price, model, options, attributes etc.)
My module Prodyuct Manipulator is able to mass change product names (and other product properties like price, model, options, attributes etc.)
No, you're talking utter nonsense as usual.straightlight wrote: ↑Wed Feb 05, 2020 9:41 pmIt has also been seen despite on the small queries the limitations set by hosting providers regarding large amount of transactions on a database table that cannot be completed but rather the operation to expire before the process even completes.
An SQL UPDATE to add a couple of letters to every product is not going to cause this kind of issue, and if it does you need to switch hosts immediately.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
This is the correct answer here, ignore any of straightlight's ramblings about twig files.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Who is online
Users browsing this forum: No registered users and 69 guests
