If you are looking to migrate an existing E-Commerce site to a different server, here are some things to keep in mind.

Perform a new install on the new server and request a new license rather than trying to copy and recreate the E-Commerce environment. There should be a test server license option available to choose from when requesting a new license.

Once you get the new install done, copy the website files from the current site (except web.config and bin folder) and overwrite the new ones and backup and restore the live database on the new server overwriting the one created in the new install. At this point you should have a running site that looks like your current site.

At this time you should also test the messaging service to make sure it works form the new server as well as a test synch from a copy of your SBO company to make sure there are no connectivity issues.

When you are ready to go live, request a new server license and then stop the synch in the current environment. Copy the web database to the new server again and re-configure the synch manager to point to the new server. You can request a new license by navigating to licenserequest.aspx from the root of the website

NOTE: when you do the new install make sure you use the same private key as your current one so you don't get errors decrypting passwords on the new site.

 

In previous versions of zed E-Commerce and WebCRM, as well as WebTools, a document (NP2SBO-DataMap.xls) was shipped in the SDK\Code Examples\SynchPlugin\ folder that contained a mapping of how the data synchs from one system to the other. However, not everyone knew this document was there and the information contained in it was considerably out of date. As part of the 7.1.2 release of zed E-Commerce and WebCRM we wanted to include the updated information as well as present it in a user friendly format that will allow the users to search for the information they require without having to scroll through pages of information to try and find it. This data will also be updated with each release to reflect the current version of the application.

Anyone who has installed 7.1.2 can view this information in the Admin under Help -> Synch Data Map. This will open a new tab displaying the basic information. For a more detailed view of the data click on the Advanced View link at the bottom of the page. The table will be updated to include information such as the field sizes and API properties.

If you haven't yet downloaded 7.1.2 you can view this information at http://www.b1webcrm.com/admin/synchmap.aspx . However, this link will reflect the mapping as of the version installed on the b1webcrm site (currently 7.1.2).

I've included a couple of examples as part of this document of how a beginner or a more advanced user might use the data mapping to solve issues that they may encounter. If there are any specific situations which you have used this information for, or plan to use this information for please add a comment here so that others can learn from your experience. Also, as this information is every changing please feel free to comment on how we could improve the presentation to make it more beneficial.

Basic View:

 The Basic View contains the follow Columns:

Name:

          A friendly name used to identify the Synch Object.

zed Table:

          The table name in the zed E-Commerce and WebCRM database.

zed Field:

          The name of the field in the zed E-Commerce and WebCRM table.

B1 Table:

          The table name in the SAP Business One database.

B1 Field:

          The name of the field in the SAP Business One table.

To B1:

          Does this field Synch to Business One.

To zed:

          Does this field Synch to zed E-Commerce and WebCRM.

Comments:

          Any additional information about the line.

Finding Information:

Page Control:

The page control is located at the bottom of the table. The user can click the First, Next, Previous, and Last buttons to scroll through the data. A picture of this control can be seen below.

 

Group By Area:

The Group By area allows users to group the data by dragging columns from the table and dropping them in this area. This will change the display to group by the specified columns. For example, if we drag the Name column to the Group By Area it will be updated to look like this:

Sections can then be expanded by clicking on the '+' at the beginning of the row. To ungroup the data the column can be dragged back to its place in the table.

 

Search Box:

The Search Box is displayed in the far right corner of the Group By Area. The user can type characters into this field and it will search all columns and rows for cells containing this information. The table is refreshed as each character is typed so it is not necessary to press the enter key after entering the word that you wish to search for. For example, if a user wanted to know where all of the fields in the PartsMaster table synch they could type PartsMaster into the search box and the following will be displayed:

 

Additional Features:

Sorting:

          The data in the table can be sorted by clicking on the column header.

Organizing:

The columns can be dragged and dropped in the table allowing the user to change the order of the columns.

Resizing:

The width of columns can be increased by dragging the column separator to the desired width.

Examples:

Q: I want to know if the remarks on an Item in E-Commerce synchs to the Item Master in Business One?

A: Using the Search Box type in the information that you know. In this example, you know the field is called Remarks so type in Remarks. A few lines will be returned. Looking at the lines you will notice that one is for Items.

Reading the rest of the line you can see that it synchs to the UserText field in the OITM table of Business One. Also, that it synchs in both directions.

Q: I want to Synch quotes but I'm not sure if all of the information that I require will be synched. What exactly synchs for quotes and where does it Synch?

A: Since you know that you want information about Quotes type Quote in the Search Box. The table will be filled with the data associated with quotes. From this list you can identify which fields synch and where they synch to.

Advanced View:

For more advanced users another view of the data mapping is available that displays additional information. A user can see this view by click the Advanced View link at the bottom of the page. All features described above also apply to the Advanced View. This view can be seen below:

Additional Columns:

zed Field Size:

          The size of the field in the zed E-Commerce and WebCRM table.

