Одно свойство для всех товаров. Добавление позиций. Обмен опытом. - [VM1] Управление товарами, атрибутами, типами, ценами

INSERT INTO `jos_vm_product_attribute_sku` (`product_id`, `attribute_name`, `attribute_list`) VALUES
(1, 'Размер', 0),
(2, 'Размер', 0),
(3, 'Размер', 0),
(4, 'Размер', 0),
(5, 'Размер', 0),
(6, 'Размер', 0),
(7, 'Размер', 0),
(8, 'Размер', 0),
(9, 'Размер', 0),
(10, 'Размер', 0),
........
(1000, 'Размер', 0);

/administrator/components/com_virtuemart/html/shop_browse_queries.php

foreach( $keywordArr as $searchstring ) {
		$sq .= "\n (`#__{vm}_product`.`product_name` LIKE '%$searchstring%' OR ";
		$sq .= "\n `#__{vm}_product`.`product_sku` LIKE '%$searchstring%' OR ";
		$sq .= "\n `#__{vm}_product`.`product_s_desc` LIKE '%$searchstring%' OR ";
		$sq .= "\n `#__{vm}_product`.`product_desc` LIKE '%$searchstring%') ";
	
		if( $i++ < $numKeywords ) {
			$sq .= "\n  AND ";
		}
}

$search1parent=0;

$sq .= "\n `#__{vm}_product`.`product_parent_id` LIKE '%$search1parent%' AND ";

$search1parent=0;
foreach( $keywordArr as $searchstring ) {
		$sq .= "\n `#__{vm}_product`.`product_parent_id` LIKE '%$search1parent%' AND ";
		$sq .= "\n (`#__{vm}_product`.`product_name` LIKE '%$searchstring%' OR ";
		$sq .= "\n `#__{vm}_product`.`product_sku` LIKE '%$searchstring%' OR ";
		$sq .= "\n `#__{vm}_product`.`product_s_desc` LIKE '%$searchstring%' OR ";
		$sq .= "\n `#__{vm}_product`.`product_desc` LIKE '%$searchstring%') ";
	
		if( $i++ < $numKeywords ) {
			$sq .= "\n  AND ";
		}
	}

$q .= "#__{vm}_product_category_xref.category_id='$category_id' ";
			$q .= "AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id ";
			$q .= "AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id ";
			//$q .= "AND #__{vm}_product.product_parent_id='' ";
			if( !$perm->check("admin,storeadmin") ) {
				$q .= " AND product_publish='Y'";
				if( CHECK_STOCK && PSHOP_SHOW_OUT_OF_STOCK_PRODUCTS != "0") {
					$q .= " AND product_in_stock > 0 ";
					//$q .= " AND product_parent_id != 0 ";
				}
			}

// Let's have a look wether the product has related products.
$q = "SELECT product_sku, related_products FROM #__{vm}_product,#__{vm}_product_relations ";
$q .= "WHERE #__{vm}_product_relations.product_id='$product_id' AND product_publish='Y' AND product_in_stock!='0' ";
$q .= "AND FIND_IN_SET(#__{vm}_product.product_id, REPLACE(related_products, '|', ',' )) LIMIT 0, 6";
$db->query( $q );