Hello David
On several of my magazine feeds they list the same title 4 or 5 times and give different subscription terms, like 3 month, years etc..
I think price tapestry is choosing either the first or last identical item and ignoring the others.
Is there any way I could modify my site and still use the data though?
Also, if not is there any way the datafeed could be read and the lowest value of the item shown?
Cheers Mally
I just encountered a problem similar to this one.
Some of the products in my feed has exactly the same name, but they are of different brand. Now I´ve read your instructions and fixed so they all get imported and is showing in the list, but now I noticed that the prices for one of the products show up in the other products prices. So if the product "Shoe" of the brand "Nike" has the prices €20 and €40, those prices shows up under the product "Shoe" of the brand "Adidas". and vice versa.
Is is possible for the script to check that two products with identical names belongs to different categories and see that they aren´t the same product? It would be great if it was possible without having to change the name to name+brand.
I´m just starting out with PHP, but I would guess it´s a matter of changing something in products.php, right? Is it the code below that gets the prices from the database?
<?php
$sql = "SELECT * FROM `".$config_databaseTablePrefix."products` WHERE name = '".database_safe($q)."' ORDER BY price LIMIT ".$config_resultsPerPage;
?>
/Daniel
Hi Daniel,
Could you email me one or two example URLs showing the products appearing in
different categories so I understand it properly and I'll see what to suggest...
Cheers,
David.
Hello David
The probelm with using
%issues% Issues
Is it will create 2 or more product pages when its the same item, just a different payment price.
Is there any other way you can think of?
Thanks Mally
Hi Mally,
My apologies for this not occurring to me earlier. It should be possible to simply include the price field in the duplication filter during import. In includes/admin.php look for the following code at around line 248:
/* create dupe_hash value */
$dupe_key = $admin_importFeed["merchant"];
// uncomment any additional fields that you wish to filter duplicates on (description not recommended)
$dupe_key .= $record[$admin_importFeed["field_name"]];
// $dupe_key .= $record[$admin_importFeed["field_description"]];
// $dupe_key .= $record[$admin_importFeed["field_image_url"]];
// $dupe_key .= $record[$admin_importFeed["field_buy_url"]];
// $dupe_key .= $record[$admin_importFeed["field_price"]];
$dupe_hash = md5($dupe_key);...and simply uncomment the price field from the $dupe_key construction, as follows:
/* create dupe_hash value */
$dupe_key = $admin_importFeed["merchant"];
// uncomment any additional fields that you wish to filter duplicates on (description not recommended)
$dupe_key .= $record[$admin_importFeed["field_name"]];
// $dupe_key .= $record[$admin_importFeed["field_description"]];
// $dupe_key .= $record[$admin_importFeed["field_image_url"]];
// $dupe_key .= $record[$admin_importFeed["field_buy_url"]];
$dupe_key .= $record[$admin_importFeed["field_price"]];
$dupe_hash = md5($dupe_key);(don't forget to import affected feeds for the duplicate entries to be imported...!)
Cheers,
David.
Hi David
I have the problem with a merchant that gives different products the same product name. Having read the above I guess I will have to add the productID to the name, but am unsure how to do this.
I looked at the filters and selected text after and then productname but don't know what to put in the next field (text)
---------
Jill
Hi Jill,
Whatever the product ID field is called when you are viewing the sample
data on Feed Registration (Step 2), use that inbetween % characters as
the placeholder in the text box on the configuration page for the Text
After filter. Remember to use a space infront of the placeholder so
that it does not appear joined to the product name, for example:
" %productid%"(without quotes of course)
Cheers,
David.
Hi Mally,
Could you combine the subscription length with the product (magazine) name using Text After filter, for example if there is an "issues" field in the feed you could use:
%issues% IssuesCheers,
David.