API Class:

          The class in the Netpoint.API library that references the zed table.

API Property:

          The property in the API class that references the zed field.

 

DI API Class:

          The class in the SAP Business One DI API that references the B1 Table.

 

DI API Property:

          The property in the DI API class that references the B1 Field.

 

B1 Field Size:

          The size of the field in the SAP Business One table.

 

Examples:

Q: After the Item Synch completes, I want to create a Synch Plugin that will update the dimensions with data from a custom table to handle a conversion we need in Business One. How do I know what to use in the Netpoint.API to update these fields.

A: Using the Search Box type in the information that you know. In this example, you know that it is part of the Item synch so type Item. This will return rows related to the synching of items. From this list locate the dimensions. Using the API Class and API Property columns you will see that it uses NPPart and the Properties are Depth, Width and Height.

 

Q: I've created a synch plugin to update the name of the Contract Template once it has been added to the WebTools database. I'm using the DI API to retrieve the Contract Templates in Business One. My plugin fails stating that the Template Name is too long. I don't have access to the database server. How can I find out the maximum size of this field?

A: Using the Search Box type in the DI API property (TemplateName) that you are using to access the field in Business One. This will return the row that you are looking for. From here you can see that the maximum field size is 100 characters.

 

Upgrading from SAP Web tools 6 Service Pack 2 to zed E-Commerce 7.1.2 requires knowledge of the Web tools product and should be completed by a person that performed the implementation or is familiar with it.

Customizations made to the Web tools distributed source code files will need to be reapplied to the zed E-Commerce files, therefore some programming knowledge will also be necessary if this was done.

This document only serves as a guide and may not address every issue that could be encountered.  Please proceed with caution. 

Overview of steps:

• 1. Download and upgrade to SAP Web tools Service Pack 2(if necessary)
• 2. Uninstall SAP Web tools Service Pack 2 Installer and Synch manager
• 3. Install zed E-Commerce Installer
• 4. Copy instances.xml file to zed E-Commerce Installer directory
• 5. Open zed E-Commerce Installer and upgrade instance
• 6. Launch zed E-Commerce website and complete license key request, install received key
• 7. Install zed E-Commerce Synch manager
• 8. Copy NPSynchConfig.xml file to zed E-Commerce Synch manager directory
• 9. Launch zed E-Commerce Synch manager
• 10. Complete synchronization as normal

 

Prerequisites:

Must be on SAP Business One E-Commerce and WebCRM Service Pack 2 or later

This information is available on the about.aspx page of a web tools website  (ie. http://localhost/about.aspx)

NetPoint   2009.2.655.0

NetPoint.API   2009.2.655.0

NetPoint.CreditCards   2009.2.655.0

NetPoint.WebControls   2009.2.655.0

Web Tools Database   655

Make sure to create a test environment that is an exact copy of the live site, with B1 database and Web  tools database, and with copies of the customized files(if any)

 

Download Service Pack 2 for Web tools:

• 1. Go to http://service.sap.com/support -S number login required
• 2. Choose "Downloads" , "SAP Support Packages" , "Support Packages and Patches - Entry by Application Group" , "SAP Business One" , "SAP Business One 2007" , "SAP BUSINESS ONE WEB TOOLS 6" , "SAP BUSINESS ONE WEB TOOLS 6" , "Win32"
• 3. Choose the link in the "Download Object" column with the title "SAP Business One Web tools 6 SP02"

 

After downloading the zip file, extract the contents to the desktop of the web server and run setup.exe

 Upgrading the Web tools Installer to Service Pack 2

A message will display asking if you wish to upgrade - click yes

 

 

The upgrade will continue, stopping and starting the messaging service

After the upgrade is complete, open the Installer and upgrade the desired instance, by selecting it and clicking the Upgrade button.

 

 

The installer will create a backup of the database and web files, upgrade the database and replace all files with the latest versions

 

Click Upgrade to begin this process, when it is complete the home screen will display

 

Uninstall the Web tools Installer

Uninstall SAP Business One Web tools Installer, via Add/Remove Programs in the control panel or the Start Menu - All Programs - SAP Business One E-Commerce and WebCRM - Uninstall

Some of the files will remain in the Program Files\SAP\...\Installer directory and the website will continue to function

 

 

Upgrade to zed E-Commerce 7.1.2

Go to /softwaredownload.aspx

Username and Password is available upon request

After downloading the zip file, extract the contents to the desktop of the web server and run setup.exe

 

 

Install the zed E-Commerce and WebCRM Installer

 

If a message asking if you would like to upgrade appears, click no and ensure that neither the Installer or Synch Manager are installed

If no message appears continue with the installation of the Installer using the setup program.

You can install the installer on the web server and the synch manager on the B1 server, just as you would a normal installation of SAP Web tools.

Continue the installation...

After the setup program is finished you should see the icons for the programs you chose to install on the desktop.

 

 

Next copy the instances.xml file from C:\Program Files\SAP\SAP Business One Web tools\Installer to C:\Program Files\zedIT Solutions\zed Ecommerce and WebCRM\Installer. This file contains all the configuration data for the instance, including web files location, database connection info, and private key. We do this so that the zed E-Commerce Installer knows where the locations of these assets are, so it can upgrade them.

 

Upgrade the old Web tools Instance

Open the Installer and upgrade the desired instance, by selecting it and clicking the Upgrade button.

The installer will create a backup of the database and web files, upgrade the database and replace all files with the latest versions.

Note: If you have customized aspx or ascx files that are distributed with the product(default system files), they will be replaced with default system files that are included with the latest version.
The default system files you customized will be within the archive created in the Installer program files directory(C:\Program Files\zedIT\...\Installer). Check the release notes for a list of the default system files that have changed, and if you have changed one of those files, merge your changes into the new file. Otherwise, simply place your customized default system files back in the correct directory and overwrite the new default system files.

Click Upgrade to begin this process, when it is complete the home screen of the zed E-Commerce Installer will display.

 

License new zed E-commerce Website

It is possible to have SAP Web tools and zed Ecommerce on the same physical server, provided the licenses for both are in the BIN directory for each website.

Launch the website(default is http://localhost/zedsuite) and the license request form page should display

Complete the license request and email the license request key to support@zedit.com

Support will validate the request key and return a response key - please configure any spam filtering or blocking software to allow emails from support@zedit.com or this email may never arrive or will be delayed.

Return to website and enter response key and the site should now display.

Note: Upon entering the license response key you may get a .Net error. If this happens follow the steps below

• 1) Perform a search on the system drive (c:\) for any file with a .lic extension, making sure you include hidden files in the search.
• 2) The old SAP Web tools license file will be in a folder deep within the user profile directory called "Isolated Storage". Move(do not copy) this file to the BIN directory of the web tools website. By default this is Inetpub\wwwroot\B1Webtools\BIN. The Web tools website should still work.
• 3) Try to enter the license for zed Ecommerce again. If this fails, save the license file itself in the BIN directory of the zed Ecommerce website. (Inetpub\wwwroot\zedsuite\BIN)

 

