Posts categorized "Database Integration"

26 September 2007

Control MOM's data sync and behaviors

E-commerce merchants that operate Dydacomp's Mail Order Manager (a.k.a. MOM) can now more easily, precisely control the flow of data between MOM and their website. The Total Blue System integration with MOM goes back four years, so there's not a lot that's new in the way of raw functionality in this latest System Update. What is new and important is the introduction of a dedicated MOM configuration tab within the configuration options of Total Blue System's Admin Area.

Our objectives included:

  • Enable site owners to directly control site-wide configuration settings, managed in one place, that affect all relevant data on the site. So in contrast to the MOM configuration setting specific to one product described here, the merchant can more efficiently control data sync behaviors.
  • Make explicit and obvious to site owners and their web team the behaviors that govern the MOM integration. Now you can see exactly what's going on for product names, description, inventory, web order types, and more. And you can make adjustments directly as you work out the best solution for you.
  • Update the chart in the Help section showing data flows and behaviors for MOM and Total Blue System. This chart concerns products that exists within MOM and the web catalog.

If you don't use Mail Order Manager, then don't be concerned with this. You'll only see the new MOM configuration tab if your site has been set-up for such an integration.  E-commerce merchants using something besides MOM will prefer the API integration with Total Blue System that uses RESTful XML over HTTPS.

20 September 2007

MOM users can sync data specific to one product, or not

