DUAL Pricing v2

[aliali81]

[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?

[I.dannati]

[QUOTE=aliali81;1126606]

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!

[I.dannati]

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!

[I.dannati]

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!

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

[I.dannati]

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

[voltar]

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.

[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?

[I.dannati]

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

[voltar]

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

Here is what's happening. I add a wholesale price to a product along with 2 attributes with 4 values entered in the Trade field. On the retail side of the site, the correct wholesale price displays along with the attributes. I select an attribute and add to the cart.

In the cart, the correct wholesale price is displayed based on the wholesale level of the customer. however, the correct attribute price does not add. Only the 1st level of the wholesale attribute string is added. And here's another odd thing, the cost of the attribute is not displayed but the total shows the added attribute.

What have I missed? Thanks.