SitemapXML v.2

[Adrian Ciocîrlan]

@Adrian,
If the CSV import of manufacturers breaks things but entering them manually via the admin works fine, then something is incomplete when processing your CSV data. Either the data isn't keyed properly, or there are records with invalid data, or maybe you've made alterations to require multiple tables for manufacturer data but your import doesn't take those into account.
Best to fix the CSV import issue, because there are probably additional bad side-effects to the bad import beyond just this XML feed issue.

10x DrByte,

How would I know if the import went wrong when all the manufacturers seem imported right?

They all apear in the Admin & Catalog , their pictures asign well, CEON uris asign right through admin update uri, manufacturer dropdown and product info page manufacturer sidebox work fine....every manufacturer's individual page works and sorts products right...

Does the csv import seem corrupted?

A

[mesnitu]

This has something to do with this query ( in modules/pages/sitemapxml/sitemapxml_manufacturers.php ).

Looking at db tables doesn't have a difference ( as I can see) between inserting with EP4 or in the admin in the date added.
I've change some dates added since with EP upload they add the same date and time, but no diference.



The first query $table_status = $db->Execute("SHOW TABLE STATUS LIKE '" . TABLE_MANUFACTURERS . "'");
returns

[fields] => Array
        (
            [Name] => manufacturers
            [Engine] => MyISAM
            [Version] => 10
            [Row_format] => Dynamic
            [Rows] => 59

But the next one :

$manufacturers = $db->Execute("SELECT m.manufacturers_id, GREATEST(m.date_added, IFNULL(m.last_modified, '0001-01-01 00:00:00')) AS last_date, mi.languages_id" . $select . "
                                 FROM " . TABLE_MANUFACTURERS . " m
                                 LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi ON (mi.manufacturers_id = m.manufacturers_id)
                                 WHERE mi.languages_id IN (" . $sitemapXML->getLanguagesIDs() . ") " .
                                 (SITEMAPXML_MANUFACTURERS_ORDERBY != '' ? "ORDER BY " . SITEMAPXML_MANUFACTURERS_ORDERBY : '')); 

[resource] => mysqli_result Object
(
[current_field] => 0
[field_count] => 3
[lengths] => Array
(
[0] => 2
[1] => 26
[2] => 1
)

[num_rows] => 50
[type] => 0
)

............so , by this time you may have thought that I was posting a solution.... but no .... any idea why this happens ? :)

[mesnitu]

@Adrian Ciocîrlan do you have the same manufacturers ID in manufacturers_info ID table ?

I do not , but I' using a altered version of EP4 .... so I can't tell, got to check some more stuff .

[mesnitu]

10x DrByte,

How would I know if the import went wrong when all the manufacturers seem imported right?

They all apear in the Admin & Catalog , their pictures asign well, CEON uris asign right through admin update uri, manufacturer dropdown and product info page manufacturer sidebox work fine....every manufacturer's individual page works and sorts products right...

Does the csv import seem corrupted?

A

Check if this works : https://www.zen-cart.com/showthread....04#post1314404

For me it does , but if you have the same IDs in manufacturer and manufacturer_info.... well.... I don't know

[a_berezin]

But could this be related if a manufactured has products or not ?

not, does not depend on the products.

[a_berezin]

Why don't you consider this option?

wow! What a strict examiner! You do not mistake? If it is important for you to make it work with EP4, understand the problem and offer solutions.

[mesnitu]

not, does not depend on the products.

Thanks.

By the way, I was about to ask this before I saw this issue a spent some time around it, but, adding this to the google webmaster brings any advantages ? Or more or less it's the same using just the normal sitemap link ?

It says he will receive a fresh sitemapindex.xml....this means that the rebuild the sitemap ?

inline=yes - output file sitemapindex.xml. In Google Webmaster Tools you can define your "Sitemap URL":
http://your_domain/index.php?main_pa...xml&inline=yes
And every time Google will get index.php?main_page=sitemapxml he will receive a fresh sitemapindex.xml.

[a_berezin]

do you have the same manufacturers ID in manufacturers_info ID table ?
I do not

This is an error - a violation of the logical integrity of the database.

[a_berezin]

By the way, I was about to ask this before I saw this issue a spent some time around it, but, adding this to the google webmaster brings any advantages ? Or more or less it's the same using just the normal sitemap link ?

What are the advantages sitemap XML?
1. RTFM - https://support.google.com/webmasters/answer/156184
2. Be loyal to the search engines - they appreciate it.
3. Sitemap helps to index new products.
4. Sitemap contains an actual list of all pages that should be indexed. In Google Search Console You can see how many of them are indexed, what errors occurred while indexing. It is very convenient.
Notice.
If in the store 10 products, there is no need to Sitemap.
Sitemap - not a magic pill. This is just one of the tools that must be used in conjunction with the other.

It says he will receive a fresh sitemapindex.xml....this means that the rebuild the sitemap ?

This means that the date of the site map is new, and there has changed content or not is unknown.

inline=yes - output file sitemapindex.xml. In Google Webmaster Tools you can define your "Sitemap URL":
http://your_domain/index.php?main_pa...xml&inline=yes
And every time Google will get index.php?main_page=sitemapxml he will receive a fresh sitemapindex.xml.

Yes. But I never use it. I generate Sitemap by the cron, once a day. It allows to save resources of the server. Trifle of course, but nice. :) Well, the static file is given much faster. Of course I'm talking about stores where thousands of products and not just 10.

Sitemap Less - anyone can easily get information about the products, categories, brands, and other selling pages. This facilitates content theft (grabbing). That too is solved - it is necessary to use protection against third-party mods. On checking the reverse DNS. Give saytmap only the robots, which have specified User-Agent and come up with search engine servers.

[mesnitu]

ok !
I've using this plugin for a long time , 3 years I think... but only now I actually read the readme file about the $_GET parameters, and that's why I've ask about the "inline=yes"

Yep, I think I'll continue with the "normal" link.
Thanks