Dynamic Price Updater

[marcopolo]

This is the other module I'm trying to get it to work with:
https://www.zen-cart.com/downloads.php?do=file&id=1637

[Design75]

This is the other module I'm trying to get it to work with:
https://www.zen-cart.com/downloads.php?do=file&id=1637

For DPU to work on the product listing you would have to rewrite the whole DPU mod

[HeathenMagic]

Hello there,

Does anybody have success making this work on 1.5.5? Thanks in advance

[orochi_kyo]

Hello there,

Does anybody have success making this work on 1.5.5? Thanks in advance

This, Im receiving errors anytime I try to get to the admin after installing. This is one of the best modules, please update it.

[02-May-2016 21:02:51] Request URI: /sitio2/Claim-ppo-Whack/login.php?camefrom=index.php, IP address: 186.32.18.63
#1  trigger_error(1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),') ==> (as called by) /home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php on line 50 <==, 256) called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:167]
#2  queryFactory->show_error() called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:139]
#3  queryFactory->set_error(1136, Column count doesn't match value count at row 1, 1) called at [/home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php:266]
#4  queryFactory->Execute(INSERT INTO configuration VALUES (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),')) called at [/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php:50]
#5  require(/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php) called at [/home/etechnol/public_html/sitio2/includes/autoload_func.php:48]
#6  require(/home/etechnol/public_html/sitio2/includes/autoload_func.php) called at [/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/application_top.php:171]
#7  require(/home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/application_top.php) called at [/home/etechnol/public_html/sitio2/Claim-ppo-Whack/login.php:9]

[02-May-2016 21:02:51] PHP Fatal error:  1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES (NULL, 'Dynamic Price Updater Status', 'DPU_STATUS', 'false', 'Enable Dynamic Price Updater?', '38', 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),') ==> (as called by) /home/etechnol/public_html/sitio2/Claim-ppo-Whack/includes/init_includes/init_dpu_config.php on line 50 <== in /home/etechnol/public_html/sitio2/includes/classes/db/mysql/query_factory.php on line 167

[orochi_kyo]

I got around those install errors, adding a ", null" in some lines then adding "sometext" in others in the code between 50 and 60 at init_dpu_config, it seems one column to add to the database was missing in those lines.
But now I cant see how to make the plugin to work, I can see the options on the admin side, "Where to display the price", when I use "productsGeneral" which is the <h2> that contains the price text tag, I choose between the attributes I see the loading GIF but the main price doesnt change, if I leave it blank or try to set another ID(of course I create a input field or a simple text spam field with an ID first), nothing happens, even the loading GIF is not there.

Im using Zencart 1.5.5 with responsive Sheffield blue, I had tried the default template too, it doesnt work.

I have been using zen cart for ten years, this kind of stuff should be there by default by now, like when people select another quantity of the same product, price should be updating without the need of pressing "add to cart" button.

[Design75]

I got around those install errors, adding a ", null" in some lines then adding "sometext" in others in the code between 50 and 60 at init_dpu_config, it seems one column to add to the database was missing in those lines.
But now I cant see how to make the plugin to work, I can see the options on the admin side, "Where to display the price", when I use "productsGeneral" which is the <h2> that contains the price text tag, I choose between the attributes I see the loading GIF but the main price doesnt change, if I leave it blank or try to set another ID(of course I create a input field or a simple text spam field with an ID first), nothing happens, even the loading GIF is not there.

Im using Zencart 1.5.5 with responsive Sheffield blue, I had tried the default template too, it doesnt work.

I have been using zen cart for ten years, this kind of stuff should be there by default by now, like when people select another quantity of the same product, price should be updating without the need of pressing "add to cart" button.

I will be away for the major part of the day, but I will take a look at your bug tonight. Below you find the default settings

Title	Value
Dynamic Price Updater Status	true
Dynamic Price Updater Version	3.1
Where to display the price	productPrices
Define used to set a variable for this script	cart_quantity
Where to display the weight	productWeight
show a small loading graphic	true
Show currency symbols	true
Show product quantity	false
Where to display the second price	cartAdd

[orochi_kyo]

This is how my config Admin looks like.

This is an url with a product with attributes, DPU is on.
http://etechnologycr.com/sitio2/inde...oducts_id=1581

Thanks in advance.

[strelitzia]

For DPU to work on the product listing you would have to rewrite the whole DPU mod

I've seen it working on the product listing pages. I coded this site so I know it can be done.
Go to https://www.liberro.co.uk/electronic...dvanced-vapers and then look at product Aspire Plato All in One Kit. Click the Select Options button and the attributes will pop up. Select the option to add a Mains Charger and you will see the listing price updates after you click the Finished button.
I can't remember how much I had to do on DPU to get it working as that site has had a LOT of customisation to get attributes to display on listings.
Slightly off the DPU topic, but it's so heavily modified that it even displays all products within sub categories on a single page, as can be seen here https://www.liberro.co.uk/ecig-liquid-uk. That took a fair bit of work too!

[clange]

Something to keep in mind with your attribute pricing seeing as you offer a sample of a product is the effect of any pricing "arrangement" on "published" pricing and others searching for that product based on the "base" price.

As to posting the link, I had not. Partially because although I was trying to get everything modified merged into one branch and tested a few additional things about it. I was able to update the changes onto a test site and didn't get JS errors but I didn't totally have a chance to compare the code at that state with the original code to see if one of the issues had really been corrected or just simply "ignored".

Anyways, I have a forked copy of what looks like the current version found at:
https://github.com/mc12345678/Dynamic_Price_Updater
with all of the changes I have made found at:
https://github.com/mc12345678/Dynami...debox-possibly

The changes include a little data sanitization and then action taken to permit "fair play" with other javascript code affecting the product_info page, and I think I have prevented one of the objSB errors related to the sidebox from becoming an issue with a default install, but could still be implemented with an appropriate code change where some additional comment was added to describe what may be necessary to use that feature.

Hey mc12345678,
I tried the latest fork from github: https://github.com/mc12345678/Dynami...debox-possibly
However, the price always shows as $0... Using ZC 1.5.5a - will this work, or is there something extra I need to do?
Thanks,
Chris

[mc12345678]

Hey mc12345678,
I tried the latest fork from github: https://github.com/mc12345678/Dynami...debox-possibly
However, the price always shows as $0... Using ZC 1.5.5a - will this work, or is there something extra I need to do?
Thanks,
Chris

How do you have your attributes setup? Product priced by attributes? Sample page of where this issue is occurring? (can obscure the address slightly if wish).