Merge Customizations

Merge any changes from the old website files into the new website files. An archive of the webfiles from before the upgrade is within C:\Program Files\zedIT\zed E-Commerce and WebCRM\Installer

A list of changed files is published with each release of zed E-Commerce. If you have customized a file that has been changed in a patch, merge your changes into the new file. If you have customized a file that has not been changed in a patch, you may overwrite this file.

Load the website and test to make sure all customizations were correctly merged and that the website is functional.

Theme Slot Update

You may encounter an error when attempting to login to the new theme.  This is due to the addition of a new content placeholder in the commonlogin master page used to show the Express Checkout login field.  If the instance upgraded included a theme created in Web tools Service Pack 2 and was set as the default theme, or if you directed the browser to this theme you would see an error indicating the commonlogin master page does not contain this content placeholder.

To correct this issue, follow the steps below.

 

1) Open the theme details and go to the masters tab, and click on the link for commonlogin.master page

 

2)  The next window is the contents of the file, click the edit icon to edit

3)  By default, the main slot content contains the new user and login user slots highlighted below

 4)  This should be updated with the new layout, copy the:

<asp:Content ContentPlaceHolderID="mainslot" ID="mainslotcontent" runat="server">
    <table width="100%" cellpadding="3" cellspacing="0" border="0">
   <tr>
    <td width="100%" valign="top" colspan="2">
   <asp:ContentPlaceHolder ID="messageslot" runat="server"></asp:ContentPlaceHolder>
    </td>
    </tr>
    <tr>
    <td width="50%" valign="top">
    <asp:ContentPlaceHolder ID="newuserslot" runat="server"></asp:ContentPlaceHolder>
    </td>
    <td width="50%" valign="top">
    <asp:ContentPlaceHolder ID="loginslot" runat="server"></asp:ContentPlaceHolder>
    </td>
    </tr>
    <tr>
    <td width="100%" valign="top" colspan="2">
   <asp:ContentPlaceHolder ID="expressslot" runat="server"></asp:ContentPlaceHolder>
    </td>
    </tr>
    </table>

</asp:Content>

5)  When finished click save and click the Home icon in the Administration Toolbar to view the theme

6) Logout from the theme and return to /common/accounts/login.aspx the page should load successfully.

 

 

Item Remarks Content Placeholder

In version 7.1.0 of zed E-Commerce new functionality was introduced that synchronizes item remarks in Business One with a new field in zed E-Commerce called "part remarks"

This new functionality included an update to the catalogpartdetail.master template and the content placeholder must be included in this template for the item detail screen to display in the  webstore.

Any theme created in a previous version must have this content placeholder within the catalogpartdetail.master

• 1) To edit the catalogpartdetail.master page, open the theme details and click the highlighted item below

 

 

