DUAL Pricing v2

[hayden]

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.

www.hthring.com

[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/dua...als_mod-02.zip

[Elle Fresco]

** #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/dua...als_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.

[hayden]

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

[Elle Fresco]

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?

[Elle Fresco]

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.

[Elle Fresco]

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?

[hayden]

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

[hayden]

it would require further work to support this

[hayden]

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