Introduction to Get Web Orders (GWO)

[conor_harding]

WebStore orders are downloaded to the NSc client using the NSc Sync synchronization mechanism.
NSc Get Web Orders (GWO) is an RMS Store Operations POS add-on that controls and manages these WebStore orders. Once installed, it can be accessed from within Store Operations POS by clicking the Get Web Orders button:

The NSc GWO window displays unprocessed WebStore orders by default (to also show processed and cancelled orders, click the arrow beside Options, then select Filter WebOrders, then Show All). Each order is represented by a table row, and is sorted by the most recently received. By double-clicking (or pressing the Return key), an order begins the process of tendering an NSc Web Order within the RMS system.

The following order details are displayed:

Web Order Number: The unique order reference number. An e-mail containing this number is generated at order time from the store to the customer.

Customer Name: Customer name. A customer can be an existing RMS customer, or can be created within the WebStore using the registration service.

Date: The date and time the order is downloaded by NSc Sync.

Status: The status of an order, either processed or unprocessed. By default, all new orders are unprocessed. When a Web Order has been tendered through RMS, it is given a status of processed.

The Lookup Web Order Number text field at the top of the window is designed to make it easier to find a specific order. This is a useful feature, because over time NSc GWO may contain a large amount of Web Orders. As you type the order reference, the order list is filtered, enabling quicker access to the order you are seeking.

Tip: If the number of Web Orders you have received in NSc GWO becomes very large, you can trim them based on the length of time they have been in the system. To do so, in NSc Sync Configuration, select the Web Orders item from the list on the left of the window, then select the checkbox within the Web Order Trimming section. Any Web Orders that are older than a specified number of days, weeks, months, or years will be removed from the system.

If the number of Web Orders you have received in NSc GWO becomes very large, you can trim them based on the length of time they have been in the system. To do so, in NSc Sync Configuration, select the Web Orders item from the list on the left of the window, then select the checkbox within the Web Order Trimming section. Any Web Orders that are older than a specified number of days, weeks, months, or years will be removed from the system.

Clicking Cancel closes the window. Clicking OK has the same effect as double-clicking a selected order, that is, the process of tendering an NSc Web Order within the RMS system begins.

NSc GWO Options
When you click the NSc GWO Options button, the following menu items are displayed:

Filter Web Orders: Click Hide Processed to display only unprocessed Web Orders. Click Show All to display all orders in the system (processed, unprocessed, and cancelled). Hide Processed is the default filter when NSc GWO is first opened.

Set Web Order Status: Changes the status of a selected order to either Processed, Unprocessed, or Cancelled. When a Web Order has been tendered through RMS, it is given a status of processed. The ability to switch between processed and unprocessed status “manually” using Set WebOrder Status provides more flexibility when processing an order. For example, if Web Orders are mistakenly tendered (requiring a change from processed to unprocessed), or if Web Orders should be ignored and removed from the pending unprocessed orders list (requiring a change from unprocessed to processed).

Note that setting a Web Order to processed does not trigger either the sending of e-mails or the charging of the customer. It simply marks it as processed and removes it from the unprocessed list. In order for the “processed.xml” e-mail to be generated and sent, the order must also be tendered successfully in your POS.

If you set an order as cancelled, it is simply marked on the list of orders as cancelled. No e-mail is automatically sent to the customer and any previously processed transaction is not reversed.

Send Feedback: Enables the manual submission of e-mail messages from the POS user to the customer, to notify the customer of ordered items on back order. Note: In order to send feedback, NSc Mail must be set up and configured properly.

Print Picklist: Prints to a thermal receipt printer the list of items to be picked for the selected Web Order. In addition, in RMS Store Operations, if you select Reports > Custom > NitroSell - Pending Web Orders, you can generate a report that can be printed on a Windows printer.

Options: Under Options, you can select to display NitroSell licensing information, to configure the RMS database, or to automatically select the sales representative for an order.

[brian_twomey]

Multiple WebStores

