Magento Forum

Rebates
 
pumba
Jr. Member
 
Total Posts:  28
Joined:  2008-05-14
 

Hello

I wonder how can I implement mail-in rebates?

Basically mail-in rebate is just text page with description and rebate form attached. Each rebate active during some period startDate - endDate and can be assigned with one or more products.

What I want is when there is available rebate, it should be automatically shown on product page. As soon as rebate expires, it dissapears from product page.

Also I’d like to have page like ‘Current rebates’ which shows available rebates. Also each rebate should have link ‘eligible products’ which will list all products associated with this rebate.

Is it possible to do with basic Magento or it requires custom module?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
pumba
Jr. Member
 
Total Posts:  28
Joined:  2008-05-14
 

Does anybody know the answer?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Napier
Member
 
Total Posts:  47
Joined:  2008-05-24
 

would also be interested in this

 
Magento Community Magento Community
Magento Community
Magento Community
 
MXWest
Jr. Member
 
Avatar
Total Posts:  5
Joined:  2008-10-06
 

Yup a real biggie. I’ll let you know what I can find out, I have a real bigggggggg issue with this. This is not ready for primetime without an answer for mail-in rebates for me.

 
Magento Community Magento Community
Magento Community
Magento Community
 
zadpro
Sr. Member
 
Avatar
Total Posts:  247
Joined:  2007-12-10
FL, USA
 

This is doable with the attribute.
I have done this for my client. To see an example, go to http://www.bargaincollection.com and click on the Rebate link that you can see in the top menu (above the user menu). It will give you list of products that has rebate. Then scroll down to “Additional Information” section and see the rebate information and link.

The only problem with this method is that visitors don’t see the rebate on the catalog (list or grid view). It would be nice to be able to subtract the rebate price in the view. That will help alot for advertising and sale.
I think this is one of the major things that should be added to future Magento releases.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mrtech
Sr. Member
 
Total Posts:  87
Joined:  2008-06-30
 

hi

i also need this module and i am ready to give it in for developing. but i am wondering if any one one to chip into the project i think that if we will split the cost over 5-6 companys we will all gain

please let me know

 
Magento Community Magento Community
Magento Community
Magento Community
 
Grant Chambers
Jr. Member
 
Total Posts:  1
Joined:  2009-06-18
 

Zadpro - are you still using the same method for rebates?  We have a magento store that will be selling cameras and other related items.  Need to be able to offer rebates.  I am hoping this extension may now be available?

 
Magento Community Magento Community
Magento Community
Magento Community
 
mrtech
Sr. Member
 
Total Posts:  87
Joined:  2008-06-30
 

hi

i start it working on a mail in rebate function for my site

i will pos the code that i have until now

i created 3 new attributes

mir_amount (Mail In Rebate Amount)
mir_start_date (Mail In Rebate Start date)
mir_end_date ((Mail In Rebate End date)

now i wrote this block of code

<?php 

// check if the item has a sale price
        
$begin_date =$_product->getmir_start_date();
        
$end_date =$_product->getmir_end_date();
        
$now = (date('Ymd'));
        
        
$begin_date strtotime($begin_date);
        
$end_date strtotime($end_date);
        
$now strtotime ($now);
        
        
        
    
        
     
        
        if (
$begin_date <= $now && $end_date >= $now)
        
        

            $baseprice 
$_product->getPrice();
            
$rebate $_product->getmir_amount();
            
$final_price $baseprice $rebate ;
            

        
}
?>
<?php 
if  ($begin_date <= $now && $end_date >= $now) :?>
<span class="regular-price"><?php echo $final_price ?><br>
<?php echo 'After'.' '.'$'.''.$rebate.' '.'mail in rebate' ?>
</span>
<?php else :?>

now i open this file
app/design/frontend/default/defiance21/template/catalog/product/view.phtml
look for this line of code

<?php $_product $this->getProduct() ?>

this shuold be at around line 37

and paste in the above code

it works for me

 
Magento Community Magento Community
Magento Community
Magento Community
 
mrtech
Sr. Member
 
Total Posts:  87
Joined:  2008-06-30
 

i am working now to have a option in the admin to upload the rebate form

and also to rewrite the code in a form of an extension so any body can use it with no need of copy paste and get stuck with new upgardes

 
Magento Community Magento Community
Magento Community
Magento Community
 
Boatmagic
Sr. Member
 
Avatar
Total Posts:  91
Joined:  2010-08-14
 

I just finished this on my site today. Here is how I proceeded.

1. Create 4 new attributes: rebate_url.....rebate_description ......rebate_start_date......rebate_end_date
2. For the rebate_url attribute, I named it Current Rebates.
2. Make sure this is set for each (Visible on Product View Page on Front-end)
3. Make sure the date fields are set to Date, etc.,,,,,
4. Create a folder on your server name (downloads) or whatever you want.
5. I copied all of my rebate.pdf’s to that folder.
6. In the rebate_url for each product I use the following code:

RIGHT-CLICK and SAVE AS to download! <a href=/downloads/25246.pdf>Download Rebate Form</a>

7. I used a .csv file to upload the product info for items that have a rebate and to set the products rebate information.
See attached:

Here’s a few tricks I use when changing my .csv when I add lots of products..

For the fields; image,small_image and thumbnail, I just copy this formula in the formula bar for the field image;
="/" & F2 & “.gif”
(this is because when you upload new products and the product image is already uploaded to the media folder, this ensures the image is created when the product is created)

Now I copy that formula into the image field above for each product. So each image field should show 12345.gif (or whatever sku your using)
Now, copy the contents of the image column and copy it over to all 3 fields by right-clicking, choosing Paste-Special, then formulas.

Ok, so now each field for image information should be taking the sku from F2 of the csv, adding .gif to the end of it. Any questions...lol

I do the same thing for rebate_url. Formula in csv..
="RIGHT-CLICK and SAVE AS to download! <a href=/downloads/” & F2 & “.pdf” & “>Download Rebate Form</a>”

Again, this takes the sku number, adds the information before it, adds the .pdf and the information after it. Any questions..

REMEMBER: When you save a .csv file, the formulas WILL NOT be saved! That’s just how csv’s work.

Here’s my store showing how it looks on a product page;
example

It’s not the greatest way to accomplish this, but it’s all I could come up with..
The original post for the idea and the attributes is here; Thanks to MXWest
Mail-In Rebates

Well I can’t upload the csv file..go figure Magento is broke

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top