Free Gifts-Dangling Carrot support

If you're using the Install SQL Patches, the backticks should be removed, too

# Add the following to your database via Zen Cart Admin.
# NOTE...IF YOU USE A DATABASE PREFIX YOU MUST ADD IT INTO THESE TABLE UPDATES - FOR EXAMPLE:
# If your db prefix is zen_, then change 
# CREATE TABLE free_gifts ( 
# to 
# CREATE TABLE zen_free_gifts (
CREATE TABLE free_gifts (
gift_id tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
threshold mediumint( 9 ) NOT NULL default '0',
products_id mediumint( 9 ) NOT NULL default '0',
PRIMARY KEY ( gift_id ) 
) ENGINE= MyISAM ;

i managed to install this mod on 1.5.0 the only problem i have is carrot item that is being hidden because the price set at $0.00 is searchable. It is possible to add this product into cart from search, it shows you have 1 item in shopping cart, but then shopping-cart page shows nothing and on refresh the item dissappeares from the shopping cart. so not big of a deal, but still looks like a bug. anyone knows how to fix this?

i need some help sorting this bug out, and it occurs when customer adds the free gift into a cart, and then does a search for free gift, then he is able to add same free gift again via "add to cart" button. How to make this free gift items non searchable, or how to disable "add to cart" button on them in any other situations besides under checkout page when they are eligible to add a free gift.
thanks

I would like to install this to my 1.5.1 cart as well. Hopefully some of the better minds out there are working on it. I am willing to kick in for a few hours of time via paypal (if that is allowed?). for the good of all.

Does this contribution work with 1.5.1 please, or is there an alternative?

Thanks

Sorry...posted twice....internet problem

Can anybody please tell me if this works properly with 1.3.9h?

Many Thanks

Hi...

Just installed and got this error:

1146 Table 'london_zc5.zen_free_gifts' doesn't exist
in:
[SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM (zen_free_gifts fg, zen_products p) LEFT JOIN zen_products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '5' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC]

Cannot do anything in link on admin side, but cannot add product to shopping cart with out same error showing. Site is down. Any help would be GREATLY appreciated.

I have uninstalled the module...thanks. :)

amandavz:

Hi...

Just installed and got this error:

1146 Table 'london_zc5.zen_free_gifts' doesn't exist
in:
[SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM (zen_free_gifts fg, zen_products p) LEFT JOIN zen_products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '5' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC]

Cannot do anything in link on admin side, but cannot add product to shopping cart with out same error showing. Site is down. Any help would be GREATLY appreciated.

Looks like the sql patch didn't take which is why you got this error message. I would recommend trying the sql patch again. The zen_free_gift table was not created in the db. If you used lat9's sql from the above post, you need to uncomment the one line (create table zen_free_gifts) and comment the one below it.

I tried it on a test site and got more errors. I have since uninstalled from my site and probably will not use it. I may revisit this again in the future. Thanks for your help. Have a great day.

Hi. I had this plugin up to 1.5.0 . Now i am moving to 1.5.1 and it will not work. I would like some advice on what other options other plugins i can use instead that would work with 1.5.1 and would do what dangling carrot was doing - an ability for customer to add a free item, if spent say $100. any advise is needed at this point. Because my customers will definitely not like it, if i will disable this option.

It's is 9/6/2013, has this mod been updated to work in version 1.5.1?

If not could someone please report on any progress in updating this mod so that it will work on 1.5.1.

It appears that there are a lot of folks wanting to incorporate this into their Zen Stores...

Will someone inform us if there is any intention of updating it so it will work on 1.5.1

If this mod is a lost cause for version 1.5.1 is there an alternative that anyone knows of that will accomplish the same results and will work with 1.5.1?

WetSteve:

It's is 9/6/2013, has this mod been updated to work in version 1.5.1?

If not could someone please report on any progress in updating this mod so that it will work on 1.5.1.

It appears that there are a lot of folks wanting to incorporate this into their Zen Stores...

Will someone inform us if there is any intention of updating it so it will work on 1.5.1

If this mod is a lost cause for version 1.5.1 is there an alternative that anyone knows of that will accomplish the same results and will work with 1.5.1?
The original author and I are working on developing this mod with some new features and bugfixes and it will work for 1.5.1. I can't give any type of release date yet since we are both very busy on other projects, I personally don't have a lot of time to devote to it in the next couple weeks. There is a commercial mod you can search for with your favorite search engine if you need it now. Unfortunately, it is encrypted so you cannot make any changes if you need to modify the code for your specific purposes.

Free Gift version 2 is currently in Beta testing.
It's been completely rewritten for zen cart 1.5.1

No need to make hidden gift category and duplicate products.
Any product can be set as a gift via the normal add/edit product page. Simply mark the checkbox, and fill in new fields for gift price, Net and Gross of tax.
Side box with ajax popup to view gifts.
Gift page so that customers can see them all.
Products with attributes can now be used as a gift. Base price will be the reduced price. Attribute prices are added onto this.

Sadly, due to the number of hours that have been invested in this, the module is now a commercial offering. Further enhancements are planned. A 1.3.9 version will be built if there is sufficient customer demand.

strelitzia:

Free Gift version 2 is currently in Beta testing.
It's been completely rewritten for zen cart 1.5.1

No need to make hidden gift category and duplicate products.
Any product can be set as a gift via the normal add/edit product page. Simply mark the checkbox, and fill in new fields for gift price, Net and Gross of tax.
Side box with ajax popup to view gifts.
Gift page so that customers can see them all.
Products with attributes can now be used as a gift. Base price will be the reduced price. Attribute prices are added onto this.

Sadly, due to the number of hours that have been invested in this, the module is now a commercial offering. Further enhancements are planned. A 1.3.9 version will be built if there is sufficient customer demand.

Download page still shows compatible with 1.3.8. How we can buy/download new version you have developed?

I have installed this from zencart add ons page which says compatible with 1.3.8 on 1.5.0 and its working fine on admin section but I am not sure how this work on website as I do not see anywhere in admin where to select shopping cart minimum total for free gifts?

Please advise. Thank you.

I can't post a link to the module on here due to forum rules. If you wish to purchase the module you need to send me a PM for details.

Free Gifts v2.1.1 has been updated and is now compatible with both 1.5.1 and 1.5.3
Further details via PM only due to forum rules.

I was installing the older version and when I insert this SQL I got this:

Error

SQL query:

CREATE TABLE free_gifts (

gift_id tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
threshold mediumint( 9 ) NOT NULL default '0',
products_id mediumint( 9 ) NOT NULL default '0',
PRIMARY KEY ( gift_id )
) TYPE = MYISAM ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6

I am using the newest version of Zen Cart.

morrisgiftshop:

I was installing the older version and when I insert this SQL I got this:

Error

SQL query:

CREATE TABLE free_gifts (

gift_id tinyint( 4 ) NOT NULL AUTO_INCREMENT ,
threshold mediumint( 9 ) NOT NULL default '0',
products_id mediumint( 9 ) NOT NULL default '0',
PRIMARY KEY ( gift_id )
) TYPE = MYISAM ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6

I am using the newest version of Zen Cart.

You need to change TYPE = MYISAM to ENGINE = MYISAM, but please be aware that the version of the module available for download via ZC plugins IS NOT compatible with zen cart 1.5.3 and has many bugs.
There is a newer version that has been completely rewrittenand is compatible with zen cart version 1.5.x but it is now a commercial module as significant hours were put into rewriting pretty much the entire module.

Due to forum rules i cannot give you the information on where this available by forum post but if you PM me i can give you further information.