CMS MADE SIMPLE FORGE

Shop Made Simple

 

[#9700] SKU missing

avatar
Created By: Rein Krijgsman (reinkrijgsman)
Date Submitted: Sun Dec 01 18:39:52 -0500 2013

Assigned To: Duketown (duketown)
Version: Version 0.3.9
CMSMS Version: 1.11.9
Severity: Minor
Resolution: None
State: Open
Summary:
SKU missing
Detailed Description:
SKU entry missing from module, cannot display SKU in product list. Please allow
{$entry->sku} to work.


History

Comments
avatar
Date: 2013-12-03 17:28
Posted By: Rein Krijgsman (reinkrijgsman)

FIXED! Thanks Duketown! You're my hero!

The following was missing in action.fe_product_list.php:



Add underneath rule 163 ($onerow->price = $row['price'];):

	$onerow->sku = $row['sku'];

And replace rule 54 till 59 with: 

$query = 'SELECT p.name AS prodname, p.product_id, p.description AS proddesc, 
	p.price AS price, p.netweight, p.sku AS sku, p.maxattributes FROM '
	.cms_db_prefix().'module_sms_product_category c LEFT OUTER JOIN '
	.cms_db_prefix().'module_sms_products p ON c.product_id = p.product_id 
	WHERE c.category_id = ? AND p.active = 1
	ORDER BY p.position';

      
Updates

Updated: 2013-12-01 18:42
description: SKU entry missing from module, cannot display SKU in product list. => SKU entry missing from module, cannot display SKU in product list. Please allow {$entry->sku} to work.
resolution_id: => 5