Hi everyone,
I have imported more than 3500 products from another e-shop, using Magmi mass importer.
After import i have noticed that product urls doesn't have category path.
example: http://website.com/product.html (should be only in home page)
should be: http://website.com/category/subcategory/product.html (when you are in a category of course)
I have done the following steps:
1. Truncated core_url_rewrites table
2. Reindexed everything
3. Cleared cache.
4. Enabled Use product category path in urls
5. Reindexed everything
6. Cleared cache.
Nothing fixed my issue. Can anyone help me with this one?
I wrote this issue in so many forums.. Even Magmi and Theme support, no answer..
Any help would be very appreseated.
Hi zygimantas123,
Did you try to reindex from command line?
1 – Go to ‘shell’ folder in your Magento installation:
cd shell
2 – Execute reindex using this command:
php -f indexer.php reindexall
It is possible to get full list of Magento indexer commands using this command:
php -f indexer.php help
To get a list of available indexes, execute this command:
php -f indexer.php info
By default there are 7 indexes in Magento:
catalog_product_attribute Product Attributes
catalog_product_price Product Prices
catalog_url Catalog URL Rewrites
catalog_category_product Category Products
catalogsearch_fulltext Catalog Search Index
cataloginventory_stock Stock Status
tag_summary Tag Aggregation Data
Individual commands for re-indexing:
php indexer.php --reindex catalog_product_attribute
php indexer.php --reindex catalog_product_price
php indexer.php --reindex catalog_url
php indexer.php --reindex catalog_category_product
php indexer.php --reindex catalog_search_fulltext
php indexer.php --reindex cataloginventory_stock
php indexer.php --reindex tag_summary
My suggestion: run one at time.
Thanks for reply.
Nope. That didn't fix my issue.
Any more suggestions?
ok, let's try another solution.
go to Admin > System > Configuration > Catalog > Search Engine Optimization > Use Categories Path for Product URLs and make sure this option is set "Yes".
I hope this can help you.
Yes it is already enabled.
Thanks
Sorry I didn't understand your answer.
The issue is solved?
Sorry for not clear answer. No that didn't solve my issue.
And i can't find any solution so far. Do you know any more solutions for this?
Thanks
You will only see the product urls with the categories in them if you browse to them via the categories. If you access them directly or through the sitemap - you will go straight to the canonical url e.g. {site.com}/{url}.html.
If you browse through your category tree on the frontend and then click a product - does this show the category in the URL for you?
If not; then my suspicion would be that it is down to the theme you are using ; could you try using magentos base template to see if the urls have categories in them when accessed like that?
Hi,
Run this query with product id that you're sure that exist:
SELECT * FROM core_url_rewrite WHERE product_id = 999
It will return all url "resquest_path" that should work for that product and all "target_path"
I have found that in Magento Community that if Is_Anchor is set to Yes then the category path will not be in urls for products within that category.