Zen Cart Logo

Mzmt Sql

Views: 52,476

Results 41 to 60 of 72
21 Sep 2007, 1:16 PM
#41
msdave avatar

msdave

New Zenner

Join Date:
Aug 2007
Posts:
18
Plugin Contributions:
0

Mzmt Sql

I have never had the ability to set the number of tables only zones in the admin
-> configuration page. Now I don't even have the configuration menu. I have tried deleting the files and uploading a back up but no help.

21 Sep 2007, 1:56 PM
#42
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: Mzmt Sql

msdave:

I have never had the ability to set the number of tables only zones in the admin
-> configuration page. Now I don't even have the configuration menu. I have tried deleting the files and uploading a back up but no help.

Did you run the install.sql that comes with the MOD?

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

21 Sep 2007, 7:17 PM
#43
msdave avatar

msdave

New Zenner

Join Date:
Aug 2007
Posts:
18
Plugin Contributions:
0

Re: Mzmt Sql

Everything seems to be working now (don't ask me how) but I still do not have my configuration drop down menu. I uploaded the instal.sql file again and now I the mzmt listed but nothing else.

21 Sep 2007, 10:34 PM
#44
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: Mzmt Sql

msdave:

Everything seems to be working now (don't ask me how) but I still do not have my configuration drop down menu. I uploaded the instal.sql file again and now I the mzmt listed but nothing else.

admin -> configuration -> MultiGeoZone MultiTable Shipping

should have these options

Number of Geo Zones 3
Number of Tables per Geo Zone 1

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

13 Nov 2007, 4:08 PM
#45
smap avatar

smap

New Zenner

Join Date:
May 2006
Posts:
42
Plugin Contributions:
0

Re: Mzmt Sql

Hi - great mod.

I am not using multiple zones but I am using multiple table rates (one each for UPS Ground, 2-Day, and Next Day). This mod handles that with no sweat - my only problem is that I only want Ground method available for orders >= $130.00.

So I guess I am looking for a way to disable table rates 2 & 3 for orders >= $130.00. Any help?

13 Nov 2007, 4:43 PM
#46
smap avatar

smap

New Zenner

Join Date:
May 2006
Posts:
42
Plugin Contributions:
0

Re: Mzmt Sql

Well I think I kludged this in with a line inside the quote function around line# 100 in includes\modules\shipping\mzmt.php.

After this```
} else {
for ($j=1; $j<=$this->num_tables; $j++) {
if (!zen_not_null(constant('MODULE_SHIPPING_MZMT_GEOZONE_' . $this->delivery_geozone . 'TABLE' . $j))) continue;


I added this```
          if ($j > 1 && $this->order_total > 129.99) {continue;}
19 Nov 2007, 9:46 AM
#47
laboboo avatar

laboboo

New Zenner

Join Date:
Nov 2007
Posts:
1
Plugin Contributions:
0

Re: Mzmt Sql

After I setup MZMT,the web's stylesheet does not action.
why?

19 Nov 2007, 9:53 PM
#48
netforce avatar

netforce

New Zenner

Join Date:
Mar 2007
Posts:
15
Plugin Contributions:
0

Re: Mzmt Sql

I followed the install instructions exact and I still get nothing under admin-->configuration-->MultiGeoZone MultiTable Shipping

28 Nov 2007, 1:19 AM
#49
roccanet avatar

roccanet

New Zenner

Join Date:
Nov 2007
Posts:
1
Plugin Contributions:
0

Re: Mzmt Sql

hello,

im using the MZMT shipping module to determine flat shipping rates vs. province/state. My payment method is paypal express.

Is there a way i can exclude orders or block users from ordering from certain specific (group) of zip codes or postal codes?

16 Dec 2007, 4:31 AM
#50
dude_s avatar

dude_s

New Zenner

Join Date:
May 2005
Posts:
39
Plugin Contributions:
0

Re: Mzmt Sql

Hi, I'm trying to set up the MZMT (MultiZone MultiTable) shipping module along with Google Checkout but I end up disabling Checkout and even damaging the Admin/Modules/Payment page.

I set up MZMT for only one zone but three tables for Uninsured, Insured, and Express shipping. Each of the three options calculates shipping charges by weight. This is the only shipping module I have activated in admin and works perfectly in ZC's own checkout process.

Now to Google. At first, the Checkout badge showed "Error: Shipping Methods not configured - mzmt (ignored)" So I went through the Shipping Generator at /googlecheckout/shipping_generator/shipping_method_generator.php and got the PHP code. According to the instructions, I pasted this code into /googlecheckout/shipping_methods.php replacing everything except the commented header lines. With that back on my server...

  • the Checkout badge disappears completely from my store.
  • the Admin/Modules/Payment page does not show the details and edit pane on the right anymore, only the list of moduls. Google CO is not listed anymore.
  • my error log shows:
    PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/dude_s/public_html/googlecheckout/shipping_methods.php on line 14

Line 14 simply says
'mzmt'##=>##array(
where before I pasted in the new code it said
'usps' => array(

I don't see any mistake there. When I replace the patched shipping_methods.php file with the original one, everything is back to "normal", i.e. the three issues above are gone, but it says "Error: Shipping Methods not configured - mzmt (ignored)"

How do I get it to work?
Thanks!

16 Dec 2007, 4:35 AM
#51
dude_s avatar

dude_s

New Zenner

Join Date:
May 2005
Posts:
39
Plugin Contributions:
0

Re: Mzmt Sql

Woah... where did those ## come from??

Ok, when I just pasted this in, this was
'mzmt' => array(
Looks like there may be some invisible characters in there. That may of course be the key to my problems. Gonna check with a hex editor...

16 Dec 2007, 6:02 AM
#52
dude_s avatar

dude_s

New Zenner

Join Date:
May 2005
Posts:
39
Plugin Contributions:
0

Re: Mzmt Sql

So I checked and I found.

The pasted code was full of A0s where there should have been 20s (spaces). If you know hex code, you'll notice thats 20 with an additional bit enabled (A0-20=80 and 80h=10000000b). Strange.

After I fixed that, I got more errors.
This time, the entry in my error log said:
PHP Parse error: syntax error, unexpected T_STRING in /home/dude_s/public_html/googlecheckout/shipping_methods.php on line 8

Line 8 is simply a comment:
####// see that you must set flat methods too!
and sure enough, as you can tell there were more weird invisible codes in front of the //, where there should have been spaces (after pasting here revealed by #s). Fixed that too.

Now, it seems to work. :-)

Glad I found it when this all revealed itself after pasting here in the forum. So the forum helped even though no one replied :-) But could it be that the Shipping Generator produces those weird invisible characters? I never had such problem before.

16 Dec 2007, 9:38 AM
#53
dude_s avatar

dude_s

New Zenner

Join Date:
May 2005
Posts:
39
Plugin Contributions:
0

Re: Mzmt Sql

Hi, I'm trying to set up the MZMT (MultiGeoZone MultiTable) shipping module along with Google Checkout. When I try to complete an order in the Sandbox, it shows me only the default shipping values I entered in Admin -> Modules -> Payment -> Default Values for Real Time Shipping Rates. It doesn't use the calculated value, which I set to be based on weight.

What can I do?

24 Dec 2007, 2:48 AM
#54
mavvy avatar

mavvy

New Zenner

Join Date:
Sep 2007
Location:
Singapore
Posts:
15
Plugin Contributions:
0

Re: Mzmt Sql

Does this mod work in 1.3.7.1 currently ? Anyone ?

24 Dec 2007, 3:04 AM
#55
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Mzmt Sql

It does work for me.

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

24 Dec 2007, 12:19 PM
#56
mavvy avatar

mavvy

New Zenner

Join Date:
Sep 2007
Location:
Singapore
Posts:
15
Plugin Contributions:
0

Re: Mzmt Sql

Thanks...

4 Mar 2008, 2:36 PM
#57
danstever avatar

danstever

New Zenner

Join Date:
Feb 2008
Posts:
3
Plugin Contributions:
0

Re: Mzmt Sql

I'm having difficulty figuring this out.

I have installed MZMT, set the number of zones and tables under Admin - Configuration (4 zones - 1 table), installed the SQL data, changed the code on mzmt.php in languages, and every time I assign a zone to my last zone in the shipping module, MZMT will not work.

I have found if I want 4 zones, I set up the configuration for 5 zones and then 1-4 will work but 5 will not.

Likewise, if I change to config to 6 zones, 1-5 work and 6 will not.

The Last Geo zone will not work.

Any Ideas?

Does this make sense?

12 Mar 2008, 6:58 PM
#58
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Mzmt Sql

thanks dreamscape ! I had no idea what to do until I saw this post :smile:

17 Mar 2008, 7:16 AM
#59
mrmigraine avatar

mrmigraine

New Zenner

Join Date:
Mar 2008
Posts:
2
Plugin Contributions:
0

Re: Mzmt Sql

Hello all,
I am creating a zen-cart store for a winery in Napa.

They use a freight forwarder with their own unique rates for ground and 2nd day shipping (not UPS). There are 5 different zones made up of US states that were defined. California tax is charged for all areas. Shipping rate is determined by weight. ie: Each bottle is 3.25 lbs, 8 bottle sampler is 26 lbs, 12 bottle case is 39 lbs.

I installed Joshua Dechant's "MultiGeoZone MultiTable Shipping for Zen Cart - version 1.101"

It appears to be the answer to the storefront, BUT no matter what I do I cannot make it take the numbers entered in the shipping tables when I use the Geo Zone Table Method of "weight".

It will take a handling fee, it will take the table data if I tell it to use the "price method", It will NOT take the data if "weight" or "count" method is used

Am I missing something mind-numbingly simple??

A screen capture of my MZMT Settings and shopping cart results are at:
http://www.anoid.com/zencart/MZMT-shipping.gif

fyi:The wine prices are "real". The shipping amounts are fabricated numbers so I know which table is appearing in the checkout page

The zen-cart test store is at:
http://www.tvinecellars.com/store

I am SO ready to get this store onto the next step then online, all help is appreciated

thanks
russell

18 Mar 2008, 8:02 AM
#60
mrmigraine avatar

mrmigraine

New Zenner

Join Date:
Mar 2008
Posts:
2
Plugin Contributions:
0

Re: Mzmt Sql

I changed the sort order of the MZMT module from "0" to "1"
...now it seems to work!

i'm very confused why that worked, but am pleased nonetheless!

russell