guys,

i did a lot of changes in subproducts module. and dont have time to slipt each mod in a single .patch file, so im posting the entire directory.

changes:
(f) you can now create subproducts with more than 5 variations (i think its already fixed)
(f) variations without attributes wont make the module misbehave
(*) each attribute can have a image, like in dell.com (with javascript/ajax)
(*) on the fly final price calculation (with javascript/ajax)
(*) subproducts with many variations will get a very long name. now its possible to set the product title as the SKU (SKU are also combined)
(*) variations can be show as radio, dropdown list or checkbox (which permits be a null value)
(*) if the propper combination doesnt exist or has 0 in stock, it blocks the 'add to cart' button (with javascript/ajax)
(*) when creating new subproducts, the predefined stock looks for each attribute and set is as the lesser one
(*) a tagged table on parent product page permits a better theming

1- sorry for not provide a better documentation and .patch
2- someone should provide a patch against head and 4.7
3- i didnt wrote a script in .install to convert all subproducts prices to the new updated price.
4- stock control yet not totally working: it should decrease attribute stock when a subproduct is sold.
5- if someone add me in CVS, i would post more regular changes directly

best regards

massa

CommentFileSizeAuthor
#13 desiredChange.PNG35.52 KBkuahyeow
#3 subproducts_1.zip28.25 KBbrmassa
#2 subproducts_0.zip27.93 KBbrmassa
subproducts.zip27.92 KBbrmassa

Comments

drupaceous’s picture

drupaceous commented
Title: Advanced Subproducts Module » Unable to install

replacing the current subproducts dir with yours generates this error:

Parse error: parse error, unexpected T_OBJECT_OPERATOR in /var/www/silkflower/sites/default/modules/ecommerce/subproducts/subproducts.module on line 585
brmassa’s picture

brmassa commented
Title: Unable to install » Advanced Subproducts Module
StatusFileSize
new subproducts_0.zip27.93 KB

Quinten,

sorry for that. i forgot that php 4.X doesnt accept some code shortcuts.
fixed. please try and give me feedback.

best regards,

massa

brmassa’s picture

brmassa commented
StatusFileSize
new subproducts_1.zip28.25 KB

guys,

a new version. it fixes some issues:
* dynamic pricing and stock verification now works correctly
* creating subproducts now doesnt show an anoying "foreach warning"

and added new stuff:
* category and forbidden combination feature: imagine you sell customized computers. there is a variation called OS for "Win XP Home" and "No OS" and another variation called Installed Softwares with "Anti virus", "Office Suite". Well, if you choose No OS you shouldnt be able to select and other software ok?! so you can now enter a forbidden combination on "Anti virus" and "Office Suite" attributes to not combine witn "No OS" attributes. It really helps on subproducts with hundreds or thousand combinations.

best regards for all,

massa

drupaceous’s picture

drupaceous commented
Category: task » bug

Still get error, adding product variation with this subproducts module gives me an error: undefined column "description".

drupaceous’s picture

drupaceous commented

... specific error message is:

Unknown column 'description' in 'field list' query: INSERT INTO ec_variation (vid, name, weight, ptype, description, showprice ) VALUES (2, 'zwart vierkant pot', 0, 'apparel', 'zwart vierkant pot', 1) in /var/www/silkflower/includes/database.mysql.inc on line 120.

jeanmichel-1’s picture

jeanmichel-1 commented

Ok.
so in my setup, seems like the inventory management system doest work with the different variations of a product.

I want to be able to inform the user about the number of red small pants letft and the number of blue small pants left and the number of blue large pants left, etc.

And i checked in the different columns of the ec_variations table and the item "description" in your error is not there. Accordingly, it isnt there neither in the subproduct_install file.

So obviously, something's missing somewhere (even though i havent found a way to get your error message...)

brmassa’s picture

brmassa commented

Drupaceos,

i changed the ".install" file. you should go to admin >> modules >> update.php (or just type www.yoursite.com/update.php). click on "run the satabase update script" then, open the "Select versions" and choose "1" for subproducts. it will install again this module and a field called 'description' will be added in database. report any other error!

jean,

do you want to show the product (combination) stock, isnt it? well... i can program something later to include this feature (actually it cant be shown). I may observe that there is no inventory management to attributes (yet), so you cant show each attributes stock.

best regards,

amssa

biztoe’s picture

biztoe commented

This is a great addon! We are currently using it for a client (dev link: http://trubendz.biztoe.com/node/71) We found that the subproduct image and dynamic pricing works well with IE (a little slow) and it does not work with firefox.

biztoe’s picture

biztoe commented

I think being able to add description to the attribute would be good also.

brmassa’s picture

brmassa commented

Biztoe,

its great to read positive feedbacks. well:
1* dynamic pricing is slow because it uses AJAX. AJAX in Drupal is very very slow... it uses AJAX to format the price (maybe i can add a "format price" option) to skip this and speed it up
2* i use firefox and konqueror browsers for linux and it works on both. I must see so how to make it works on Fx and Windows so.
3* Attribute description: well, yes it can be added in a near furure.
4* you site looks very good. congratulations.

now.. some news:
due some unused features (as base subproducts), missing features ("corrected" in this "patch"), and mainly because its impossible to create subproducts with tousands/million variations (php stop working during the permutation calculation), im creating a brand new subproduct module.
Im gonna post the new code as EC Live Subproducts module and includes all features included in this "patch" and:
* the combinations are not created at one time: it is genarated when the product is sold, avoiding HUGGEE server overload
* new layout: more information, less complicated to create subproducts
* a new node type: tangible subproducts (once subproduct and ec_live_subproducts module cant have the same functions, a new node type calling the new functions were needed)
* faster
* New default values
IT is my objective one day to merge with the subproducts.

best regards,

massa

biztoe’s picture

biztoe commented

Can't wait for the next version :)

sime’s picture

sime
any/any
Location Melbourne
commented
Project: e-Commerce » eC Live Subproducts
Version: 4.7.x-1.x-dev »
Component: subproducts » Code

switching to appropriate queue

kuahyeow’s picture

kuahyeow commented
StatusFileSize
new desiredChange.PNG35.52 KB

Is the subproducts image working in Firefox now? The link provided by biztoe seems to indicate not.

Would someone be able to patch subproduct images to the subproducts code or is it not ready yet. I would not mind something like this (see attached screenshot).

brmassa’s picture

brmassa commented

Thong Kuah,

this code/patch, posted here, turns possible to link and show images to each attribute.
its not possible to created (yet maybe) the color selector you proposed (i must say that i liked the idea), but if you visit biztoe's site you will see the images working fine (at least i can see here using firefox under linux).

about the EC Live Subproducts Module, i completly forgot to submit the code. Im gonna do this in the next few days.

regards,

massa

kuahyeow’s picture

kuahyeow commented

Hi Massa, no I cannot see the images in Firefox Windows XP SP 2.

I will have a look at the code you posted here, and look forward to helping you on this project. :)

Maybe I can produce a patch for this to merge with the subproducts module...[Sorry, i'm a total noob at contributing]

kuahyeow’s picture

kuahyeow commented

Firefox Windows XP (Firefox 2.0)

The specific problem with images not displaying seems to be:

at_surcharge[selectx.vid] has no properties

according to firebug.

biztoe’s picture

biztoe commented

kuahyeow, I have the same problem with Firefox 2.0 in Windows 2003.

kuahyeow’s picture

kuahyeow commented

hi,

I submitted a patch from brmassa just for images, so please have a look here
http://drupal.org/node/97705

brmassa’s picture

brmassa commented
Status: Active » Closed (fixed)