Web Order Interface Web Site Requirements

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
(Other Formatting Considerations)
(15 intermediate revisions not shown.)
Line 1: Line 1:
 +
{{TOCright}}
This section will help you understand how to program your Web site so FTD Mercury can retrieve Web orders from your e-commerce email address. Give this information to your Web site designer before you set up the Web Order Interface.
This section will help you understand how to program your Web site so FTD Mercury can retrieve Web orders from your e-commerce email address. Give this information to your Web site designer before you set up the Web Order Interface.
==General Requirements==
==General Requirements==
-
E-commerce Web site with SMTP capability and symmetric encryption capability.
+
*E-commerce Web site with SMTP capability and symmetric encryption capability.
-
A working Internet connection.
+
*A working Internet connection.
-
An outgoing SMTP server. You can use FTD’s mail server or your own. This should be set up in
+
*An outgoing SMTP server. You can use FTD’s mail server or your own. This should be set up in Mercury Administration on the MailServer screen.
-
Mercury Administration (see MailServer Screen on page 24–30).
+
*An email address for e-commerce Web orders. The account must be accessible via POP3 or IMAP protocols from the Internet, SSL is not supported. If your ISP has any IP restrictions on which addresses are allowed to communicate with the mail server, then WOI will be unable to pick up these email messages.
-
An email address for e-commerce Web orders. The account must be accessible via POP3 or
+
*A separate email address for error reporting. It is recommended that this address use the same incoming mail server as your e-commerce email address (for example, if your email address for Web orders is orders@email.com, it is recommended that your Web site for error reporting is errors@email.com). You do not have to use this email address for error reporting only (it can be used for personal use as well).
-
IMAP protocols from the Internet. If your ISP has any IP restrictions on which addresses are
+
-
allowed to communicate with the mail server, then WOI will be unable to pick up these email
+
-
messages.
+
-
A separate email address for error reporting. It is recommended that this address use the
+
-
same incoming mail server as your e-commerce email address (for example, if your email
+
-
address for Web orders is orders@email.com, it is recommended that your Web site for error
+
-
reporting is errors@email.com). You do not have to use this email address for error reporting
+
-
only (it can be used for personal use as well).
+
-
FIELD REQUIREMENTS
+
-
The following table lists the requirements for fields on your Web site. Information about the
+
-
contents of each column is provided below:
+
-
• Web Site Field—This column lists the fields that FTD Mercury is able to interpret on your Web
+
-
site.
+
-
• Requirements for Field—This column lists the standards that your field must follow (if any) so
+
-
that FTD Mercury can properly interpret the information. If no standards are listed, then there
+
-
are no requirements for this field (the text will be copied into FTD Mercury “as is”).
+
-
• Number of Characters—This column lists the maximum number of characters that FTD
+
-
Mercury can use to obtain information. You may decide to allow your customers to enter more
+
-
characters than what is listed here; however any number of characters that is greater than
+
-
what is listed here will be lost.
+
-
WEB SITE FIELD REQUIREMENTS FOR FIELD NUMBER OF
+
==Field Requirements==
-
CHARACTERS
+
The following table lists the requirements for fields on your Web site. Information about the contents of each column is provided below:
-
Additional Information Goes in Order Notes 1000
+
*'''Web Site Field—'''This column lists the fields that FTD Mercury is able to interpret on your Web site.
-
Bill Address1 100
+
*'''Requirements for Field—'''This column lists the standards that your field must follow (if any) so that FTD Mercury can properly interpret the information. If no standards are listed, then there are no requirements for this field (the text will be copied into FTD Mercury “as is”).
-
Bill Address2 100
+
*'''Number of Characters—'''This column lists the maximum number of characters that FTD Mercury can use to obtain information. You may decide to allow your customers to enter more characters than what is listed here; however any number of characters that is greater than what is listed here will be lost.
-
Bill City 30
+
 
