misc2

Misc. Continued

Question: Is there a way to easily obtain the IP and Host name on orders?

Answer: Here is a simple way to have the IP & hostname sent to you (the merchant) when an order is placed. In the meremail.mv (or equivalent fulfillment module) placed the following 2 lines right before the </MvSMTP>

<MvEVAL EXPR = "{ remote_addr }">
<MvEVAL EXPR = "{ remote_host }">

This will place the hostname and IP at the bottom of the order email for
every order placed. A little quicker and easier than searching the log files for the info.

The same thing could be used on the INVC screen (or any other screen) in the **ui.mv to let the customer (or thief) know that you have recorded their IP address.

Answered by Mike Crawford @ crawford@myhome.net

Question: How can you place a Back Button in the program to take you back to the page you came from?

Answer: You can simply use the following href tag to send someone back to the page
they came from...

<a href="JavaScript:history.back()">

Of course, they would have to be using a Java-enabled browser....

Answered by Eran @ edekel@optonline.net

Question: How can I create a horizontal display of thumbs in the category page?

Answer: I think this is what you are looking for, (from Amy, coders-list, March) :
<<Several of you have asked about how I got the thumbnails to display
across columns so here it is. It's all in the MMUI_Category routine in
mmui.mv. I've put the new function on my web site at
http://www.e-golfer.com/temp/mmui_category.txt. (I put it there to avoid and concerns about viruses so you can just view it thru your browser and cut and paste the code).

This routine is based on Miva Merchant 2.01 and I've commented the
changes necessary. The entire routine is provided but if you have to
merge these changes, lines to delete are included inside comments and
lines to add are annotated with comments. All changes are comment so
just search for COMMENT.

Answered by Amy @ http://www.e-golfer.com

Question: Why do I receive this error:
Error Code:
MER-DTB-00237

Description:
Error writing to 'Merchant2/00000001/storekey.dbf00000001':
Quota exceeded

Answer: This is a simple one, you are out of hard-drive space on your server. You need to contact your hosting company

Answered by Darren Ehlers @ http://www.starbase21.com/

Question: Is there a possible way to put the code for Human Click in the category column but have Miva check to see if it is in secure mode, and if so, to NOT execute the Human Click code?

Answer: Yes, you can add it to the <head> tags within the Begin_Screen function of mmui. However, there is one trick if you are linking an external style sheet. You need to make the path to the style sheet change during secure sessions (or get rid of it entirely). Else, you will get one of those "this page contains secure and non-secure info... " messages. Sample code below.
<MvIF EXPR = "{ g.Secure }">
<link rel="stylesheet" type="text/css"
href="secureserverpath/style.css">
<MvELSE>
<link rel="stylesheet" type="text/css" href="style.css">
</MvIF>

You can also avoid the secure session problem by using an embedded style sheet rather than an external.

Answered by Adam

Question: How does the Search Function work?

Answer: When you are searching on the store front, it will search 3 things....

Product Name
Product Code
AND
Product Description.

There is no way you can change the search engine to search by partial match though.

Answered by Jeremy @ Miva Technical Support

Question: Our site sell convention registrations. We do not accept registrations year round. I do not want a choice available until we do. I uncatagorized the different choices, but they are still visible in the "Products List".
> Is there anyway to hide these so I don't not have to re-enter them every
year ?

Answer: Create an availability group called "Secret" and assign no one to it.

Then when you want to hide your product/service, just assign it to this
availability group.

You can also do this with entire categories though you may also have to add each individual product.

Answered by Jo Pop

Question: Why am I receiving this error:

> Fatal error: merchant2/merchant.mv is not owned by > 005GVX4

Answer: This happens when the hosting company has not given ownership rights of the files to your domain/IP address.

Answered by Pamela http://www.designextend.com

Question: How can I display Dates in Plain Language?

Answer:

Day of year: <MvEVAL EXPR="{ tm_yday }">
Numbe of Month: <MvEVAL EXPR="{ tm_month }">
Day of month: <MvEVAL EXPR="{ tm_mday }">

They are all built-in to Miva Script.

hope that helps some....

Answered by Jonathan Wray

Question: How can I create a hyperlink in the description that will open in a new window:?

Answer: The simplest method is adding TARGET="_blank" which opens a new
instance of the browser, or you could use something like:

But that wouldn't work for non-js enabled browsers.

Or you could add

Answered by Bruce Golub

Question: What are the New York County Tax Rates?

