DUAL Pricing v2

I.dannati:

WB Twitch......

BTW... if your ever in or near Port Hope let me know.... I feel like I owe you a beer for all the work you've put in... Thanks a ton for it all

Divorce... need I say anymore?

Twitch is back!

Here is some eye candy in case you wanted a simple filter that works pretty much anywhere...

// bof Twitch Wholesale Filter 1 of 2 May 14th 2012

        if($_SESSION['customers_wholesale'] =='' or $_SESSION['customers_wholesale'] !='1'){

// eof Twitch Wholesale Filter 1 of 2 May 14th 2012

// bof Twitch Wholesale Filter 2 of 2 May 14th 2012    

} else {

// do nothing - show no text/personalize data

} // eof Twitch Wholesale Filter 2 of 2 May 14th 2012

So this is how simple you can filter between guest, retail or wholesale.

Thanks I.d... appreciation goes a long way with me.

Twitch.

I.dannati:

This was figured out pages ago.... check out post 903 . . .

Thanks for your reply although I have done this already and it still wont work. I have no problems when I add a price for just 1 attribute but when there is multiple prices / products.

twitchtoo:

Yes this is a bug I have fixed, not sure if I've posted it in this thread yet. I am in the process of completing the wholesale module with complete instructions for 1.3.9h. I know it's been a while but I have also corrected the most common sub total error, new signup log in sub total error, installed grid pricing to work with wholesale and retail as well as a host of wholesale filters to essentially run wholesale 'underground' throughout the whole site... while multi site runs. Meaning you could technically create a 'wholesale' template and have access to the entire database, with a completely different look and function.

The bad news - I have invested many many hours into 1.3.9h with all of these features and it looks like most of them will have to be re-written for 1.50.

Twitch.

SOOO at the moment for this particular prob I have there is no fix???

I thought I was going nuts :-) And more then happy to swing you a $20.

Would LOVE if you could let me know the fix as I cant find it??? Everything else works fine - its just this one issue :-)

aliali81:

SOOO at the moment for this particular prob I have there is no fix???

I thought I was going nuts :-) And more then happy to swing you a $20.

Would LOVE if you could let me know the fix as I cant find it??? Everything else works fine - its just this one issue :-)

Are you getting the correct price for the first item then $0.00 for others? My problem was I have 12 products that are different but have the same attributes.. Like candles... Different scents but my attributes are the same (Size)

What I ran into was the [Copy To] problem in attribute controller... After I setup the first one I copied to all the other candles... That doesn't work.. even if in attribute controller it looks like it did... it doesn't

For me I had to manually edit each attribute for each product for it to work... try that with 2 particular products then test.. hopefully it works for you too...

twitchtoo:

Divorce... need I say anymore?

Lol no you don't...

I hope your lawyer was better than mine :P

I.dannati:

Are you getting the correct price for the first item then $0.00 for others? My problem was I have 12 products that are different but have the same attributes.. Like candles... Different scents but my attributes are the same (Size)

What I ran into was the [Copy To] problem in attribute controller... After I setup the first one I copied to all the other candles... That doesn't work.. even if in attribute controller it looks like it did... it doesn't

For me I had to manually edit each attribute for each product for it to work... try that with 2 particular products then test.. hopefully it works for you too...

Hi l.dannati - No correct pricing - it shows on screen but add to cart and its back to retail price. The attributes work great in this example:

1 x large candle with 25 fragrances in a drop down and the price is the same.

Does not work when I have a fragrance and 6 different products in a drop down with all different pricing.

Have tried doing them separately and doing all together and has not changed.

aliali81:

Hi l.dannati - No correct pricing - it shows on screen but add to cart and its back to retail price. The attributes work great in this example:

1 x large candle with 25 fragrances in a drop down and the price is the same.

Does not work when I have a fragrance and 6 different products in a drop down with all different pricing.

Have tried doing them separately and doing all together and has not changed.

Hmm... thats odd

I've encountered several glitches with this mod when I switch my test user back and forth from wholesale and non wholesale client.... But all in all it sounds like this is a issue with /includes/classes/shopping_cart.php ...

I think it would be easiest if i just zip up all the files as I have them, being that its working flawlessly on my site and post them here for you to try..

Of course you would have to delete all the current sql fields related to this and start over but it might solve your problem in the long run..

To see it working on my site go to http://www.thewickedwik.com

user: [email protected]
pass: wholesale

Let me know if you want to try the mod as I have it

OK click the following link for a zip of all the files as I have them working... I combined this and hidden wholesale together and changed the readme.txt just a lil

Let me know if this helps

Dual_pricing_1.8.zip

Btw none of this would even be possible if not for all the awesome people here who make zen and its mods work... Cheers

Nice.. Is this for Zen v1.5 or 1.3.9??

I.dannati:

OK click the following link for a zip of all the files as I have them working... I combined this and hidden wholesale together and changed the readme.txt just a lil

Let me know if this helps

Dual_pricing_1.8.zip

Btw none of this would even be possible if not for all the awesome people here who make zen and its mods work... Cheers

DivaVocals:

Nice.. Is this for Zen v1.5 or 1.3.9??

Oh lol sorry... I'm running 1.3.9h

[QUOTE=I.dannati;1126459]OK click the following link for a zip of all the files as I have them working... I combined this and hidden wholesale together and changed the readme.txt just a lil

Let me know if this helps

Dual_pricing_1.8.zip

IT WORKED! I only copied over the shopping cart .php file and now the wholesale price appears in both the website and in the cart! Wooohoo

