Page 1 of 1
SEO Urls
Posted: Wed Jan 30, 2019 9:46 pm
by chrisgwynne
Hello
I've just upgraded to the latest version of OC from 2.3.0.2 - in 2.3.0.2 I have SEO URL filled out on 5000 products. Now on v3 they're blank. Have I made an error somewhere or doesn't this get converted over? How do I fix without manually redoing every URL?
Kind regards,
Chris
Re: SEO Urls
Posted: Wed Jan 30, 2019 10:19 pm
by xxvirusxx
Check seo_url table from phpMyAdmin to see if is empty.
If is empty you can easily convert url_alias(from 2.3.0.2) to seo_url(from 3.0.2.0) table using a text editor
Example:
url_alias
Code: Select all
(824, 'product_id=48', 'ipod-classic'),
Code: Select all
(824, 0, 1, 'product_id=48', 'ipod-classic'),
If you made backup before
Re: SEO Urls
Posted: Wed Nov 13, 2019 7:18 am
by brian47374
I have the exact same issue. However, I am not clear on what you are using the text editor for. Are you renaming the url_alias to seo_url? Would you be so kind as to elaborate on this process a little more in detail?
Thanks,
Re: SEO Urls
Posted: Wed Nov 13, 2019 11:17 pm
by letxobnav
Well, upgrading OC always goes wrong.
For this particular issue:
V3 uses a different table name, different column names and added 2 columns for seo urls.
V2
Code: Select all
CREATE TABLE IF NOT EXISTS `oc_url_alias` (
`url_alias_id` int(11) NOT NULL AUTO_INCREMENT,
`query` varchar(255) NOT NULL,
`keyword` varchar(255) NOT NULL,
PRIMARY KEY (`url_alias_id`),
KEY `query` (`query`),
KEY `keyword` (`keyword`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
V3
Code: Select all
CREATE TABLE IF NOT EXISTS `oc_seo_url` (
`seo_url_id` int(11) NOT NULL AUTO_INCREMENT,
`store_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`query` varchar(255) NOT NULL,
`keyword` varchar(255) NOT NULL,
PRIMARY KEY (`seo_url_id`),
KEY `query` (`query`),
KEY `keyword` (`keyword`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
So, if you have an export of the V2 table, you need to edit that to conform to the V3 table before importing.
Re: SEO Urls
Posted: Thu Nov 14, 2019 10:19 am
by brian47374
I exported the v2.0.3.2 (url_alias_id) to csv and then edited the table columns to be named the same and in order as the seo_url table. I then imported them into the 3.0.3.2 seo_url and the data imported. However, all of the store_id and language_id values are set to “0” which occurred when I imported the csv file.
Now, when I go to the products, I still do not see anything in the product tabs to display the change. Is there something that I am missing? Is there some sort of cache issue?
Re: SEO Urls
Posted: Thu Nov 14, 2019 1:21 pm
by letxobnav
check what your language's language_id is (probably 1) and update the table seo_url setting language_id to that.
Re: SEO Urls
Posted: Thu Nov 14, 2019 9:43 pm
by brian47374
Great! It worked!!! Saved me A LOT of work.
Thank you very much!