E-commerce merchants who use Mail Order Manager for their internal order management needs can integrate with Total Blue System, sending a daily feed of product data to the website. You can configure what data is sent and how it behaves (updates products once, or updates continuously overwriting what's there, etc.). But prior to the latest system update, you could only control this site-wide.

  • Now you can control it on a per product basis. A new "Disable Import from MOM" check box on the edit product screen in the Catalog module's Admin Area enables this feature.

Why might you want to do this?

As background, the MOM integration assumes that the product be displayable on the website, if the CANNOT SELL field in MOM is NOT checked. So, if you can sell it in MOM, it's on the website to be displayed.

Each night, the settings for the product are updated from MOM, and this includes the Displayable? field, which is nightly set to Yes. It's set to "Yes" because the Cannot Sell field is unchecked, and it's not Discontinued with inventory less than 1. These are the conditions that need be met to display the product on the website.

Would you like to hide products on the website, even though the product meets all the "sell online" conditions in MOM? Maybe because of a print catalog you must be able to take orders for the product by phone, but your website presentation of the product isn't ready yet? Or you have terms established by your suppliers that restrict on-line sell dates. Whatever the reason, here's how:

  1. Mark the product as Displayable? = No.
  2. Then check the  new "Disable Import from MOM" check box.

04 September 2007

Update more Total Blue System data via API

More data about orders and customers is now exposed to third-party developers or your internal order management system. Our e-commerce software's application programming interface (API) enables you to securely share data in a RESTful, XML format over SSL.

The latest System Update extends the ability for third-party or remote data sources to update more information about a website shopper's "My Account" and order history. This is an incremental but important enhancement to the data made available via the API.

The documentation about how to use Total Blue System's API reflects the new changes. Additional details have also been added to the documentation posted in the Admin Area of your website management tool. These details explain more about how to make the most use of the API when dealing with customer data, reflecting lessons learned by a client's third-party contract programmer who is completing a new API integration with their e-commerce website.

24 May 2007

MOM 6 database integration with e-commerce websites

Total Blue System's e-commerce package provides a data integration with Dydacomp's Mail Order Manager, known as MOM. We've upgraded this website sync process to work with the latest version of MOM, version 6. Now MOM 5 users can upgrade to MOM 6 and know that their product inventory, pricing, product descriptions, order status and more can continue to be updated automatically on their website. Likewise, web orders and catalog requests can be downloaded into MOM 6 just as before the upgrade.

Note: A number of important database fields in MOM's Foxpro database changed in version 6, and there may be implications to upgrading from version 5 that go beyond your e-commerce website. As a tip to our clients, some assistance in your upgrade may be provided you by Debra Ross of Axton Enterprises, known as a MOM guru and long-time moderator of the MOM user's group on Yahoo! This MOM mail order consultant has advised our own effort, and is likely able to make your transition easier as concerns any business reporting that's driven by data in MOM.

18 April 2007

Share data with 'best of breed' systems via Total Blue System API

Our e-commerce clients demand a great web sales channel, and want their websites to both receive and share data with their other IT systems. A new application programming interface (API)  for Total Blue System data makes it happen in a new, improved way.

The importance of an e-commerce API cannot be understated, for it's presence and sophistication enables a merchant to NOT settle for less. In a prior day and age, companies settled for an e-commerce software product that functioned less than they wanted because it held the appealing promise of product or data integration with other internal systems. Call it "best of suite." The best of suite solution didn't work in all the ways you wanted, but hey, it all worked together and shared data nicely.

We consider the "best of suite" phrase derogatory and dated. "Best of suite" in contrast to "best of breed" reflects a prior time when API integrations were either cost-prohibitive or scary unknown projects that nobody but the biggest, well-funded companies would consider. This isn't the case anymore, a fact recognized by Internet Retailer in a March 2007 article. It's a thorough examination of the opportunity, but the headline just about says it all: "Weighing technology choices: New e-commerce technology is no longer a choice between best-of-breed or single-source provider. Web integration technology makes both possible in the same installation."

In short, don't settle. Demand the best of breed e-commerce package and then expect to integrate it with your back-office order management or point of sale systems.

Here's some details about how our clients do it via an API:

Total Blue System uses the Representational State Transfer   (REST) style of API.   The Total Blue API is accessible as XML over HTTP secured with SSL.   All requests should set the "Accept" header to "application/xml". If this is not done, you may get the HTML   view of the application rather than the XML API view. Requests that POST or PUT XML data should also set the "Content-Type"   header to "application/xml" in order for the data to be interpreted correctly.

The API is protected with   Basic Authentication Scheme, using   an administrator's username and password.

The data accessible through the API is grouped into resources   published as a group of URLs where different HTTP request methods to   perform different actions listed below. Note that not all of these   actions will be available for each resource and there may be   additional actions available.

GET
Used to fetch XML information such as a list of items or an individual item.
POST
Create a new item
PUT
Update an existing item
DELETE
Destroy an item

Find more documentation in the Admin Area of your Total Blue System website management tool, under the Help section.

Note: MOM 5 and MOM 6 users are not able to make use of this API given the limitations of Mail Order Manager's data integration options.

07 March 2007

Ask or observe source of orders

Identifying the source from which you acquire a new customer -- hey, everybody wants to do that! The question of how to go about it exactly, and how precisely it can be done, well, that's not as clear cut. But here's one way within Total Blue System that you can both observe and or ask customers directly from whence they've come:

  • Create a Source,Adminarea_newsource starting within the Contacts module in Total Blue's Admin Area. See the nearby screen shot showing the Name and Code that can be configured. The Name is what you'll call it, and what can appear to shoppers on the public website.
  • The Code is relevant when your website integrates with your internal database or order fulfillment system and you want to pass in a tracking code along with the order. Note that if a shopper enters a Coupon Code during the cart check-out process, and there's no other overriding code matched according to the Sources explained here, than the coupon code will be inserted into this Code field when the order is downloaded to your order fulfillment system.
  • Sources can be configured to appear on a "How did you hear about us?" Newaccount_source question when a shopper is completing the form to create a new website account. In such a case, you're asking the customer to tell you directly by choosing from a set of possible answers. This is helpful should you advertise or be featured in a print publication, for example. It serves in cases when the only way of knowing the source is to ask people to identify their referring source.

Sometimes people choose not to identify their source. Sometimes they don't create a new website account, but choose the Express checkout option. In such circumstances, you still want to know where the order came from. In this case, better to observe directly the referring source web site. That's where the Domain Pattern configuration is useful.

  • A regular expression can be created to recognize the referring URL for a website shopper. When that domain name is marked as a source, then orders placed by visitors who were referred from those domains can have special details included in the order to identify their source. These details are imported into your internal database or internal order management system with each order.

In the example shown in the nearby screen shot, both asking and observing are inAdminarea_newsource_1 progress. The "how did you hear about us?" form is asking the shopper, and the domain pattern is watching and matching shoppers with pre-established "sources" that match the shoppers' referring URL's. Either way, you'll identify the source. 

Note: there are abilities to track the source of orders within Google Analytics that are independent of this method described here. But they can complement one another. Google Analytics is concerned with the marketer's dilemma of what can be observed about a website visitor's activities. Goals can be established and tracking codes embedded in URL's to identify sources like Froogle. 

That method is useful for slicing and dicing the data within Google Analytics, but it's not going to tie back into your order management system. Therefore the Source configuration described above ought also be given attention. If we keep the example of Froogle, the link above describes embedded tracking codes in the URL's. But what also ought be done is to configure a Source in the Admin Area for Froogle.

In the screen shot nearby, Adminarea_frooglesource   see how the Source will observe orders referred by the Froogle (or GoogleBase) shopping engine. The Domain Pattern match will identify it. However, shoppers won't be asked whether they came from Froogle when creating a new account. You're observing, not asking.

If using the Catalog module's product feed to GoogleBase, you'll want to configure a Source in the Contacts module to track sources accordingly.

02 February 2007

MOM integration gets new logging capability

The integration between our e-commerce website and clients' Mail Order Manager (MOM) order fulfillment software just got better. The data that is extracted from MOM daily (or more often) and transferred to the website usually flows automatically, reliably.

What we've introduced today is a greater level of logging to help us diagnose those instances when the data doesn't get uploaded to the website. If there's a breakdown in the normal database integration process, it's often because of something that's changed on your local area network, perhaps a security update or permissions change that has unintended consequences.

Now the component that transfers data has a higher degree of logging to track exactly what's happening, and spot exactly where a process may have broken down.

19 January 2007

MOM Connector Module becomes self-monitoring

Mail Order Manager (MOM) powers the order fulfillment process for some E-business Coach clients. If you're one of those who connect your Total Blue System e-commerce site with MOM, the reliability of that data link just got better. In fact, it got smarter.

Total Blue System's Connector Module for MOM works in this way:

Periodically data about products (descriptions, prices, orderability, inventory, etc.) and orders (status, etc.)gets pulled out of MOM's .dbf database files and compiled on your office server. Then it's encrypted in transit to your e-commerce website using a file transfer method that's scheduled to run at certain times of the day. Similarly, on your website's server, there are processes that are scheduled to run that process this newly imported data. The data updates filter throughout your website modules, and drive all kinds of functionality and display decisions that determine what your customer can see and do on your e-commerce website.

That's how it works for getting data out of MOM. The tools used in this process meet or overcome MOM's unique constraints on sharing data with other applications or across a network. Because of that fact, the tools can also be sensitive to changes on your server environment, meaning everything from operating system patches to (LAN) network permission issues to whether the power is turned on.

Here's what's been improved:

We have fortified the Connector Module programs that are resident on your office server, introducing a new monitoring component. This observes the execution ofthe standard data export program; if it detects an error, it aborts the data export and restarts it from the beginning.  With this improvement, the Connector module for MOM becomes more of a self monitoring system. The upside is a reduction in the frequency of MOM sync failures for any reason whatsoever, and a corresponding reduction in the possible need for human intervention.

22 November 2006

Release new products with precision

Introducing "what's new" in your website catalog can be an important way to recapture the interest of your existing customers. Now you can carefully time the release of new products on your website for optimal merchandising. Here's how:

You can now establish a "debut date" for each product in your catalog, which can be scheduled out into the future. Screenshot_debutdate_1 This practically means that the product becomes "displayable = yes" and "orderable = yes" within the Catalog module. To set this date, go within the Admin Area to the Catalog module, and select a product to view or edit. Select the Display Options tab to view the debut date.

 

Some ideas for how it might be used:

  • The debut date can be used to gradually unveil new products within a line of products, in keeping with manufacturer's guidelines.
  • Coordinate the display of website products to match the arrival of a print catalog by setting the debut date to match your mail drop.
  • If your website catalog is integrated with your order fulfillment software, like Mail Order Manager or Microsoft Retail Management System, then each product that's imported into the website will carry a "product creation date" that matches the time of the server to server sync that performs the integration. This date may be several weeks earlier than the product is actually made displayable or orderable on the website. This time delay may effectively overlap with the Catalog Product Default New Days configuration variable, which sets the number of days a product will be listed as a new product by default.

    So, for example, if you have set products to be marked "new" for 14 days, the countdown for this started on the product creation date -- the day you imported the product from your order fulfillment software. If it took you 12 days before you reviewed and approved the product to display on the website, it would be featured as a new product for only 2 days (14 - 12 = 2). That would hinder how visible your new product was in the several areas of your website that make use of the "product is featured as new" display option.

    Now, with this debut date feature being introduced, you can specify the day that the "new until" countdown starts from, which is now the debut date.

Urchin_whatsnew

What's one place that makes direct use of the Debut Date setting? The default "What's New" page template that is included with your software license. Look for it at http://www.yourdomain.com/new_products.php. Here's an example.

20 November 2006

Encourage more catalog requests, if you want

Would you like to encourage more catalog requests from your website's visitors? We know that shoppers who come to our clients' sites after receiving a print catalog are more likely to buy than other visitors, and spend more per visit than visitors from other sources.

Now there's one less obstacle for a site visitor to request a print catalog from your website. There's now no longer a requirement that an email address be given when requesting a catalog on your website. We've separated the Catalog Request process from the process of creating a Website Account. The website account creation process required an email address as a unique identifier. Now there's no connection between these processes, making it more likely that a catalog request won't be avoided by a website visitor for fear of giving up a sensitive email address.

Here's a couple other changes:

  • The URL to the Catalog Request page has changed, to http://www.yourdomainname.com/catalog_request.php. We've updated your site's universal navigation menus and email templates that link to this form.
  • You can now add a "Teaser" to the top of the Catalog Request page. Create a new teaser that features photos of your catalogs, along with a text description of their frequency and subject matter. Assign it to the Catalog Request "Teaser Spot" in the Teasers section of the Admin Area.

Note: If your website automatically imports catalog requests into your order fulfillment software, like Mail Order Manager, then expect this to continue. There are no changes in how this data is integrated with your other software packages.