Jump to content
TENCENTS

Custom Product Builder

Recommended Posts

I haven't been keeping up to date with the forums but I'll be back soon. Just a quick update to let you all know that I have been working on some new features for this contrib, they're 99% done just tieing up some loose ends.

 

New functionality:

Visitor-uploadable product image.

Minimum components allowed before "building".

Currency formatting revised - I haven't been able to break it yet.

Form data reloading - this is a cool step towards future rebuild functionality but for now it's being used to save and reload the page incase of build-processing errors (component shortage, etc).

 

Just a few more days...


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites

Thx for the great work!

 

I have a problem: in my Admin Panel > Custom Products > Categories, I can't create any new category, edit or delete it. After push the "Reload" button, or push the Enter button in the field, nothing happens. I've done a new osCommerce installation, and checked the installation instruction many times again... please help. :blush:

Share this post


Link to post
Share on other sites

Hi,

 

Great contribution, just can't get it working. I have the same problem as the previous poster being that I cannot add new categories or make changes to any of them. I received an error when updating to create the databases:

 

1067 - Invalid default value for 'catalog_products_id'

 

ALTER TABLE products_options_values ADD COLUMN `catalog_products_id` int(11) NULL default 'NULL'

 

[TEP STOP]

 

Any idea what might be causing this?

 

I've tried adding the fields myself but it doesn't fix the category problem.

 

Cheers,

 

Lee

Share this post


Link to post
Share on other sites

I changed the default values back to NULL for catalog_products_id and it now allows me to choose from the components in the popup box but it still does not allow me to add or edit the builder categories. It also gives this error when I click build:

 

1136 - Column count doesn't match value count at row 1

 

insert into products_attributes values (NULL, '110', '28', '192', '0', '+')

 

[TEP STOP]

 

Regards,

 

Lee

Share this post


Link to post
Share on other sites

1136 - Column count doesn't match value count at row 1

insert into products_attributes values (NULL, '110', '28', '192', '0', '+')

[TEP STOP]

 

I think I've figured out that the error above is because I'm using the attribute sort order contribution? This adds extra fields to the products_attributes table so when the builder tries to add the PC it is expecting there to only be 6 columns in the table whereas there are actually 10 due to the change made with sort order. Is there a way to change the insert to:

 

insert into products_attributes values (NULL, '110', '28', '192', '0', '+', '', '', '', '')

 

If so, in which php file would I need to do this? I may not even have this right as I'm not really a coding maestro but any help would be awesome.

 

Thanks,

 

Lee

Share this post


Link to post
Share on other sites
1136 - Column count doesn't match value count at row 1

insert into products_attributes values (NULL, '110', '28', '192', '0', '+')

[TEP STOP]

 

I think I've figured out that the error above is because I'm using the attribute sort order contribution? This adds extra fields to the products_attributes table so when the builder tries to add the PC it is expecting there to only be 6 columns in the table whereas there are actually 10 due to the change made with sort order. Is there a way to change the insert to:

 

insert into products_attributes values (NULL, '110', '28', '192', '0', '+', '', '', '', '')

 

If so, in which php file would I need to do this? I may not even have this right as I'm not really a coding maestro but any help would be awesome.

 

Thanks,

 

Lee

add columns in the right postion to

insert into products_attributes values (NULL, '110', '28', '192', '0', '+', '', '', '', '')

Share this post


Link to post
Share on other sites

nobody have a solution to my problem please?

 

I found the problem as to why its not adding to the cart and was hoping someone could help me with. I have tested everything and found the exact line that is making the problem. The problem is with another contribution i installed to put a pull down quantity box in product info (http://addons.oscommerce.com/info/5553). The code with the problem is in /catalog/includes/application_top.php :

 

$cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+$HTTP_POST_VARS['quantity'], $HTTP_POST_VARS['id']);

 

The code that needs fixing is in /catalog/builder_main.php :

 

$cart->add_cart($products_count[$i], $cart->get_quantity(tep_get_uprid($products_count[$i], $_POST['id']))+$products_qty[$i], $_POST['id']);

 

Hope this information can help someone to help me.

 

Thanks

Share this post


Link to post
Share on other sites

Just a quick note to say that I have just released version 1.1.0 which sorts out a lot of old ossues and introduces some new goodies.

 

The package contains instructions for both NEW INSTALLS and UPGRADES (from version 1.0.x).

 

What's New:

~~~~~~~~~~

Addition of five new builder options. (yeehaa!!)

Visitor-uploadable build image.

Minimum components per build control.

Currency formatting revised - complete redesign.

