Versions Compared

Old Version 22

changes.mady.by.user Documenter

Saved on

compared with

New Version Current

changes.mady.by.user Documenter

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

This feature requires may require some implementation by Commerce Vision. 


Overview

Order templates are created from prepared csv files uploaded to the website by administrators. They Template Maintenance provides CMS/Website Administrators 'backend' access to all order templates that have been uploaded for or created by your customers. Order templates contain lists of products ('order lines') regularly reordered by either on a Customer account or by a user. The user Users can easily edit the products required and copy them the order lines to their shopping cart. If a template is linked to a Customer account, purchasing users on that account can access an the order template if their Role has ordering rights. Otherwise, it is accessible available only by the named user(s). Template Maintenance provides CMS/Website Administrators access to all templates that have been uploaded. They  


At the backend, order templates are created from prepared csv files uploaded to the website by administrators. You can decide on the basic settings, e.g., should there be fields for cost centre info or notes, for the template. Existing order templates can be viewed, edited and deleted here.


(NOTE - Users can also edit and remove templates they have access to Depending on access levels and template settings, and user role, users can edit order lines in individual templates. They can also remove user templates they created themselves as well as company templates created by other users that are set to allow deletion by all users. See: Order Templates.)      


Example

Here is an example of an order template. The template looks similar to the a shopping cart page. However, But it contains saved order lines of selected products, each with a set reorder quantity, last checked price, and any system (ERP) discount (if enabled). Depending on how a the basic template has been set up for the Customer or User, other fields such as for cost centre information and notes, may also be included. 



Panel

On this page:

Table of Contents



Set up Order

Templates

Template Maintenance

This step may have been implemented by Commerce Vision. If you can see the 'Template Maintenance' and 'Order Templates' menu items, go to Create an Order Template.

Note
iconfalse
titlePrerequisites

The following These two pages need to be added as an Administrator's menu item on your website and in the CMS. Add to the website first, then in the CMS. For instructions, see: Add a New Menu Item and Add a page to the CMS menu. 

  1. Import Templates (zImportTemplates.aspx) 

  2. Template Maintenance (zTemplatesMaintenance.aspx)


Once these the pages are added, you can access Template Maintenance on the CMS navigation menu. You can also access it while logged into the website. NOTE - The locations of these menu items will depend on where they have been added. In the example, they have been added to the 'E-Commerce' submenu in the CMS.


Anchor
create
create

Create an Order Template

This step is for Admin users to create and upload an order template. If a Role for a Customer has been enabled for Order templates are csv files that have to be createdTemplates, applicable users can create their own order templates. 


At the backend, an order template is created and uploaded through a CSV file. The first row of the CSV file will list the fields you need must contain the field names needed for the template. Each subsequent additional row contains a product data, e.g.,product, quantity, user, customer, etc, for the reorder template. Some fields are mandatory. If not present, the upload will display an error.

You can download this example template with all mandatory fields and add data rows as needed:. You can also add optional fields to it.

View file
nameOrder_Template_1.csv
height250


Example

This is an example with all mandatory fields and two rows of data. 



Info
titleField Information

Mandatory fields

ProntoSalesOrderLine.SolLineType,  SoCustCode, SoCustReference, SoUserIdCode, CompanyTemplate, AllowTemplateBillTo, ProntoSalesOrderLine.StockCode, ProntoSalesOrderLine.SolOrderedQty

Optional fields

ProntoSalesOrderLine.CostCentreCode, ProntoSalesOrderLine.SolLineDescription, UserRoleWhenOrderTemplate


Field Descriptions:

FieldValueComment
ProntoSalesOrderLine.SolLineType

Line type. 'S' = Stock; 'N' = Note

