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

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.

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!

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

Anybody have a link for where to download this?

-lindasdd

lindasdd:

Anybody have a link for where to download this?

-lindasdd

Dual Pricing mod

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

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

www.pushingbuttonsaz.com/dual_pricing_PB.zip

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

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> 
              <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; ?> </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.

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

I have a problem were products with attributes are going into the shopping cart with the base price not attached. I have set my attributes to add to the base price. This is happening to both resale and wholesale pricing.

Any ideas on why this maybe happening. I need to get this resolved fairly quickly.

The url is http://www.safewireless.com/hands-free-store/

I should also note that the sub-total price shows up correctly, but not per-item totals. When continuing through the check out process the per-item price (which is wrong) is being calculated for the total to be billed.

Hi,

Great contribution, working nicely on 1.3.5! Spent the day playing around with it. I recommend the combined use of the contribution : quick_updates_2.04
So you can quickly add all of your wholesale prices. The Quick Updates mod has a feature that works with DP built into it (has to be activated manualy in the following file :
admin/includes/extra_configures/quick_updates.php
)

Quick question, is there a way I can define products that can only be seen by wholesalers (by ticking a nice little box maybe in product edit page!) ?

I've read through nearly every post about DP here (took a few hours), but I may have missed something about this, it does get to your head reading through so many pages of DP ;-)

Thanks everyone for all of your DP posts...

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

I'm finding myself with the same trouble right now, I believe there is a line we can add to functions_prices.php to basically drop out of the sale function if the customer is wholesale but I haven't been able to do it yet.

Post back if you figured it out already, or I'll post a fix sometime later today hopefully.

did anyone, yet, came up with a possibility to dis-allow the discounts for wholesale customers? really seems an issue and a should be adresses soon in this mod. i would LOVE it.

Was hoping someone could help me. I would like to "unpatch" my database or undo the changes from this mod. I was unable to really make it work do to sdales being taken off pricing. When I bumped up to 1.3.8 I did not reinstall this mod as I did not plan to use it but now I am having probs with my attributes and creating new ones I get this

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

From a little reading I found that this is likely caused by his mod or the remanents of it so to speak. I tried editing the general.php adding the -

'" . $products_copy_from->fields['options_values_price_w'] . "',
options_values_price_w='" . $products_copy_from->fields['options_values_price_w'] . "',

thinking it might be a work around but no go. I also tried uploading all the files from the Dual Pricing from 1.3.8 and the error only got "worse".

Am hoping if I undo what was done to the DB it would be wiped?

thanks for any help!!!

I fixed my above question. I just dropped the 3 tables in the DB that the mod adds..... all works well now it seems

stevefriedman71:

did anyone, yet, came up with a possibility to dis-allow the discounts for wholesale customers? really seems an issue and a should be adresses soon in this mod. i would LOVE it.

Steve,

I paid "That Software Guy", Scott Wilson, to write this for one of my sites. It might be worth contacting him. PM me if you need his contact information.

Janelle

**MAKE SURE NOT TO MAKE THIS MISTAKE
**I don't know if anyone else has had problems with this but on my cart I noticed that when you add the number to a product to determine it's price level (example you put a zero if there is no whole sale etc) MAKE SURE THERE IS A NUMBER IN THAT FIELD... If it is left blank it seems that the product can go for FREE... :(

I sell a product on my site with two different costs.. the wholesale price and the retail price.
Can someone lead me in the right direction or link that shows how I can have an area for each?
I have seen it on other sites (don't know if zen) and I would like to do it as well but not a clue as to how to do it.
Any help appreciated.
Sandy