Inveo Community • [PrestaShop] Sitemaps exceeds 100,000 urls

Page 1 of 1

[PrestaShop] Sitemaps exceeds 100,000 urls

Posted: Tue Sep 04, 2012 12:26 am

by monstreyhans

I have a problem whit sitemap.php. I have more than 100.000 URL"s and google accept only 50.000 URL's in one sitemap-file. How can i split it in different sitemap-files.

Re: [PrestaShop] Sitemaps exceeds 100,000 urls

Posted: Wed Sep 05, 2012 11:38 am

by inveo

Please make a second copy of sitemaps/products.php file and put it to
the same folder.

Then open-up both files and change the line:

Code: Select all

$result = Db::getInstance()->ExecuteS("SELECT p.`id_product`,
p.`date_add`, p.`date_upd` FROM ".TABLE_PRODUCT." p,
".TABLE_PRODUCT_LANG." pl WHERE p.`active` = '1' AND pl.`id_product` =
p.`id_product` AND pl.`id_lang` = '".$langId."' AND p.`id_product` IN
(SELECT cp.`id_product` FROM ".TABLE_CATEGORY_GROUP." cg LEFT JOIN
".TABLE_CATEGORY_PRODUCT." cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1) ORDER BY p.`id_product` DESC");

to (in the first file):

Code: Select all

$result = Db::getInstance()->ExecuteS("SELECT p.`id_product`,
p.`date_add`, p.`date_upd` FROM ".TABLE_PRODUCT." p,
".TABLE_PRODUCT_LANG." pl WHERE p.`active` = '1' AND pl.`id_product` =
p.`id_product` AND pl.`id_lang` = '".$langId."' AND p.`id_product` IN
(SELECT cp.`id_product` FROM ".TABLE_CATEGORY_GROUP." cg LEFT JOIN
".TABLE_CATEGORY_PRODUCT." cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1) ORDER BY p.`id_product` DESC LIMIT 0,40000");

to (in the second file):

Code: Select all

$result = Db::getInstance()->ExecuteS("SELECT p.`id_product`,
p.`date_add`, p.`date_upd` FROM ".TABLE_PRODUCT." p,
".TABLE_PRODUCT_LANG." pl WHERE p.`active` = '1' AND pl.`id_product` =
p.`id_product` AND pl.`id_lang` = '".$langId."' AND p.`id_product` IN
(SELECT cp.`id_product` FROM ".TABLE_CATEGORY_GROUP." cg LEFT JOIN
".TABLE_CATEGORY_PRODUCT." cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` = 1) ORDER BY p.`id_product` DESC LIMIT
40000,80000");

Cart

(empty)

No products

Shipping 0,00 €
Total 0,00 €

Cart Check out »

Prices are tax inclusive.

The VAT rate for your country (US) * is 0,0 % because it is not a member of the European Union (EU).

* Please create an account if your country does not match.

Community feed

[Zen Cart] Can't execute Magic SEO URLs sitemaps
I installed Magic SEO URLs Sitemaps Add-On for ZenCart MSU4.x/MSU5.x 2.0 on my server, when I try to generate sitemaps using: https://www.pechesudv155.owally.com/sitemaps.php I received :...
by peter@pechesud.com
[phpBB3] Sharing users between phpBB / PrestaShop
Hi i have 2 question 1- prestashop module support phpBB 3.3 ? 2- why we can not login in prestashop and phpbb with same user?
by zohall
[phpBB3] AJAX Userinfo Extension
Hi! I'm having trouble with this extension: https://www.phpbb.com/customise/db/exte ... _userinfo/ I tried asking support from the author but for no avail, since now. My request for support...
by Lord Phobos
[phpBB3] Upgrade to phpBB 3.2.3
Hello.. after Upgrade to phpBB 3.2.3 I am getting this message.. How can I solve this issue..? Thank you
by ingbrzy
[phpBB3] URL path changed
Hello.. I have changed my site path after moving to new hosting and now can not activate SEO module.. new path http://www.miuios.cz/domains/miuios.cz/ could you help me? thank you
by ingbrzy2

Join our support forum » Pre-Sales Questions »

Featured Testimonials

Great work - great support - great tool! Thank you for your whole work and your great support. We're very glad with the plugin and our online portals now run much faster than before.

Alexander, the owner of Die Wirtschaft Köln

The support provided by the Inveostore.com team was top-notch! I had some questions regarding installation and they provided fast and friendly help. I’ll be recommending Magic SEO URLs to anyone who needs a quality URL re-write application from a great company.

Andrew, the owner of Right Channel Radios

More Testimonials »