Ultimate SEO v3 (and v2.200) [Support Thread]

[icecold]

Where the urls are stored? I mean I need to know where in the database or how can I pull the list of rewritten URLs either from the database or somewhere else talking about product 'landing' pages. THe table usu doesn't have the url ... I just need the url and product id or whatever index is used to reference it, so I can I add each url to a csv matching the corresponding product's id.

[mc12345678]

Where the urls are stored? I mean I need to know where in the database or how can I pull the list of rewritten URLs either from the database or somewhere else talking about product 'landing' pages. THe table usu doesn't have the url ... I just need the url and product id or whatever index is used to reference it, so I can I add each url to a csv matching the corresponding product's id.

They are not stored, they are generated.

One way to obtain the product's url is to use EasyPopulate v4 and export with the product's URL option turned on from the configuration menu. A column will exist with the product's url/uri as generated by your uri rewriter. The other information you are wanting included can be added as a user identified field if it exists in the products table and is already not included in the export or it can be pieced together as necessary.

[icecold]

I don't use EasyPopulate, if they are generated I thought once created there were stored somewhere, any way to avoid installing EasyPopulate4?

[DrByte]

Here's a really simple way:

a) visit a product in your store
b) note the URL
c) see the pattern: the segments with slashes etc, and where the product-id number appears

Now you can replicate the same in your spreadsheet.

Also: USU honors default Zen Cart URLs and tells search engines the correct rewritten ("canonical") URL to index, so there's no harm in giving out the non-rewritten URL too

[icecold]

I have thousands of products ... to do this manually is crazy, I tried doing a VLOOKUP, to match exactly what was active, didn't work ... Anyway thanks for the tips I'll try something else ...

[mc12345678]

I have thousands of products ... to do this manually is crazy, I tried doing a VLOOKUP, to match exactly what was active, didn't work ... Anyway thanks for the tips I'll try something else ...

Also any process that will access zen_href_link and is provided the correct ZC information can generate or be used to generate your desired information in the CSV.

[mc12345678]

Here's a really simple way:

a) visit a product in your store
b) note the URL
c) see the pattern: the segments with slashes etc, and where the product-id number appears

Now you can replicate the same in your spreadsheet.

Also: USU honors default Zen Cart URLs and tells search engines the correct rewritten ("canonical") URL to index, so there's no harm in giving out the non-rewritten URL too

I have thousands of products ... to do this manually is crazy, I tried doing a VLOOKUP, to match exactly what was active, didn't work ... Anyway thanks for the tips I'll try something else ...

I think you missed DrByte's point. If you look at the example of a single uri, And you look at the data you have available in your csv, the thought is that you can "reverse engineer" what it takes to get the same type of uri for all products. Then apply that "rule" and tada. Sure, in answering the question of is there another way to get all the URIS, manually one by one is a way, but because this plugin doesn't store/offer manual manipulation of the uri, it is going to be "rule" based and methodical.

[holawill]

i tested to install ultimate_urls-215 for localhost zencart1.5.5b, just follow the steps one by one, finally when i click any link in admin page, it shows error: WARNING: An Error occurred, please refresh the page and try again.

so i checked logs as following:

[09-Nov-2016 12:42:59 UTC] Request URI: /new/admin/index.php, IP address: ::1
#1 trigger_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167]
#2 queryFactory->show_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139]
#3 queryFactory->set_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266]
#4 queryFactory->Execute() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:145]
#5 usu_plugin->handleDatabaseChanges() called at [D:\wamp\www\new\admin\includes\classes\plugin.php:336]
#6 plugin->install() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:474]
#7 usu_plugin->install() called at [D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php:7]
#8 require(D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php) called at [D:\wamp\www\new\includes\autoload_func.php:48]
#9 require(D:\wamp\www\new\includes\autoload_func.php) called at [D:\wamp\www\new\admin\includes\application_top.php:171]
#10 require(D:\wamp\www\new\admin\includes\application_top.php) called at [D:\wamp\www\new\admin\index.php:10]


WAMP I used: wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10

Could anyone help me? I have spent several hours and test many times, but still failed to install it. or ultimate_urls-215 does not work for the latest zencart version 1.5.5b???

Any help would be highly appreciated!
Thanks in advance.
Will

[mc12345678]

i tested to install ultimate_urls-215 for localhost zencart1.5.5b, just follow the steps one by one, finally when i click any link in admin page, it shows error: WARNING: An Error occurred, please refresh the page and try again.

so i checked logs as following:

[09-Nov-2016 12:42:59 UTC] Request URI: /new/admin/index.php, IP address: ::1
#1 trigger_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:167]
#2 queryFactory->show_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:139]
#3 queryFactory->set_error() called at [D:\wamp\www\new\includes\classes\db\mysql\query_factory.php:266]
#4 queryFactory->Execute() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:145]
#5 usu_plugin->handleDatabaseChanges() called at [D:\wamp\www\new\admin\includes\classes\plugin.php:336]
#6 plugin->install() called at [D:\wamp\www\new\admin\includes\classes\usu_plugin.php:474]
#7 usu_plugin->install() called at [D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php:7]
#8 require(D:\wamp\www\new\admin\includes\init_includes\init_usu_install.php) called at [D:\wamp\www\new\includes\autoload_func.php:48]
#9 require(D:\wamp\www\new\includes\autoload_func.php) called at [D:\wamp\www\new\admin\includes\application_top.php:171]
#10 require(D:\wamp\www\new\admin\includes\application_top.php) called at [D:\wamp\www\new\admin\index.php:10]


WAMP I used: wampserver3.0.6_x86_apache2.4.23_mysql5.7.14_php5.6.25-7.0.10

Could anyone help me? I have spent several hours and test many times, but still failed to install it. or ultimate_urls-215 does not work for the latest zencart version 1.5.5b???

Any help would be highly appreciated!
Thanks in advance.
Will

Please provide the remainder of the error message. Ie. The error itself... The above information is simply the path of files involved at the time of the error.

[lat9]

@holawill, do you also have the Edit Orders plugin installed?