Pricing issues revisited - rounding problems found and fixed - unstable only at 4th decimal place by .0001 cents.

Form data saving/reloading on errors (and now opens the door for planned rebuild functionality - cool!!).

Error trapping enhanced - highlights the component selections that have errors.

Autoclear function now resets component count too (bugfix).

Built products 'hide' feature added.

Direct to cart for single builds has been redesigned and now working 100%.

Builder fully honors the store's config setting: 'display cart after adding product'.

Addition of a dedicated component viewer (builder_component_info.php) - just another rip of product_info.php.

 

Gotta go now - I'll be back later to catchup on PMs and Forum posts.

Apologies for my absence! - this thing has kept me quite busy.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
WOW.. seems like this is coming a LONG way!

 

One thing that i would REALLY like to see, for my application of building calenders..

 

Basically, we do separate photo shoots for each person, so this custom product builder will need to have different products for each customer. So say my customer that we did a puppy photo shoot came and wanted a calender, i would LIKE for her to be able to choose her "gallery" (which is a category) from a drop down at the begining, and THEN that would populate all of the option (the months of the year) with all of the products placed in her "gallery" (or category)

 

This way, the customer will basically be populating the builder themselves with their own products BEFORE even starting the build.

 

Obviously this would not work for computers, but would be AWESOME for people who do things like calenders, photo books, and other customized items

 

I like your suggestions Lindsay, by the next release I think these will be a reality. I'll PM you for the finer details when I get going on this.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
That is a good enough description.

this way others can write the services that would used by the builder for the type of buider they want.

the PHP file would have the init, add, delete, update, retrieve methods.

Just have to add the hook into the builder code to read the table.

this leave the basic builder code unchanged.

Then the person using the website can add which ever of the services want to offer.

 

The enterprise software I work with operates this way.

Thought could bring it to here.

 

I'm replying to all the posts leading up to this one.

 

So basically what we're looking at then is a custom product creator which ties/integrates into this builder. Allowing customers to define their own products with uploadable/configurable attributes and then using those products in the builder to assemble them (in the right order, etc...). And obviously affording the customer some sort of privacy at the same time, ie. the ability to hide 'their' products from other visitors, and a bunch of things I haven't mentioned.

 

Well, anything's possible. Give me a big stick and enough time and I'll change the world.

Edited by TENCENTS

Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
Hey Mike, and All!

 

Wondering if anyone else does not get the correct weight when in single mode, and more than one of an individual component is added in builder_main.php.

 

I'm just getting the weight for one, no matter the quqntity added in builder_main.php, when I reach the checkout_shipping.php file.

 

Thanks in advance for any input!

 

Regards,

 

JF

Well spotted!

 

BUGFIX - Component total weight when using quantity > 1

 

Edit /catalog/builder_main.php

 

## FIND:

 

$products_weight = $products_weight + $products['products_weight'];

 

## REPLACE WITH:

 

$products_weight = $products_weight + ($products['products_weight'] * $components_quantity[$i]);

 

## Done!


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
I tried this, but without success.

The problem is not the tax amount, but the additional text wich is coming out with contribution "tax_info".

The "tax_info" contrib modifies the display_price function in /catalog/includes/classes/currencies.php, the builder uses this function too.

 

There are two ways around this - create a new class function, oh maybe builder_price or something - get a copy of the original (osC) display_price function and paste that somewhere in the currencies.php file, remember to rename the function. Then search all the builder php files for '$currencies->display_price' and replace them with '$currencies->builder_price'.

 

I had a look at the tax_info contrib history and saw that there have been various fixes for files that were forgotten - like product_listing.php for example. I'm sure the changes involved would be similar - you would then need to modify the builder files wherever they use the display_price function in a similar way so that they incorporate the tax_info contrib - and I think this is what you want/need.

 

If you still have problems let me know which tax_info contrib you've got; 19-Jul-08 Tax info 1.0 or 14-May-05 tax_info1.3 contrieb for SPPC

Edited by TENCENTS

Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
Thank you for this insight. I installed Seperate Pricing Per Customer and that changes the query so i copied it same and it works.

 

Now the question i have is if a product has attributes how can you chooses what attribute of the product you want to add to custom build?

Spot on.. SPPC installs do have this affect on the builder. In future there will be a release for SPPC mainly because I need it to be that way, but not now, that's a hectic mod.

 

As for attributes, well, support for that will be coming much sooner. At the moment I think the builder takes the default attribute, ie. the first one that shows up if you're viewing it in the product_info page.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
Is there nobody that can help me please?