-
Bill Country USA or CND for example 3
+
<table style="width:775px; border: 1px black solid; border-collapse: collapse; border-spacing: 0px; text-align: left; ">
-
Bill Fax Area Code 3
+
<tr style="background:#D1BC61;">
-
Bill Fax Number Prefix plus phone number, or remaining phone number
+
<td style="padding: 3px; text-align:left; font-size: 10pt; font-weight: bold; width: 150px;">Web Site Field</td>
-
values
+
<td style="padding: 3px; text-align left; font-size: 10pt; font-weight: bold;">Requirements for Field</td>
-
20
+
<td style="padding: 3px; text-align left; font-size: 10pt; font-weight: bold;">Number of Characters</td>
-
Bill Fax Prefix Can be left blank 3
+
</tr>
-
Bill Name This field should list the person that is PLACING the
+
<tr>
-
order
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Additional Information</td>
-
50
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Goes in Special Instructions</td>
-
Bill Phone Area Code 3
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">1000</td>
-
Bill Phone Extension Must be SEPARATE field from Phone Number 4
+
</tr>
-
Bill Phone Number Prefix plus phone number, or remaining phone number
+
<tr style="background:#f2ebd8;">
-
values
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Address1</td>
-
20
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
Bill Phone Prefix Can be left blank 3
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">100</td>
-
Bill Phone2 Area Code 3
+
</tr>
-
Bill Phone2 Extension Must be SEPARATE field from Phone Number 4
+
<tr>
-
Bill Phone2 Number Prefix plus phone number, or remaining phone number
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Address2</td>
-
values
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
20
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">100</td>
-
Bill Phone2 Prefix Can be left blank 3
+
</tr>
-
Bill State 2-digit abbreviation 2
+
<tr style="background:#f2ebd8;">
-
Bill Zip Code 10
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill City</td>
-
Business Name Populates the company name for the recipient on the
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
order.
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">30</td>
-
50
+
</tr>
-
Card Message 600
+
<tr>
-
CC Cardholder (Not Required.) This field should list the same name that
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Country</td>
-
is on the CREDIT CARD. If payment is to be applied to a
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">USA or CND for example</td>
-
house account, provide house account number.
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
-
30
+
</tr>
-
CC Company Credit card company that the number applies to (VISA,
+
<tr style="background:#f2ebd8;">
-
DISCOVER, etc.). If payment is to be applied to a house
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Fax Area Code</td>
-
account, supply “INHOUSE”
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
10
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
-
CC CVV Code Credit card security code (on back of card) 10
+
</tr>
-
CC Expiration (Month) 2-digit number 2
+
<tr>
-
CC Expiration (Year) 2- or 4-digit year 4
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Fax Number</td>
-
CC Number Credit card number. If payment is to be applied to a
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Prefix plus phone number, or remaining phone number values</td>
-
house account, provide house account number.
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">20</td>
-
20
+
</tr>
-
Delivery (Day) 2-digit number 2
+
<tr style="background:#f2ebd8;">
-
Delivery (Month) 2-digit number 2
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Fax Prefix</td>
-
Delivery (Year) 2- or 4-digit year 4
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can be left blank</td>
-
Delivery Charge Can include the decimal or dollar sign 8
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
-
Delivery Instructions 250
+
</tr>
-
Discount Amount Can include the decimal or dollar sign 8
+
<tr>
-
E-mail Address 50
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Name</td>
-
Occasion Code 0 = None
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">This field should list the person that is PLACING the order</td>
-
1 = Sympathy
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">50</td>
-
2 = Illness
+
</tr>
-
3 = Birthday
+
<tr style="background:#f2ebd8;">
-
4 = Business Gifts
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone Area Code</td>
-
5 = Holiday
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
6 = Maternity
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
-
7 = Anniversary
+
</tr>
-
8 = Other
+
<tr>
-
2
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone Extension</td>
-
Product AmountX Where X is the line item number of the product 8
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Must be SEPARATE field from Phone Number</td>
-
Product CodeX Where X is the line item number of the product 10
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">4</td>
-
Product DescriptionX Where X is the line item number of the product 350
+
</tr>
-
Product QtyX Where X is the line item number of the product 4
+
<tr style="background:#f2ebd8;">
-
Recipient Address1 100
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone Number</td>
-
Recipient Address2 100
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Prefix plus phone number, or remaining phone number values</td>
-
Recipient City 30
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">20</td>
-
Recipient Country Code USA or CND for example 3
+
</tr>
-
Recipient Name 100
+
<tr>
-
Recipient Phone Area Code 3
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone Prefix</td>
-
Recipient Phone Extension Must be SEPARATE field from Phone Number 4
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can be left blank</td>
-
Recipient Phone Number Prefix plus phone number, or remaining phone number
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
-
values
+
</tr>
-
20
+
<tr style="background:#f2ebd8;">
-
Recipient Phone Prefix Can be left blank 3
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone2 Area Code</td>
-
Recipient Phone2 Area
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
Code
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
-
3
+
</tr>
-
Recipient Phone2 Extension (Must be SEPARATE field from Phone Number) 6
+
<tr>
-
Recipient Phone2 Number Prefix plus phone number, or remaining phone number
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone2 Extension</td>
-
values
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Must be SEPARATE field from Phone Number</td>
-
10
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">4</td>
-
Recipient Phone2 Prefix Can be left blank 3
+
</tr>
-
Recipient State 2-digit abbreviation 2
+
<tr style="background:#f2ebd8;">
-
Recipient Zip Code 10
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone2 Number</td>
-
Relay Charge Can include the decimal or dollar sign 8
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Prefix plus phone number, or remaining phone number values</td>
-
Retrans Charge Can include the decimal or dollar sign 8
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">20</td>
-
Service Charge Can include the decimal or dollar sign 8
+
</tr>
-
Tax Amount Can include the decimal or dollar sign 8
+
<tr>
-
Total Order Amount Total order amount should be the total of all products,
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Phone2 Prefix</td>
-
fees, and taxes minus any discounts. Can include the
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can be left blank</td>
-
decimal or dollar sign
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill State</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2-digit abbreviation</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Bill Zip Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">10</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Card Message</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">600</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC Cardholder</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">(Not Required.) This field should list the same name that is on the CREDIT CARD. If payment is to be applied to a house account, provide house account number.</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">30</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC Company</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Credit card company that the number applies to (VISA, DISCOVER, etc.). If payment is to be applied to a house account, supply “INHOUSE”</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">10</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC CVV Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Credit card security code (on back of card)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">10</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC Expiration (Month)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2-digit number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC Expiration (Year)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2- or 4-digit year</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">4</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC Number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Credit card number. If payment is to be applied to a house account, provide house account number.</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">20</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Delivery (Day)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2-digit number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Delivery (Month)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2-digit number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Delivery (Year)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2- or 4-digit year</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">4</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Delivery Charge</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Delivery Instructions</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Goes into Time Detail</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">250</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Discount Amount</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">E-mail Address</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">50</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Occasion Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">0 = None<br>1 = Sympathy<br>2 = Illness<br>3 = Birthday<br>4 = Business Gifts<br>5 = Holiday<br>6 = Maternity<br>7 = Anniversary<br>8 = Other</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Product AmountX</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Where X is the line item number of the product</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Product CodeX</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Where X is the line item number of the product</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">10</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Product DescriptionX</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Where X is the line item number of the product</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">350</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Product QtyX</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Where X is the line item number of the product</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">4</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Address1</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">100</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Address2</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">100</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient City</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">30</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Company</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Populates the company name for the recipient on the order.</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">50</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Country Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">USA or CND for example</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Name</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">100</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone Area Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone Extension</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Must be SEPARATE field from Phone Number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">4</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone Number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Prefix plus phone number, or remaining phone number values</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">20</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone Prefix</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can be left blank</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
 +
