<?php

	linkCustomFields('In-Commerce', 'p', 2);

	linkCustomFields('KERNEL', 'c', 1);

	$application =& kApplication::Instance();

	$query = 'REPLACE INTO '.TABLE_PREFIX.'CategoryItems (CategoryId, ItemResourceid, Primarycat, ItemPrefix, Filename)
						SELECT
							ci.CategoryId,
							ci.ItemResourceId,
							ci.PrimaryCat,
							\'p\' AS ItemPrefix,
							i.Filename as Filename
						FROM `'.TABLE_PREFIX.'Products` as i
						LEFT JOIN '.TABLE_PREFIX.'CategoryItems as ci
						ON ci.ItemResourceId = i.ResourceId;';
	$application->Conn->Query($query);

	moveItemTemplatesToCustom('In-Commerce', 'p');

?>