- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
$aProductType = [];
$productName = $conn->query("SELECT value FROM catalog_product_entity_varchar WHERE entity_id = '" . $value['entity_id'] . "' AND attribute_id = 71")->fetch();
$productUrl = $conn->query("SELECT value FROM catalog_product_entity_varchar WHERE entity_id = '" . $value['entity_id'] . "' AND attribute_id = 98")->fetch();
$productImage = $conn->query("SELECT value FROM catalog_product_entity_media_gallery WHERE entity_id = '" . $value['entity_id'] . "'")->fetchAll();
$productPrice = $conn->query("SELECT value FROM catalog_product_entity_decimal WHERE entity_id = '" . $value['entity_id'] . "' AND attribute_id = 75")->fetch();
$productType = $conn->query('SELECT category_id FROM catalog_category_product WHERE product_id = ' . $value['entity_id'])->fetchAll();
$productAvailable = $conn->query('SELECT qty FROM cataloginventory_stock_item WHERE product_id = ' . $value['entity_id'])->fetch();
$productDesc = $conn->query('SELECT value FROM catalog_product_entity_text WHERE entity_id = "' . $value['entity_id'] . '"')->fetch();
Keeper 09.07.2016 10:04 # −4
guestinho 10.07.2016 10:23 # +2
inkanus-gray 10.07.2016 13:01 # +2
bormand 10.07.2016 14:03 # 0
inkanus-gray 10.07.2016 14:14 # +1
Keeper 11.07.2016 09:09 # 0
inkanus-gray 10.07.2016 14:24 # 0
Там все таблицы из трёх колонок: entity_id, attribute_id, value?