</tr>
 +
<!--
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone2 Area Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone2 Extension</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">(Must be SEPARATE field from Phone Number)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">6</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone2 Number</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Prefix plus phone number, or remaining phone number values</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">10</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Phone2 Prefix</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can be left blank</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">3</td>
 +
</tr>
 +
-->
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient State</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2-digit abbreviation</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Recipient Zip Code</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">10</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Relay Charge</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Retrans Charge</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Service Charge</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Tax Amount</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">8</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">Total Order Amount</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Total order amount should be the total of all products, fees, and taxes minus any discounts. Can include the decimal or dollar sign</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">20</td>
 +
</tr>
 +
</table>
===Special Instruction Tags for Preauthorized Credit Cards===
===Special Instruction Tags for Preauthorized Credit Cards===
-
FTD Mercury supports cards preauthorized via your Web site. When transmitting information to
+
FTD Mercury supports cards preauthorized via your Web site. When transmitting information to FTD Mercury, information is received in the special instructions for orders received from WOI. Credit card processing is not performed in FTD Mercury if an approval code is transmitted with a WOI order.
-
FTD Mercury, information is received in the special instructions for orders received from WOI.
+
 
-
Credit card processing is not performed in FTD Mercury if an approval code is transmitted with a
+
<table>
-
WOI order.
+
<tr>
-
IMPORTANT These fields also apply to Florists Online (FOL) orders.
+
<td>
-
The following tags are available for preauthorized credit cards using WOI or FOL (you must have
+
[[Image:ImportantInfoIcon.png]]
-
previously provided the credit card number, type, and expiration date to use these tags):
+
</td>
 +
