Magento - Tabellen: catalog_

catalogrule_product Spalten: sub_simple_action sub_discount_amount fehlen in der Version 2.1.2 SQL

REPLACE INTO mage2pd.catalogrule_product
(rule_product_id,rule_id,from_time,to_time,customer_group_id,product_id,
action_operator,action_amount,action_stop,sort_order,website_id) 
SELECT
rule_product_id,rule_id,from_time,to_time,customer_group_id,product_id,
action_operator,action_amount,action_stop,sort_order,website_id
FROM pool5.catalogrule_product;

catalog_product_entity Spalte: entity_type_id fehlt in der Version 2.1.2 SQL

REPLACE INTO mage2pd.catalog_product_entity_text
(value_id, attribute_id,store_id,entity_id,value) 
SELECT
value_id, attribute_id,store_id,entity_id,value
FROM pool5.catalog_product_entity_text;

Reihenfolge beachten!

Es werden FOREIGN KEY constraint verwendet, d.h die entsprechenden Tabellen müssen entsprechend vorher importiert werden.

catalog_product_entity_text Spalte: entity_type_id fehlt in der Version 2.1.2 SQL

REPLACE INTO mage2pd.catalog_product_entity_text
(value_id, attribute_id,store_id,entity_id,value) 
SELECT
value_id, attribute_id,store_id,entity_id,value
FROM pool5.catalog_product_entity_text;

Reihenfolge beachten!

Es werden FOREIGN KEY constraint verwendet, d.h die entsprechenden Tabellen müssen entsprechend vorher importiert werden. catalog_product_entity

SQL Fehler (1452): 
Cannot add or update a child row: a foreign key constraint fails (`mage2pd`.`catalog_product_entity_text`, CONSTRAINT `CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCA ...