DUAL Pricing v2

[Gary777]

Hello All,

Can someone please help me fix a goof? I installed the Dual Pricing add on but dummy me uploaded the files first before installing the SQL patches and now when I try to install an SQL patch it gives me a 403 Forbidden error...

Any ideas?

Thanks in advance!

Gary777

[Gary777]

Hello Again,

I went into my SQL admin area on my server and uploaded the patches by hand, things seem to be working great, I like the concept of this mod... I have no clue if the "Install SQL Patches" works now, is there a bit of innocuous sql I can patch in to test it?


Also, is there a possibility of making the whole sale levels discount based? I.E.

level 1 - 5%
level 2 - 10%
level 3 - 15%
level 4 - 20%

Thanks again for a great mod!

Gary777

[hayden]

Hello All,

Can someone please help me fix a goof? I installed the Dual Pricing add on but dummy me uploaded the files first before installing the SQL patches and now when I try to install an SQL patch it gives me a 403 Forbidden error...

Any ideas?

Thanks in advance!

Gary777

good to hear it worked, ive had a similiar thing happen to me b4 with austpost mod.

levels could be coded, not that id be doing that

[ryanb4614]

Just downloaded this mod, do i need the file "includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php" if i dont upload it will it cause errors? I ask of this because it messes up my add to cart box that i have customized.
Another few questions i have that I would like to see if possible?

1- Charge a wholesaler $2.00 fee on every order?
2-Charge a wholesaler $2.50 fee on every order under 10lbs
3- I offer free shipping on order over $50 but under $15.00 can i disable this for a wholesaler?
-OR-
Would it be easier just to be able to set a certain amount or certain weight that if they do not reach that they cannot checkout?...
FOR EXAMPLE:
They have an order of 15.99 and for wholesalers I have a minimum order of $20.00, and have the cart tell them they cannot checkout or just not allow them two? thanks!
**great mod!

[Gary777]

Hi Again folks,

Well my database problems are much worse than I originally imagined... When I made the good I refer to above it apparently jacked something up because now I can't log into other PHP applications and my databases are NOT allowing writes from any of my apps except Zen Cart (this is very bad!)

When I try to log into the administrative areas of two PHP apps this is the error I get...

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

I have checked the .htaccess files that I think could have been the culprit with no luck... Any ideas???

Help would be greatly appreciated!

Gary777

[madfastride]

Also, is there a possibility of making the whole sale levels discount based? I.E.

level 1 - 5%
level 2 - 10%
level 3 - 15%
level 4 - 20%

Gary currently there is not a way to do this. But there could be an easy work in the admin section to get this to work. Either automatically using pre-defined percentages or using percentages you enter in. Also there would be an easy SQL patch you could run to define this. The problem there is you'd have to run the patch every time you added a new item.

The percents might be a good thing to do for a next release. I'm working on one but it's back burner for now because I have way to much other work.

[madfastride]

Hi Again folks,

Well my database problems are much worse than I originally imagined... When I made the good I refer to above it apparently jacked something up because now I can't log into other PHP applications and my databases are NOT allowing writes from any of my apps except Zen Cart (this is very bad!)

When I try to log into the administrative areas of two PHP apps this is the error I get...

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

I have checked the .htaccess files that I think could have been the culprit with no luck... Any ideas???

Help would be greatly appreciated!

Gary, the only thing I could think of is checking and double checking your user rights for MySQL. Maybe creating new ones and swapping the programs over and seeing if that cleans things up. If not the fastest and most reliable way to get this done will be through your server admin. give them a call and see. this problem is outside of the scope of Dual Pricing and Zen-cart for that matter. Although if you search some of the other forums you might get an idea.

[madfastride]

Just downloaded this mod, do i need the file "includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php" if i dont upload it will it cause errors? I ask of this because it messes up my add to cart box that i have customized.

Ryan, The template needs to be installed in order to show the prices. But you are combining two custom files. Use something like WinMerge to get this done. Also you can look at the Dual Pricing file and see that it's clearly noted where the file is modified and what needs to carry over to your site.

Another few questions i have that I would like to see if possible?

1- Charge a wholesaler $2.00 fee on every order?
2-Charge a wholesaler $2.50 fee on every order under 10lbs
3- I offer free shipping on order over $50 but under $15.00 can i disable this for a wholesaler?
-OR-
Would it be easier just to be able to set a certain amount or certain weight that if they do not reach that they cannot checkout?...
FOR EXAMPLE:
They have an order of 15.99 and for wholesalers I have a minimum order of $20.00, and have the cart tell them they cannot checkout or just not allow them two? thanks!
**great mod!

all this is possible, you or somebody familiar with Zen-Cart code will need to add some checks and custom applications of dual pricing to your site. Disabling free shipping is probably the easiest.

[Gary777]

Thanks madfastride!

I was able to get most of my issues sorted out and 1 of the issues was unrelated (an odd consequence.) Things are back to normal for the most part...

The problem seems to have stemmed from my calling the script before I had uploaded the SQL patches (still not sure if that function in Zen Cart is working as I haven't tried to apply a patch since.) For whatever reason it put a temporary whammy on my MYSQL database/s (must have been some kind of recursive issue that finally timed out, I suspect sessions may have had something to do with it as well.)

Thanks again for your help,

Gary777

[weezee]

I changed display:

//***********************************************************************
//***DISPLAY NET RETAIL PRICE IF WHOLESALE CUSTOMER IS LOGGED ON
//***********************************************************************

echo '<span id="retailwhole">' . ' Retail Price: '.$one_time . ((zen_has_product_attributes_values((int)$_GET['products_id']) and $flag_show_product_info_starting_at == '1') ? TEXT_BASE_PRICE : '') . zen_get_products_display_retail_net_price((int)$_GET['products_id']).'</span><br /> ';

//********************************************************************

It someone go to my site and don't sign in the retail price shows twices on the product page.
What I need to do to have display retail for non customer who visit my site and just browse.
currysgiftshop.com