Community Add-Ons

Minor bug fix - Admin login page produced error

Defined TABLE_ADMINISTRATORS in catalog/admin/includes/database_tables.php

added a couple of minor changes for osCommerce Online Merchant v2.2

Complete Package.

Rewrote the install docs and added support thread. Much easier to understand. This is based on v1.5.1, and also includes all previous mods, no code changes, just updated install docs.

http://forums.oscommerce.com/index.php?showtopic=313412

Complete package and

By popular demand, assemble all the manual installation instructions into the package.

This is a rollup of all the uploads to this contribution to date, plus
some added features and fixes.

Fixes: I ran into a few problems with Eoin's otherwise very helpful
upload, and hopefully I've managed to include all of my fixes here.
Kudos to Eoin for getting the ball rolling in the right direction.

Features: I included some code intended to prevent overselling. For
example, if a bundle contains 3 apples and 2 pears, you have 3 apples
in stock, and a customer puts 1 of these bundles into the cart, plus
an apple by itself, this code will mark the individual apple as being
insufficiently stocked. The code tries to give priority to bundles when doing
its insufficient-stock marking, i.e. it allows the bundle to sell before it
allows the individual item(s) that make up the bundle to sell. Please PM me if
you have questions or suggestions about this added feature.

Eoin forgot to include the /catalog/admin/includes/database_tables.php file. This is a very important file and if you don't have it, this is the error you'll recieve

1146 - Table 'XXX_oscX.TABLE_PRODUCTS_BUNDLES' doesn't exist

SELECT pb.subproduct_id, pb.subproduct_qty, pd.products_name FROM products_description pd INNER JOIN TABLE_PRODUCTS_BUNDLES pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = '12' and language_id = '1'

http://forums.oscommerce.com/index.php?showtopic=77738&st=240#

I installed the contribution according to the directions included in version 1.4 as well as the various fixes listed.

Here are the resulting changed files. I hope it's useful for anyone else installing this contribution.

This is a little modification to the great contribution. It will allow you to sort your products by Model --- Name (ID) in your admin/categories.php Set Bundles dropdown list. I hope anybody else can find it useful.

It's not a full package, just a sorting by Model modification.

This is my first post/contriubtion.

I installed the Bundled Products contribution and found while testing that deleting
orders would not put the items in the bundle back in stock, but instead it put
the bundle back in stock even though it was never taken out. Below is the fix I used.
Most likely nobody else but me would use this, but I like things to be neat.

Calculate the Bundle Quantity before displaying it in Product Listing ..

This is my 1st post .. i hope everything is alright

Thanks

Major improvement!

Quantity of bundles is calculated before a sale is made.

If there isn't sufficient stock of one or all of the subproducts, the bundle is marked "Out of Stock" in the cart (if you want).

Also, if there is abundant stock of the subproducts, you can buy as many bundles as the stock level will allow.

This is a bugfix. Nothing new in this one.

Fixes some admin side problems:
1. adds a missing text def
2. allows for updates of existing bundles
3. denys the ability to link a bundle to itself
(this is a good thing. would break both the admin
and catalog displays for an affected bundle.)

Cheers,
Matt

Addition with product image, link to product and price per unit

Bundle Mod Addition is multilanguage see step 7

Attention: No stock update of the subproducts


In action here:
http://www.infotopnet.de/oscommerce_2.2ms2_vkp1/product_info.php?cPath=3_21&products_id=28

In checkcout_confirmation.php I get an error that says table TABLE_PRODUCTS_BUNDLES does not exist. The query in question is: $bundle_query_nested .Where do I define it? I have the table in the database. I have done everything according to the instruction and everything works great except that it crashes in checkout_process.php because it can not find the table. I have tried to make a define in both database_tables.php, configure.php and checkout_process.php without result

This contribution allows you to create bundles of products:

- a user can buy a bundle of parts that may be priced at something different from the total cost of the parts. The cost saving is shown to the customer on the products_info page.
- The stock of each sub product is updated separately when a sale is made.
- A subproduct that is out of stock will prevent the bundle from selling (if you have set STOCK_ALLOW_CHECKOUT to false in admin)
- bundles are created and edited using the admin system
- bundle "master products" are virtual containers for subproducts, ie the stock is not updated. Otherwise, they are regular products with a description, price and other features.

For an example of how the system works take a look at the longboards at www.lushlongboards.com.