My headache begins with a common URL Rewrite issue. I am running Magento 2.3 and rely heavily on an extension called Firebear Import / Export to handle my suppliers CSV feed imports.
Let's say in this example, I currently have no products and then run the import one by one until all 4 of my suppliers products are in the shop (note that a percentage of products will be duplicated as each supplier are in the same trade) - the import runs smoothly and Magento generates the URLs as it should.
Here lies where I am stuck, the URL paths for the products display as such:
I need the URLs to be displayed showing the full category path, yes I have changed all the settings in admin such as
Use Categories Path for Product URLs = Yes
This doesn't make a difference even after a reindex and cache clean. Here's the catch, I purchased an extension that regenerates URLs and when I run it (takes about 20 minutes) the category path shows properly in the URL! Fantastic until i run a product import job, it now throws errors like this:
Some URL paths already exist in the url_rewrite table and not related to Product ID: 5013. Please remove them and execute this command again.
The import completes but the products that display in these errors will not update, meaning prices and quantity will never change and that's not good.
I am desperate to get the category paths shown but do not use the 3rd party extension as it creates an issue in my product imports.
My questions are:
- Why isn't Magento allowing the category path to be shown even though I'm telling it to?
- How can i get it to work properly without using 3rd party extensions?