Review Groups

Review Groups Feature is Enabled

Add Review Groups Form

Status

Group Name

Stores

(Default)

Conditions

Column	From
Name	Begining End Anywhere Equal
Model	Begining End Anywhere Equal

Column to Match

Column	From
Model	Begining End Anywhere Equal
SKU	Begining End Anywhere Equal
UPC	Begining End Anywhere Equal
EAN	Begining End Anywhere Equal
JAN	Begining End Anywhere Equal
ISBN	Begining End Anywhere Equal
MPN	Begining End Anywhere Equal

Match

Full String - xx characters - Match xxx characters either from begining, end, between. Utilize PHP function substr

Substring

Put two values - int $offset, ?int $length = null only.
Checkout
w3schools
OR Copy and paste link Web browser (Google Chrome)
https://www.w3schools.com/php/func_string_substr.asp

PHP WEBSITE
OR Copy and paste link Web browser (Google Chrome)
https://www.php.net/manual/en/function.substr.php

Test Substring in Action


                     substr(string $string, int $offset, ?int $length = null): string

string $string
int $offset
?int $length = null

Base Product

Query	Search String
SELECT p.`product_id` FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON (p.product_id=pd.product_id) WHERE pd.`language_id`='1' AND p.`product_id`!='28' AND p.`model` LIKE '%duct%' ORDER BY p.product_id ASC LIMIT 0,20	duct