You are here:  » PT cant count!

Support Forum



PT cant count!

Submitted by Eddie on Tue, 2006-11-28 10:05 in

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

Submitted by dbfcs on Mon, 2006-12-11 16:29

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?

Submitted by support on Mon, 2006-12-11 16:41

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.