• 2) Edit the master page by clicking on the edit icon

 

• 3) Enter this code in the master page in the desired location. For example between the partcrossell and the partnotes content placeholders

<asp:ContentPlaceHolder ID="partremarks" runat="server"></asp:ContentPlaceHolder>

 

• 4) Save

 

Uninstall Web tools Synch Manager

Ensure the Synchronization Service is stopped before continuing. If a synch is in progress, let it complete and then stop the service.

Uninstall the Web tools Synch Manager, via Add/Remove Programs  in the control panel or the Start Menu - All Programs - SAP Business One E-Commerce and WebCRM - Uninstall

Some files will remain in C:\Program Files\SAP\...\Synch Manager directory

Run setup.exe and install the zed E-Commerce Synch Manager

If you are prompted to upgrade, click no and ensure that the Synch Manager is fully uninstalled

 

Launch zed E-Commerce Synch Manager

Copy NPSynchConfig.xml from C:\Program Files\SAP\...\Synch Manager to C:\Program Files\zedIT\Synch Manager

 

Open the zed E-Commerce Synch Manager and complete a normal synchronization, do not initialize synch. You might see some upgrade scripts executed and after it says "Finished Synchall" in the log the upgrade is complete.

You are now on the latest version of zed E-Commerce and WebCRM!

 

Neither the basic theme or any theme that does not include changes to the default system files will be overwritten by the upgrade process. Only when default system files(outside of the assets/common/themes/themename folder) are modified will you lose changes made to the theme.

A backup archive of every file in the folder for the website(inetpub\wwwroot\zedsuite) is made and placed in the installer directory C:\Program Files\zedIT..\Installer, so you will always have a backup of the files as they were. There is also a backup of the db made and placed in this folder as well, so any changes made to the theme in a theme slot(stored in db) will be backed up.

Also, although the upgrade replaces all files in the website folder, a list of only those files that were changed in the patch is included in the release notes. Meaning, you then only need to merge your custom changes made to default system files for the files that were changed in the patch; all others you can simply overwrite the new file with your custom changed file.

Say for instance patch 7.1.1 had an update to /commerce/cart.aspx and you have modified /commerce/cart.aspx as well. The upgrade will archive your file and replace it with the new /commerce/cart.aspx. Since this file was modified in patch 7.1.1 you should merge your changes into it.

If however, you modified /commerce/shipping.aspx and patch 7.1.1 did not change this file, you can simply place your custom shipping.aspx back, and overwrite the distributed shipping.aspx that came with 7.1.1

This document outlines the steps necessary to launch a zed E-Commerce. website. Much of this information is outside the scope of E-Commerce, and should be completed by a knowledgeable consultant with experience launching ecommerce websites.

This is not an installation document for zed E-Commerce. This document assumes you have done all the work necessary on the E-Commerce website, including licensing, synchronization of data with B1, site design, B2B or B2C logins created, catalog and categories sorted, item availability defined, price list functional, internal testing completed. For information on how to complete these steps, see the guides available as part of the E-Commerce download. It is recommended you work with a partner that has experience installing, customizing, and implementing E-Commerce.

Network Settings

* Web server on premise

1. Firewall/Router configuration

- Using Network Address Translation or Port Forwarding

i.    Forward HTTP requests on TCP/IP Port 80 to internal IP address of web server

ii.    Forward HTTPS requests on TCP/IP Port 443 to internal IP address of web server

2. dMZ established for Web server IP Addresses

- TCP Port 1433(SQL) available between web server and B1 server, regardless of location of E-Commerce database, that being on the web server(local) or on the B1 server(remote)

 

* Web server hosted with B1 server on premise

1. Firewall/Router configuration

- TCP Port 1433(SQL) available between IP Address of hosted web server and B1 server for synchronization

i.    Recommended to run in a secure tunnel(SSH) or encrypted connection using VPN

ii.   This most likely has already been done during setup of the solution to enable any synchronization between E-Commerce and B1

 

Domain Name

1.    Register desired domain name with any provider

• Network Solutions
• DirectNic
• Verisign

Note : Do not configure DNS servers or records until completed with all go live steps. This is how you make the site available to the world.

2.   You must have a domain name to complete the SSL certificate process

 

SSL Certificate

1. Generate request within IIS

2. Register account with SSL provider

• Network Solutions
• Verisign
• Thawte

128-bit regular strength will suffice

Avoid using own Certificate Server if deploying website to non-internal customers as the browser will not be set to accept the certificate as it does not trust a non-standard certificate authority

3. Install on web server in IIS

• Choose port 443 for SSL
• Consider using tertiary domain name(store.example.com) for SSL transactions

4. Enable E-Commerce for secure checkout

If the E-Commerce website will be accepting credit cards it is necessary that the billing page, where the credit card numbers are entered, be encrypted with SSL between the client(browser) and server.  The following steps will enable the billing page to be SSL secured.

i.    Within the administration, choose Layout - Webflow

