Comments (4)
These warnings are due to the fact that magmi cannot identify root category associated for store view or website for given items.
Have you a multiple store setup ?
Have you set up a root category for your store ?
from magmi-git.
What we think happened is when we cleared all the products and categories using the utilities, Magmi did not clear the tables correctly. Therefore, when we were running a fresh import this caused error. So we run this as a recommendation from a stackoverflow post. We're not sure if it is needed, but it did the job (it appears).
-- Perform this below and then set the category (ID:2) name to default and is_active.
-- Index should then run without issue
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute`;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_link_type`;
TRUNCATE TABLE `catalog_product_option`;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_product_entity`;
TRUNCATE TABLE `catalog_product_entity_group_price`;
TRUNCATE TABLE `catalog_product_index_group_price`;
TRUNCATE TABLE `catalog_product_index_price`;
TRUNCATE TABLE `catalog_product_index_price_idx`;
TRUNCATE TABLE `catalog_product_index_tier_price`;
TRUNCATE TABLE `cataloginventory_stock`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
INSERT INTO `catalog_product_link_type`(`link_type_id`,`code`) VALUES (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
INSERT INTO `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) VALUES (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
INSERT INTO `cataloginventory_stock`(`stock_id`,`stock_name`) VALUES (1,'Default');
TRUNCATE TABLE `catalog_category_entity`;
TRUNCATE TABLE `catalog_category_entity_datetime`;
TRUNCATE TABLE `catalog_category_entity_decimal`;
TRUNCATE TABLE `catalog_category_entity_int`;
TRUNCATE TABLE `catalog_category_entity_text`;
TRUNCATE TABLE `catalog_category_entity_varchar`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `catalog_category_product_index`;
INSERT INTO `catalog_category_entity`(`entity_id`,`entity_type_id`,`attribute_set_id`,`parent_id`,`created_at`,`updated_at`,`path`,`POSITION`,`level`,`children_count`) VALUES (1,3,0,0,'0000-00-00 00:00:00','2009-02-20 00:25:34','1',1,0,1),(2,3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0);
INSERT INTO `catalog_category_entity_int`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,32,0,2,1),(2,3,32,1,2,1);
INSERT INTO `catalog_category_entity_varchar`(`value_id`,`entity_type_id`,`attribute_id`,`store_id`,`entity_id`,`value`) VALUES (1,3,31,0,1,'Root Catalog'),(2,3,33,0,1,'root-catalog'),(3,3,31,0,2,'Default Category'),(4,3,39,0,2,'PRODUCTS'),(5,3,33,0,2,'default-category');
# Truncate attribute values
TRUNCATE eav_attribute_option;
TRUNCATE eav_attribute_option_value;
SET FOREIGN_KEY_CHECKS = 1;
from magmi-git.
The "Clear catalog, categories & reviews" plugin is buggy (not developped
by me), it destroys too many category entries.
I'll remove it from the next version.
Instead use "clear catalog" & "Custom SQL" for removing categories. this
one is safer.
2014-07-08 10:28 GMT+02:00 cellulosa [email protected]:
What we think happened is when we cleared all the products and categories
using the utilities, Magmi did not clear the tables correctly. Therefore,
when we were running a fresh import this caused error. So we run this as a
recommendation from a stackoverflow post. We're not sure if it is needed,
but it did the job (it appears).-- Perform this below and then set the category (ID:2) name to default and is_active.
-- Index should then run without issueSET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE
catalog_product_bundle_option
;
TRUNCATE TABLEcatalog_product_bundle_option_value
;
TRUNCATE TABLEcatalog_product_bundle_selection
;
TRUNCATE TABLEcatalog_product_entity_datetime
;
TRUNCATE TABLEcatalog_product_entity_decimal
;
TRUNCATE TABLEcatalog_product_entity_gallery
;
TRUNCATE TABLEcatalog_product_entity_int
;
TRUNCATE TABLEcatalog_product_entity_media_gallery
;
TRUNCATE TABLEcatalog_product_entity_media_gallery_value
;
TRUNCATE TABLEcatalog_product_entity_text
;
TRUNCATE TABLEcatalog_product_entity_tier_price
;
TRUNCATE TABLEcatalog_product_entity_varchar
;
TRUNCATE TABLEcatalog_product_link
;
TRUNCATE TABLEcatalog_product_link_attribute
;
TRUNCATE TABLEcatalog_product_link_attribute_decimal
;
TRUNCATE TABLEcatalog_product_link_attribute_int
;
TRUNCATE TABLEcatalog_product_link_attribute_varchar
;
TRUNCATE TABLEcatalog_product_link_type
;
TRUNCATE TABLEcatalog_product_option
;
TRUNCATE TABLEcatalog_product_option_price
;
TRUNCATE TABLEcatalog_product_option_title
;
TRUNCATE TABLEcatalog_product_option_type_price
;
TRUNCATE TABLEcatalog_product_option_type_title
;
TRUNCATE TABLEcatalog_product_option_type_value
;
TRUNCATE TABLEcatalog_product_super_attribute
;
TRUNCATE TABLEcatalog_product_super_attribute_label
;
TRUNCATE TABLEcatalog_product_super_attribute_pricing
;
TRUNCATE TABLEcatalog_product_super_link
;
TRUNCATE TABLEcatalog_product_enabled_index
;
TRUNCATE TABLEcatalog_product_website
;
TRUNCATE TABLEcatalog_product_entity
;TRUNCATE TABLE
catalog_product_entity_group_price
;
TRUNCATE TABLEcatalog_product_index_group_price
;
TRUNCATE TABLEcatalog_product_index_price
;
TRUNCATE TABLEcatalog_product_index_price_idx
;
TRUNCATE TABLEcatalog_product_index_tier_price
;TRUNCATE TABLE
cataloginventory_stock
;
TRUNCATE TABLEcataloginventory_stock_item
;
TRUNCATE TABLEcataloginventory_stock_status
;INSERT INTO
catalog_product_link_type
(link_type_id
,code
) VALUES (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
INSERT INTOcatalog_product_link_attribute
(product_link_attribute_id
,link_type_id
,product_link_attribute_code
,data_type
) VALUES (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
INSERT INTOcataloginventory_stock
(stock_id
,stock_name
) VALUES (1,'Default');TRUNCATE TABLE
catalog_category_entity
;
TRUNCATE TABLEcatalog_category_entity_datetime
;
TRUNCATE TABLEcatalog_category_entity_decimal
;
TRUNCATE TABLEcatalog_category_entity_int
;
TRUNCATE TABLEcatalog_category_entity_text
;
TRUNCATE TABLEcatalog_category_entity_varchar
;
TRUNCATE TABLEcatalog_category_product
;
TRUNCATE TABLEcatalog_category_product_index
;INSERT INTO
catalog_category_entity
(entity_id
,entity_type_id
,attribute_set_id
,parent_id
,created_at
,updated_at
,path
,POSITION
,level
,children_count
) VALUES (1,3,0,0,'0000-00-00 00:00:00','2009-02-20 00:25:34','1',1,0,1),(2,3,3,0,'2009-02-20 00:25:34','2009-02-20 00:25:34','1/2',1,1,0);
INSERT INTOcatalog_category_entity_int
(value_id
,entity_type_id
,attribute_id
,store_id
,entity_id
,value
) VALUES (1,3,32,0,2,1),(2,3,32,1,2,1);
INSERT INTOcatalog_category_entity_varchar
(value_id
,entity_type_id
,attribute_id
,store_id
,entity_id
,value
) VALUES (1,3,31,0,1,'Root Catalog'),(2,3,33,0,1,'root-catalog'),(3,3,31,0,2,'Default Category'),(4,3,39,0,2,'PRODUCTS'),(5,3,33,0,2,'default-category');Truncate attribute values
TRUNCATE eav_attribute_option;
TRUNCATE eav_attribute_option_value;SET FOREIGN_KEY_CHECKS = 1;
—
Reply to this email directly or view it on GitHub
#65 (comment).
from magmi-git.
Thanks for that, we'll keep that in mind
from magmi-git.
Related Issues (20)
- Error with attribute set association
- Attributes Options needs resaving
- can't check Magmi Magento Reindexer v1.0.3a
- Optimize Magmi HOT 2
- Weee Tax
- Is Magmi compatible with PHP 7.2?
- Magmi stalls on the first line, only sometimes errors HOT 3
- Datapump Ingest returning empty value for [ok]
- PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/cl_prod/vendor/dweeves/magmi/magmi/inc/magmi_mixin.php on line 28
- password stripped of capitals/uppcase
- Magmi Login fails after SUPEE-11219 update? HOT 3
- PHP Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/clients/client2/web2/web/magmi/plugins/extra/itemprocessors/valuetrim/valuetrimmer.php on line 37
- If the image title is the same, it doesn't replace the old image when imported. HOT 5
- Magmi keeps asking for login (M 1.9.4.4) HOT 1
- Products Salable Quantity Remains '0' While Importing New Products.
- Magmi - Imageattribute processor is not working with WEBP images
- Magmi don't work in magento 2.3.7 and php 2.4 HOT 2
- Installation issues Nginx HOT 1
- unable to download image from external URL
- Not updated inventory in the inventory_source_item table while importing Magmi HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from magmi-git.