<td>
 +
These fields also apply to Florists Online (FOL) orders.
 +
</td>
 +
</tr>
 +
</table>
 +
 
 +
The following tags are available for preauthorized credit cards using WOI or FOL (you must have previously provided the credit card number, type, and expiration date to use these tags):
-
TAG REQUIREMENTS/NOTES CHARACTERS
+
<table style="width:775px; border: 1px black solid; border-collapse: collapse; border-spacing: 0px; text-align: left; ">
-
APPROVAL CODE If this contains a value, the approval code is
+
<tr style="background:#D1BC61;">
-
displayed in the Payments window for the order.
+
<td style="padding: 3px; text-align:left; font-size: 10pt; font-weight: bold; width: 150px;">Tag</td>
-
The order will not be reprocessed unless the
+
<td style="padding: 3px; text-align left; font-size: 10pt; font-weight: bold;">Requirements/Notes</td>
-
order total is changed.
+
<td style="padding: 3px; text-align left; font-size: 10pt; font-weight: bold;">Characters</td>
-
1024 (AP, DECLINED,
+
</tr>
-
ERROR)
+
<tr>
-
AVS RESPONSE Must be either Y or N 1 (alpha)
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">APPROVAL CODE</td>
-
CARD CODE Always blank
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">If this contains a value, the approval code is displayed in the Payments window for the order. The order will not be reprocessed unless the order total is changed.</td>
-
CARD CODE RESPONSE Always blank
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">1024 (AP, DECLINED, ERROR)</td>
-
CC MESSAGE Stored in Order Notes 48
+
</tr>
-
CLIENT REFERENCE ID 64 (alphanumeric)
+
<tr style="background:#f2ebd8;">
-
RESPONSE CODE AP or DC (approved or declined) or blank.
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">AVS RESPONSE </td>
-
NOTE: If this is blank and both Transaction ID
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Must be either Y or N </td>
-
and Client Reference ID are not blank,
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">1 (alpha)</td>
-
a query of CCAPI will be performed to
+
</tr>
-
receive the updated status.
+
<tr>
-
If this is blank and Transaction ID and
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CARD CODE</td>
-
Client Reference ID are blank, the
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Always blank</td>
-
order will be availble for normal credit
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
-
card processing in FTD Mercury.
+
</tr>
-
2 (alpha)
+
<tr style="background:#f2ebd8;">
-
TRANSACTION ID CCAPI Transaction ID# (required if approval code
+
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CARD CODE RESPONSE</td>
-
exists)
+
<td style="padding: 3px; text-align:left; font-size: 9pt;">Always blank</td>
-
9 (numeric)
+
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CC MESSAGE</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">Stored in Order Notes</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">48</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">CLIENT REFERENCE ID</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;"></td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">64 (alphanumeric)</td>
 +
</tr>
 +
<tr>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">RESPONSE CODE</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">AP or DC (approved or declined) or blank.<br>''NOTE: If this is blank and both Transaction ID and Client Reference ID are not blank, a query of CCAPI will be performed to receive the updated status.<br>If this is blank and Transaction ID and Client Reference ID are blank, the order will be availble for normal credit card processing in FTD Mercury.''</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">2 (alpha)</td>
 +