ii.    Click the new icon, while Checkout is displayed in the dropdown

iii.    In the field labeled "Source page" enter "commerce/cart.aspx"

iv.    In the field labeled "Next page" enter "commerce/shipping.aspx"

v.    Tick the box labeled "Secure"

vi.    Click the save icon

vii.    Click the new icon, while Checkout is displayed in the dropdown

viii.    In the field labeled "Source page" enter "commerce/shipping.aspx"

ix.    In the field labeled "Next page" enter "commerce/billing.aspx"

x.    Tick the box labeled "Secure"

xi.    Click the save icon

xii.    Click the new icon, while Checkout is displayed in the dropdown

xiii.    In the field labeled "Source page" enter "commerce/billing.aspx"

xiv.    In the field labeled "Next page" enter "commerce/verify.aspx"

xv.    Tick the box labeled "Secure"

xvi.    Click the save icon

xvii.    You may wish to include links on the theme that take the shopper out of SSL mode, as this can be taxing on the server. Consider adding a "Return to site" link that is not HTTPS.

 

Credit Card Gateway Testing

1. Registration with approved gateway

• Authorize.Net
• Payflow Pro
• Ogone(UK)
• SkipJack

2. Configure E-Commerce with login information provided by gateway

Administration - Setup - Credit Card Gateways

Try test transactions using test credit card numbers

i.    Test numbers available from provider or use 4111111111111111 for Visa 1/2020 for expiration

Verify information in payment gateway admin

Note: E-Commerce has internal number format checking on billing page of checkout

 

IIS Configuration

* Multi-Homed

Multiple IP addresses assigned to single network device or multiple network interface(s) on single server

i.    Select IP address in website properties in IIS

ii.    Define host header details(www.example.com, port 80)

1.    Can assign more than one domain to a single IP

2.    Can be used for tertiary domains(store.example.com)

 

Single IP address assigned to single network interface
Select IP address in website properties in IIS

 

Messaging

This will configure the messaging service so that order confirmation and shipment notifications will be sent.

1. Go to Administration - Config Settings - Messaging
If using remote SMTP server, such as internal Exchange server

-          Enter the FQDN(Fully Qualified Domain Name) or IP address in the SMTP Host field

-          Enter a valid email address or account for sending mails in the SMTPAuthUsername field and if there is a password enter it into the SMTPAuthpassword field

-          Set the sleep field to the desired interval(in minutes) you wish the service to send all messages queued in the E-Commerce db

-          Tick the SendOrderDocuments and SendDeliveryNotices boxes

-          Make sure port 25 is available between web server and internal SMTP server

-          You will also most likely have to configure Exchange or your SMTP server to accept connections from the web server.

 

If using a local SMTP server

-          Some versions of Windows ship with a free SMTP server, the default Pickup directory for messages is C:\Inetpub\mailroot\Pickup. Enter this into the field MailPickupDirectory

-          There is a local system service, SMTP, that needs to be enabled for messages to be picked up and sent.

-          It is recommended that you configure the local SMTP server to use your ISP's mail server or your internal mail server as a smart host. Documentation on how to do this is included in Windows help.

-          Other settings for remote server then also apply

Also assign mail templates for invoice and shipment to the desired theme to apply the CSS found in this theme to the emails going to shoppers.

-          Administration - Layout - Mail Templates

 

 Themes Configuration

Associate domain with Theme

Administration - Layout - Theme Designer - Theme details

i.    Enter domain name in the Associated domain field

ii.    Check Default if this theme should load for first time visitors to this domain by default

iii.    This sets the %%VirtualPath%% themes variable to point to this domain

 

Final DNS configuration

When you are ready to start accepting traffic, go back to the site that you registered your domain name and edit the DNS records for the domain to point to a registered DNS server. This could be provided by your ISP, hosting provider or the domain name company itself. Do not try to use your own internal DNS server, unless you feel comfortable with the knowledge you have regarding this.

Then edit the A records for the domain and point them to the external IP address of either your hosting provider or your own public facing router. You do not need to do this separately for SSL, one A record should suffice.

You will now be accepting all traffic that comes to your registered domain. It may take up to 24-hours to propagate the information in the DNS records to the rest of the Internet. 

The latest release of zed E-Commerce and WebCRM adds new synchronization capabilities such as tax, address format, country and state definitions.

In addition, we have added options for how inventory levels are calculated, and the ability to include multiple postal codes on tax details. SAP Business One running on Microsoft SQL 2008 is now available as a database server option in the Synch Manager, as we have moved to using the 2007 DI API. This also means that SAP Business One 2005A is no longer able to synchronize with zed E-Commerce and WebCRM in version 7.1.0.

If you are an existing customer, please download today!
http://www.zedsuite.com/softwaredownload.aspx  

Contact Tom Costa for more information:

Direct: 709.722.7213 ext.216 | Toll Free: 877.722.1177
Skype: tom.costa_zedit
tom.costa@zedit.com

 

