Hi David,
You kindly helped me with the glossary modification which is just about finished. I would like to do a similar thing with voucher codes.
AW has the ability to download all the voucher codes. I have done this and stored them in a database in the following fields: -
merchant_id
merchant_name
voucher_desc
voucher_deeplink
voucher_code
voucher_start
voucher_exp
voucher_sub
Along with this I have added a merchant_id field to the products / feeds. They now need to be matched up so if a product is viewed and that merchant has voucher codes, then a link is displayed to the codes. I can do this by a database query loop but figure that there must be an easier way to match them up during import to save on resources. Perhaps something similar to the glossary addition?
Could you point me in the right direction please?
Thanks,
Simon
Don't know if this helps, we added additional fields to the database and also fields wheer we can add in words like "Exclusive" that now displays within the merchant image/logo, next to the code to show the user that's in an exclsive deal
Hi Simon,
The `products` table only contains a single voucher_code field; the voucher details are pulled from the vouchers table at display time so without adding a whole new set of fields to the products table I think what you suggest would be the best option; and would actually be more storage efficient as the voucher code data wouldn't need to be duplicated for all products...
Cheers,
David.
--
PriceTapestry.com