News:

Support the VirtueMart project and become a member

Main Menu

Product Options Custom Field Dropbox Plugin (Updated)

Started by PRO, March 16, 2012, 11:52:11 AM

Previous topic - Next topic

lipes

i've updated the plugin .. but now the price dont work (dont do the automatic update) in my Product Details page....  (no override template)

I've got again a brand new instalation J+VM ... with default J template...
i'll instal your Plugin and test again there to report...
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

lipes

#181
in the brand new J2.5.4+VM(2.0.7c)

1st step:
Installing plugin was successful.
VMCUSTOM_DROP_BOX_DESC


2nd: i go  to /index.php?option=com_plugins&view=plugins
and clicked in enable
"Plugin successfully enabled"

3rd step:
index.php?option=com_virtuemart&view=custom
and create NEW
-> Custom Field Type: Plugins
Published Yes
Title: price test
Cart Attribute: yes
Select a plug-in: VMCustom - dropbox
Custom Dropbox: Title: price test
Options: Small,Medium| +5,Large| +10
I've hit Save & Close

4th step: in the product area  (index.php?option=com_virtuemart&view=product&task=edit&virtuemart_product_id=1&product_parent_id=0)
Last Tab: Custom Field
I've hit in bottom: Custom Field Type
Drop Box Selections seperated by comma: Small,Medium| +5,Large| +10
I've hit: Save & Close

Now its time to go to the front End ..
Dont work if we select for example:
'price test title'  LARGE (10,00 )
The price got the same value!

But ok, i hit in ADD TO CART by the same way and....
Total: 2,00 €
Its a bug ? it should be 10 (Custom Field Price for LARGE) + 2 (Product Price)   = 12,00

See here: http://img341.imageshack.us/img341/4597/new3g.jpg
Brand New .. No more 3rd plugins/modules/components instaled (only Joomla and VM default ones)

in Tables SQL and website front end now:
http://img96.imageshack.us/img96/4301/tableupdate.jpg
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

PRO

Quote from: lipes on May 18, 2012, 15:11:38 PM

3rd step:
index.php?option=com_virtuemart&view=custom
and create NEW
-> Custom Field Type: Plugins
Published Yes
Title: price test
Cart Attribute: yes
Select a plug-in: VMCustom - dropbox
Custom Dropbox: Title: price test
Options: Small,Medium| +5,Large| +10
I've hit Save & Close


IF IT HAS a price variant, DO NOT do it here  index.php?option=com_virtuemart&view=custom

HERE     index.php?option=com_virtuemart&view=custom
You ONLY save "templates" that are NOT price variants, Like here   http://www.kaizenmediaworks.com/images/files/custom-field.png


AND::;   

WHY did you do the sql update when you just tested this?

The SQL update was to convert the database from the 1st version of this, to the 2nd version.


lipes

Hi. What is or mean the "price variant" ?
I just got/work with 1 price, it's the product final price (with tax)... that i've inserted in the Product admin page..
It's not possible to have an increment in the Product Final Price + Custom Field (extra price) ?


I just did that sql update before all that first test...
I dont understand why the product final price is the same.. so i just was trying to see if whit that sql update was different...
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

PRO

Quote from: lipes on May 18, 2012, 21:14:24 PM
Hi. What is or mean the "price variant" ?
I just got/work with 1 price, it's the product final price (with tax)... that i've inserted in the Product admin page..
It's not possible to have an increment in the Product Final Price + Custom Field (extra price) ?


I just did that sql update before all that first test...
I dont understand why the product final price is the same.. so i just was trying to see if whit that sql update was different...

go into your price configuration, and enable all of them, and see what happens?


and a "price variant" is an option that changes price.



PRO

Quote from: lipes on May 18, 2012, 22:39:46 PM
sorry BT.pro, i cant fint "price configuration" label did you mean any of this print screen images:

or its in another place?!

http://img802.imageshack.us/img802/794/49825871.jpg

enable them all and see what happens

lipes

VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

lipes

#188
i need to remove the DB ?
Since i've done the SQL update the Price in drop down list (Front end) disappear

http://img94.imageshack.us/img94/2259/test1qm.jpg
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

