Jump to content



Photo
- - - - -

Bundled products


  • Please log in to reply
330 replies to this topic

#1   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 07 February 2004 - 15:21

I tried master products contribution but it's not what I want and it looks like quite a few others have similar issues.

The idea is to update the stock of a number of sub-products in a bundle when a single item is purchased. The cost of the single item does not need to be related to the total cost of the items in the bundle, so deals can be applied. All products in the bundle are normal, only the main product needs an extra field. Sub-products in a bundle may be used in any number of master products (eg bearings on a skateboard)

I'm working on the following concept; my PHP and knowledge of OSC is still young so it will take a few weeks....

A) are there any other contribs that will do this?
/cool.gif' class='bbc_emoticon' alt='B)' /> Shall I try and make it into a contribution module?

Add a field into the products information (eg "bundle_contents")

Insert into this field a string containing the codes/SKUs for the subproducts (eg "23&45&65&111"). I'm not sure what delimiter would be best at this point.

When the product is displayed, PHP checks to see if the product has data in this field. If data exists, it prints a simple list of bundle contents in the product info part.

This list may be extended to include a "saving" figure if I can get it to calculate the total cost of the contents and compare with the product price.

No other changes are made until "callback" after order (I have not found this file yet). This file will check each product for bundle_contents before updating stock.

If bundle_contents contains bundle data (product contains others) then it will expand and update the stock of each subproduct.

If anybody sees any flaws or suggestions please submit here, or email me. If I can get it to work it may be worth a new contribution as it is a different approach to "Master Product"

chris

#2   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 22 February 2004 - 21:35

OK, the mod is done, I'll post it up once it's been running clean for a week or so after site launch (which is in 2 weeks) so give it 3 weeks or so.

chris

#3   safoo

safoo
  • Members
  • 514 posts
  • Real Name:Safoo

Posted 23 February 2004 - 06:23

Great...keep us up to date.

#4   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 18 March 2004 - 23:41

OK, bundles are now live on www.lushlongboards.com

take a look at product
http://www.lushlongb...&products_id=40

too see the user's view.

bundles are created in admin section, and are all valid stock items which may be visible or not visible to the customer (using active/inactive as comes with OSC)

stock of bundled items is checked before checkout ... ie the bundle is opened before stock check. likewise, after sale, stock of individual items is updated.

1 level of nesting is allowed, ie a bundle may contain another bundle, but not another bundle within that.

would anyone like a contrib?

#5   safoo

safoo
  • Members
  • 514 posts
  • Real Name:Safoo

Posted 19 March 2004 - 11:38

Hello,
I didn't really see what was different with the item.

Is the following text created by OSC??

This product contains the following items:
Hardware kit and assembly
    Black grip tape
    8mm bearing spacer set
    1 1/2 inch boltset
    Regular 1/2 inch riser
    Assembly charge
Swiss ABEC 5 bearings
Kryptonics True 65 wheels
Lush L175 trucks
Lush Kuni Deck

Cost of separate parts: 130.97
You save 45.98

A contribution would be great!

Edited by safoo, 19 March 2004 - 11:40.


#6   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 19 March 2004 - 12:43

yes, that is generated by OSC - it looks at the contents of the bundle, displays it to the user and calculates a saving over the cost of parts separately.

chris

#7 ONLINE   burt

burt

    Vanquisher of Demons

  • Community Team
  • 9,730 posts
  • Real Name:G Burton
  • Gender:Male
  • Location:UK/DEV/on

Posted 19 March 2004 - 12:47

So this:

Hardware kit and assembly
    Black grip tape
    8mm bearing spacer set
    1 1/2 inch boltset
    Regular 1/2 inch riser
    Assembly charge
Swiss ABEC 5 bearings
Kryptonics True 65 wheels
Lush L175 trucks
Lush Kuni Deck


Is a bunch of seperate products all available in your Store. Whereas this particular product : http://www.lushlongb...?products_id=40

is not a real product at all - it's simply a few products added together at a cheaper price than buying them all seperately?

Is that about right? If so, I think a lot of people would have a use for such a Mod, particularly Computer Sellers.
IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS
 
Responsive osCommerce, join in:
http://forums.oscomm...rom-the-get-go/