Answer: NY TAX RATES
County or Borough Rate Code
New York State - ONLY 4 0002
Albany 8 0179
Allegany 8 0215
Bronx (borough) 8 1/4 8009
Brooklyn (borough) 8 1/4 8009
Broome 8 0313
Cattaraugus 8 0499
Cayuga 8 0503
Chautauqua 7 0602
Chemung 7 0793
Chenango 7 0805
Clinton 7 0993
Columbia 8 1003
Cortland 8 1122
Delaware 6 1202
Dutchess 7 1/4 1303
Erie 8 1415
Essex 7 1502
Franklin 7 1602
Fulton 7 1706
Genesee 8 1894
Greene 8 1903
Hamilton 7 2002
Herkimer 8 2104
Jefferson 7 2202
Kings (Brooklyn) 8 1/4 8009
Lewis 7 2303
Livingston 7 2402
Madison 7 2582
Monroe 8 2605
Montgomery 7 2793
Nassau 8 1/2 2804
Manhattan (borough) 8 1/4 8009
New York City 8 1/4 8009
Niagara 7 2902
Oneida 8 3003
Onondaga 7 3102
Ontario 7 3272
Orange 7 1/4 3303
Orleans 8 3473
Oswego 7 3598
Otsego 7 3603
Putnam 7 1/4 3714
Queens (borough) 8 1/4 8009
Rensselaer 8 3875
Richmond (Staten Island) 8 1/4 8009
Rockland 7 1/4 3904
St. Lawrence 7 4092
Saratoga 7 4103
Schenectady 7 1/2 4233
Schoharie 7 4303
Schuyler 7 4402
Seneca 7 4512
Staten Island (borough) 8 1/4 8009
Steuben 8 4688
Suffolk 8 1/4 4760
Sullivan 7 4812
Tioga 7 1/2 4903
Tompkins 8 5096
Ulster 7 3/4 5113
Warren 7 5292
Washington 7 5302
Wayne 7 5402
Westchester 6 3/4 5503
Wyoming 8 5605
Yates 7 5702

EXCEPTIONAL CITIES
County Exclusion Rate Code
Cattaraugus Olean 8 0419
Cattaraugus Salamanca 8 0429
Cayuga Auburn 8 0552
Chenango Norwich 7 0844
Fulton Gloversville 7 1715
Fulton Johnstown 7 1724
Genesee Batavia 8 1824
Madison Oneida 7 2526
Oneida Rome 8 1/4 3033
Oneida Sherrill 8 3045
Oneida Utica 8 3056
Ontario Canandaigua 7 3232
Ontario Geneva 7 3242
Oswego Fulton 7 3532
Oswego Oswego 7 3542
St. Lawrence Ogdensburg 7 4012
Steuben Corning 8 4616
Steuben Hornell 8 4630
Tompkins Ithaca 8 5013
Warren Glens Falls 7 5212
Westchester Mount Vernon 8 1/4 5513
Westchester New Rochelle 8 1/4 6855
Westchester White Plains 7 3/4 5555
Westchester Yonkers 8 1/4 6578

(Actual Excel file available on request.)

