catalog_url reindex only new items

[MinKR]

so

DELETE FROM core_url_rewrite WHERE is_system = 0

is what i should run before reindexing is started in the script right? 

@iweb_p3mbo

[iweb_neil]

Ideally.. you would not need to run the DELETE *every* time. So running that manually one-off and fixing your duplicate URL Keys shoudl be sufficient.

[MinKR]

but the url rewrite table gets filled with duplicates quite fast... why does it even create those duplicates? is there no option to check for that built into the indexer?

[iweb_p3mbo]

Hi,

It creates them because you have 2 or more products that have the same URL key for some reason. So until you fix them; no matter how many times you clear them down.. the table will eventually grow.

[MinKR]

the products i import are the same... is that the reason?

(its the same csv with the same data)

i guess i had to rewrite some core file to fix the duplication issue?!

but if using DELETE *every* time doesn't cause any problems i would stick with that

@iweb_p3mbo

[iweb_p3mbo]

Running the DELETE each time would resolve the issue - however that's just masking the problem. Running the same import over again also shouldn't affect the url keys.. is when you have 2 products with the same URL key that the problem occurs.

e.g.

• Black Top
• Red Top
• Green Top
• Red Top

Would create a duplicate URL key for the red-top (even though they're both technically 2 different products).

Hope this makes sense.