DUAL Pricing v2

[agamic]

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

Anyone have any ideas for this problem?
Thanks

[madfastride]

I don't have any specific solution to the problems people are having but I had many of them too when I downloaded the module and copy and pasted the files into my cart (using the newest version of the module and 1.3.8) Next I tried a different rout and used WinMerge instead. And compared files and made sure things were right. If anybody is partial to this I could upload my files and have people try those instead as they contain the Cowoa (sorry this is from memory can't remember if that's actually the name) fix and a fix for displaying "whole sale price" when the customer is actually seeing retail price.

[gossamerLL]

For a clean installing dual pricing, use the one by Delia. It does not give errors on a fresh, no module installation.

In my opinion, this is how a module should be.

I think the one by Steve should be removed or have a note by it. It has extra code from the checkout without account. If you are not running this module, you will crash your customers table.

REMEMBER, always do a backup before installing any module. In this case, my backup saved me a lot of time!

[agamic]

I don't have any specific solution to the problems people are having but I had many of them too when I downloaded the module and copy and pasted the files into my cart (using the newest version of the module and 1.3.8) Next I tried a different rout and used WinMerge instead. And compared files and made sure things were right. If anybody is partial to this I could upload my files and have people try those instead as they contain the Cowoa (sorry this is from memory can't remember if that's actually the name) fix and a fix for displaying "whole sale price" when the customer is actually seeing retail price.

Hi madfastride.
I have PM you but I would also like a peek at your files to compare mine as I am still getting the retail price showing through checkout rather than the wholesale price on products that are priced by attribute. I have done a compare on the release files and my uploaded files and they are the same. So I am now at a loss.
Thanks

[lindasdd]

Anybody have a link for where to download this?

-lindasdd

[craftzombie]

Anybody have a link for where to download this?

-lindasdd

Dual Pricing mod

[madfastride]

I have had some PMs so here we go...

I have cleaned up the files and made a few modifications. Specifically the original displayed "Whole Sale" when it should have displayed "Retail" and several other issues. The following link is to my files. Please download and try these instead. I'd like to post them as a new version of this modification but would like more testing. Specifically with the attributes activated on whole sale items. If I get enough positive feed back I will post this as a new version. PLEASE DO NOT CONTACT ME WITH PROBLEMS IF YOU ARE NOT USING 1.3.8 UNLESS YOU WANT TO PAY ME TO UPGRADE YOU FIRST... Break this rule and you will be immediately blocked from my email account.

www.pushingbuttonsaz.com/dual_pricing_PB.zip

Thanks,
Emiliano Jordan
emilianosemail "at" gmail "dot" com

[craftzombie]

Oops, your link was a little funky... here's the correct one:

www.pushingbuttonsaz.com/dual_pricing_PB.zip

[stevefriedman71]

My bad... sorry to all...

All you guys that have downloaded my mod seem to have had issues with the Cowoa-mod pieces in there. please accept my appology. it was the first mod-update i puit back to the download section. I do have Cowoa installed on my side so i didn't got any error and didn't think of taking it out when i updated it...

But, the good news... Cowoa is a pretty good and ovious mod and pretty easy to spot.

Please delete the folowing sections in YOUR_ADMIN/customers.php

line 348

// COWOA additional field included in this select statement

line 356

c.COWOA_account,

line 517 to line 536

<?php
// COWOA add new frameset here to display account status when looking at a customer detail record
?>
<tr>
<td class="formAreaTitle"><?php echo COWOA_SECTION_HEADING; ?></td>
</tr>
<tr>
<td class="formArea"><table border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="main"><?php if ($cInfo->COWOA_account) echo COWOA_STATUS_TRUE; else echo COWOA_STATUS_FALSE; ?></td>
</tr>
</table>
</td>
</tr>
<tr>
<td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
</tr>
<?php
// END OF COWOA new frameset
?>

line 1012 to line 1019

// COWOA+
case "COWOA-asc":
$disp_order = "c.COWOA_account";
break;
case "COWOA-desc":
$disp_order = "c.COWOA_account DESC";
break;
// COWOA+

line 1077 to line 1085

<!-- COWOA+ additional column heading in list of customers -->
<td class="dataTableHeadingContent" align="center">
<?php echo (($_GET['list_order']=='COWOA-asc' or $_GET['list_order']=='COWOA-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_COWOA . '</span>' : TABLE_HEADING_COWOA); ?><br>
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=COWOA-asc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='COWOA-asc' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</b>'); ?></a>&nbsp;
<a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=COWOA-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='COWOA-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</b>'); ?></a>
</td>
<!-- COWOA+ -->

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?>&nbsp;</td>

line 1102 to line 1105

// COWOA+ additional field added
$new_fields=', 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';
// COWOA+ additional field added
$customers_query_raw = "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 " . $new_fields . " from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_INFO . " ci on c.customers_id= ci.customers_info_id left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by $disp_order";

line 1189 to line 1192

<td class="dataTableContent" align="center"><?php echo ($customers->fields['customers_authorization'] == 0 ? '<a href="' . zen_href_link(FILENAME_CUSTOMERS, 'action=status&current=' . $customers->fields['customers_authorization'] . '&cID=' . $customers->fields['customers_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_CUSTOMERS, 'action=status&current=' . $customers->fields['customers_authorization'] . '&cID=' . $customers->fields['customers_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
<!-- COWOA+ additional field in table -->
<td class="dataTableContent" align="center"><?php if ($customers->fields['COWOA_account']) echo 'X'; ?></td>
<!-- COWOA+ -->

This SHOULD take care of the problems if you don't have cowoa installed.

Again, PLEASE accept my apologies.

[janellez]

I hope this question hasn't been asked to death - but I can't find it if it has.

I've installed this mod and it works fine. However, when we put something on sale through SaleMaker or Specials, we don't want it to apply the discount to wholesale customers.

I thought I had this solved in that I created a Discount Group called "Wholesale" with a 0% discount but it isn't working. I also used this method to exclude wholesale customers from getting charged sales tax, but again, this isn't working.

It it my install (I didn't do it - it came with the site)? Is there some other way to exclude wholesale customers from getting sale prices?

Thanks,

Janelle