POTENTIAL COUNTY SELECTION CODE
<MvCOMMENT>
(I don't do MvDatabases - Obviously this could all be done through a
database lookup and a loop.)</MvCOMMENT>
<TR><TD ALIGN = "left" VALIGN = "middle">
<FONT FACE = "Ariel, Helvetica" SIZE = "2">
<B>New York State Residents ONLY</I><br>Please Select Your County:</B>
</FONT>
</TD><TD ALIGN = "left" VALIGN = "middle">
<FONT FACE = "New Times Roman, Arial" SIZE = "3">
<SELECT NAME = "g.customer_shipcounty">
<OPTION VALUE = "Not in NY State">Not in NY State</OPTION>
<OPTION VALUE = "Albany">Albany</OPTION>
<OPTION VALUE = "Allegany">Allegany</OPTION>
<OPTION VALUE = "Bronx (borough)">Bronx (borough)</OPTION>
<OPTION VALUE = "Brooklyn (borough)">Brooklyn (borough)</OPTION>
<OPTION VALUE = "Broome">Broome</OPTION>
<OPTION VALUE = "Cattaraugus">Cattaraugus</OPTION>
<OPTION VALUE = "Cayuga">Cayuga</OPTION>
<OPTION VALUE = "Chautauqua">Chautauqua</OPTION>
<OPTION VALUE = "Chemung">Chemung</OPTION>
<OPTION VALUE = "Chenango">Chenango</OPTION>
<OPTION VALUE = "Clinton">Clinton</OPTION>
<OPTION VALUE = "Columbia">Columbia</OPTION>
<OPTION VALUE = "Cortland">Cortland</OPTION>
<OPTION VALUE = "Delaware">Delaware</OPTION>
<OPTION VALUE = "Dutchess">Dutchess</OPTION>
<OPTION VALUE = "Erie">Erie</OPTION>
<OPTION VALUE = "Essex">Essex</OPTION>
<OPTION VALUE = "Franklin">Franklin</OPTION>
<OPTION VALUE = "Fulton">Fulton</OPTION>
<OPTION VALUE = "Genesee">Genesee</OPTION>
<OPTION VALUE = "Greene">Greene</OPTION>
<OPTION VALUE = "Hamilton">Hamilton</OPTION>
<OPTION VALUE = "Herkimer">Herkimer</OPTION>
<OPTION VALUE = "Jefferson">Jefferson</OPTION>
<OPTION VALUE = "Kings (Brooklyn)">Kings (Brooklyn)</OPTION>
<OPTION VALUE = "Lewis">Lewis</OPTION>
<OPTION VALUE = "Livingston">Livingston</OPTION>
<OPTION VALUE = "Madison">Madison</OPTION>
<OPTION VALUE = "Monroe">Monroe</OPTION>
<OPTION VALUE = "Montgomery">Montgomery</OPTION>
<OPTION VALUE = "Nassau">Nassau</OPTION>
<OPTION VALUE = "Manhattan (borough)">Manhattan (borough)</OPTION>
<OPTION VALUE = "New York City">New York City</OPTION>
<OPTION VALUE = "Niagara">Niagara</OPTION>
<OPTION VALUE = "Oneida">Oneida</OPTION>
<OPTION VALUE = "Onondaga">Onondaga</OPTION>
<OPTION VALUE = "Ontario">Ontario</OPTION>
<OPTION VALUE = "Orange">Orange</OPTION>
<OPTION VALUE = "Orleans">Orleans</OPTION>
<OPTION VALUE = "Oswego">Oswego</OPTION>
<OPTION VALUE = "Otsego">Otsego</OPTION>
<OPTION VALUE = "Putnam">Putnam</OPTION>
<OPTION VALUE = "Queens (borough)">Queens (borough)</OPTION>
<OPTION VALUE = "Rensselaer">Rensselaer</OPTION>
<OPTION VALUE = "Richmond (Staten Island)">Richmond (Staten Island)</OPTION>
<OPTION VALUE = "Rockland">Rockland</OPTION>
<OPTION VALUE = "St. Lawrence">St. Lawrence</OPTION>
<OPTION VALUE = "Saratoga">Saratoga</OPTION>
<OPTION VALUE = "Schenectady">Schenectady</OPTION>
<OPTION VALUE = "Schoharie">Schoharie</OPTION>
<OPTION VALUE = "Schuyler">Schuyler</OPTION>
<OPTION VALUE = "Seneca">Seneca</OPTION>
<OPTION VALUE = "Staten Island (borough)">Staten Island (borough)</OPTION>
<OPTION VALUE = "Steuben">Steuben</OPTION>
<OPTION VALUE = "Suffolk">Suffolk</OPTION>
<OPTION VALUE = "Sullivan">Sullivan</OPTION>
<OPTION VALUE = "Tioga">Tioga</OPTION>
<OPTION VALUE = "Tompkins">Tompkins</OPTION>
<OPTION VALUE = "Ulster">Ulster</OPTION>
<OPTION VALUE = "Warren">Warren</OPTION>
<OPTION VALUE = "Washington">Washington</OPTION>
<OPTION VALUE = "Wayne">Wayne</OPTION>
<OPTION VALUE = "Westchester">Westchester</OPTION>
<OPTION VALUE = "Wyoming">Wyoming</OPTION>
<OPTION VALUE = "Yates">Yates</OPTION>
</SELECT>
</FONT>
</TD></TR>