Several customers have requested the ability to make the whole zed e-commerce site secure. Currently the only built-in capability to do this focuses on specific aspects of the site such as checking out or logging in using webflow functionality.

The following plugin will accomplish this task by checking if the current page is secure and if not, redirect to the secure page. The advantage of using a plugin to do this is it can be theme specific so ThemeA can force a secure connection but ThemeB can remain non-secure.

To install, copy the plugin to the plugins folder and modify the theme to include the plugin in a new slot. The plugin does not display any HTML so the design should not be affected.

Before installing the plugin, test that the site will work under ssl. Access the site by manually typing https:// as the url and if the site loads properly then the site should be properly configured.

Potential Issues: If the ssl certificate isn't properly installed all secure requests to the page could fail and with this plugin running it won't be possible to get back to the theme to disable it. If this (or any problems) occur, navigate to the plugins folder and simply delete or rename the plugin. This will allow you to navigate the site insecurely again.

Download the zed E-Commerce for SAP Business One security plug-in here.

 

 

zedIT Solutions would like to announce the general availability of zed E-Commerce and WebCRM 7.0.2!  Download now at http://www.zedsuite.com/softwaredownload.aspx , username and password available to zedIT partners upon request.

What's New in 7.0.2

Additions

• Shipping Zones
  • A shipping zone is a customizable group of countries, states or provinces, or postal codes
  • Allows merchants to define a different shipping rate matrix to multiple groups of countries, states, or postal codes under a single shipping option
• Real time shipping quotes from FedEx
  • Each individual shipping option definition can use rate matrix or real time rate quotes from FedEx

 

Fixes and Changes

 

Service calls

• Service queues with exactly a 20 character title now synch from Business One to zed E-Commerce
• Description field on service call detail removed
• Remarks tab and page added to service call details that synchronizes with B1 - Service Calls - Remarks
• Tasks tab and page removed from service call details
• Clicking on activity detail opens new window
• Add or edit activity opens new window
• Relevant business partner and user shortcut link updated when viewing service call detail
• "Subject" field label changed to "Name" to match B1
• Service call ID and name now displayed on service call detail screen
• No longer possible to delete service calls
• Service call creation requires valid business partner

• Activity

• Link to Linked Document now points to correct page

Synchronization

• Length of UDF increased for credit card authorization code allowing SkipJack authorization codes
• Business Partner Contact synchronization does not skip subsequent contacts if first contact does not have email address or web userid and synch is set to email address or userid
• Business One default business partner payment terms no longer overridden by synchronization for non-credit card payments on B2B sales orders

Installation

• Installer no longer attempts to create new virtual directory when one with the same name already exists

Item Variant Configurator

• If multiple variant categories had the same item and one of those categories had the item as the category default but not the other, the item will now not be the default in the other
• Price calculation fixed with same item in multiple variant categories
• Variant categories now listed sorted by entered sorting value
• Item configuration no longer saved for shopper unless added to cart

Checkout

• Shipping options moved to verify page from shipping address page
• Shipping options utilize AJAX calls instead of reloading entire page
• Shipping options displayed based on zone contents assigned to shipping option, ie. FedEx Ground will display for all Canadian orders if zone assigned to FedEx Ground contains Canada

Static Pages

• Using %%VirtualPath%% within a static page to call another static page now possible

Administration UI

• Last viewed business partner shortcut link now updated when viewing service call details
• Last viewed user shortcut link now updated when viewing service call details

Campaigns

• Resolved error when using "send one copy" function in campaigns with campaign titles of 50 or more characters

Accounts and Users

• Special Pricing link on my account page does not display if currently logged in account does not have special pricing or if all special pricing has expired

Shipping Rates

• General page includes dropdown to specify real time rate option
• Definitions page allows creation of multiple "zone groups" allowing single shipping rate to have different rate matrix for different zones, or one zone uses real time rates and another uses rate matrix
• Definition active/inactive switch

Shipping Provider Details

• New shipping provider details page to specify authentication credentials to FedEx rates web service

Shipping Zone Details

• New shipping zone details screen for creating and editing shipping zones by country, state or province, and postal code
• Ability to make zone active/inactive
• Country and states "Unset" list populated from Country Definitions

 

System Requirements

 

• Windows Server 2003/2008 all editions, XP Professional, 32 or 64-bit, with IIS installed
• *SQL Server 2005/2008 all editions, 32 or 64-bit
• **Microsoft .Net 2.0 or 3.5 SP1
• SMTP service available via MS Exchange or other mail server
• SAP Business One 2005A PL42 or higher or SAP Business One 2007A SP0 PL47/SP1 PL6

*SQL 2008 can only be used for the zed E-Commerce website and not for Business One, due to restrictions within the DI API

**Microsoft .Net 3.5 contains 2.0 libraries compatible with zed E-Commerce

 

Known Limitations

 

