DUAL Pricing version 2 for 1.3.0.2 Donations

[ahwoogamac]

So, after all this back and forth, is there a definitive 1 or 2 sentence explanation for how to make the newest DUAL Pricing work for 1.3.5? With the newsletter bug in 1.3.0.2, I need to upgrade, but I really need for DUAL Pricing to work too.

[mommydesigns]

So, after all this back and forth, is there a definitive 1 or 2 sentence explanation for how to make the newest DUAL Pricing work for 1.3.5? With the newsletter bug in 1.3.0.2, I need to upgrade, but I really need for DUAL Pricing to work too.

I have it installed and working on a 1.3.5 install but when I edit a product, I have to renter my wholesale pricing.

Any thoughts on why this might be happening?

[Danielle]

OK, found a bug When trying to copy attributes from one product to another, the following error comes up after you've chosen the product you're copying to and hit the copy to button:



I'm guessing it's because there was an extra field added into the attributes table, but I don't have a clue what will fix it! Any thoughts? The site I'm working on has products with lots of attributes, so the copy feature would be SO helpful

Thanks!

Anybody have any clue how I could possibly fix this? Other then this, it appears to be working great with 1.3.0.2.

[Danielle]

Got it!!! Thanks to Marg from an archived thread

If you're getting this error when trying to copy attributes:

1136 Column count doesn't match value count at row 1
in:
[insert into products_attributes values (0, '15', '1', '5', '0.0000', '+', '0', '1', '0', '+', '0', '0', '1', '', '1', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '', '', '0.0000', '0', '0.0000', '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.

Here is the solution:

In admin/includes/functions/general.php, find the following line:
'" . $products_copy_from->fields['options_values_price'] . "',

Right under it, add this line:
'" . $products_copy_from->fields['options_values_price_w'] . "',

Now in the same file, just a little further down, find this line:
options_values_price='" . $products_copy_from->fields['options_values_price'] . "',

Add this line right underneath:
options_values_price_w='" . $products_copy_from->fields['options_values_price_w'] . "',

It works beautifully now

[Islandnewbie]

Oops, posted twice, sorry

[Islandnewbie]

I am a newbie when it comes to programming, but I have found Zencart and their support group to be the best, I have learnt alot and thank the group.

Here is my current problem:

I was having problems with this module, so I freshly installed to my site 1.3.5 and slowly rebuilt everything to make sure I was current. That went OK.

I also installed the FCKeditor.

However, once I installed this beta version for dual-pricing, my FCKeditor stopped working. It was there in the pull-down option, but when you would go to edit a product, nothing below "Product Qty Min/Unit Mix:" showed.

Using Winmerge, trial and error on my part, I was able to get everything running.

However, I have the same problem as Mommydesigns.

Before editing a product it shows the retail/wholesale price. Example 6.95/3.45. Yet when I go in the edit that product, the retail shows 6.95 (and keeps the cents on update) , but the wholesale field only shows 3, and if I do not change it to 3.45, when I update the file, it would only show a wholesale price of 3.

Any thought would be appreciated.

PS - Thanks to Danielle, your post really helped out.....

Thanks in advance,

Islandnewbie

[Islandnewbie]

Hi All

Though I am a newbie at this, I have been playing around on a test site to get this module working.

I found in the file admin/includes/modules/products/collect_info.php file a line that was causing the "wholesale" amount to round off. Once I changed the following, everything seems to be working.

Approximately line 343

Find:

<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_price_w', (int)$pInfo->products_price_w); ?><?php echo TEXT_WHOLESALE_PRICE_COMMENT; ?></td>

Replace with:

<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_price_w', $pInfo->products_price_w); ?><?php echo TEXT_WHOLESALE_PRICE_COMMENT; ?></td>

I am still trying this out to make sure I have not caused any problems, but it seems to be working fine.

I hope this helps,


Islandnewbie

[mommydesigns]

That's great! Thank you!!

Now to get this working with Easy Populate and I'll be home free.

[anjordan77]

those of you trying to remove the SQL patch if you screwed up like me and had major issues:

ALTER TABLE `customers` DROP `customers_whole`
ALTER TABLE `products` DROP `products_price_w`
ALTER TABLE `products_attributes` DROP `options_values_price_w`

or you can just delete those lines that were added from your file.

[flightoffancy]

Is there a version of Dual Pricing that works with Zen 1.3.0.1?