POTENTIAL LONG & MESSY CODE TO CHECK FOR COUNTY AND ASSIGN RATES & CODES
<MvIF EXPR = "g.customer_shipcounty EQ 'Not in NY State'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "0%">
<MvASSIGN NAME = "report_code" VALUE = "0000">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Albany'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0179">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Allegany'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0215">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Bronx (borough)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Brooklyn (borough)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Broome'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0313">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Cattaraugus'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0499">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Cayuga'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0503">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Chautauqua'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "0602">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Chemung'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "0793">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Chenango'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "0805">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Clinton'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "0993">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Columbia'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "1003">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Cortland'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "1122">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Delaware'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "6%">
<MvASSIGN NAME = "report_code" VALUE = "1202">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Dutchess'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "1303">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Erie'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "1415">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Essex'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "1502">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Franklin'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "1602">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Fulton'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "1706">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Genesee'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "1894">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Greene'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "1903">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Hamilton'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2002">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Herkimer'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "2104">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Jefferson'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2202">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Kings (Brooklyn)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Lewis'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2303">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Livingston'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2402">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Madison'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2582">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Monroe'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "2605">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Montgomery'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2793">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Nassau'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/2%">
<MvASSIGN NAME = "report_code" VALUE = "2804">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Manhattan (borough)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'New York City'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Niagara'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2902">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Oneida'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "3003">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Onondaga'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3102">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Ontario'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3272">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Orange'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "3303">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Orleans'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "3473">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Oswego'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3598">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Otsego'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3603">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Putnam'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "3714">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Queens (borough)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Rensselaer'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "3875">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Richmond (Staten Island)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Rockland'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "3904">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'St. Lawrence'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4092">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Saratoga'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4103">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Schenectady'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 1/2%">
<MvASSIGN NAME = "report_code" VALUE = "4233">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Schoharie'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4303">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Schuyler'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4402">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Seneca'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4512">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Staten Island (borough)'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "8009">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Steuben'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "4688">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Suffolk'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "4760">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Sullivan'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4812">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Tioga'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 1/2%">
<MvASSIGN NAME = "report_code" VALUE = "4903">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Tompkins'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "5096">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Ulster'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 3/4%">
<MvASSIGN NAME = "report_code" VALUE = "5113">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Warren'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "5292">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Washington'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "5302">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Wayne'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "5402">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Westchester'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "6 3/4%">
<MvASSIGN NAME = "report_code" VALUE = "5503">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Wyoming'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "5605">
</MvIF>
<MvIF EXPR = "g.customer_shipcounty EQ 'Yates'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "5702">
</MvIF>

POTENTIAL LONG & MESSY CODE TO CHECK EXCEPTIONAL CITIES AND ASSIGN RATES &
CODES
<MvIF EXPR = "(g.customer_shipcounty EQ 'Cattaraugus') AND (shipcity EQ
'Olean'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0419">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Cattaraugus') AND (shipcity EQ
'Salamanca'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0429">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Cayuga') AND (shipcity EQ 'Auburn'"
>
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "0552">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Chenango') AND (shipcity EQ
'Norwich'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "0844">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Fulton') AND (shipcity EQ
'Gloversville'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "1715">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Fulton') AND (shipcity EQ
'Johnstown'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "1724">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Genesee') AND (shipcity EQ 'Batavia
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "1824">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Madison') AND (shipcity EQ 'Oneida
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "2526">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Oneida') AND (shipcity EQ 'Rome'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "3033">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Oneida') AND (shipcity EQ 'Sherrill
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "3045">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Oneida') AND (shipcity EQ 'Utica'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "3056">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Ontario') AND (shipcity EQ
'Canandaigua'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3232">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Ontario') AND (shipcity EQ 'Geneva
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3242">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Oswego') AND (shipcity EQ 'Fulton'"
>
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3532">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Oswego') AND (shipcity EQ 'Oswego'"
>
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "3542">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'St. Lawrence') AND (shipcity EQ
'Ogdensburg'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "4012">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Steuben') AND (shipcity EQ 'Corning
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "4616">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Steuben') AND (shipcity EQ 'Hornell
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "4630">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Tompkins') AND (shipcity EQ 'Ithaca
'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8%">
<MvASSIGN NAME = "report_code" VALUE = "5013">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Warren') AND (shipcity EQ 'Glens
Falls'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7%">
<MvASSIGN NAME = "report_code" VALUE = "5212">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Westchester') AND (shipcity EQ
'Mount Vernon'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "5513">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Westchester') AND (shipcity EQ 'New
Rochelle'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "6855">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Westchester') AND (shipcity EQ
'White Plains'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "7 3/4%">
<MvASSIGN NAME = "report_code" VALUE = "5555">
</MvIF>
<MvIF EXPR = "(g.customer_shipcounty EQ 'Westchester') AND (shipcity EQ
'Yonkers'">
<MvASSIGN NAME = "g.statetax_rate" VALUE = "8 1/4%">
<MvASSIGN NAME = "report_code" VALUE = "6578">
</MvIF>

Answered by Andrew @ Simplified Systems

Question: What happened to the UPS module in Merchant 4.0?

Answer: UPS requested that we make a number of changes in order for Miva to
continue offering UPS as a bundled feature of Miva Merchant 4.0. All of
which we did make. When we went back to UPS for certification they
requested one more change that would have caused us to change our API -
which would have been a huge and unnecessary last minute effort. We
asked them to let us release with all of the original changes and they
denied our request. So we had to pull UPS from Miva Merchant 4.0. We
are working with them vigorously to resolve this issue.

The UPS module from 3.0 will still work in 4.0 as long as you are
running Miva Empresa 3.91. Looking ahead - should we not resolve the
issue with UPS, the UPS module from 3.0 will not run on Miva Empresa
4.x. Obviously, We hope to have this issue resolved one way or another
before that.

Answered by: Damon@Miva Technical Support