-- url of the page with the problem -- : local test server
-- HikaShop version -- : 2.3.5
-- Browser(s) name and version -- : N/A
-- Error-message(debug-mod must be tuned on) -- : N/A
Hi,
Having just renewed my subscription I've updated to the latest version of Hikashop on a local test server and have discovered that the mod to achieve the change of product code (from xxxx_1 etc to xxxx01, xxxx02 - Post #34414 refers) is no longer a workable solution.
I've tried to find where the product code is generated in product.php and think it's somewhere around lines 770, but am unable to identify exactly what needs changing. Also I've been unable to identify any other code that may be affected and require modification.
$query = 'UPDATE ' . hikashop_table('product') . ' AS p ' .
' SET p.product_code = CONCAT(p.product_code,\'_'.(int)$characteristics[(int)$a]->default_id.'\') '.
' WHERE p.product_parent_id = ' . (int)$product_id . ' AND p.product_type = ' . $this->database->Quote('variant') .
' AND p.product_code LIKE '.$product_code;
With the major changes that have been made to the code, what is the feasibility of implementing the requirement?
Thanks in anticipation of a workable solution.
Regards,
Martyn