DUAL Pricing v2

Hey buriko... the last update has be done by me... the other update for 1.3.8 was based on code for zen version 1.3.0 to 1.3.5... i only put the needed code into the files for 1.3.8
This was only the second time that i uploaded a contibution... thanks to point out that i left the cowoa in there. but it should be fairly easy to delete the cowoa part since - if i remember right - the are all pretty obious marked...

stevefriedman71:

i left the cowoa in there. but it should be fairly easy to delete the cowoa part since - if i remember right - the are all pretty obious marked...

Im getting this error after uploading DUAL mod to a new install of zen. What should i be deleting and where?

Thanks!

in the version I uploaded I simply compared the files and added the code for 1.3.8 - I don't know what Steve is talking about. I used that version to update a 1.3.8 cart - no problems and there's nothing extra in there. If there are extra files in my version and I don't believe there are, the cart still works. So if you have a problem with his version - use mine!

Delia and Steve,

Thank you so much for updating this. You are absolute life savers!!!!!!! (p.s. I'm glad the COWOA is in there - you saved me from the extra work)

:clap:

I have seen others have had this problem but I can't seem to find a solution. The mod seems to be working fine. When logged in as a wholesale account the prices are changed. The problem is that when I continue to the shopping cart the price reverts back to the Retail Price. HELP!!!!
Thanks
E

(SEE PREVIOUS POST)

I would like to let anyone who is having this problem it only happened on my testing server. I decided since it wasn't detrimental to the site to try this live before trying more trouble shooting, I uploaded to my live store and sure enough it's working with no problems.

madfastride:

(SEE PREVIOUS POST)

I would like to let anyone who is having this problem it only happened on my testing server. I decided since it wasn't detrimental to the site to try this live before trying more trouble shooting, I uploaded to my live store and sure enough it's working with no problems.

Having fixed the error Attribute error 1136 I am also getting the retail price being displayed in the cart rather than the w/s price. I have been through the thread and although some peeps have had a similar problem no "fixes" have been posted. Does anyone know whether it has been fixed? and if so what was it?
Thanks

Madfastride....
Do you know what difference there is between your testing server and the live server? This may throw some light on to why it is happening to some of us. Thanks for your help.

madfastride:

(SEE PREVIOUS POST)

I would like to let anyone who is having this problem it only happened on my testing server. I decided since it wasn't detrimental to the site to try this live before trying more trouble shooting, I uploaded to my live store and sure enough it's working with no problems.

getting this error when adding a new attribute:

1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required) values (0, '599', '6', '952', '0', '0', '', '0', '0', '0', '', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
any ideas how it is fixed?

To fix the 1136 error when adding attributes, try this:

in admin/attributes_controller.php, add options_values_price_w to the list, as shown below:

$db->Execute("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_attributes_id, products_id, options_id, options_values_id, options_values_price, options_values_price_w, price_prefix, products_options_sort_order, product_attribute_is_free, products_attributes_weight, products_attributes_weight_prefix, attributes_display_only, attributes_default, attributes_discounted, attributes_image, attributes_price_base_included, attributes_price_onetime, attributes_price_factor, attributes_price_factor_offset, attributes_price_factor_onetime, attributes_price_factor_onetime_offset, attributes_qty_prices, attributes_qty_prices_onetime, attributes_price_words, attributes_price_words_free, attributes_price_letters, attributes_price_letters_free, attributes_required)

You should backup this file because it will be overwritten during an upgrade. This information should probably be added to the download as well.

Wow craftzombie you are a star! That fixed it for me and I am very thankful to you.

Cheers

Heathenmagic:smile:

Hi,
Can somebody please help me.
When i click on the Customers Page in admin is get this error.

Customers Search:

ID# Last Name
Asc Desc First Name
Asc Desc Company
Asc Desc Account Created
Asc Desc Last Login
Asc Desc Pricing Group
Asc Desc TABLE_HEADING_GV_AMOUNT
Asc Desc Authorized
Asc Desc Action TABLE_HEADING_COWOA
Asc Desc Action
1054 Unknown column 'c.COWOA_account' in 'field list'
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, a.entry_country_id, a.entry_company, ci.customers_info_date_of_last_logon, ci.customers_info_date_account_created , c.customers_telephone, a.entry_company, a.entry_street_address, a.entry_city, a.entry_postcode, c.customers_authorization, c.customers_referral, c.COWOA_account from customers c left join customers_info ci on c.customers_id= ci.customers_info_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by ci.customers_info_date_account_created DESC limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

This happened after i installed this addon.

did you process your sql patch from the dual pricing folder?

jaskarn:

Hi,
Can somebody please help me.
When i click on the Customers Page in admin is get this error.

Customers Search:

ID# Last Name
Asc Desc First Name
Asc Desc Company
Asc Desc Account Created
Asc Desc Last Login
Asc Desc Pricing Group
Asc Desc TABLE_HEADING_GV_AMOUNT
Asc Desc Authorized
Asc Desc Action TABLE_HEADING_COWOA
Asc Desc Action
1054 Unknown column 'c.COWOA_account' in 'field list'
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_pricing, a.entry_country_id, a.entry_company, ci.customers_info_date_of_last_logon, ci.customers_info_date_account_created , c.customers_telephone, a.entry_company, a.entry_street_address, a.entry_city, a.entry_postcode, c.customers_authorization, c.customers_referral, c.COWOA_account from customers c left join customers_info ci on c.customers_id= ci.customers_info_id left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by ci.customers_info_date_account_created DESC limit 0, 20]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

This happened after i installed this addon.

Someone who updated this mod also uses the Checkout Without Account (COWOA) mod and left the code in there, probably thinking it wouldn't hurt the functionality of the Dual Pricing mod (???). I probably would've left it in there too. I went through the customers.php file and hopefully removed all of the cowoa code. You can download that version of the file here:

customers.zip

Install it into your admin folder and then click on your customers and see what happens. Let me know....

Hi everyone,
thank you for your efforts and help.

1. I did proccess the patch by going to Zencart Admin and pasting the complete file provided.
2. I tried the file without the COWOA supplied but now it gives me this error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1137

Looks like we are hopefully getting closer. Please advise :yes:

jaskarn:

Hi everyone,
thank you for your efforts and help.

1. I did proccess the patch by going to Zencart Admin and pasting the complete file provided.
2. I tried the file without the COWOA supplied but now it gives me this error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1137

Looks like we are hopefully getting closer. Please advise :yes:

Sorry about that. I couldn't test it properly at the time because my test site was 1.3.7. I just upgraded it and tested the file and of course, I made a mistake. I fixed it and tested it and it seems to be working now. Download the customer zip file again and upload it to your admin folder. Let me know what happens.

Hi craftzombie,
I downloaded the file from the link in your last post and tried it but still i get the same error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1146

When i deleted line 1146, it worked but the formatting was all wrong, i guess there is something wrong with bringing up the address book.

Please HELP!

Thanks.
Jaskarn

jaskarn:

Hi craftzombie,
I downloaded the file from the link in your last post and tried it but still i get the same error:

Fatal error: Call to undefined function: zen_get_customers_address_book() in /home/pjdhatt/public_html/dgtech/admin/customers.php on line 1146

When i deleted line 1146, it worked but the formatting was all wrong, i guess there is something wrong with bringing up the address book.

Please HELP!

Thanks.
Jaskarn

I have a test cart installed with no other mods on it but Dual Pricing and I am not getting any errors with this new customers.php file. What mods do you have installed?

Hi again,
i have easy populate installed, sales_report_rev104, and aquick_price_search. From what i think the zen_address get thing function could have been renamed, could this be another file inlcuded in dual pricing mod download that would have changed it.

jaskarn:

Hi again,
i have easy populate installed, sales_report_rev104, and aquick_price_search. From what i think the zen_address get thing function could have been renamed, could this be another file inlcuded in dual pricing mod download that would have changed it.

Just to clarify, the newest version of Dual Pricing is for 1.3.8. I noticed the download for the 1.3.7 version does not contain an easypopulate.php file, but the 1.3.6 and 1.3.8 versions do. I'm not sure what happened there. I do not use Easy Populate. If anyone is running into problems and you use Easy Populate with this mod, make sure your versions match.