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. ('hp-elitedesk-800-g4-3-2-ghz-8th-gen-intelr-coretm-i7-i7-8700-black-silver-sff-pc-1', 'computing/desktop-computing/hp-elitedesk-800-g4-3-2-ghz-8th-gen-intelr-coretm-i7-i7-8700-black-silver-sff-pc-1');
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?