Sometimes if running multiple webstores it may be useful to populate a custom text field on the customer record with the domain name of the webstore they first registered on. This can be useful for reporting/marketing purposes. To configure GWO to do this, you need to tell it what field to store the domain name in, to do this, use the following query:

To store the details in customer.customtext4 use:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘populatedomainname’, ‘customtext4’);

To disable this behavior use:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘populatedomainname’;

You can also get GWO to show a column on the weborder listing page showing the originating WebStore, to enable:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘ShowOriginWebStore’, ‘1’);

To disable:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘ShowOriginWebStore’;

Customer Options

Merging

Every time you match a customer during the GWO order processing cycle, the customer details from the WebOrder are used to update the details in the point of sale’s customer record - this is called ‘merging’. In some situations merging may not always be desirable. There’s a number of options available to control how merging is applied or even whether it’s applied at all.

GetWebOrders Merges Customers based on the following criteria (in order) :

1)Email
2)Zip
3)Phone Number
4)Last Name
First Name
5)Customer Id
6)Nitroasl Application settings

Updating of customer details can be disabled completely using the following option:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘DontUpdateCustomer’, ‘1’);

To disable this behavior use:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘DontUpdateCustomer’;

You can also configure GWO to only merge customer details if the account number for the web customer matches the selected customer in the point of sale. The default is to always merge customer details regardless of whether the account number matches or not.

To disable customer detail merging if the account number does NOT match use the following query (note: the option name is a bit of a misnomer!):

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘MergeCustomerIfAccMatches’, ‘0’);

To disable this behavior and revert to the default (always merge regardless) use: DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘MergeCustomerIfAccMatches’;

Global Customers

When used in conjunction with NitroSell Commerce for RMS HQ, GWO will always create customer as global customers. However, this functionality can be overridden regardless of the edition used. You can force GWO to always create customers as ‘global’ using the following option:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘EnableGlobalCustomers’, ‘1’);

To always create as non-global use the following:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘EnableGlobalCustomers’, ‘0’);

or to revert to default behavior (global customers created depending on edition used) use this query:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘EnableGlobalCustomers’;

Email Correspondence

GWO can be configured to send an NSc Mail email template upon the creation of a customer at the point of sale. This can be useful for sending a ‘welcome to our online shopping experience’ type email to welcome new customers and maintain loyalty.

Use the following query to enable this functionality:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘SendWelcomeMail’, ‘1’);

To disable it, use the following:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘SendWelcomeMail’;

The above option will trigger a ‘welcome’ NSc Mail template to be sent.

Back/Work Orders

GWO can be configured to automatically import a weborder as a certain transaction type. Valid transaction types are:

||Transaction Type||Type ID || ||transactiontypeSales || 1 (this is the default) || ||transactiontypeWorkOrder || 2|| ||transactiontypeQuote || 3|| ||transactiontypeBackOrder || 4||

To activate this option, you’ll need to make an insertion in to the nitrosell_gwosettings table. This can be done once - it does not need to be done on a per register/machine basis. Here’s the query you need:

Always import as backorders (transaction type = 4):

insert into nitrosell_gwosettings ([key],value) values (‘DefaultTransactionType’, 4);

Sometimes, it can also be useful to get GWO to take a percentage deposit at the time of converting to the transaction type of your choice (e.g. back/work order). e.g. apply 50% deposit by default:

insert into nitrosell_gwosettings ([key],value) values (‘DepositPercentage’, 50);

Out of stock items

GWO can also be configured to automatically convert WebOrders to a back order if it encounters items which are out of stock. To enable this functionality use the following query:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘EnableBackOrdering’, ‘1’);

To disable it, use the following:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘EnableBackOrdering’;

Cancelling Orders

By default GWO will queue a ‘cancelled’ NSc Mail Email template if a WebOrder is set as cancelled. This behavior can be prevented using the following query:

INSERT INTO nitroasl_applicationsettings ([app],[key],[value]) values (‘csf10’, ‘SendCancellationEmails’, ‘0’);

To revert to the default, simply remove the option:

DELETE FROM nitroasl_applicationsettings WHERE app=‘csf10’ and [key]=‘SendCancellationEmails’;