Hi David,
Most of the feeds we affiliates use are quite basic, just about covering the standard fields.
I've got search filter mods working and would like to expand these to cover a few more fields. For example limiting to 32" TVs. Currently I use the model name to do this as they usually contain the size. However this isn't always accurate. I can easily create my own feed using my mapped product import to add more fields like screen size, tv type, colour etc... However I'd need to import this feed as a merchant in order to search the fields.
What is the best way to do this using the database? I thought about setting the price to either zero or £100k and then trying to hide the merchant from price tables. Or is this completely the wrong way to do it?
I want to be able to use the field values in a search but equally important is to be able to call the values on a product page so I can create a basic specs table too. However I can only call the mainProduct values on the comparison page (which is why I was thinking about a zero price and hiding the merchant on the table....).
Any ideas?
Thanks David, great solution as ever!
For others reading, there is an additional mod needed if you use pmimport.php for bulk mapping uploads.
Hi Matt,
The best approach is probably to add more fields to the productsmap table (size, colour etc.), and then add similar fields to the products table, and then during import the values from the productsmap table can be applied to the values in the products table for that product.
If you could start by following the instructions for adding new fields to the products table in this thread (this will mean that you can register them if a field does happen to be available in the feed), then email me your modified config.advanced.php and also includes/admin.php and I'll add the same fields to product mapping for you...
Cheers,
David.
--
PriceTapestry.com