• As of version 7.0.2 the only real time rate provider available is Federal Express. Future versions will provide support for more providers such as UPS, USPS, DHL and more
• Assigning a warehouse to a shipping option definition does not guarantee that the synchronized order to SAP will use inventory from that warehouse
• Warehouses assigned to the real time rate within a shipping option definition must contain a postal code at a minimum
• All items must have a weight to use real time rate quotes

 

API Delta

 

Class or Method	Summary	Parameters	Returns
NPAccount	Added an AccountHasSpecialPricing method that returns true if the account does have special pricing.
NPVariant	Updated the VariantPrice method to correctly filter the OrderDetail line Updated the CreateDefaultVariant method to include the variant category when it adds the part to the order.
NPOrder	Added an additional AddPart method that accepts a VariantID and updates the VariantID field in the OrderDetails table.
NPOrderDetail	Added a new database field, and public property called VariantID. This field stores the variant id of the of the parent variant category for any variant item that is added to an order. Updated the VariantDetail array to include the VariantID field. Updated the KitDetail array to include the VariantID field. Updated the Fetch methods to return the VariantID as part of the detail line Updated the Save method to save the VariantID as part of the detail line Updated the GetSaveSQL method to update the VariantID of the detail line.
NPCode	Added the GetCodeIDByValue method.
GetCodeIDByValue	Gets the ID of an NPCode using an explicit NPConnection	CodeValue The value of the code searched. CodeType The type of code searched. conn NPConnection defining a connection to the zed E-Commerce and WebCRM Database.	The ID of the NPCode, null if not found.
NPSupportContract	Updated the BindAccountContracts method to display "no active contracts available" if there are no contracts. Added the ValidContract method
ValidContract	Returns if the contract is valid for the account	contractid Contract ID to validate   accountid Account ID for the contract.   connectionString Connection string to the zed E-Commerce and WebCRM Database.	Yes/No
NPSupportWorkOrder	Added a new database field, and public property called Resolution. This field stores the resolution to a Service Call. Update the Fetch methods to return the resolution. Added a check to the Valid method to verify that a valid account was entered.

 

 

Upgrading from SAP Web tools 6 SP1 Patch 4 to zed E-Commerce 7.0.2 requires knowledge of the Web tools product and should be completed by a person that performed the implementation or is familiar with it.

Customizations made to the Web tools distributed source code files will need to be reapplied to the zed E-Commerce files, therefore some programming knowledge will also be necessary if this was done.

This document only serves as a guide and may not address every issue that could be encountered.  Please proceed with caution. 

Overview of steps:

1. Download and upgrade to SAP Web tools patch 4(if necessary)
   • Uninstall SAP Web tools patch 4 Installer and Synch manager
   • Install zed E-Commerce Installer
   • Copy instances.xml file to zed E-Commerce Installer directory
   • Open zed E-Commerce Installer and upgrade instance
   • Launch zed E-Commerce website and complete license key request, install received key
   • Install zed E-Commerce Synch manager
   • Copy NPSynchConfig.xml file to zed E-Commerce Synch manager directory
   • Launch zed E-Commerce Synch manager
   • Complete synchronization as normal 

Prerequisites:

Must be on SAP Business One E-Commerce and WebCRM patch 4 or later