PRO

Quote from: lipes on May 18, 2012, 23:30:50 PM
i need to remove the DB ?
Since i've done the SQL update the Price in drop down list (Front end) disappear

http://img94.imageshack.us/img94/2259/test1qm.jpg


Go to the product, and the admin, and see if itsa like this

Red,Blue,Yellow|+10,Green


NEVER put a "comma" at the end of the line.

and MAKE sure there are NOT 2   ||

lipes

#190
now i get back the price in your Custom Field Plugin...
http://img52.imageshack.us/img52/7302/test2eni.jpg

But... I've clicked on Yellow (+10,00)  and i saw a litle "refresh colour" hover the Price but.... doesnt change the default value "2.00".
The Product Price value persists at 2.00 €  not 2+10= 12.00 € like it should be...
I've also clicked in "add to cart" but its the same... only show 2.00 €

Cart:
http://img404.imageshack.us/img404/7795/test3jw.jpg
like you could see the "Yellow" word at bottom of the image ... but no information about +10 in any place ...
Even in the mini cart at left side ...
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

PRO

are you using child products?

are you using discounts as markups?



lipes

#192
nop...
In all print screen images that i've sent i am showing the brand new instalation folder in the localhost with the name "novo".
Just only got 1 product inserted in the DB, and I even didnt the instalation of the default VM2 data.
http://img232.imageshack.us/img232/6291/test4q.jpg
http://img191.imageshack.us/img191/2048/test5a.jpg

After that i was in another instalation folder (the oldest one) that i am working since november/december called "mp5"  in the same localhost (Softaculous AMPPS).
I dont have any child products in both cases. i think i wont use that because i must read more about "child products" information to know better if is really needed to my fathers store..
About the discounts = cupon codes?
I dont activate this and never tested yet... maybe i will test that and use in the future.. like a cupon code for facebook fans or something else...

PS: i never tested an order since VM 2.0.0... because is near the last step of a online website...
I'm yet checking this 2nd steps in order to jump to another step and do the simulation Order ..
and then (finally) search a cheapest webhost and configure emails to test again if everything is working fine...
i think that i cant test emails in localhost :S (i must read more about that too)


thanks for the attention for you're giving. I am just reporting
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25

CMYKreative

Quote from: BanquetTables.pro on May 18, 2012, 13:08:04 PM
Quote from: CMYKreative on May 18, 2012, 05:59:43 AM
Not sure what I'm doing wrong, but I need to update the DB, but can't get it to do it properly.

In the instructions, it says:

update jos_virtuemart_product_customfields set custom_param=replace(custom_param,'+','|+')
update jos_virtuemart_product_customfields set custom_param=replace(custom_param,'-','|-')

How do I get this to run?

jos_    you need to change the jos to YOUR table prefix

OK, changed the jos_ to the correct prefix and I 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 'update berke_virtuemart_product_customfields set custom_param=replace(custom_par' at line 2

Any ideas?

PRO

Quote from: CMYKreative on May 19, 2012, 03:36:06 AM
Quote from: BanquetTables.pro on May 18, 2012, 13:08:04 PM
Quote from: CMYKreative on May 18, 2012, 05:59:43 AM
Not sure what I'm doing wrong, but I need to update the DB, but can't get it to do it properly.

In the instructions, it says:

update jos_virtuemart_product_customfields set custom_param=replace(custom_param,'+','|+')
update jos_virtuemart_product_customfields set custom_param=replace(custom_param,'-','|-')

How do I get this to run?

jos_    you need to change the jos to YOUR table prefix

OK, changed the jos_ to the correct prefix and I 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 'update berke_virtuemart_product_customfields set custom_param=replace(custom_par' at line 2

Any ideas?

'update berke_virtuemart_product_customfields set custom_param=replace(custom_par'

^^^^ THAT IS NOT THYE WHOLE SATTEMENT

CUSTOM_PAR    ???


TO do an sql update
BACKUP FIRST
update jos_virtuemart_product_customfields set custom_param=replace(custom_param,'+','|+')
update jos_virtuemart_product_customfields set custom_param=replace(custom_param,'-','|-')