Hi. Up until now the builder has been using a modified add_product 'switch' (in application_top.php as you mentioned), in the new version 1.1.0 the original add_product switch has been restored and the builder now uses it's own, add_build.

 

If you've tried the builder in Bundle mode and it works properly then 1.1.0 should sort the problem out.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites

Hi.

 

Great update, love the new features, I like being able to have the created product hidden from other customers, it was a feature I was going to request!

 

I've installed the upgrade, all went well, nice and easy however unfortunately the prices are still a bit out!

I've attached an image below to show what happens, as it's probably much easier

customproduct.jpg

As you can see the total is still wrong, but this time it's just a decimal place in the wrong place!

This error also happens on the print preview. Once the item is added to the cart the price is correct again!

 

Also, a little request for a little help, as you can see I have pics for each part of the dress, (these are just temporary ones!)

How hard would it be to combine all the separate parts into one big picture to give an overall impression of the finished article in the "print preview" page?

I'm not asking for you to write this! Just a few pointers!!!

 

Thanks

 

Mat

Share this post


Link to post
Share on other sites
I received an error when updating to create the databases:

 

1067 - Invalid default value for 'catalog_products_id'

 

ALTER TABLE products_options_values ADD COLUMN `catalog_products_id` int(11) NULL default 'NULL'

 

[TEP STOP]

I found something, try this...

 

BUGFIX - MySQL legality issue - fix error when creating tables for first time

--------------------------------------------------------------------------------------

Edit /catalog/admin/builder_options.php

 

## FIND:

 

tep_db_query("ALTER TABLE " . TABLE_PRODUCTS_OPTIONS_VALUES . " ADD COLUMN `catalog_products_id` int(11) NULL");

 

## REPLACE WITH:

 

tep_db_query("ALTER TABLE " . TABLE_PRODUCTS_OPTIONS_VALUES . " ADD COLUMN `catalog_products_id` int(11) DEFAULT NULL");

 

## Done!


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
I've installed the upgrade, all went well, nice and easy however unfortunately the prices are still a bit out!

I've attached an image below to show what happens, as it's probably much easier

 

As you can see the total is still wrong, but this time it's just a decimal place in the wrong place!

This error also happens on the print preview. Once the item is added to the cart the price is correct again!

 

Also, a little request for a little help, as you can see I have pics for each part of the dress, (these are just temporary ones!)

How hard would it be to combine all the separate parts into one big picture to give an overall impression of the finished article in the "print preview" page?

I'm not asking for you to write this! Just a few pointers!!!

Hi Mat - thanks!. Okay now I see - I'll look into this a bit later. BTW, that extra decimal point should be a thousands separator symbol, is your currency setup for one? It's not a criteria I'm just curious.

 

An 'overall image' in the print preview would be quite easy if all your product/component images were GIF or PNG - they would be special images and they would take you a bit of time to produce (in something like PhotoShop). Using the GIF/PNG transparency feature you can erase certain parts of the image, so for the t-shirt 'body' images you would erase the sleeves (maybe leave just an outline), and for the 'sleeves' images erase the body area. When you lay any sleeve image over a body image (or vica versa) the image you will see is a complete t-shirt. Then in builder_print_preview.php (and even builder_product_info.php) you would create a place to display the 'overall image', it would then be a trick of getting the component images to display ontop of each other in the 'overall image' location. I dunno if the 'trick' is easy though, I've never tried it before.

 

I might not write it for you but I will certainly consider implementing something like this at some stage - it just makes the contrib more awesome.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
Hi Mat - thanks!. Okay now I see - I'll look into this a bit later. BTW, that extra decimal point should be a thousands separator symbol, is your currency setup for one? It's not a criteria I'm just curious.

 

An 'overall image' in the print preview would be quite easy if all your product/component images were GIF or PNG - they would be special images and they would take you a bit of time to produce (in something like PhotoShop). Using the GIF/PNG transparency feature you can erase certain parts of the image, so for the t-shirt 'body' images you would erase the sleeves (maybe leave just an outline), and for the 'sleeves' images erase the body area. When you lay any sleeve image over a body image (or vica versa) the image you will see is a complete t-shirt. Then in builder_print_preview.php (and even builder_product_info.php) you would create a place to display the 'overall image', it would then be a trick of getting the component images to display ontop of each other in the 'overall image' location. I dunno if the 'trick' is easy though, I've never tried it before.

 

I might not write it for you but I will certainly consider implementing something like this at some stage - it just makes the contrib more awesome.

Hi,

 