This information is available on the about.aspx page of a web tools website  (ie. http://localhost/about.aspx)

NetPoint   2007.1.654.4

NetPoint.API   2007.1.654.4

NetPoint.CreditCards   2007.1.654.4

NetPoint.WebControls   2007.1.654.4

Web Tools Database   654

Make sure to create a test environment that is an exact copy of the live site, with B1 database and Web  tools database, and with copies of the customized files(if any)

 

Download patch 4 for Web tools SP1:

1. Go to http://service.sap.com/support -S number login required
2. Choose "Downloads" , "SAP Support Packages" , "Support Packages and Patches - Entry by Application Group" , "SAP Business One" , "SAP Business One 2007" , "SAP BUSINESS ONE WEB TOOLS 6" , "SAP BUSINESS ONE WEB TOOLS 6" , "Win32"
3. Choose the link in the "Download Object" column with the title "SAP Business One Web tools 6 Patch 04 (SP01) "

 

After downloading the zip file, extract the contents to the desktop of the web server and to the desktop of the Business One server, or wherever the Synch Manager is located, and run setup.exe

 

A message will display asking if you wish to upgrade - click yes
If this does not show, neither the Installer or Synch manager is installed

 

 

The upgrade will continue, stopping and starting the messaging service and or the synch service

 

After the upgrade is complete, open the Installer and upgrade the desired instance, by selecting it and clicking the Upgrade button.

 

The installer will create a backup of the database and web files, upgrade the database and replace all files with the latest versions

 

Click Upgrade to begin this process, when it is complete the home screen will display

 

Open the Synch manager and go to the Synchronization screen

Run a synchronization, do not click Initialize Synch

You may see messages in the Synch log indicating an upgrade. When the upgrade is complete you will see Finished SynchAll in the synch log

 

*Uninstall the Web tools Installer

Uninstall SAP Business One Web tools Installer, via Add/Remove Programs in the control panel or the Start Menu - All Programs - SAP Business One E-Commerce and WebCRM - Uninstall

Some of the files will remain in the Program Files\SAP\...\Installer directory and the website will continue to function

*If the Installer and Synch Manager are installed on the same computer you can uninstall them both at the same time.

 

Upgrade to zed E-Commerce 7.0.2

Go to http://www.zedsuite.com/softwaredownload.aspx

Username and Password is available upon request

After downloading the zip file, extract the contents to the desktop of the web server and to the desktop of the Business One server, or wherever the Synch Manager is located and run setup.exe

 

Install the zed E-Commerce Installer

 

If a message asking if you would like to upgrade appears, click no and ensure that neither the Installer or Synch Manager are installed

If no message appears continue with the installation of the Installer using the setup program.

You can install the installer on the web server and the synch manager on the B1 server, just as you would a normal installation of SAP Web tools.

Continue the installation...

After the setup program is finished you should see the icons for the programs you chose to install on the desktop.

Next copy the instances.xml file from C:\Program Files\SAP\SAP Business One Web tools\Installer to C:\Program Files\zedIT Solutions\zed Ecommerce and WebCRM\Installer. This file contains all the configuration data for the instance, including web files location, database connection info, and private key. We do this so that the zed E-Commerce Installer knows where the locations of these assets are, so it can upgrade them.

 

Upgrade the Web tools Instance

Open the Installer and upgrade the desired instance, by selecting it and clicking the Upgrade button.

The installer will create a backup of the database and web files, upgrade the database and replace all files with the latest versions
Click Finish to begin this process, when it is complete the home screen will display.

 

License Website

Launch the website and the license request form page should display
Complete the license request and email the license request key to support@zedit.com
Support will validate the request key and return a response key - please configure any spam filtering or blocking software allow emails from support@zedit.com or this email may never arrive or will be delayed.

Return to website and enter response key and the site should now display.

 

Theme Slot Update

You may encounter an error when attempting to login to the new theme. This is due to the addition of a new content placeholder in the commonlogin master page used to show the Express Checkout login field. If the instance upgraded included a theme created in Web tools patch 4 and was set as the default theme, or if you directed the browser to this theme you would see an error indicating the commonlogin master page does not contain this content placeholder.

To correct this issue, follow the steps below.

1) Open the theme details and go to the masters tab, and click on the link for commonlogin.master page

2) The next window is the contents of the file, click the edit icon to edit
 

3) By default, the main slot content contains the new user and login user slots highlighted below

 

4) To update the theme's commonlogin master page to include the new content placeholder, copy the code below and replace the highlighted code above with it. Make a backup of the highlighted code if you had changed it, and integrate the new slot where desired

<asp:Content ContentPlaceHolderID="mainslot" ID="mainslotcontent" runat="server">
     <table width="100%" cellpadding="3" cellspacing="0" border="0">
         <tr>
              <td width="100%" valign="top" colspan="2">
                   <asp:ContentPlaceHolder ID="messageslot" runat="server"></asp:ContentPlaceHolder>
              </td>
         </tr>
         <tr>
              <td width="50%" valign="top">
                   <asp:ContentPlaceHolder ID="newuserslot" runat="server"></asp:ContentPlaceHolder>
              </td>
              <td width="50%" valign="top">
                   <asp:ContentPlaceHolder ID="loginslot" runat="server"></asp:ContentPlaceHolder>
              </td>
              </tr>
              <tr>
              <td width="100%" valign="top" colspan="2">
                    <asp:ContentPlaceHolder ID="expressslot" runat="server"></asp:ContentPlaceHolder>
              </td>
          </tr>
    </table>
</asp:Content>

5)When finished click save and click the Home icon in the Administration Toolbar to view the theme

6) Logout from the theme and return to /common/accounts/login.aspx the page should load successfully.

Uninstall Web tools Synch Manager

Ensure the Synchronization Service is stopped before continuing. If it is running, let it complete and then stop it.

Uninstall the Web tools Synch Manager, via Add/Remove Programs  in the control panel or the Start Menu - All Programs - SAP Business One E-Commerce and WebCRM - Uninstall

Some files will remain in C:\Program Files\SAP\...\Synch Manager

Run setup.exe and install the zed E-Commerce Synch Manager

If you are prompted to upgrade, click no and ensure that the Synch Manager is fully uninstalled

Launch zed E-Commerce Synch Manager

Copy NPSynchConfig.xml from C:\Program Files\SAP\...\Synch Manager to C:\Program Files\zedIT\Synch Manager

Open the zed E-Commerce Synch Manager and complete a normal synchronization, do not initialize synch. You might see some upgrade scripts executed and after it says "Finished Synchall" in the log the upgrade is complete.