S is used for a product order line.
SoCustCodeCustomer Code this template is forUnique code of customer this template is linked to.
SoCustReferenceTemplate nameUnique name that describes the template. Template of the same name as for existing one can be used to overwrite. 
SoUserIdCodeUser IDUnique User ID login.
CompanyTemplate'Y' or 'N'.Y if this is a company template. If N, this template will be a user template. See: Configure Company Template options.
AllowTemplateBillToAllow bill to? Enter 'Y' or 'N'.Y only if this feature is enabled for the Customer.
ProntoSalesOrderLine.StockCodeProduct codeUnique code that identifies a product.
ProntoSalesOrderLine.SolOrderedQtyDefault quantityQuantity displayed when template is first accessed.


Optional fields:

FieldValueComment
ProntoSalesOrderLine.CostCentreCode

Cost centre code

The Cost Centre feature must be enabled and configured for the Customer.
ProntoSalesOrderLine.SolLineDescriptionProduct noteAdd an input field for each order line to allow entry of notes.

Anchor
role
role
UserRoleWhenOrderTemplate

Role name. Enter an existing

role

Role or 'None'. This allows templates to be limited to the Users in a specific Role.

The Allow Role Based Order Templates flag for the Role must be enabled. 

  1. Go to Users → Role Maintenance.
  2. Click the radio button next to the required Role.
  3. Click the Functions tab. 
  4. Click Modify.
  5. Tick the checkbox for Allow Role Based Order Templates.
    Image Added
  6. Click OK.

Both company and user templates can be saved for a specific Role.

Image Added



Info
titleAdding Whole Order Note Lines

Contact Commerce Vision to implement this non-standard note input feature. Once implemented, you can add whole order note lines in various places on the page. They can also be used for inserting breaks or as headings in the template.


To create a whole order note line (instead of a product line), override the normal product line processing using the following format. They can also be used for inserting breaks or as headings in the template. 

Instead of a product (stock) line, enter the following: 

Line Type [ProntoSalesOrderLine.SolLineType] (Enter 'N'), Customer Code [SoCustCode], Template name [SoCustReference], User name [SoUserIdCode], Product Note [ProntoSalesOrderLine.SolLineDescription]


Import an Order Template

You must have the order template CSV file ready for upload. 


  1. In the CMS, navigate to Orders → Order Templates. (NOTE - 'Order Templates' may have been named something else, e.g., 'Import Templates'.)
    Image Modified

  2. To upload the order template csv file, click Choose File.
    Once the file is selected, to import the template, click

  3. At the bottom of the page, select either New/Replace existing template (default) or Append to existing template. 'New/replace' will overwrite a template with the same name. 'Append' will add any new rows to the existing file.
    Image Added
  4. Click Import Now. 
    Image Added

    Success and/or error messages will be displayed in the dialogue box on completion of the import.  

Image Removed

Tip

There are actually two file formats accepted by the import program. The format shown above will include a note input area within each product line.

However, some organisations prefer the note lines to be separate to the product lines. To achieve this, simply add a column at the start of the file for ProntoSalesOrderLine.SoILineType (N for Note line, S for Stock line). 

Maintain an Order Template

Once a template has been uploaded, product information
  1. NOTE - Upload can also be partially successful. Just check 'Successfully Inserted' for the number of lines added and skipped. 
    Successful
    Image Added
    Unsuccessful
    Image Added


Edit Contents of an Order Template

An order template can be edited in the CMS or on your website. NOTE - Users Depending on settings, users with access to a template can also edit it through their Dashboard menu. 

  1. In the CMS. go to Orders → Template Maintenance.

  2. Enter the Customer Code you wish to edit templates linked to the template for, then click Search. TIP - To display all templates on your website, just click Search without entering anything.
     
  3. Select the customer by clicking To select a customer, click its radio button. 

     
  4. The list of templates for that customer account will load. Click View against next to the required template.


  5. Edit the template as needed. You can edit quantities, resequence product order lines, delete products and add other products.
     
  6. You can also update the template to display the latest prices for listed products. To update prices, click 'Click Here'.
     

  7. Click Save Template Changes at the bottom of the grid.


