DUAL Pricing v2

[stevefriedman71]

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...

[sassayone]

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!

[delia]

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!

[craftzombie]

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)

[madfastride]

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

[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.

[agamic]

(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

[agamic]

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.

(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.

[stevefriedman71]

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?

[craftzombie]

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.