cancel
Showing results for 
Search instead for 
Did you mean: 

catalog_url reindex only new items

Re: catalog_url reindex only new items

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

 

 

Re: catalog_url reindex only new items

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.

Neil - Magento Certified Solutions Specialist
www.iwebsolutions.co.uk | Magento Small Business Partner

Re: catalog_url reindex only new items

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?

 

Re: catalog_url reindex only new items

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.

Problem solved? Click Accept as Solution!
Magento Certified Developer Plus | www.iwebsolutions.co.uk | Magento Small Business Partner

Re: catalog_url reindex only new items

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 Cat Happy

@iweb_p3mbo

 

Re: catalog_url reindex only new items

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.

Problem solved? Click Accept as Solution!
Magento Certified Developer Plus | www.iwebsolutions.co.uk | Magento Small Business Partner