Selecting retail products page

<< Click to Display Table of Contents >>

Navigation:  Exporting data > Export wizard > ASCII text export wizard >

Selecting retail products page

The ASCII Text Export Wizard selecting retail products page allows you to determine exactly what you wish to export to an ASCII text file.  The page will look like the one below.

 

asciitextexportret1

 

 

 

This page is divided into three main sections.  They are as follows:

 

Retail product selection

Field selection

Export product costs/prices from... selection

 

Retail product selection

 

From this section you must decide which retail products you wish to export.  You can choose from the following options:

 

All products - will export all available retail products from your database                or

A Single Category - will export all available retail products assigned to a single category        or

A Single Menu - will export all available retail products within a single menu.        

 

Choose the option you wish to export. If selecting a single category or menu, use the drop lists to choose the category or menu you wish to export.

 

Field selection

 

The field selection allows you to choose exactly which details you wish to export for the selected group of retail products.

 

You can choose any or all of the following details for the retail products from the 'Recipe/Ingredients database fields' list box to be exported:

 

Name

Stock code

Product code

POS code

Production/Purchase quantity

Production/Purchase unit (name)

Production/Purchase unit (symbol)

Production cost

Unit cost

Retail cost

Retail quantity

Retail unit

Unit price (including tax)

Unit price (excluding tax)

Food cost percentage

Factor

Markup

Gross profit

Gross profit percentage

Tax rate

Tax

Category name

 

By clicking on one of the above fields you can move it to and from the 'Fields in destination file' list box.  

 

Adding a field

 

Adding a field to the 'Fields in destination file' list box will mean that this field will be exported to the ASCII text file.  

 

To add a single field, highlight the field in the 'Recipe/Ingredients database fields' list box and click the wizardaddbutton button.  This will move the selected field into the 'Fields in destination file' list box.

 

To add all fields, click the wizardaddallbutton button.  All fields available will be moved to the 'Fields in destination file' list box.

 

Removing a field

 

Removing a field from the 'Fields in destination file' list box will mean that this field will not be exported to the ASCII text file.

 

To remove a single field, highlight the field in the 'Fields in destination file' list and click the wizardremovebutton button.  This will remove the selected field from the 'Fields in destination file' list box and place it back in the 'Recipe/Ingredients database fields' list box.

 

To remove all fields, click the wizardremoveallbutton button.  All fields in the 'Fields in destination file' list box will be returned to the 'Recipe/Ingredients database fields' list box.

 

It is also possible to move the names of the fields appearing in the 'Fields in destination file' list box up or down to suit your presentation requirements.  To do this, select the field and click on the wiardmoveupbutton or wizardmovedownbutton buttons.

 

In the example below we are exporting all retail products including their name, production/purchase quantity, production cost, markup, gross profit and category name.

 

asciitextexportret2

 

 

Export product costs/prices from...

 

This section allows you to choose which sales outlet you would like to export data from. Select the relevant outlet from the droplist.  

 

An additional selection you can make from this page is whether you wish to export ingredient prices in usage units or in purchase units. If you wish to export ingredient usage units, mark the "Export ingredient prices in usage units" checkbox. If this checkbox remains unchecked, all ingredient prices will be exported using purchase units.

 

Once you have selected the fields you require to be exported and made all other relevant selections, click the "Next" button.  This will take you to the Text format page.