Great idea with the transparent gifs, I was thinking of a selection of jpgs all put together carefully to create the final item, but I like your idea better! One thought about this is that some of the product images might look a bit odd if there has to be a bit of spacing to allow everything to slot together, what might work is to have 2 pics per item, one for the main pic, and one for the "print preview"pic?

 

I've copied and pasted the currency settings for the store below, so you can see how it's formatted.

Title: UK Pound 
Code: GBP 

Symbol Left: £ 
Symbol Right:  

Decimal Point: . 
Thousands Point: . 
Decimal Places: 2 

Last Updated: 02/16/2008 
Value: 1.00000000 

Example Output:
£30.00 = £30.00 

 

Taking the decimal point out of the thousands setting has fixed the error, though technically this is a bit of a "fix" rather than repair the issue?

 

Cheers

 

Mat

Share this post


Link to post
Share on other sites
Hi. Up until now the builder has been using a modified add_product 'switch' (in application_top.php as you mentioned), in the new version 1.1.0 the original add_product switch has been restored and the builder now uses it's own, add_build.

 

If you've tried the builder in Bundle mode and it works properly then 1.1.0 should sort the problem out.

 

This is wonderful now and it works great. Appreciate it.

 

I just noticed one thing. If you have items in the cart and you go ahead to select products and then click on "Build Product" then all the items that were in the cart get removed even though the session id is still the same. Could you test this and let me know if you get the same problem please?

Share this post


Link to post
Share on other sites
1. .... some of the product images might look a bit odd if there has to be a bit of spacing to allow everything to slot together.

2. .... Taking the decimal point out of the thousands setting has fixed the error, though technically this is a bit of a "fix" rather than repair the issue .

1. If you had a css type background colour or image set (eg. background:#xxxxxx; or background-image: <imagefile>;) for the area that you're displaying the overall image then the background should come through the transparencies - you would want something contrasting though, like a grey with thin yellow lines running through it - a solid colour would be confusing. My curiosity is killing me so I'm gonna be playing around with this sometime today.

 

2. I see that your thousands point separator is a period (.) - shouldn't it be a comma (,) instead? The builder relies on the fact that the thousands separator is different to the decimal point, so if you're using a period for thousands then using a comma for the decimal would work properly - if you made them both commas then I think it'll cause the same trouble.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
This is wonderful now and it works great. Appreciate it.

 

I just noticed one thing. If you have items in the cart and you go ahead to select products and then click on "Build Product" then all the items that were in the cart get removed even though the session id is still the same. Could you test this and let me know if you get the same problem please?

Great!

 

Okay, I've tested it and everything seems to be working fine with the cart. You don't maybe have the builder in 'bundle' mode? If so then have a look in the builder options for 'Bundled Mode: Clear cart Before Carting' and make sure it's set to No.

 

If not then we have a genuine problem albeit isolated. I assume you're still running the latest xampp (P5/M5) and RC2a, with register globals off?, have you tried this with other browsers?, and have you got any other contribs installed that would affect the shopping cart and/or checkout processes?


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
Is it perhaps the PHP / MySQL version? I'm using PHP 5.2.3, Apache 2.2.4 and MySQL 5.0.45.

I doubt it, still looking into this though.

 

Did you have any trouble with the installation?

 

At some stage we did run into problems with the post_vars in php5 and this was the type of trouble it was causing. You might find that version 1.1.0 works fine, if not then let me know.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
some of the product images might look a bit odd if there has to be a bit of spacing to allow everything to slot together, what might work is to have 2 pics per item, one for the main pic, and one for the "print preview"pic?

Sorry Mat, the penny has just dropped... yes you're quite right, the product images themselves would look pretty odd.


Never underestimate the power of stupid people, especially in groups.

Share this post


Link to post
Share on other sites
Great!

 

Okay, I've tested it and everything seems to be working fine with the cart. You don't maybe have the builder in 'bundle' mode? If so then have a look in the builder options for 'Bundled Mode: Clear cart Before Carting' and make sure it's set to No.

 

If not then we have a genuine problem albeit isolated. I assume you're still running the latest xampp (P5/M5) and RC2a, with register globals off?, have you tried this with other browsers?, and have you got any other contribs installed that would affect the shopping cart and/or checkout processes?

 

Sorry my mistake. What is actually happening is i am losing the session id and whenever i press "Build Product" it creates a new session id and thats why my contents from the cart are being removed. I think it might have something to do with Ultimate SEO URLs v2.1d UPDATED - 07-11-2008 (just a wild guess). Will test on this further tommorrow. Can you think of something as to why the session id might be getting refreshed?

 

Appreciate all your help.

 

Edit: I am still running latest xampp, rc2a and register globals is off.

Edited by CGhoST

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×