cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate data from M1 to M1 Products not displayed after copyting tables

Migrate data from M1 to M1 Products not displayed after copyting tables

Hi

 

 

I am copyring data from current Magento1 site to a new Magento1 site.

I have copied

catalog_product_index
catalog_product_link
catalog_product_link_attribute
catalog_product_link_attribute_decimal
catalog_product_link_attribute_int
catalog_product_link_attribute_varchar
catalog_product_option
catalog_product_option_price
catalog_product_option_title
catalog_product_option_type_price
catalog_product_option_type_title
catalog_product_option_type_value
catalog_product_relation
catalog_product_website
donwloadable
catalog_product_index
catalog_product_flat_1
catalog_category_entity
 catalog_category_entity_datetime
 catalog_category_entity_decimal
catalog_category_entity_int
catalog_category_entity_text
catalog_category_entity_varchar
 catalog_category_flat
customer_entity
customer_entity_datetime
customer_entity_decimal
customer_entity_int
customer_entity_text
customer_entity_varchart
customer_form_attribute

 

After indexing all, products are not displayed on frontend.

Do you have any suggestions?

1 REPLY 1

Re: Migrate data from M1 to M1 Products not displayed after copyting tables

I've found the table `mg_catalog_product_index_price` is truncated when "re-index" is ran.

Would you tell me why this table is updated with no records when re-indexed?