greetings David,
Hope you are back up to full recovery by now.
Since I run my queries locally and upload the product table, and the feeds table as it also has the product count in it.
Any idea what else I could be missing or is it just a webmaster tool issue?
As looking at the sitemap file appears to only look @ the product table and feeds table.
Bob L.
Thanks for the quick reply.
That feeds table that I upload thur myphpadmin, in my thinking should have given the correct product count and import time.
Or at least I thought so. I know it appears correct in the admin area.
Hi Bob,
Ah - if you're importing both the `feeds` and `products` tables from your off-site installation then all should be fine so my initial thought then is whether the discrepancy is down to GWT grouping by idential URLs (which logically it should be); since any compared products sourced from different feeds would appear in more than one sitemap.
For the same reason, the "Total Products" count on the /admin/ home page is the physical total number of product records; not the total number of unique products.
Also as convergance notes (thanks!) there can be a delay before GWT updates.
If you're still not sure if you could le me know the scope of the discrepancy etc. I'll check it out further for you - if you could post the URL of the installation (I'll remove before posting your reply) that would be handy then I can check it all out...
Cheers,
David.
--
PriceTapestry.com
Bob L.
Hope all is well David,
This appears to be a google WMT issue. As Bing is showing the right submitted urls.
{link saved}
Hello Bob,
sitemap.php returns a sitemap index, which is derived from the `feeds` table of the installation; but since you are creating your database "off site" this may no longer be representative of the entire feed set populating the site.
It is a simple modification to derive the index from the `products` table instead, the only functionality that would be lost is the <lastmod> element within the index, but this is optional anyway and could be re-introduced programatically based on your manual update frequency if required - just let me know. In sitemap.php look for the following code at line 76:
$sql = "SELECT * FROM `".$config_databaseTablePrefix."feeds` WHERE imported > 0 ORDER BY filename";...and REPLACE with:
$sql = "SELECT DISTINCT(filename) FROM `".$config_databaseTablePrefix."products` ORDER BY filename";Finally, remove or comment out the following code at line 73:
print "<lastmod>".@date("Y-m-d",$row["imported"])."</lastmod>";Hope this helps!
Cheers,
David.
--
PriceTapestry.com