“重新编制索引的过程有问题."产品进口后 [英] "There was a problem with reindexing process." after product import

问题描述

使用Magento 1.6

Using Magento 1.6

我必须对目录进行一些批量更改，因此必须完整导出产品，进行更改，然后导入修改后的文件.

I had to make some bulk changes to my catlog and so did a full product export, made the changes then imported the ammended file.

此后，有一些索引需要更新，除了产品属性"索引正确外，其余所有索引都需要更新.

Afterwards there were a few index that needed updating, all of them except the "Product Attributes" index correctly.

当我尝试重新索引该索引时，出现错误重新索引过程存在问题."

When I try to re index that one I get the error "There was a problem with reindexing process."

在var/report中没有创建新的错误，因此我不知道问题出在哪里.

There are no new errors created in var/report and so I have no idea what the problem is.

csv-> http://lazytrek.com/magento_export.csv

编辑-根据OSdave的建议，出现以下错误:

edit - As per OSdave's suggestion I got the following error:

SQLSTATE [23000]:违反完整性约束:1062键'PRIMARY'的重复条目'84 -142-1-58'

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '84-142-1-58' for key 'PRIMARY'

推荐答案

好，我自己修复了此问题

OK I fixed this myself

在SQL错误中，第一个数字(在我的情况下为84)表示产品ID，某些商品未正确导入该ID，我进入该产品，手动进行了保存，嘿，我可以重新编制索引.

In the SQL error the first number (in my case 84) indicates the product id, something did not import properly with that ID, I went into the product, saved it manually and hey presto I could re-index.

希望可以帮助某人:-)

Hope that helps someone :-)

这篇关于“重新编制索引的过程有问题."产品进口后的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！