--
Making your shop better, one osCommerce module at a time - get in touch, or get my newsletter every 1st of the month.
 
Big Bang Templates for 2.3.4

#8   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 19 March 2004 - 13:14

that is correct. You add the bundle master (the bundle) as you would a normal product, then select it's contents on the admin page.

the stock level of the bundle master is irrelevant and is never checked or updated, only the contents matter. This naturally makes it quite a complicated mod, and while it works well on my heavily hacked site, it will take some time to neaten up for an osC mod. I'll do it as soon as I can.

chris

#9   safoo

safoo
  • Members
  • 514 posts
  • Real Name:Safoo

Posted 19 March 2004 - 21:35

yes, that is generated by OSC - it looks at the contents of the bundle, displays it to the user and calculates a saving over the cost of parts separately.


Awesome. Can't wait for the contribution.

#10 ONLINE   burt

burt

    Vanquisher of Demons

  • Community Team
  • 9,730 posts
  • Real Name:G Burton
  • Gender:Male
  • Location:UK/DEV/on

Posted 19 March 2004 - 21:50

Can you tell us what happens id one of the items in the bundle sells out of stock? Does the whole bundled product then go out of stock as well ?

Sounds like a great modification! Well done.
IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS
 
Responsive osCommerce, join in:
http://forums.oscomm...rom-the-get-go/

--
Making your shop better, one osCommerce module at a time - get in touch, or get my newsletter every 1st of the month.
 
Big Bang Templates for 2.3.4

#11   safoo

safoo
  • Members
  • 514 posts
  • Real Name:Safoo

Posted 28 March 2004 - 21:03

Any update on this, lushlongboards?

#12   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 29 March 2004 - 09:02

doing my best ... I could put a hacked undocumented version up now but I'd rather get it properly ready first ... I've not even read the tips on submitting contributions yet...

#13   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 14 April 2004 - 10:33

here's the mod:

http://www.oscommerc...tributions,2015


please post queries in this thread only!

chris

#14   langers

langers
  • Members
  • 46 posts
  • Real Name:Richard Lang

Posted 14 April 2004 - 13:09

nice1 mate! going to give it a try now.

How does it handle attributes of its child products?

#15   radders

radders
  • Members
  • 2,036 posts
  • Real Name:David Radford
  • Location:London

Posted 14 April 2004 - 19:20

Sounds exciting! Just taking a look. Deleted my original question.

Edited by radders, 14 April 2004 - 19:23.


#16   CC

CC
  • Members
  • 1,289 posts
  • Real Name:....
  • Gender:Male
  • Location:Here \o/

Posted 15 April 2004 - 22:47

Nice mod, and gonna give it a go now.

The biggest issue behind this was the stock count for us, but it seems you have approached this problem well.

#17   CC

CC
  • Members
  • 1,289 posts
  • Real Name:....
  • Gender:Male
  • Location:Here \o/

Posted 15 April 2004 - 23:28

Works a treat.

Although there are some small bits missing:

define('TEXT_PRODUCTS_BUNDLE', 'Create a Bundle:'); - (In categories language file)
define('TABLE_PRODUCTS_BUNDLES', 'products_bundles'); - (application_top.php or database_tables.php depending on your version)

Think that was about all tho.
Works great even on our heavily modded site, no problems going in at all.

Nice1 /wink.gif' class='bbc_emoticon' alt=';)' />

#18   cdamianou

cdamianou
  • Members
  • 239 posts
  • Real Name:Costas

Posted 16 April 2004 - 06:23

I am having trouble understanding the install of this mod. I am not a very advance oscommecer/

I was wondering if their was anyone that was willing to help with the install.

Thanks

Costas

#19   lushlongboards

lushlongboards
  • Members
  • 42 posts
  • Real Name:Chris

Posted 16 April 2004 - 06:27

hi costas -

what part of the install is troubling you?

You need to edit your version of the files given in the instructions then upload them to your server. No extra files are needed. You also need to alter your database using an admin tool that should be provided by your server, such as myPhpAdmin.

chris

#20   cdamianou

cdamianou
  • Members
  • 239 posts
  • Real Name:Costas

Posted 16 April 2004 - 07:25

I have access to PHPmy Admin, but not shure exactly how to acomplish that pasrt of the install. everything else looks straight forward.

Thanks

Costas