</tr>
 +
<tr style="background:#f2ebd8;">
 +
<td style="padding: 3px; text-align:left; font-size: 9pt; font-weight: bold;">TRANSACTION ID</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">CCAPI Transaction ID# (required if approval codeexists)</td>
 +
<td style="padding: 3px; text-align:left; font-size: 9pt;">9 (numeric)</td>
 +
</tr>
 +
</table>
==Other Formatting Considerations==
==Other Formatting Considerations==
Line 184: Line 408:
</pre>
</pre>
-
''NOTE: There is no space between the heading and the colon, and there is a space between the colon and the relevant information.''
+
<table>
 +
<tr>
 +
<td>
 +
[[Image:NoteIcon.png]]
 +
</td>
 +
<td>
 +
There is no space between the heading and the colon, and there is a space between the colon and the relevant information.
 +
</td>
 +
</tr>
 +
</table>
==Encryption==
==Encryption==
-
ENCRYPTION
+
*The cipher mode used for all encryption types is CBC.
-
Only a user-friendly password will be required for configuration by the user. This password will
+
*The padding mode used for all encryptions is PKCS7.
-
be used to generate both the key and initialization vector required by the encryption process.
+
*Only a user-friendly password will be required for configuration by the user. This password will be used to generate both the key and initialization vector required by the encryption process.
-
If the password is longer than necessary, it will be truncated to fit.
+
*If the password is longer than necessary, it will be truncated to fit.
-
If the password is shorter than necessary, it will be right padded with asterisks (*).
+
*If the password is shorter than necessary, it will be right padded with asterisks (*).
-
The valid lengths that will determine truncation or padding are defined as being the maximum
+
*The valid lengths that will determine truncation or padding are defined as being the maximum length allowed for each respective algorithm. Currently, those lengths are defined as follows:
-
length allowed for each respective algorithm. Currently, those lengths are defined as follows:
+
*Valid key lengths:
-
Valid key lengths:
+
**DES - 8 bytes
-
DES - 8 bytes
+
**RC2 - 16 bytes
-
RC2 - 16 bytes
+
**Rijndael - 32 bytes
-
Rijndael - 32 bytes
+
**TripleDES - 24 bytes
-
TripleDES - 24 bytes
+
*Valid IV lengths:
-
Valid IV lengths:
+
**DES, RC2, TripleDES - 8 bytes
-
DES, RC2, TripleDES - 8 bytes
+
**Rijndael - 16 bytes
-
Rijndael - 16 bytes
+
 
-
For example, the key and IV that should be used for a password of “flower,” for example
+
For example, the key and IV that should be used for a password of “flower,” for example the TripleDES encryption algorithm:
-
the TripleDES encryption algorithm:
+
<pre>
Key: “flower******************”
Key: “flower******************”
IV: “flower**”
IV: “flower**”
-
TripleDES: Since a weak key provided to TripleDES will cause an error, the FTD Mercury encryption
+
</pre>
-
library will predetermine whether or not the key is weak. If the key is found to be weak, encryption
+
 
-
will be processed via the DES algorithm, not TripleDES. This will not impact the user in any way.
+
<table>
 +
<tr>
 +
<td>
 +
[[Image:NoteIcon.png]]
 +
</td>
 +
<td>
 +
Since a weak key provided to TripleDES will cause an error, the FTD Mercury encryption library will predetermine whether or not the key is weak. If the key is found to be weak, encryption will be processed via the DES algorithm, not TripleDES. This will not impact the user in any way.
 +
</tr>
 +
</table>

Revision as of 09:33, 20 October 2014

Contents

This section will help you understand how to program your Web site so FTD Mercury can retrieve Web orders from your e-commerce email address. Give this information to your Web site designer before you set up the Web Order Interface.

