David,
In the admin I have:
echo "<p><strong>Essential Statistics</strong><br />Total number of products: ".number_format($totalproducts)."<br />";
echo "Total number of clicks: ".$totalclicks."</p>";
which reports
Essential Statistics
Total number of products: 132,221
yet on the site I have
require("config.php");
/*require("includes/database.php");*/
$sql = "SELECT count(*) as numProducts FROM `".$config_databaseTablePrefix."products`";
database_querySelect($sql,$rows);
$numProducts = $rows[0]["numProducts"];
print "Today ShopSort is comparing ".number_format($numProducts)." products";
which reports
Today ShopSort is comparing 117,205 products
Why the difference ?
Eddie
Hi,
Where you've got commas in the description; have you made sure that the autodetection selected a quoted file format?
You can double check this by selecting the format manually - make sure you select something like:
"Quoted Text - No Header Row - Comma Separated"
or
"Quoted Text - Header Row - Comma Separated"
(if your feed has a header row)
This should help...
Cheers,
David.
This works fine with me though I have noticed one problem.
Some retailers have put pesky commas in their descriptions. This means that the CSV file isn't imported properly.
PT admin reports say 100 products for example yet the main site reports 75.
Perhaps this is causing the difference?