Hi David,
I have asked this question before and you replied with details of the export and import features, so thanks for that..
I am not sure I explained what I wanted very well as can't do what I want through the export file provided, as that feature provided exports mapped products and not all product names, if I have undertsood it correctly.
What I need to do is find a way to export all product names (not mapped), then re-name them and import them so they appear in the productsmap.php section of the admin area. This will not change the names in the feeds as I update the feeds weekly.
What this des is allows me to get all the names set-up with the naming conventions I want, then I can go through and start maping ALL products, once mapping is complete I can then impliment my 301 re-directs with the product new names I have added.
Thanks again
Stuart
Hi Stuart,
Here's a simple export script to output all products as a text file... create as something like allproducts.php and then upload to and browse to from the main Price Tapestry installation folder:
<?phprequire("includes/common.php");
header("Content-Type: text/plain");
header("Content-Disposition: attachment; filename=allproducts.txt");
$sql = "SELECT DISTINCT(name) FROM `".$config_databaseTablePrefix."products` ORDER BY name";
$link = @mysql_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword);
@mysql_select_db($config_databaseName,$link);
$result = mysql_unbuffered_query($sql,$link);
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
print $row["name"]."\n";
}
exit();
?>
Cheers,
David.
--
PriceTapestry.com