General Requirements

  • E-commerce Web site with SMTP capability and symmetric encryption capability.
  • A working Internet connection.
  • An outgoing SMTP server. You can use FTD’s mail server or your own. This should be set up in Mercury Administration on the MailServer screen.
  • An email address for e-commerce Web orders. The account must be accessible via POP3 or IMAP protocols from the Internet, SSL is not supported. If your ISP has any IP restrictions on which addresses are allowed to communicate with the mail server, then WOI will be unable to pick up these email messages.
  • A separate email address for error reporting. It is recommended that this address use the same incoming mail server as your e-commerce email address (for example, if your email address for Web orders is orders@email.com, it is recommended that your Web site for error reporting is errors@email.com). You do not have to use this email address for error reporting only (it can be used for personal use as well).

Field Requirements

The following table lists the requirements for fields on your Web site. Information about the contents of each column is provided below:

  • Web Site Field—This column lists the fields that FTD Mercury is able to interpret on your Web site.
  • Requirements for Field—This column lists the standards that your field must follow (if any) so that FTD Mercury can properly interpret the information. If no standards are listed, then there are no requirements for this field (the text will be copied into FTD Mercury “as is”).
  • Number of Characters—This column lists the maximum number of characters that FTD Mercury can use to obtain information. You may decide to allow your customers to enter more characters than what is listed here; however any number of characters that is greater than what is listed here will be lost.
Web Site Field Requirements for Field Number of Characters
Additional Information Goes in Special Instructions 1000
Bill Address1 100
Bill Address2 100
Bill City 30
Bill Country USA or CND for example 3
Bill Fax Area Code 3
Bill Fax Number Prefix plus phone number, or remaining phone number values 20
Bill Fax Prefix Can be left blank 3
Bill Name This field should list the person that is PLACING the order 50
Bill Phone Area Code 3
Bill Phone Extension Must be SEPARATE field from Phone Number 4
Bill Phone Number Prefix plus phone number, or remaining phone number values 20
Bill Phone Prefix Can be left blank 3
Bill Phone2 Area Code 3
Bill Phone2 Extension Must be SEPARATE field from Phone Number 4
Bill Phone2 Number Prefix plus phone number, or remaining phone number values 20
Bill Phone2 Prefix Can be left blank 3
Bill State 2-digit abbreviation 2
Bill Zip Code 10
Card Message 600
CC Cardholder (Not Required.) This field should list the same name that is on the CREDIT CARD. If payment is to be applied to a house account, provide house account number. 30
CC Company Credit card company that the number applies to (VISA, DISCOVER, etc.). If payment is to be applied to a house account, supply “INHOUSE” 10
CC CVV Code Credit card security code (on back of card) 10
CC Expiration (Month) 2-digit number 2
CC Expiration (Year) 2- or 4-digit year 4
CC Number Credit card number. If payment is to be applied to a house account, provide house account number. 20
Delivery (Day) 2-digit number 2
Delivery (Month) 2-digit number 2
Delivery (Year) 2- or 4-digit year 4
Delivery Charge Can include the decimal or dollar sign 8
Delivery Instructions Goes into Time Detail 250
Discount Amount Can include the decimal or dollar sign 8
E-mail Address 50
Occasion Code 0 = None
1 = Sympathy
2 = Illness
3 = Birthday
4 = Business Gifts
5 = Holiday
6 = Maternity
7 = Anniversary
8 = Other
2
Product AmountX Where X is the line item number of the product 8
Product CodeX Where X is the line item number of the product 10
Product DescriptionX Where X is the line item number of the product 350
Product QtyX Where X is the line item number of the product 4
Recipient Address1 100
Recipient Address2 100
Recipient City 30
Recipient Company Populates the company name for the recipient on the order. 50
Recipient Country Code USA or CND for example 3
Recipient Name 100
Recipient Phone Area Code 3
Recipient Phone Extension Must be SEPARATE field from Phone Number 4
Recipient Phone Number Prefix plus phone number, or remaining phone number values 20
Recipient Phone Prefix Can be left blank 3
Recipient State 2-digit abbreviation 2
Recipient Zip Code 10
Relay Charge Can include the decimal or dollar sign 8
Retrans Charge Can include the decimal or dollar sign 8
Service Charge Can include the decimal or dollar sign 8
Tax Amount Can include the decimal or dollar sign 8
Total Order Amount Total order amount should be the total of all products, fees, and taxes minus any discounts. Can include the decimal or dollar sign 20

