ะ ืืื ืืืกืงืจืืืื ืืขื ืคึผืจืึธืฆืขืก ืคืื ืืืคึผืึธืจืืื ื ืคึผืจืึธืืืงืื ืืื Magento 2 ืืืืฃ ืื ืืขืืืืื ืืืขื ืืืขื - ืืืจื ืืึธืืขืืก ืืื ืจืืคึผืึทืืึทืืึธืจืื. ืื ืืขืืืืื ืืืขื ืืืคึฟื ืืื ืึท ืืืืขืจ ื ืืืขืจืืง ืืึทืื ืคึผืจืึทืกืขืกืื ื ืืืืงืืึทื. ืืืึทื ืืึทืคึผืืึทืคึผ ืืื ืืขืืืขื ืคึผืจืึทืืืกืื ื ืืืขืื ืืืื ืคึผืจืึธืืืงื ืคึผืขืจ ืกืขืงืื ืืข. ืืื ืืขื ืงืึทื ืืื ืืืืืฉืึทื, ืืื ืืึทืืจืึทืืื ืึทื ืึธืืืขืจื ืึทืืืื ืืืขื ืฆื ืึทืจืืึทื ืคืืจ ืึท ืคึผืจืึธืืืงื - ืืืจื ืืืจืขืงื ืคึผืึธืืืฆืืข ืืื ืื ืืึทืืึทืืืืก, ืืืืคึผืึทืกืื ื ืื ื ืึธืจืืึทื ืืึทืืขื ืืึธ 2 ืืขืงืึทื ืืืึทืื (ืืึธืืขืืก, ืคืืืจืืงื, ืจืืคึผืึทืืึทืืึธืจืื). ืื ืกืืงืืืึทื ืก ืคืื ืกืืขืคึผืก ืฆื ืึทืจืืึทื ืคืืจ ืคึผืจืึธืืืงืื ืงืขื ืขื ืืืื ืฆืืืขืคืืกื ืฆื ืงืืื ืคึผืจืึธืืจืึทืืืื ื ืฉืคึผืจืึทื ืืืึธืก ืงืขื ืขื ืึทืจืืขืื ืืื MySQL.
ืึธืคึผืืืืงืขื ืื ื: Magento ืืื ืคืึทืจืืืง ืคืึทื ืืงืฉืึทื ืึทืืืื ืคึฟืึทืจ ืืื, ืจืืึฟ ืืกืชึผืื, ืขืก ืืืขื ืืืื ืืขื ืื ืคึฟืึทืจ ืืืจ. ืึธืืขืจ, ืืืื ืืืจ ืืึทืจืคึฟื ืืขืจ ืคืืืฉืืขื ืืืง ืงืึธื ืืจืึธื ืืืืขืจ ืืขื ืึทืจืืึทื ืคืืจ ืคึผืจืึธืฆืขืก, ื ืื ืืืืืืขื ืฆื ืคึผืจืืคึผืขืจืื ื ืึท ืงืกืื ืืขืงืข ืคึฟืึทืจ ืืืึธืก ืืืจ ืืึธื, ืืจืืืื ืืืืื ืฆื ืงืึทืฅ.
ืื ืงืึธื ืจืืืึทืืืื ื ืคืื ืฉืจืืืื ืืืืืข ืึทืจืืืงืืขื ืงืขื ืขื ืืืื ืืืืื ืืื ืื Magento ืืึธืืืืข "". ืืึธ ืืขื ืขื ืขืืืขืืข ืจืืกืืจืืงืฉืึทื ื ืืื ื ืืืืขืืื ืืขื ืฆื ืคืึทืจืคึผืึธืฉืขืืขืจื ืื ืืขืืึธ ืืึธืืืืข ืงืึธื:
- ืคึผืจืึธืืืงืื ืืขื ืขื ืืืืื ืืืฉืืคื, ื ืืฉื ืืขืจืืืึทื ืืืงื.
- ืืืื ืืืขืจืืึทืืก
- ืืืืื ืงืึทืืขืืึธืจืืข ื ืขืืขื ืืขื ืขื ืืืคึผืึธืจืืื, ืึธื ืืืืขืจ ืกืืจืืงืืืจ
- ืืึทืืึท ืกืืจืึทืงืืฉืขืจื ื ืึธืืงืืืขื ืืื ืืืขืจืกืืข 2.3
JSON ืคึฟืึทืจ ืืืคึผืึธืจืืื ื ืึท ืืืื ืคึผืจืึธืืืงื:
{
"sku": "MVA20D-UBV-3",
"name": "ะะฐะณะปััะบะฐ ะดะปั ะฟะปะพะผะฑะธัะพะฒะบะธ ะะ47-29 IEK",
"desc": "ะะฑะตัะฟะตัะตะฝะธะต ะดะพัััะฟะฐ ะบ ััััะพะนััะฒะฐะผ ...",
"desc_short": "ะะฐะณะปััะบะฐ ะดะปั ะฟะปะพะผะฑะธัะพะฒะบะธ ะะ47-29 IEK ะฟัะตะดะฝะฐะทะฝะฐัะตะฝะฐ ะดะปั ...",
"price": 5.00,
"qty": 25,
"categories": ["ะะฐัะตะณะพัะธั 1", "ะะฐัะตะณะพัะธั 2"],
"image_path": "mva20d_ubv_3.png"
}ืืืืขืจืืืืง ืคืื ืื ืืืืคึผื ืกืืึทืืขืก ืคืื ืึทืจืืึทื ืคืืจ
- ืจืขืืืกืืจืึทืฆืืข ืคืื โโืื ืคึผืจืึธืืืงื ืืื
- ืงืฉืจ ืฆืืืืฉื ืคึผืจืึธืืืงื ืืื ืืืขืืืืืื
- ืืงืขืจืืืง ืคึผืจืึธืืืงื ืึทืืจืืืืืฅ (EAV)
- ืื ืืืึทื ืืึธืจื ืืึทืื (ืงืืืึทื ืืืื ืคืื ืคึผืจืึธืืืงื ืืื ืืึทืืขืจ)
- ืืขืืืข (ืืืืืขืจ)
- ืงืฉืจ ืืื ืงืึทืืึทืืึธื ืงืึทืืขืืึธืจืืขืก
ืคึผืจืึธืืืงื ืจืขืืืกืืจืึทืฆืืข
ืืงืขืจืืืง ืคึผืจืึธืืืงื ืืื ืคึฟืึธืจืืึทืฆืืข ืงืขื ืขื ืืืื ืืขืคึฟืื ืขื ืืื catalog_product_entity:
CREATE TABLE `catalog_product_entity` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
`attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
`type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type ID',
`sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
`has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
`required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
PRIMARY KEY (`entity_id`),
KEY `CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` (`attribute_set_id`),
KEY `CATALOG_PRODUCT_ENTITY_SKU` (`sku`)
)ืื ืืื ืืืื ืืื ืคึฟืึธืจืืึทืฆืืข ืคืืจืืื ืื ืฆื ืฉืึทืคึฟื ืึท ืคึผืึธืืืฆืืข ืืื ืื ืคึผืจืึธืืืงื ืจืขืืืกืืจื ืืื:
attribute_set_idsku
ื ืึธื:
type_id- ืืืื ืืืจ ืืึธื ื ืื ืกืคึผืขืฆืืคืืฆืืจื ืขืก, "ืคึผืฉืื" ืืืขื ืืืื ืืขืืืืื ื
ืฆื ืฉืจืืึทืื ืืืืึทื ืฆื ืื ืืึทืืึทืืืืก, ืืื ื ืืฆื ืื ืื ืึทืืึทืคึผืืขืจ ืคืื Magento ืืื:
function create($sku, $typeId, $attrSetId)
{
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('catalog_product_entity');
$bind = [
'sku' => $sku,
'type_id' => $typeId,
'attribute_set_id' => $attrSetId
];
$conn->insert($table, $bind);
$result = $conn->lastInsertId($table);
return $result;
}ื ืึธื ืจืขืืืฉืืกืืขืจืื ื ืื ืคึผืจืึธืืืงื ืืื catalog_product_entity ืขืก ืืืขืจื ืงืขื ืืืง ืืื ืื ืึทืืืื ืืกืืจืึทืืึธืจ ืืึทืคืืืข, ืืื ืื ืคึผืจืึธืืืงื ืืจืื (ืงืึทืืึทืืึธื / ืคึผืจืึธืืืงืื).
ืฉืืืืืช ืฆืืืืฉื ืคึผืจืึธืืืงื ืืื ืืืขืืืืืื
ืืขืจ ืคืึทืจืืึทื ื ืคืื ืื ืคึผืจืึธืืืงื ืืื ืืขื ืคึผืืึทืฅ ืืืืขืจืืึทื ื ืืื ืืืึธืก ืกืืึธืจื ืืื ืืืกืคึผืืืื ืื ืคึผืจืึธืืืงื ืืืขื ืืืื ืื ืืืฆื ืืื ืื ืคืจืึธื ื.
function linkToWebsite($prodId, $websiteId)
{
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('catalog_product_website');
$bind = [
'product_id' => $prodId,
'website_id' => $websiteId
];
$conn->insert($table, $bind);
}
ืืงืขืจืืืง ืคึผืจืึธืืืงื ืึทืืจืืืืืฅ
ืืขืจ ื ืื ืจืขืืืกืืจืืจื ืคึผืจืึธืืืงื ืืื ื ืืฉื ื ืึธื ืึท ื ืึธืืขื ืึธืืขืจ ืืึทืฉืจืืึทืืื ื. ืืึธืก ืึทืืฅ ืืื ืืืจืืืขืงืึธืื . ืืึธ ืืื ืึท ืจืฉืืื ืคืื ืืงืขืจืืืง ืคึผืจืึธืืืงื ืึทืืจืืืืืฅ ืืืึธืก ืืขื ืขื ืืืจืฃ ืืื ืกืืจ ืฆื ืืืืึทืื ืื ืคึผืจืึธืืืงื ืจืืืืืง ืืืืฃ ืื ืคืจืึธื ื:
namepricedescriptionshort_descriptionstatustax_class_idurl_keyvisibility
ื ืืึทืืื ืืขืจ ืึทืืจืืืืื ืืื ืืืกืืฃ ืฆื ืึท ืคึผืจืึธืืืงื ืืื ืืึธืก (ืื ืืขืืึทืืืก ืคืื ืืืงืืืขื ืื ืืืขื ืืืคืืขืจ ืืื ืืืคึผ ืคืื ืึทืืจืืืืื ืคืื ืืืื ืงืึธื ืืขื ืขื ืืืืขืจืืขืืืคึผืขืจื):
public function create($prodId, $attrCode, $attrValue)
{
$attrId = /* get attribute ID by attribute code */
$attrType = /* get attribute type [datetime|decimal|int|text|varchar]) by attribute code */
if ($attrId) {
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$tblName = 'catalog_product_entity_' . $attrType;
$table = $this->resource->getTableName($tblName);
$bind = [
'attribute_id' => $attrId,
'entity_id' => $prodId,
/* put all attributes to default store view with id=0 (admin) */
'store_id' => 0,
'value' => $attrValue
];
$conn->insert($table, $bind);
}
}ื ืืฆื ืื ืึทืืจืืืืื ืงืึธื, ืืืจ ืืึทืฉืืืืขื ืืืึทื ืฉืืึทื ืืื ืืึทืื ืืืคึผ (datetime, decimal, int, text, varchar), ืืื ืฉืจืืึทืื ืื ืืึทืื ืคึฟืึทืจ ืื ืึทืืืื ืืกืืจืึทืืืืืข ืคึฟืขื ืฆืืขืจ ืืื ืื ืฆืื ืขืืขื ืืืฉ (store_id = 0).
ื ืึธื ืึทืืื ื ืื ืืืืื ืึทืืจืืืืืฅ ืฆื ืืขื ืคึผืจืึธืืืงื, ืืืจ ืืึทืงืืืขื ืืขื ืืืื ืืื ืื ืึทืืืื ืืึทืคืืืข:
ืื ืืืึทื ืืึธืจื ืืึทืื
ืกืืึทืจืืื ื ืคืื ืืืขืจืกืืข 2.3 ืืื Magento, ืขืก ืืขื ืขื ืฆืืืื ืคึผืึทืจืึทืืขื ืฉืืขืื ืคืื ืืืฉื ืืืึธืก ืฆืืฉืืขืื ืกืืึธืจืืืืฉ ืคืื ืื ืืืึทื ืืึธืจื ืืื ืคึฟืึธืจืืึทืฆืืข (ืคึผืจืึธืืืงื ืงืืืึทื ืืืื):
cataloginventory_*: ืึทืื ืกืืจืืงืืืจ;inventory_*: ื ืืึท ืกืืจืืงืืืจ (ืืกื - ืืืืื ืืงืืจ ืื ืืืขื ืืึธืจื);
ืืืจ ืืึทืจืคึฟื ืฆื ืืืืื ืื ืืืึทื ืืึธืจื ืืึทืื ืฆื ืืืืืข ืกืืจืึทืงืืฉืขืจื, ืืืืึทื ืื ื ืืึทืข ืกืืจืืงืืืจ ืืื ื ืึธื ื ืืฉื ืืึธืจ ืคืจืืึท ืคืื ืื ืึทืื (ืขืก ืืื ืืืืขืจ ืืกืชึผืื ืึทื ืคึฟืึทืจ default ืืืขืจืืึทืืก ืืื ืื ื ืืึท ืกืืจืืงืืืจ ืึท ืืืฉ ืืื ืื ืืืึทืืืื cataloginventory_stock_status ืืื inventory_stock_1).
ืงืึทืืึทืืึธื-ืืื ืืืขื ืืึธืจื_
ืืืขื ืืืคึผืืืืื ื Magneto 2.3 ืืืจ ืืืืืขืก ืืึธืื 2 ืืืื ืกื ืืื store_website, ืืืึธืก ืงืึธืจืึทืกืคึผืึทื ืื ืฆื ืฆืืืื ืืืืืืขื - ืึทืืืื ืืกืืจืึทืืืืืข ืืื ืืืืคึผื ืงืืืขื ื:
website_id|code |name |sort_order|default_group_id|is_default|
----------|-----|------------|----------|----------------|----------|
0|admin|Admin | 0| 0| 0|
1|base |Main Website| 0| 1| 1|ืืืฉ cataloginventory_stock ืืืจ ืืึธืื ืืืืื ืืืื ืคึผืึธืืืฆืืข:
stock_id|website_id|stock_name|
--------|----------|----------|
1| 0|Default |ืืึธืก ืืื, ืืื ืืื ืืืขืจ ืึทืื ืกืืจืืงืืืจ ืขืก ืืื ืืืืื ืืืื "ืืืขืจืืึทืืก" (stock) ืืื ืขืก ืืื ืืื ืืงื ืฆื ืื ืึทืืืื ืืกืืจืึทืืืืืข ืืืขืืืืืื. ืึทืืื ื ื ืืึท ืึธื ืขืก ืืืจื ืื ืึทืืืื ืืึทืคืืืข sources/stocks ืืื MSI (ื ืืึท ืกืืจืืงืืืจ) ืืื ื ืืฉื ืจืขืืืืืึทื ืืื ื ืืึทืข ืืืื ืกื ืืื cataloginventory_stock.
ืื ืืืึทื ืืึธืจื ืืึทืื ืืืขืื ืคึผืจืึธืืืงืื ืืื ืื ืึทืื ืกืืจืืงืืืจ ืืขื ืขื ืืืืืขืก ืจืขืงืึธืจืืขื ืืื ืืืฉื:
cataloginventory_stock_itemcataloginventory_stock_status
cataloginventory_stock_item
function createOldItem($prodId, $qty)
{
$isQtyDecimal = (((int)$qty) != $qty);
$isInStock = ($qty > 0);
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('cataloginventory_stock_item');
$bind = [
'product_id' => $prodId,
/* we use one only stock in 'cataloginventory' structure by default */
'stock_id' => 1,
'qty' => $qty,
'is_qty_decimal' => $isQtyDecimal,
'is_in_stock' => $isInStock,
/* default stock is bound to admin website (see `cataloginventory_stock`) */
'website_id' => 0
];
$conn->insert($table, $bind);
}cataloginventory_stock_status
function createOldStatus($prodId, $qty)
{
$isInStock = ($qty > 0);
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('cataloginventory_stock_status');
$bind = [
'product_id' => $prodId,
/* we use one only stock in 'cataloginventory' structure by default */
'stock_id' => 1,
'qty' => $qty,
'stock_status' => MagentoCatalogInventoryApiDataStockStatusInterface::STATUS_IN_STOCK,
/* default stock is bound to admin website (see `cataloginventory_stock`) */
'website_id' => 0
];
$conn->insert($table, $bind);
}ืื ืืืึทื ืืึธืจื_
ืืืืืขืก, ืื ื ืืึทืข ืกืืจืืงืืืจ ืคึฟืึทืจ ืกืืึธืจืื ื ืื ืืืึทื ืืึธืจื ืืึทืื ืึผืืื 1 "ืืึธืงืขืจ"(inventory_source):
source_code|name |enabled|description |latitude|longitude|country_id|...|
-----------|--------------|-------|--------------|--------|---------|----------|...|
default |Default Source| 1|Default Source|0.000000| 0.000000|US |...|ืืื ืืืื ืขืจ"ืืืึทืจืขืืึธืืกืข"(inventory_stock):
stock_id|name |
--------|-------------|
1|Default Stock|ยซืืึธืงืขืจยป ืจืขืคึผืจืึทืืขื ืฅ ืื ืืฉืืืืช ืกืืึธืจืืืืฉ ืคึฟืึทืจ ืคึผืจืึธืืืงืื (ืื ืจืขืงืึธืจื ืึผืืื ืืฉืืืืช ืงืึธืืึธืจืืึทื ืึทืฅ ืืื ืืืืืื ื ืึทืืจืขืก). "ืืืขืจืืึทืืก"ืืื ืึท ืืึทืืืฉืืงืึทื ืคืึทืจืืึทื ื ืคืื ืขืืืขืืข "ืงืืืืื" (inventory_source_stock_link)
link_id|stock_id|source_code|priority|
-------|--------|-----------|--------|
1| 1|default | 1|ืืื ืืขืจ ืืืจืื ืืื ืืืึธืก ืื ืงืฉืจ ืฆื ืื ืคืืจืงืืืคืื ื ืงืึทื ืึทื ืึทืงืขืจื (inventory_stock_sales_channel)
type |code|stock_id|
-------|----|--------|
website|base| 1|ืืืื ืืฉืคืื ืืืื ืื ืืึทืื ืกืืจืืงืืืจ, ืคืึทืจืฉืืื ืืืืคึผืก ืคืื ืคืืจืงืืืคืื ื ืืฉืึทื ืึทืื ืืขื ืขื ืื ืืขื ืืืขื, ืึธืืขืจ ืืืจื ืคืขืืืงืืึทื ืืืืื ืื ืงืฉืจ "ืืึทืืขืจ"-"ืืืขืืืืึทืื"(ืืขืจ ืืื ืง ืฆื ืื ืืืขืืืืืื ืืืื ืื ืืืขืืืืืื ืงืึธื - base).
ืืืื"ืืืึทืจืขืืึธืืกืข"ืงืขื ืขื ืืืื ืืื ืืงื ืฆื ืขืืืขืืข"ืงืืืืื"ืืื ืืืื ืขืจ"ืืึธืงืขืจ"- ืฆื ืขืืืขืืข"ืืืขืจืืึทืืืื"(ืคืืืข-ืฆื-ืคืืืข ืฉืืืืืช). ืื ืืืืกื ืขืืขื ืืขื ืขื ืคืขืืืงืืึทื "ืืึธืงืขืจ"ืืื"ืืืึทืจืขืืึธืืกืข". ืืื ืืขื ืขื ื ืืฉื ืฉืืึทืขื-ืืื ืืงื ืฆื ืื ืืขืจืข ืขื ืืืืื (ืืืืจืขื ืขืฆื ืืื ืื ืงืึธื ืืืจืื - ืืขืจ ืืขืืช "ืงืขื ืขื ื ืื ืจืึทืืขืืืขื ืื ืืื ืง ืฉืืึทืืืช ืฆื ืืืคืึธืื ืืงืืจ ืึธืืขืจ ืืืคืึธืื ืืึทืืขืจ"). ืืขืจ ืืขืืึทืืืก ืืืขืื ืื MSI ืกืืจืืงืืืจ ืืื Magento 2 ืงืขื ืขื ืืืื ืืขืคึฟืื ืขื ืืื ืืขื ืึทืจืืืงื "".
ืืื ืืืขื ื ืืฆื ืื ืคืขืืืงืืึทื ืงืึทื ืคืืืืขืจืืืฉืึทื ืืื ืืืืื ืึทืืข ืื ืืืึทื ืืึธืจื ืืื ืคึฟืึธืจืืึทืฆืืข ืฆื ืื ืืงืืจ default, ืืืึธืก ืืื ืื ืืืึทืืืื ืืื ืื ืคืืจืงืืืคืื ื ืงืึทื ืึทื ืคึฟืึทืจืืื ืื ืืื ืื ืืืขืืืืืื ืืื ืื ืงืึธื base (ืงืึธืจืึทืกืคึผืึทื ืื ืฆื ืื ืคืจืึธื ื ืกืืฃ ืคืื ืื ืงืจืึธื - ืืขื store_website):
function createNewItem($sku, $qty)
{
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('inventory_source_item');
$bind = [
'source_code' => 'default',
'sku' => $sku,
'quantity' => $qty,
'status' => MagentoInventoryApiApiDataSourceItemInterface::STATUS_IN_STOCK
];
$conn->insert($table, $bind);
}ื ืึธื ืึทืืื ื ืื ืืืึทื ืืึธืจื ืืึทืื ืฆื ืื ืคึผืจืึธืืืงื ืืื ืื ืึทืืืื ืืึทืคืืืข, ืืืจ ืืึทืงืืืขื ืืขื ืืืื:
ืืขืืืข
ืืืขื "ืืึทื ืืืึทืื" ืึทืืื ื ืึท ืืืื ืฆื ืึท ืคึผืจืึธืืืงื ืืืจื ืื ืึทืืืื ืืึทืคืืืข, ืื ืืึทืืืึทืืืง ืืื ืคึฟืึธืจืืึทืฆืืข ืืื ืืขืฉืจืืื ืืื ืื ืคืืืืขื ืืข ืืืฉื:
catalog_product_entity_media_gallery: ืืขืืืข ืจืขืืืกืืจื (ืืืืืขืจ ืืื ืืืืืขื ืืขืงืขืก);catalog_product_entity_media_gallery_value: ืคึฟืึทืจืืื ืืื ื ืืขืืืข ืฆื ืคึผืจืึธืืืงืื ืืื ืฉืึธืืงืืืกืื (ืืึธืืงืึทืืึทืืืืฉืึทื);catalog_product_entity_media_gallery_value_to_entity: ืคึฟืึทืจืืื ืืื ื ืคืื ืืขืืืข ืืืืื ืฆื ืคึผืจืึธืืืงืื (ืืึทืฉืืึธืขืก ืคืขืืืงืืึทื ืืืืืึท ืืื ืืึทืื ืคึฟืึทืจ ืื ืคึผืจืึธืืืงื);catalog_product_entity_varchar: ืื ืจืึธืืขืก ืืื ืืืึธืก ืื ืืืื ืืื ืืขื ืืฆื ืืขื ืขื ืกืืึธืจื ืืึธ;
ืืื ืื ืืืืืขืจ ืืื ืืขื ืขื ืืขืจืืืขืืืขื ืืื ืืขืจ ืืืขืืืืืึทืืขืจ ./pub/media/catalog/product/x/y/ืืื x ะธ y - ืืขืจ ืขืจืฉืืขืจ ืืื ืจืืข ืืืชืืืช ืคืื ืื ืืืื ืืขืงืข ื ืึธืืขื. ืคึฟืึทืจ ืืืึทืฉืคึผืื, ืืขืงืข image.png ืืึธื ืืขืจืืืขืืืขื ืืืขืจื ืืื ./pub/media/catalog/product/i/m/image.png, ืึทืืื ืึทื ืื ืคึผืืึทืืคืึธืจืืข ืงืขื ืขื ื ืืฆื ืขืก ืืื ืึท ืืืื ืืืขื ืืืกืงืจืืืืื ื ืคึผืจืึธืืืงืื ืคืื ืืขื ืงืึทืืึทืืึธื.
catalog_product_entity_media_gallery
ืจืขืืืกืืจืืจื ืึทืจืืึทื ืืขืฉืืงื ืืื ./pub/media/catalog/product/ ืืขืืืข ืืขืงืข (ืืขืจ ืคึผืจืึธืฆืขืก ืคืื ืคึผืืืืกืื ื ืื ืืขืงืข ืืื ืืื ื ืืฉื ืืืกืงืึทืกื ืืื ืืขื ืึทืจืืืงื):
function createMediaGallery($imgPathPrefixed)
{
$attrId = /* get attribute ID by attribute code 'media_gallery' */
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('catalog_product_entity_media_gallery');
$bind = [
'attribute_id' => $attrId,
'value' => $imgPathPrefixed,
/* 'image' or 'video' */
'media_type' => 'image',
'disabled' => false
];
$conn->insert($table, $bind);
$result = $conn->lastInsertId($table);
return $result;
}ืืืขื ืจืขืืืกืืจืืจื, ืึท ื ืืึทืข ืืขืืืข ืืขืงืข ืืื ืึทืกืืื ื ืึท ืืืืขื ืืืืขื.
catalog_product_entity_media_gallery_value
ืืืจ ืคืึทืจืืื ืื ืื ืจืขืืืกืืจืืจื ืืืืืึท ืืขืงืข ืืื ืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืคึผืจืึธืืืงื ืคึฟืึทืจ ืื ืคืขืืืงืืึทื ืกืืึธืจืคืจืึทื ื:
function createGalleryValue($mediaId, $prodId)
{
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('catalog_product_entity_media_gallery_value');
$bind = [
'value_id' => $mediaId,
/* use admin store view by default */
'store_id' => 0,
'entity_id' => $prodId,
'label' => null,
/* we have one only image */
'position' => 1,
'disabled' => false
];
$conn->insert($table, $bind);
}catalog_product_entity_media_gallery_value_to_entity
ืืืจ ืคืึทืจืืื ืื ืื ืจืขืืืกืืจืืจื ืืืืืึท ืืขืงืข ืืื ืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืคึผืจืึธืืืงื ืึธื ืืืื ืืืื ืฆื ืงืืื ืกืืึธืจืคืจืึทื ื. ืขืก ืืื ื ืืฉื ืงืืึธืจ ืืื ืคึผืื ืงื ืื ืืึทืื ืืขื ืขื ืืขื ืืฆื ืืื ืืืึธืก ืขืก ืืื ืืืืืขืืืขื ืฆื ืฆืืืจืื ืื ืืึทืื ืคืื ืื ืคืจืืขืจืืืงืข ืืืฉ, ืึธืืขืจ ืืขืจ ืืืฉ ืืืืืกืฅ ืืื ืื ืืึทืื ืืขื ืขื ืืขืฉืจืืื ืฆื ืืื ืืืขื ืึท ืืืื ืืื ืฆืืืขืืืืื ืฆื ืื ืคึผืจืึธืืืงื. ืึทืืื ืึทื ืก ืขืก.
function createGalleryValueToEntity($mediaId, $prodId)
{
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('catalog_product_entity_media_gallery_value_to_entity');
$bind = [
'value_id' => $mediaId,
'entity_id' => $prodId
];
$conn->insert($table, $bind);
}catalog_product_entity_varchar
ื ืืขืืืข ืืขืงืข ืงืขื ืขื ืืืื ืืขืืืืื ื ืืื ืคืึทืจืฉืืืขื ืข ืจืึธืืขืก (ืื ืงืึธืจืึทืกืคึผืึทื ืืื ื ืึทืืจืืืืื ืงืึธื ืืื ืื ืืขืืืืื ืืื ืงืืึทืืขืจื):
- ืืืืข (
image) - ืงืืืื ืืืื (
small_image) - ืืึทืื ืืื (
thumbnail) - ืกืืืึทืืฉ ืืืื (
swatch_image)
ืคึฟืึทืจืืื ืืื ื ืจืึธืืขืก ืฆื ืึท ืืืืืึท ืืขืงืข ืืื ืคึผืื ืงื ืืืึธืก ืืึทืคึผืึทื ื ืืื catalog_product_entity_varchar. ืื ืืืื ืืื ื ืงืึธื ืืื ืขื ืืขื ืฆื ืื ืงืึธื ืืื ืื "ืืงืขืจืืืง ืคึผืจืึธืืืงื ืึทืืจืืืืืฅ".
ื ืึธื ืึทืืื ื ืึท ืืืื ืฆื ืื ืคึผืจืึธืืืงื ืืื ืื ืึทืืืื ืืึทืคืืืข, ืขืก ืงืืงื ืืื ืืึธืก:
ะะฐัะตะณะพัะธะธ
ืืืืคึผื ืืืฉื ืืื ืืึทืื ืืืื ืงืึทืืขืืึธืจืืข:
catalog_category_entity: ืจืขืืืกืืจืืจื ืคืื ืงืึทืืขืืึธืจืืขืก;catalog_category_product: ืงืฉืจ ืฆืืืืฉื ืคึผืจืึธืืืงืื ืืื ืงืึทืืขืืึธืจืืขืก;catalog_category_entity_*: EAV ืึทืืจืืืืื ืืืึทืืืขืก;
ืืืืืขืก, ืืื ืึท ืืืืืืง Magento ืึทืคึผืืึทืงืืืฉืึทื, ืื ืงืึทืืขืืึธืจืืข ืจืขืืืกืืจื ืึผืืื 2 ืงืึทืืขืืึธืจืืขืก (ืืื ืคืึทืจืงืืจืฆื ืื ืืืึทื ื ืขืืขื: crt - created_at, upd - updated_at):
entity_id|attribute_set_id|parent_id|crt|upd|path|position|level|children_count|
---------|----------------|---------|---|---|----|--------|-----|--------------|
1| 3| 0|...|...|1 | 0| 0| 1|
2| 3| 1|...|...|1/2 | 1| 1| 0|ืื ืงืึทืืขืืึธืจืืข ืืื id = 1 ืืื ืืขืจ ืืืึธืจืฆื ืคืื ืื ืืื ืฆืข Magento ืงืึทืืึทืืึธื ืืื ืืื ื ืื ืื ืืืฆื ืืื ืื ืึทืืืื ืืึทืคืืืข ืึธืืขืจ ืืืืฃ ืื ืคืจืึธื ื ืืืึทื. ืงืึทืืขืืึธืจืืข ืืื ID = 2 (ืคืขืืืงืืึทื ืงืึทืืขืืึธืจืืข) ืืื ืืขืจ ืืืึธืจืฆื ืงืึทืืขืืึธืจืืข ืคึฟืึทืจ ืื ืืืืคึผื ืงืจืึธื ืคืื ืื ืคึผืืึทืฅ (ืืืืคึผื ืืืขืืืืืื ืกืืึธืจ) ืืืฉืืคื ืืืขื ืื ืึทืคึผืืึทืงืืืฉืึทื ืืื ืืืคึผืืืื (ืืขื. ืึทืืืื / ืกืืึธืจืขืก / ืึทืืข ืกืืึธืจืขืก). ืืขืจืฆื, ืื ืืืึธืจืฆื ืงืึทืืขืืึธืจืืข ืคืื โโืื ืงืจืึธื ืืื ืืื ืืืื ื ืืฉื ืื ืืืฆื ืืื ืื ืคืจืึธื ื, ื ืึธืจ ืื ืกืึทืืงืึทืืขืืึธืจืืขืก.
ืืื ื ืื ืืขืืข ืคืื โโืืขื ืึทืจืืืงื ืืื ื ืึธื ืืืคึผืึธืจืืื ื ืืึทืื ืืืืฃ ืคึผืจืึธืืืงืื, ืืื ืืืขื ื ืืฉื ื ืืฆื ืืืจืขืงื ืคึผืึธืืืฆืืข ืืื ืื ืืึทืืึทืืืืก ืืืขื ืงืจืืืืืื ื ืงืึทืืขืืึธืจืืขืก, ืึธืืขืจ ืืื ืืืขื ื ืืฆื ืื ืงืืืกื ืฆืืืขืฉืืขืื ืืืจื Magento ืืื (ืืึธืืขืืก ืืื ืจืืคึผืึทืืึทืืึธืจืื). ืืืจืขืงื ืึทืจืืึทื ืืจืขืื ืืื ืื ืืึทืืึทืืืืก ืืื ืืขื ืืฆื ืืืืื ืฆื ืคืึทืจืืื ืื ืื ืืืคึผืึธืจืืื ืคึผืจืึธืืืงื ืืื ืึท ืงืึทืืขืืึธืจืืข (ืื ืงืึทืืขืืึธืจืืข ืืื ืืึทืืฉื ืืืจื ืืืึทื ื ืึธืืขื, ืืื ืื ืงืึทืืขืืึธืจืืข ืฉืืึทื ืืื ืจืืืจืืืื ืืขืฉืึทืก ืืึทืืืฉืื ื):
function create($prodId, $catId)
{
/** @var MagentoFrameworkAppResourceConnection $this->resource */
/** @var MagentoFrameworkDBAdapterPdoMysql $conn */
$conn = $this->resource->getConnection();
$table = $this->resource->getTableName('catalog_category_product');
$bind = [
'category_id' => $catId,
'product_id' => $prodId,
];
$conn->insert($table, $bind);
}ื ืึธื ืึทืืื ื ืึท ืคึผืจืึธืืืงื ืืื ืง ืฆื ืื ืงืึทืืขืืึธืจืืขืก "ืงืืืขืืืจืืข 1" ืืื "ืงืืืขืืืจืืข 2", ืื ืคึผืจืึธืืืงื ืืขืืึทืืืก ืืื ืื ืึทืืืื ืืึทืคืืืข ืงืืง ืขืคึผืขืก ืืื ืืึธืก:
ื ืึธื ืึทืงืฉืึทื ื
ืึทืืึธื ืื ืืึทืื ืึทืจืืึทื ืคืืจ ืืื ืืึทื ืฅ, ืืืจ ืืึทืจืคึฟื ืฆื ืคืึทืจืขื ืืืงื ืื ืคืืืืขื ืืข ื ืึธื ืกืืขืคึผืก:
- ืืึทืื ืื ืืขืงืกืื ื: ืจืืคื ืืื ืื ืงืึทื ืกืึธืื
./bin/magento indexer:reindex; - ืจืืืืฉืขื ืขืจืืืืื ื URL ืก ืคึฟืึทืจ ืคึผืจืึธืืืงืื / ืงืึทืืขืืึธืจืืขืก: ืืืจ ืงืขื ืขื ื ืืฆื ืื ืคืึทืจืืขื ืืขืจืื ื "ยซ
ืคึผืจืึธืืืงืื ืืื ืื ืึทืืืื ืืกืืจืึทืืึธืจ ืืึทืคืืืข ื ืึธื ืืืจืืคืืจื ื ืึธื ืึทืงืฉืึทื ื:
ืืื ืืื ืคืจืึธื ื:
ืงืืฆืขืจ
ืืขืจ ืืขืืืืงืขืจ ืืึทื ื ืคืื ืคึผืจืึธืืืงืื (10 ืืจืขืงืืขื) ืืื ืืื ืื ืคืจืืขืจืืืงืข ืึทืจืืืงื ืืื ืืืคึผืึธืจืืื ืืืึท ืืื ืืกืืขืจ ืึท ืกืืจ ืคืื ืืึทืื ืึทืืื ืคืึทืกืืขืจ (1 ืจืืข ืงืขืื 10). ืฆื ืืขืจ ืึทืงืืขืจืึทืืื ืึธืคึผืฉืึทืฆื ืื ืืืืงืืึทื, ืืืจ ืืึทืจืคึฟื ืึท ืืจืขืกืขืจืข ื ืืืขืจ ืคืื ืคึผืจืึธืืืงืื - ืขืืืขืืข ืืื ืืขืจื, ืึธืืขืจ ืืขืกืขืจ ื ืึธื ืืืืื ืืขืจ. ืึธืืขืจ, ืืคืืื ืืื ืึทืืึท ืึท ืงืืืื ืืจืืืก ืคืื ืึทืจืืึทื ืฉืจืืึทื ืืึทืื, ืืืจ ืงืขื ืขื ืคืึทืจืขื ืืืงื ืึทื ืื ื ืืฆื ืคืื ืื ืืืฉืืจืื ืฆืืืขืฉืืขืื ืืืจื Magento (ืืึธืืขืืก ืืื ืจืืคึผืึทืืึทืืึธืจืื) ืืื ืืึทืืืืืืง (ืืื ืื ืืขืจืฉืืจืืึทืื - ืืืืืืืืง!) ืคืึทืจืืืืขืจื ืื ืึทื ืืืืืงืืื ื ืคืื ืื ืคืืจืืื ืื ืคืึทื ืืงืฉืึทื ืึทืืืื, ืึธืืขืจ ืืื ืืขืจ ืืขืืืืงืขืจ ืฆืืื ืืืืืืืืง (ืืื ืื ืืขืจืฉืืจืืึทืื - ืืืืืืืืง!) ืจืขืืืฆืืจื ืื ืืืืงืืึทื ืืื ืืืึธืก ืืึทืื ืืึทืงืืืขื ืืื ืื ืืึทืืึทืืืืก.
ืืื ืึท ืจืขืืืืืึทื, ืื ืืืึทืกืขืจ ืืื ืืขืืืขื ื ืึทืก ืืื ืืึธืก ืืื ื ืืฉื ืึท ืืชืืืืช. ืึธืืขืจ, ืืืฆื ืืื ืืึธืื ืื ืงืึธื ืฆื ืฉืคึผืืื ืืื ืืื ืืึธืืขืจ ืงืืืขื ืฆื ืขืืืขืืข ืืขืจ ืืฉืืงืึทืืืข ืงืึทื ืงืืืืฉืึทื ื.
ืืงืืจ: www.habr.com