This is the thread for the bundled products contribution. This is a very useful mod but the installation instructions are barely legible. I am currently fixing the install docs, I don't think there will be any code changes just cleaning up the code to start with.
lildog
Latest News: (loading..)
0
48 replies to this topic
#2
Posted 23 November 2008, 20:32
Hi, my osC install is now giving the following error after installing bundled products:
1146 - Table 'commerce.TABLE_ADMINISTRATORS' doesn't exist
select id from TABLE_ADMINISTRATORS limit 1
[TEP STOP]
my table for my admin login is the default for osC which is "administrators" and nothing has been changed other than copying your files over and updating the tables as designated in your directions.
How do I fix this?
Thanks,
Sue
update - I found the error. somehow, the "administrators" syntax got replaced with the uppercase reference. and i am now able to get into my admin panel again.
1146 - Table 'commerce.TABLE_ADMINISTRATORS' doesn't exist
select id from TABLE_ADMINISTRATORS limit 1
[TEP STOP]
my table for my admin login is the default for osC which is "administrators" and nothing has been changed other than copying your files over and updating the tables as designated in your directions.
How do I fix this?
Thanks,
Sue
update - I found the error. somehow, the "administrators" syntax got replaced with the uppercase reference. and i am now able to get into my admin panel again.
Edited by prazim, 23 November 2008, 20:38.
#4
Posted 31 December 2008, 02:37
Got it installed and it is going to save me a lot of work - much thanks. Everything looks like it is working fine.
When you click on the product image in the shopping cart (to take you back the the bundled product after it is in the cart you get this:
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 '{31}126{7}58 and language_id = '1'' at line 7
SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price, p.products_image FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = 514{31}126{7}58 and language_id = '1'
[TEP STOP]
This product contains the following items:
Looks to me like it this part " 514{31}126{7}58 " that is added to the end of the url (which is because of the added attributes I assume) messes it up. The regular URL for the bundled product works fine and looks like this: /test-p-514.html
but the cart makes the URL like this: product_info.php?products_id=514{31}126{7}58 which gives the error
Other items in the cart that are not bundled products still work fine with the same URL type such as this: /product_info.php?products_id=480{7}58{55}167{56}170
This appears to be a simple fix if I knew what I was doing - please help.
Thanks
Randy
When you click on the product image in the shopping cart (to take you back the the bundled product after it is in the cart you get this:
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 '{31}126{7}58 and language_id = '1'' at line 7
SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price, p.products_image FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = 514{31}126{7}58 and language_id = '1'
[TEP STOP]
This product contains the following items:
Looks to me like it this part " 514{31}126{7}58 " that is added to the end of the url (which is because of the added attributes I assume) messes it up. The regular URL for the bundled product works fine and looks like this: /test-p-514.html
but the cart makes the URL like this: product_info.php?products_id=514{31}126{7}58 which gives the error
Other items in the cart that are not bundled products still work fine with the same URL type such as this: /product_info.php?products_id=480{7}58{55}167{56}170
This appears to be a simple fix if I knew what I was doing - please help.
Thanks
Randy
#5
Posted 24 January 2009, 21:18
prazim, on Nov 23 2008, 08:32 PM, said:
Hi, my osC install is now giving the following error after installing bundled products:
1146 - Table 'commerce.TABLE_ADMINISTRATORS' doesn't exist
select id from TABLE_ADMINISTRATORS limit 1
[TEP STOP]
my table for my admin login is the default for osC which is "administrators" and nothing has been changed other than copying your files over and updating the tables as designated in your directions.
How do I fix this?
Thanks,
Sue
update - I found the error. somehow, the "administrators" syntax got replaced with the uppercase reference. and i am now able to get into my admin panel again.
1146 - Table 'commerce.TABLE_ADMINISTRATORS' doesn't exist
select id from TABLE_ADMINISTRATORS limit 1
[TEP STOP]
my table for my admin login is the default for osC which is "administrators" and nothing has been changed other than copying your files over and updating the tables as designated in your directions.
How do I fix this?
Thanks,
Sue
update - I found the error. somehow, the "administrators" syntax got replaced with the uppercase reference. and i am now able to get into my admin panel again.
I have the same error. It happened after I made the SQL changes. I went into the admin/login.php and changed all the TABLE_ADMINISTRATORS to TABLE_administrator and I got the same error but with lower case.
Is there a way to undo the SQL changes easily? Actually, it just might be easier to reinstall OSC again.
#6
Posted 24 January 2009, 22:54
prazim, on Nov 23 2008, 08:32 PM, said:
Hi, my osC install is now giving the following error after installing bundled products:
1146 - Table 'commerce.TABLE_ADMINISTRATORS' doesn't exist
select id from TABLE_ADMINISTRATORS limit 1
[TEP STOP]
my table for my admin login is the default for osC which is "administrators" and nothing has been changed other than copying your files over and updating the tables as designated in your directions.
How do I fix this?
Thanks,
Sue
update - I found the error. somehow, the "administrators" syntax got replaced with the uppercase reference. and i am now able to get into my admin panel again.
1146 - Table 'commerce.TABLE_ADMINISTRATORS' doesn't exist
select id from TABLE_ADMINISTRATORS limit 1
[TEP STOP]
my table for my admin login is the default for osC which is "administrators" and nothing has been changed other than copying your files over and updating the tables as designated in your directions.
How do I fix this?
Thanks,
Sue
update - I found the error. somehow, the "administrators" syntax got replaced with the uppercase reference. and i am now able to get into my admin panel again.
I found the problem!
The file admin/includes/database_tables.php is missing the define('TABLE_ADMINISTRATORS', 'administrators');
lildog, can you add this to your contribution please?
#7
Posted 16 February 2009, 00:40
We need help modifying this contribution. Where do you set the bundled price discount at? As of right now it's why we aren't using module. We'd like to be able to control how much the customer gets off the bundle.
Any help or documentation will be greatly appreciated.
Thanks.
Any help or documentation will be greatly appreciated.
Thanks.
#9
Posted 04 March 2009, 12:32
I have this installed and am happy with it. However I want to add stock levels to attributes and need to install QT Pro V1.0 but there's some really big differences in the code where this contrib needs to affect the same thing as the other contribution.
Has anyone had any success with installing both of these?
Has anyone had any success with installing both of these?
#10
Posted 18 March 2009, 00:50
galey1981, on Mar 4 2009, 01:32 PM, said:
I have this installed and am happy with it. However I want to add stock levels to attributes and need to install QT Pro V1.0 but there's some really big differences in the code where this contrib needs to affect the same thing as the other contribution.
Has anyone had any success with installing both of these?
Has anyone had any success with installing both of these?
My store have install QTPro now, but how to install this module and make it can work with QTPro?
Please help to give some advice asap.
Thanks & Best Regards,
Sunrise
#11
Posted 03 April 2009, 21:53
I need HELP
After installing Bundled Products, when showing the product, it appears always THE OUT OF STOCK gif.
I do not know where could be the error, but now the shop is not opperative...
Any suggestion please
example http://www.coelvi.com/catalog/modulos-modu...rs-c-26_53.html
Thanks in advance I really needs you!
After installing Bundled Products, when showing the product, it appears always THE OUT OF STOCK gif.
I do not know where could be the error, but now the shop is not opperative...
Any suggestion please
example http://www.coelvi.com/catalog/modulos-modu...rs-c-26_53.html
Thanks in advance I really needs you!
#12
Posted 06 May 2009, 17:57
kuartokilo, on Apr 3 2009, 11:53 PM, said:
I need HELP
After installing Bundled Products, when showing the product, it appears always THE OUT OF STOCK gif.
I do not know where could be the error, but now the shop is not opperative...
Any suggestion please
example http://www.coelvi.com/catalog/modulos-modu...rs-c-26_53.html
Thanks in advance I really needs you!
After installing Bundled Products, when showing the product, it appears always THE OUT OF STOCK gif.
I do not know where could be the error, but now the shop is not opperative...
Any suggestion please
example http://www.coelvi.com/catalog/modulos-modu...rs-c-26_53.html
Thanks in advance I really needs you!
Same here
#13
Posted 13 May 2009, 21:12
this looks like a must have for shops that have a lot of items that can be bundled. My shop is a farm parts store and this would be real handy.
But after seeing that there appears to be some problems with the contribution and so very little support, I think for the time being I will manually create bundles and use cross sell.
But after seeing that there appears to be some problems with the contribution and so very little support, I think for the time being I will manually create bundles and use cross sell.
#14
Posted 08 June 2009, 06:13
Max Paint, on May 6 2009, 07:57 PM, said:
Same here
Open catalog\includes\modules\product_listing.php
Find :
case 'PRODUCT_LIST_QUANTITY':
$lc_align = 'right';
$StockChecker = tep_get_products_stock($listing['products_id']);
$lc_text = TEXT_QUANTITY .' (' . $StockChecker .')';
break;
and Replace With :
case 'PRODUCT_LIST_QUANTITY':
$lc_align = 'right';
$lc_text = ' ' . $listing['products_quantity'] . ' ';
break;
And :
Find :
case 'PRODUCT_LIST_BUY_NOW':
$lc_align = 'center';
$StockChecker1 = tep_get_products_stock($listing['products_id']);
If ( $StockChecker1 <> 0){
$lc_text = (($listing['products_price'] > 0) ? '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ' : ' ');
}else{
$lc_text = tep_image_button('button_out_of_stock.gif', IMAGE_BUTTON_OUT_OF_STOCK) . ' ';
}
break;
Replace With :
case 'PRODUCT_LIST_BUY_NOW':
$lc_align = 'center';
$lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a> ';
break;
#15
Posted 14 July 2009, 19:41
I've been using the the bundling system and it works pretty great.
The way I've been doing it is by creating each item individually, then creating a new "item" with the bundle in it and changing the price of the new "item"
i.e.
1. Drum Shell Pack is an item you can buy individually
2. Hardware Pack "C" is an item you can buy individually
3. Drum Shell Pack with Hardware Pack "C" is an item you can buy with a special price.
My question is if someone clicks to buy both items individually, is there anyway that it would lower the price to the bundle price...or change what's in the cart to the bundled item??
Thanks
The way I've been doing it is by creating each item individually, then creating a new "item" with the bundle in it and changing the price of the new "item"
i.e.
1. Drum Shell Pack is an item you can buy individually
2. Hardware Pack "C" is an item you can buy individually
3. Drum Shell Pack with Hardware Pack "C" is an item you can buy with a special price.
My question is if someone clicks to buy both items individually, is there anyway that it would lower the price to the bundle price...or change what's in the cart to the bundled item??
Thanks
#16
Posted 31 July 2009, 08:35
Still love this add on contribution.
Does anyone know if this can be modified so that the buyer can tweak the amounts of the sub products within a bundle?
This would be very useful for bundles which are, for example,kits for building something, as opposed to ones which are just a way to get rid of cheaper stock and increase revenue...
I can do the modification to allow the qty field to be an editable text field, but i need to know the way to approach the back end (cart, stock, price change etc) aspect of it...
If anyone could suggest a possible method to tackle this, it would be greatly appreciated
Best regards
Bee
Does anyone know if this can be modified so that the buyer can tweak the amounts of the sub products within a bundle?
This would be very useful for bundles which are, for example,kits for building something, as opposed to ones which are just a way to get rid of cheaper stock and increase revenue...
I can do the modification to allow the qty field to be an editable text field, but i need to know the way to approach the back end (cart, stock, price change etc) aspect of it...
If anyone could suggest a possible method to tackle this, it would be greatly appreciated
Best regards
Bee
There are 10 types of people in this world, those who understand binary and those who don't...
#17
Posted 01 August 2009, 17:50
This is a great contribution and is working perfectly on my site, www.rc-bearings.com
One thing I noticed is that you need to set the bundled part as QTY 1 or the inventory doesn't work right.
One thing that needs to be added is to have all the products in a bundle show up in the Products Purchased report. Right now it only shows the kit as being sold. I would rather use this report to show me how many individual items are going out the door rather than the kits that are sold.
Any help with this?
One thing I noticed is that you need to set the bundled part as QTY 1 or the inventory doesn't work right.
One thing that needs to be added is to have all the products in a bundle show up in the Products Purchased report. Right now it only shows the kit as being sold. I would rather use this report to show me how many individual items are going out the door rather than the kits that are sold.
Any help with this?
#19
Posted 18 November 2009, 11:05
Just wanted to say thanks for this great add-on! I had a bit of trouble (Step 18, I had to use the older version, even though I'm using v2.2).
I do have a question - I would really like to NOT have the "This product contains.... you save X amount" box. I've taken out the second section of Step 7 (in catalog/product_info.php after "<p><?php echo stripslashes($product_info['products_description']); ?></p>" ADD <!-- BOF Bundled Products-->...), and it seems to work fine so far.
Is there anything else I need to do? Just thought I'd confirm and through it up there for newbies like me
I do have a question - I would really like to NOT have the "This product contains.... you save X amount" box. I've taken out the second section of Step 7 (in catalog/product_info.php after "<p><?php echo stripslashes($product_info['products_description']); ?></p>" ADD <!-- BOF Bundled Products-->...), and it seems to work fine so far.
Is there anything else I need to do? Just thought I'd confirm and through it up there for newbies like me
#20
Posted 08 January 2010, 18:48
Hi,
I have just installed this contribution which I have to say is great!
I am however having a problem with it, as if I setup a product as a bundle, add the consituent products to the bundle, save and close the product, everything appears fine. But when I go back and edit the Bundled Product, the bundle constituents are no longer listed in the bundle fields.
Also, is there a quick and easy way to change the fact that a bundle can have up to 6 constituent products to a potentially unlimited number of products. The reason for this in my case is I sell a complete package of a radio controlled model helicopter, which in itself can have probably a dozen or so constituent products in the bundle and also it would need to list things like, build, setup and number of hours flight training which are also included in the bundle.
Any comments or ideas would be greatfully received!
Regards,
Peter.
I have just installed this contribution which I have to say is great!
I am however having a problem with it, as if I setup a product as a bundle, add the consituent products to the bundle, save and close the product, everything appears fine. But when I go back and edit the Bundled Product, the bundle constituents are no longer listed in the bundle fields.
Also, is there a quick and easy way to change the fact that a bundle can have up to 6 constituent products to a potentially unlimited number of products. The reason for this in my case is I sell a complete package of a radio controlled model helicopter, which in itself can have probably a dozen or so constituent products in the bundle and also it would need to list things like, build, setup and number of hours flight training which are also included in the bundle.
Any comments or ideas would be greatfully received!
Regards,
Peter.
