Hi David,
Please can you take a look at our site:-
{link saved} (UN: Gobbo PW: Gobbobxs)
If you look at the 'Search or browse by merchant, category or brand' and click on the links you will notice these are not given us the correct information. Now we have correctly linked up the feeds with the 'Automation Tool', but it looks like some of the feeds have not been set up correctly.
How can we easily look for the feeds which are incorrect to fix them?
Also how can we remove feeds we already registered?
Kind Regards,
Gobbo
Hi Gobbo,
I think what's happened is that your feeds are "Quoted Text" but not necessarily quoted; which means that it has only been auto-detected if there is no quoted content in the first or second rows.
If all of your feeds are the same format, then to save you having to re-register every feed the following dbmod.php script will update the format of ALL feeds to Quoted Text - Header Row - Comma Separated
<?phprequire("includes/common.php");
$sql = "UPDATE `".$config_databaseTablePrefix."feeds` SET format='csv|44|1|34'";
database_queryModify($sql,$result);
print "Done.";
?>
After running the script (from main Price Tapestry installation folder e.g. top level on your site) re-import all feeds and that should fix it. As you add further feeds from the same network rather than accepting the auto-detected Format String on Feed Registration Step 1; instead select the correct format from the drop-down box e.g. "Quoted Text - Header Row - Comma Separated".
To remove feeds that have been already registered simply delete from the /feeds/ folder and then you will see a De-Register link alongside the feed on the /admin/ home page which will remove all products from the deleted feed from the database.
Cheers,
David.
--
PriceTapestry.com