Special Instruction Tags for Preauthorized Credit Cards

FTD Mercury supports cards preauthorized via your Web site. When transmitting information to FTD Mercury, information is received in the special instructions for orders received from WOI. Credit card processing is not performed in FTD Mercury if an approval code is transmitted with a WOI order.

Image:ImportantInfoIcon.png

These fields also apply to Florists Online (FOL) orders.

The following tags are available for preauthorized credit cards using WOI or FOL (you must have previously provided the credit card number, type, and expiration date to use these tags):

Tag Requirements/Notes Characters
APPROVAL CODE If this contains a value, the approval code is displayed in the Payments window for the order. The order will not be reprocessed unless the order total is changed. 1024 (AP, DECLINED, ERROR)
AVS RESPONSE Must be either Y or N 1 (alpha)
CARD CODE Always blank
CARD CODE RESPONSE Always blank
CC MESSAGE Stored in Order Notes 48
CLIENT REFERENCE ID 64 (alphanumeric)
RESPONSE CODE AP or DC (approved or declined) or blank.
NOTE: If this is blank and both Transaction ID and Client Reference ID are not blank, a query of CCAPI will be performed to receive the updated status.
If this is blank and Transaction ID and Client Reference ID are blank, the order will be availble for normal credit card processing in FTD Mercury.
2 (alpha)
TRANSACTION ID CCAPI Transaction ID# (required if approval codeexists) 9 (numeric)

Other Formatting Considerations

  • Because the Web Order Interface is doing key/value parsing of the email, the email must be in plain text. HTML or rich text formatted (RTF) email cannot be handled and will cause error.
  • Email messages with the given subject line that have been successfully processed will be deleted from the given email server. If the email causes an error of any kind, it will be forwarded onto the error email address configured in Mercury Administration. If the attempt to forward this email fails, the mail will be left on the email server.
  • Email messages that do not have the given subject line will be forwarded to the error email address provided in Mercury Administration.
  • Whether encrypted or not, everything should reside within the body of the email. If the email body is encrypted, it should be Base64 encoded (care should be taken by the Web developer to ensure correct line block length). Attachments will be ignored.
  • Do not use special characters, except in the email address (for example, do not use #, $, %, ^, &, etc.).
  • If you are not using the Product Description field for a product description, enter the product code in both the Product Description field and the Product Code field.
  • If a field in the Web order form is unused, that field should still be included in the generated email.
  • Given the above table, a valid email body would look like this:
Bill Name: Joe Customer
Bill Address1: 12345 Main Street
Bill Address2:
Bill City: Anytown
Bill State: IL
Bill Country: USA
Bill Zip Code: 60515
Bill Phone Area Code: 630
Bill Phone Prefix: 555
Bill Phone Number: 7890
Bill Phone Extension: 1028
...etc.

Image:NoteIcon.png

There is no space between the heading and the colon, and there is a space between the colon and the relevant information.

Encryption

  • The cipher mode used for all encryption types is CBC.
  • The padding mode used for all encryptions is PKCS7.
  • Only a user-friendly password will be required for configuration by the user. This password will be used to generate both the key and initialization vector required by the encryption process.
  • If the password is longer than necessary, it will be truncated to fit.
  • If the password is shorter than necessary, it will be right padded with asterisks (*).
  • The valid lengths that will determine truncation or padding are defined as being the maximum length allowed for each respective algorithm. Currently, those lengths are defined as follows:
  • Valid key lengths:
    • DES - 8 bytes
    • RC2 - 16 bytes
    • Rijndael - 32 bytes
    • TripleDES - 24 bytes
  • Valid IV lengths:
    • DES, RC2, TripleDES - 8 bytes
    • Rijndael - 16 bytes

For example, the key and IV that should be used for a password of “flower,” for example the TripleDES encryption algorithm:

Key: “flower******************”
IV: “flower**”

Image:NoteIcon.png

Since a weak key provided to TripleDES will cause an error, the FTD Mercury encryption library will predetermine whether or not the key is weak. If the key is found to be weak, encryption will be processed via the DES algorithm, not TripleDES. This will not impact the user in any way.

Personal tools