Anchor
company
company

Configure Company Template Options

An order template can be saved as a user or company template. A user template can only be accessed, edited and used by the template creator (or if created by the Admin, the user named). A company template can be accessed by all users on the same Customer Code (if they have a Role that allows Order Template access). In the Saved Order Templates list, the Template Type is specified. 

Image Added



One of two usage options for Company Templates must be configured for each Customer user. Option 2 allows more permissions for non-creator users.

OPTION 1OPTION 2

User can create, view and use company templates.

User can delete a company template only if they created it.

User cannot save changes to company templates.

User can create, view, use and save changes to company templates.

User can delete any company template.


Note

To allow an order template to be saveable as a Company Template, at a minimum, the "Allow Creation of Company Order Templates" must be enabled on a Customer and User Customer records.

For both options:

  1. In the CMS, go to Users →  Customer Maintenance.

  2. Use the Search tool to find the Customer, and click the radio button next to it.
    Image Added
  3. Click the Customer Details tab.

  4. Click Modify.
    Image Added

  5. Scroll down to Allow Creation of Company Order Templates and tick the checkbox.
    Image Added
  6. To save, click OK.

  7. Go to Users → Advanced User Maintenance.

  8. User the Search tool to find the Customer Code. All users on this account are listed.
    Image Added 

  9. Click the radio button next to the user. 

  10. Click Modify.

  11. Select the Accounts tab.

  12. If the user is on more than one Customer account, make sure the same customer is selected.

  13. Click Modify.

  14. On the Limits tab, click Edit.

  15. Tick Allow Creation of Company Order Templates .
    Image Added
  16. Click Update.
This completes configuration for OPTION 1. 

Note

For Option 2, the "Allow Modify Company Templates" must be enabled on the User record.

For Option 2, there is one more setting.

  1. Go to Users → User Maintenance.

  2. Use the Search tool to find the user.

  3. Select the radio button next to the user.
  4. Click Modify.

  5. Scroll down to Allow Modify Company Templates and tick the checkbox.
    Image Added
  6. Click OK.

This completes configuration for OPTION 2. 


Info
titleLimit to Role

To limit a company order template to specific Roles, add the optional field UserRoleWhenOrderTemplate and enter the Role code in each data row. A company template restricted to a Role will display both 'Company Template' and 'Role Template' in Template Type in the user's order template list.

Image Added 


Allow user access to order templates

To allow the end user access to Order Templates, you will need to add the page 'OrderTemplates.aspx' must be added to their roleRole's Dashboard menu. When access is granted, Order Templates is a Dashboard menu item.

Image Removed Image Removed

See: Add a menu item. NOTE -  Users with access to this functionality can also create and manage order templates themselves. For user assistance on using order templates, see: Order Templates.

Image Added

                          

Edit Template Options & Text Displayed to User

The Order Template page template displays order templates to users on your website. You can edit the widgets that control display and text/label options on this template.

Order Template page

General template options are rendered by the Order Templates Widget.

  1. In the CMS, go to: Content → Content → Pages & Templates → Orders → Order Templates Page. 

  2. Click Edit for Order Templates Page.

  3. In the template, click Edit next to Order Templates. 
    Image Added
For a guide to display options, see:  Order Templates Widget.

Order Line section

Order Line level options and styling, e.g., cost centre and notes input fields, are rendered in the Order Templates Line Info template.

  1. In the CMS, go to: Content → Content → Pages & Templates → Orders → Order Template Lines Info. 

  2. Click Edit next to Order Template Lines Info.

  3. In the template, click Edit next to the relevant widget.
    Image Added 
    Which widget?


Related help

Content by Label
showLabelsfalse
showSpacefalse
excludeCurrenttrue
cqllabel = "order-template"

Content by Label
showLabelsfalse
showSpacefalse
titleRelated widgets
excludeCurrenttrue
cqllabel = "widget" and title ~ "'Order Template'"