Display coupons on a product details page from same merchant as the product

[badm00n]

Hi Eric,

Do you know the best way I could manually coupons to the product detail pages depending on what merchant the product is coming from?

For example I would like to do if merchant=shoebuy then show the HTML for that a shoebuy coupon only. Since I only have 5 total merchants for my store, I guess there would have to 5 if statements.

Thanks.

[Eric]

Originally Posted by badm00n

Do you know the best way I could manually coupons to the product detail pages depending on what merchant the product is coming from?

What's wrong with the tutorial I posted in this thread?

[billy_w]

If I use the code in the video only the word Coupons appear. When I use the code here I get php errors. is the &amp: supposed to be just an &. Not sure but nothing seems to work for me. I tried the product list box as well as someone with the same problem was told to use that instead of the text box but that did not fix the errors either.

[billy_w]

NVM I got it to work

[dhilditch]

Hi Eric,

I need your help again

I've:

1) Created a custom view called Coupons
2) Created a hidden category called coupons
3) Added the relevant affiliate networks (the coupon ones) to my settings
4) Added the merchants to my store
5) Tried to add coupons to my hidden category
6) Modified the product list view to show the coupons (I intend to show the coupons once a user has liked the site, and it'll be a popover of some sort)

My problem seems to come at point 5 - after updating the shop and products, there are no coupons in the DB:

select * from wp_dfr_shop_products
where tags like '%coupon%'

Above returns nothing.

Also, in the actually category, it shows the subscription but not the coupons....

As I've been writing this - I've just thought - maybe it's the fact that coupons have a price of zero?

[dhilditch]

Yes - ignore my question - I had a subscription removing zero priced products. I'll just have to get someone else to go clean up the database and remove the out-of-stock and other zero priced products manually.

[dhilditch]

Hi - I'm still having issues with coupons here:

http://www.fitness-saver.com/uk/shop/cycling/

1) I have successfully created the coupon view and am getting coupons to appear on the page in a popover
2) The following shortcodes don't work from within my view:

[coupon.code]
[coupon.ends]

The following is the only one that works:
[product.name]

Is there something I'm doing wrong?

[Eric]

Hi

Can you PM me the following information:

BLOG LOGIN INFO with ADMINISTRATOR PERMISSIONS (Temporary login information preferred)
Admin URL:
Username:
Password:

Thanks,
Eric

[Eric]

Originally Posted by dhilditch

Hi - I'm still having issues with coupons here:

http://www.fitness-saver.com/uk/shop/cycling/

1) I have successfully created the coupon view and am getting coupons to appear on the page in a popover
2) The following shortcodes don't work from within my view:

[coupon.code]
[coupon.ends]

The following is the only one that works:
[product.name]

Is there something I'm doing wrong?

Actually, can you try these PHP variables first:

PHP Code:

$s->coupon_info($product, 'code');
$s->coupon_info($product, 'end'); 


[dhilditch]

Hi Eric,

This didn't help. I tried variations too:

<?echo $s->coupon_info($product->id, 'code'); ?>

It's odd that [product.name] and [product.merchant] work but [product.description] returns 0 - if that were working I could run some split code over the coupon description like this I think:

<?php
$coupontokens = split(";", str_replace("]", "", str_replace("[", "", $product->description)));
$couponends = split(":", $coupontokens[1])[1];
$couponcode = split(":", $coupontokens[2])[1];

?>

[dhilditch]

I guess another plan could be for me to simply write a function in functions.php that queries the database for the 'merchant' name and the correct category for coupons.

That, I am sure, would work as I can see the coupons in the database with the expires, begins, code etc all contained within the 'description' column.

Dave

[Eric]

To be honest, I'm surprised any products are being returned at all because nothing is being passed in the Datafeedr query string for that view.

You might have better luck running a custom query.

[dhilditch]

Ok thanks - I guess it's because I'm trying to display the coupons in the product list rather than product details?

[dhilditch]

I'm running into an issue since the 'description' column in DataFeedr for the coupons contains something like:

[begins:02/08/2012; ends:02/09/2012; code: WIGG10]

But I'm not seeing that in the database? This makes it impossible for me to write a custom function to do this. Any ideas where this data is going?

Dave

[dhilditch]

Also - is there a function like this:

AddReferrer(url, merchantid) // ideally something like this which transforms the DB url field into one containing the right referrerid for the affiliate network?

[Eric]

Hi

Originally Posted by dhilditch

I'm running into an issue since the 'description' column in DataFeedr for the coupons contains something like:

[begins:02/08/2012; ends:02/09/2012; code: WIGG10]

But I'm not seeing that in the database? This makes it impossible for me to write a custom function to do this. Any ideas where this data is going?

That data is in the products table in the description column.

Originally Posted by dhilditch

Also - is there a function like this:

AddReferrer(url, merchantid) // ideally something like this which transforms the DB url field into one containing the right referrerid for the affiliate network?

There's no function but a simple str_replace should work. Here's the PHP for the referrer:

PHP Code:

$referrer_id = intval(@$_COOKIE['stortrak']); 


PHP Code:

str_replace("REFERRER_ID", $referrer_id, $product->url); 


Eric


Eric

[dhilditch]

Cool - thanks.

I'm re-running my store update as all I have is 0 contained in the description column for the coupons. Probably this is where the problem comes from in the first place!

[dhilditch]

FYI, this was my fault - have fixed - thanks for help.

[dhilditch]

I've written a free guide with everything I learned about adding coupons to the product detail page here:

http://www.affiliatewebdesigners.com...-to-datafeedr/

Maybe someone will find it useful.

[george3]

Worked Great ,How about maybe widget coupons?