ONLY PROB is when I create a new wholesale account - it does not show wholesale price on the screen BUT add it to the cart and then it does! So it has swapped around....lol

Any idea?

[QUOTE=aliali81;1126606]> I.dannati:

OK click the following link for a zip of all the files as I have them working... I combined this and hidden wholesale together and changed the readme.txt just a lil

Let me know if this helps

Dual_pricing_1.8.zip

IT WORKED! I only copied over the shopping cart .php file and now the wholesale price appears in both the website and in the cart! Wooohoo

ONLY PROB is when I create a new wholesale account - it does not show wholesale price on the screen BUT add it to the cart and then it does! So it has swapped around....lol

Any idea?

Lol oh boy... umm not really, , there are so many files or code snippets that effect how the wholesale prices are displayed.. It could be a missed customer_whole to customers_wholesale in one of your files found on post 687

But I made so many changes based off of the contributions on this form but really never tracked them as I didn't plan on sharing it. So I can't be entirely sure which one is effecting your product attribute display.

I would suggest copying over the rest of the files and trying that.. then uninstalling the sql statements you previously installed with this:

ALTER TABLE `customers` DROP `customers_whole` ;
ALTER TABLE `products` DROP `products_price_w`;
ALTER TABLE `products_attributes` DROP `options_values_price_w` ;
ALTER TABLE `products_discount_quantity` DROP `discount_price_w` ;
ALTER TABLE `customers` DROP `customers_wholesale` ;

Just place that sql statement in the text box found in tools>instal sql patches and submit

then reinstall with the sql code found in the zip file...

Remember tho doing that will zero out any wholesale pricing you have done..

Then try and remove the attributes you have already created and starting new ones...

It sucks but I've had to do it about 10 times now with all the code changes for this to work

And oh yeah!!! BACK UP EVERYTHING!!!! you can never have too many backups of your files and databases

Cheers!

To anyone who has an issue with hidden wholesale in the zip file I uploaded..

Goto

/includes/init_includes/overrides/init_customer_auth.php and change line 162 from

$custom_restriction= ' AND (p.products_price > 0 OR p.products_type = 4) ';

to

$custom_restriction= ' AND (p.products_price > 0 OR p.products_type = WHATEVER CATEGORY YOU WANT TO HIDE) ';

or

 $custom_restriction= ' AND p.products_price > 0 '; 

what that lil code does is allows you to not only restrict products with an original value of 0 but as well as restrict certain categories altogether...
As you see I have mine to restrict all products with products_type = 4 which is Documents Product

I hope this help some fellow zenners

Cheers!

Also - - If your using this the same way I am you'll notice that Dual Pricing doesn't work so well with products that aren't standard.. Meaning in Documents product there is no wholesale field.. So the best way to work around this is to set your product up as a regular product.. Then change the Product to Documents product by logging into PHP myadmin..

Scroll down to products and edit your product by changing its products_type to 4 Note you may have to re enter the wholesale value in php myadmin after you do that...

I know it sucks but I haven't had the time to fix the products type issue in dual pricing yet...

Cheers!

I'm running ZC 1.3.9h.

I loaded the Dual Pricing mod and everything seemed to go well except on the retail portion of the site, the attributes are moved below the product description section whereas normally they attributes are above the description section. Where can I fix this or is there something else I was suppose to do?

Also, where do I list the 4 wholesale prices for attributes? Everywhere I try to put them seems to not work.

Thanks for the mod. It will be a most excellent tool once I get it going.

voltar:

I'm running ZC 1.3.9h.

I loaded the Dual Pricing mod and everything seemed to go well except on the retail portion of the site, the attributes are moved below the product description section whereas normally they attributes are above the description section. Where can I fix this or is there something else I was suppose to do?

Also, where do I list the 4 wholesale prices for attributes? Everywhere I try to put them seems to not work.

Thanks for the mod. It will be a most excellent tool once I get it going.

Did you install the stock mod or one of the ones that a contributer has linked? If you went way of the stock you got a lot of work ahead of you..

The best place to start is reading post #912 by DivaVocals . . That post points you in the right direction for most of the fixes that need to be applied

Good Luck

I.dannati:

Did you install the stock mod or one of the ones that a contributer has linked? If you went way of the stock you got a lot of work ahead of you..

The best place to start is reading post #912 by DivaVocals . . That post points you in the right direction for most of the fixes that need to be applied

Good Luck

Thanks. I did load the stock version and have since found some of the fixes but this one has eluded me. I'll start digging at #912 and keep my fingers crossed. It's all about the journey! Thanks.

Running ZC 1.3.9h

I've loaded all of the fixes that seem to be available. So far so good. The only thing that I can seem to figure out is why the product descriptions get moved to the top of the attribute boxes. Or maybe the attribute boxes are moving below the product descriptions. Before I start hacking away, I was wondering if anyone else has seen this anomaly or is this unique to me?

voltar:

Running ZC 1.3.9h

I've loaded all of the fixes that seem to be available. So far so good. The only thing that I can seem to figure out is why the product descriptions get moved to the top of the attribute boxes. Or maybe the attribute boxes are moving below the product descriptions. Before I start hacking away, I was wondering if anyone else has seen this anomaly or is this unique to me?

Well for me its always been displayed below the product description... Never above..

Do me a favor... Check your shopping cart with multiple items that all are priced via attributes... At first I thought my cart was great but when I tested that it didn't work...

I have it working right now just making sure you didn't miss that fix..