DUAL Pricing v2

btw on the topic of specials, heres an importan easy fix to make the selection box for picking your product to be on special:

line: 316
/admin/specials.php

the only change in the below is on line 316; > size="30" (instead of 5 !! :wacko:

      <tr><form name="new_special" <?php echo 'action="' . zen_href_link(FILENAME_SPECIALS, zen_get_all_get_params(array('action', 'info', 'sID')) . 'action=' . $form_action . '&go_back=' . $_GET['go_back'], 'NONSSL') . '"'; ?> method="post"><?php if ($form_action == 'update') echo zen_draw_hidden_field('specials_id', $_GET['sID']); ?>

        <td><br><table border="0" cellspacing="0" cellpadding="2">

          <tr>

            <td class="main"><?php echo TEXT_SPECIALS_PRODUCT; ?> </td>

            <td class="main"><?php echo (isset($sInfo->products_name)) ? $sInfo->products_name . ' <small>(' . $currencies->format($sInfo->products_price) . ')</small>' : zen_draw_products_pull_down('products_id', 'size="30" style="font-size:10px"', $specials_array, true, $_GET['add_products_id'], true); echo zen_draw_hidden_field('products_price', (isset($sInfo->products_price) ? $sInfo->products_price : '')); ?></td>

          </tr>

          <tr>

http://hthring.com/downloads/dual_pricing-specials.zip

now you can have a seperate special rate for each products price braket

changes allow for seperate special for wholesale and retail prices ala dual pricing mod.

firstly, not all files may be here ... let me know if it doesnt work for u...

this will probably not work if you are using attribute pricing or sales pricing (the wholesale specials that is), and also probably doesnt work with multi wholesale pricing bracxets

secondly you need to jump into phpmyadmin and add a new field to the specials table called;

wholesale_special_products_price

with type decimal(15,4)

disclaimer: dont do this on your good cart, create backups of the files or use a test installation

this is work in progress, "testing"

once youve migrated my changes by comparing with diff, or using ftp it should be happening.

make a special the same as its corresponding standard price and it hides it for that pricing group.

https://www.hthring.com :smile:

** #02 Update, thanks to E.F. on the boards for trying this out and getting back to me... there was a missing file.

also use this sql patch/code instead of phpmyadmin if you prefer:

ALTER TABLE specials ADD wholesale_special_products_price DECIMAL( 15, 4 ) DEFAULT '0' NOT NULL;

ive tested it on a fresh ZC install, so you should have better luck this time ,sorry:

http://www.hthring.com/downloads/dual_pricing-specials_mod-02.zip

hayden:

** #02 Update, thanks to E.F. on the boards for trying this out and getting back to me... there was a missing file.

also use this sql patch/code instead of phpmyadmin if you prefer:

---

ALTER TABLE specials ADD wholesale_special_products_price DECIMAL( 15, 4 ) DEFAULT '0' NOT NULL;

---

ive tested it on a fresh ZC install, so you should have better luck this time ,sorry:

http://www.hthring.com/downloads/dual_pricing-specials_mod-02.zip

Thanks for the cudo's ... it is good as it stands .. however there needs to be a connect from the category/products page in admin to it as well, for those that wish to do the special pricing right after adding the product by using the green $ on the product listing. As it stands at the moment you get the original ... install button or edit button, but when you bring up the information there you can not edit wholesale special pricing. I am a great tester, and implementer, a lousey programer, so I couldn't even start to figure out what files need to be altered.

One word of warning!!! Do this only on a fresh install, because otherwise you will have to go fix all your wholesale pricing, because it sets everything to $0.00 and therefore everything becomes free. I learned that the hard way with over 1500 products already loaded.

Elle Fresco:

Thanks for the cudo's ... it is good as it stands .. however there needs to be a connect from the category/products page in admin to it as well, for those that wish to do the special pricing right after adding the product by using the green $ on the product listing. As it stands at the moment you get the original ... install button or edit button, but when you bring up the information there you can not edit wholesale special pricing. I am a great tester, and implementer, a lousey programer, so I couldn't even start to figure out what files need to be altered.

One word of warning!!! Do this only on a fresh install, because otherwise you will have to go fix all your wholesale pricing, because it sets everything to $0.00 and therefore everything becomes free. I learned that the hard way with over 1500 products already loaded.

i will look into that connect this afternoon, did you have that wholesale info backed up ?? i cant understand how it set everything to free, my code shouldn't touch the wholesale price itself...

hayden:

i will look into that connect this afternoon, did you have that wholesale info backed up ?? i cant understand how it set everything to free, my code shouldn't touch the wholesale price itself...

Oops ... spoke too soon it is not calculating right at all ... not sure where it's messing up as it makes no sense.

Just the dual pricing reads right the retail is right and the wholesale is calculating right if there is no discount on the wholesale price. However if you discount the wholesale as I did .. because one of my suppliers bumped me to the highest wholesale level, after 1000's in sales. So instead of changing all the pricing I just did an overall 7% discount. Now I have a messed up retail amount that shoud be 60% ... now showing 77% and a wholesale discount of 7 %. What it did was bring the retail down to the wholesale starting price.

Also there is a problem with the dual pricing mod itself as it will only display the retail size increase, and not the wholesale .. but in the shopping cart it added $5.00 ( the right amount) and not the $7.50 that it showed on the selection screen.

So there is a problem with both the specials add on as well as the Dual pricing mod itself. Here are some screen shots so you can see what I mean:

Retail:

Then Wholesale with the retail price messed up:

Then the selection menu that should be $5.00 not $7.50 for wholesale:

Then the shopping cart with the right amount in it:

Can anyone figure out what happened and where?

hayden:

i will look into that connect this afternoon, did you have that wholesale info backed up ?? i cant understand how it set everything to free, my code shouldn't touch the wholesale price itself...

On the product being sold as free ... what happened was for products that were already in the database it added a special price of 0.00 and that looked ok until I logged in as wholesale and realized that all the products were showing a cost of $0.00 I tried to change it to 0% and that did noting so I had to go into specials and actually add the actual wholesale price in for each product.

Ok after messing around some more ... I realized that you can not do a copy attributes from categories nor attributes controller. Well you can but it only takes the retail and not the wholesale mark attributes.

Anyone else have this problem?

im sorry you missed it but the specials mod is not compatible with sale maker, (store wide discounts/specials) nor pricing by attribute

it would require further work to support this

i guess i could code it in easy enough to make it no special if the special is $0.00, let me know if it make difference and ill have a look

hayden:

im sorry you missed it but the specials mod is not compatible with sale maker, (store wide discounts/specials) nor pricing by attribute

I knew that salemaker would not work for me because it did not discriminate between retail and wholesale and it discounted my wholesale by 60% also ... which would have had me bankrupt in a day ...lol

But the only specials I had running was through the specials add-on.

The attribute problem is with dual pricing itself, that I know for sure.

I had 60% on the retail side .. and a 7% on the wholesale side, on one main category .. my other main categories were not involved. I have one category per supplier and then sub categories .. so I only needed to special that one category.

I removed the specials add on files ... and now the only issue I am having is the attribute issue, which like I said is Dual pricing's issue. I am sure that's probably a simple fix .. it must have something to do with the attribute copy function. I will allow me to put wholesale imput and keep it on a per item basis .. it just will not allow me to copy them when I copy or duplicate a product.

for instance as you seen I have a sizing increase according to size ... and on a per product basis it works perfectly fine other than displaying the retail in the wholesale area of the catalog. It does calculate properly even though it was based on retail it actually charged the lower wholesale price when on the wholesale side.

So I guess there are actually 2 issues with Dual Pricing .. and that is the copy sttribute function and the display wholesale attribute, when in wholesale area of the catalog.

firstly, are you having any problems with my mod ?

i can look at the rest later...

hayden:

firstly, are you having any problems with my mod ?

i can look at the rest later...

I actually removed your mod .. because it could not resolve the issue that it also deducted more fom the retail price on the wholesale side ... it should have only ever showed 60% off retail and a wholesale price of $XXX reduced by 7 percent. For some reason by using a special on the wholesale side it increased the 60% to 77% off retail displaying on the wholesale side of the catalog.

After reasoning it out ... I think I know how the program came up with that figure ... but not the why as it makes it look like retail and wholesale are the same price. I think what it did was calculate the actual wholesale new price ... showing that the new wholesale price was equaling to 77% off the retail price. That can get confusing though for the customer ... why should the customer buy from my wholesale side if they could get the same discount on the public retail side?

See what I am saying .. look at the second screen shot .. where the retail is now not 60% but 77% and the wholesale is 7% .. but they both have the same buy it price. That is where the confusion comes in from a customer stand point.

if you can get that retail displying the wrong amount issue fixed then I would love to add it back in .. it definately had a good functionality to it and it would make things easier.

thanks for clarifying that , it is an easy fix i hope, so am looking at it now... perhaps there will be more develpment down the track...

it is fixed ,here you go
http://www.hthring.com/downloads/dual_pricing-specials_mod-03.zip

** #03 Update, corrected retail display special price while logged in wholesale, and corrected admin special row style

hayden:

it is fixed ,here you go
http://www.hthring.com/downloads/dual_pricing-specials_mod-03.zip

** #03 Update, corrected retail display special price while logged in wholesale, and corrected admin special row style

Retail on the wholesale side now displays correctly in the catalog. The link to specials.php inside of specials now works correctly.

Issues:

1. Green $ link from within categories/products still not displaying a wholesale edit box. (for those that work on a per item basis)

2. Installing on a store with products still defaults all products to 100% off and makes all pre-loaded products free. My concern here is you can not load the specials add on if you have any product in the store already or it leaves you editing each product one at a time to correct the 0.00 default with the add on.

Getting there!!! :)

I'd like my site to have a "list price" and "our price" on every product, and then sale prices on some products like on this site: http://www.diaperbags.com/designer-brands/5354+6776.cfm

Will this add on do this?

Thanks!

You'd have to modify the code a bit if you didn't want to go and manually change all your customers over to a whole sale customer. But it would be fairly easy to do. You'd just have to take out some of the checks for WS customers and leave it turned on all the time. Look back at some of my previous comments and I described how to add checks for added functionality. That's the same bit of code you are going to be removing.

This could be the easiest way to go on this one.

Cheers,