The Import/Export tab is used for configuring the Importing and Exporting of data from the current POS Terminal/Back Office.
This tab contains numerous sections with various settings to customise the way data is exported.
To skip to a particular section or a particular setting, click on one of the following links:
This function allows for a large amount of Stock Items and Stock Item Sales to be automatically exported for use in third-party applications that require the data.
You have the option of grouping the sales data from ‘All POS Terminals’, ‘This POS Only’ and ‘This Site Only’.
Go to: Setup > POS Terminals > Modify > Import/Export > Automatic Export Settings.
Browse to a location on your network or PC where you would like the export to be saved to.
Select if you want the files to be deleted automatically after a set period of days.
All Items – Will export all stock items to a file.
New Items Only – Will export all new stock items since the last export to a file.
New and Modified Items Only – Will export all new and modified items since the last export to a file.
Ishida ScaleLink Export – Will export the fields required for the Ishida scale labels. When selecting this option, a Price Level field is displayed which can be used to set the Price Level to use when generating the Export File for Ishida ScaleLink.
Digi Scale Export - This function enables all new and modified items to be exported to a Digi Scale Software format.
Webstore Items Only - This function will only export Stock Items that have the "Web Store" checkbox enabled in the Stock Item under "Other Options".
Avery Berkel Export - This function will export Stock Items in the Avery Berkel Export Format. This format also supports the exporting of Attribute Type "Best Before Days". For more information about configuring this format and the Attribute Type, click here.
Enter the department ranges you want (e.g. 1-3, 5, 7-12).
Select an Attribute Type that you want to export (e.g. Container Type, Country of Origin, Wine Varietal), or leave as blank to export all Attribute Types
Enter the time you want the stock items to be exported each day, or enter a number of minutes into the "or every # minutes" field to have the file exported using the entered interval.
Enter the name you want to use for the file once it has been exported.
You have the choice to add the Date/Time, Site Name and/or Venue ID to the filename.
Select this option to append the Date and Time to the end of the filename.
By enabling this option, each time Stock Item data is exported from Idealpos, the filename will be unique and previously exported data will not be overwritten, enabling you to open the export file for a specific date/time.
If the "Delete files older than # days" option is configured and enabled, exported data will be stored in the Export folder for the number of days that have been entered.
Select this option to append the Site Name to the filename.
The Site Name can be configured by going to: Back Office > Setup > Sites > Select Site from the list > Modify > Enter Site Name into the Description field.
The Site Name in this description field will be appended to the filename when the "Append Site Name to filename" is enabled.
Select this option to append the Venue ID to the filename.
The Venue ID is retrieved from the Venue ID field configured in Setup > Global Options > General > Venue ID.
Note that the Venue ID in Global Options is also used for Liquor File/Price Book, so if you decide to configure or modify this setting and you are also using the Liquor File or Price Book functionality, ensure that it won't clash with your Liquor File or Price Book.
Select the checkbox to Include Discontinued Items in the file.
Select the checkbox to use the Saved Automatic Export Format.
The Saved Automatic Export Format can be configured by going to Utilities > Export Data > Stock Items > Automatic Export Format.
Select this checkbox to only include Scale Items in your exported data.
The Scale checkbox in a Stock Item determines whether or not the Item is a Scale Item.
Go to: File > Stock Control > Stock Items > Open Item.
Toggling the Scale checkbox will control whether the item is a Scale Item.
The Stock Items screen can also be filtered by Scale Items by entering "Y" into the Scale column of the Stock Items search screen.
Use the drop down menu to select a format.
The following options are available from the dropdown box:
There are three different choices to choose from:
All POS Terminals – Will export data from every terminal connected on the network.
This POS Only – Will export data from a single terminal that this is set on. If you want to collect data from more than one terminal, you will need to add these settings to all other terminals.
This Site Only – This will export data from the Site that this POS Terminal is connected to on the network.
Enter the time (in 24 hour format) you want the export to take place each day, or enter a number of minutes into the "or every # minutes" field to have the file exported using the entered interval.
Note that all sales performed up to the time of the Export are included. The Export does not use the End of Day time to determine which sales to send.
If using the export every x minutes, ensure that the export daily at is set to blank, or if using export every x minutes, ensure export daily at is set to blank.
When exporting every x minutes, all the sales that were performed between the previous export and the next interval will be exported.
If sales do not take place between a period of time that spans the entire interval, then an export file will not be generated. Once sales do take place, they will be exported during the next interval.
Field # | Field Name | Field Description |
1 | Cons | This is an audit # which is unique for a transaction per POS terminal. |
2 | POS | This is the POS Terminal #. |
3 | Line | This is the Line number inside the transaction. The Combination of Cons, POS and Line will be unique across the whole system. |
4 | Date | Date/Time Stamp of the transaction. (dd MM yyyy HH:mm - e.g. 31 Aug 2012 13:51) |
5 | Stock Code | 16 character unique stock code |
6 | Text | Usually holds descriptor of stock item, occasionally with extra information |
7 | Price Level | Integer 0 to 12 - holding the price level the item was sold at |
8 | Item Qty | Quantity sold |
9 | Unit Price | Unit Price of item before any discounts applied. (Includes Tax if not Canada) |
10 | Amount | Total Price of items before any discounts applied. (Includes Tax if not Canada) |
11 | Tax Label | Usually GST or FRE |
12 | Tax Amount | Amount of Tax included in the Price |
13 | Discounted Amount | This is the actual Amount the items were sold for after the discounts were applied. |
14 | Cost | Average Cost Price of Stock Item at the time it was sold. |
15 | Site | Integer holding the Site or Store Code. |
16 | Location | Integer holding the Location or Area Code. E.g. Bottle Shop/Restaurant/Bar etc. |
17 | Customer | 10 character code indicating a Customer. This field can be empty. |
18 | Clerk | Integer holding the Clerk code that processed the transaction. |
19 | Department | Integer used to Group the Stock Items into particular departments. |
Below is a visual example of the text file that will be created by the export.
This format will export a ‘Stock Items’ file and a ‘Customers’ file.
Field # | Field Name | Field Description |
1 | AUDIT | This is an audit # which is unique for a transaction per POS terminal. |
2 | POS | This is the POS Terminal #. |
3 | LINE | This is the Line number inside the transaction. The Combination of Cons, POS and Line will be unique across the whole system. |
4 | DATE | Date/Time Stamp of the transaction. (dd MM yyyy HH:mm - e.g. 31 Aug 2012 13:51) |
5 | STOCKCODE | 16 character unique stock code |
6 | DESCRIPTION | Usually holds descriptor of stock item, occasionally with extra information |
7 | PRICELEVEL | Integer 0 to 12 - holding the price level the item was sold at |
8 | QUANTITY | Quantity sold |
9 | UNITPRICEBEFOREDISCOUNT | Unit Price of item before any discounts applied. (Includes Tax if not Canada) |
10 | TOTALPRICEBEFOREDISCOUNT | Total Price of items before any discounts applied. (Includes Tax if not Canada) |
11 | TAXLABEL | Usually GST or FRE |
12 | TAXAMOUNT | Amount of Tax included in the Price |
13 | DISCOUNTEDPRICE | This is the actual Amount the items were sold for after the discounts were applied. |
14 | COST | Average Cost Price of Stock Item at the time it was sold. |
15 | SITE | Integer holding the Site or Store Code. |
16 | LOCATION | Integer holding the Location or Area Code. E.g. Bottle Shop/Restaurant/Bar etc. |
17 | CUSTOMERCODE | 10 character code indicating a Customer. This field can be empty. |
18 | CLERK | Integer holding the Clerk code that processed the transaction. |
19 | DEPARTMENT | Integer used to Group the Stock Items into particular departments. |
Below is a visual example of the text file that will be created by the export.
This Export Sales Format can be used to export data in a format that can be imported into an Excel Spreadsheet and viewed as a Pivot Table.
To configure the Pivot Table Export, configure the Export Sales Format as follows:
As the configuration and usage of the Pivot Table data in Excel is extensive, this is listed on a separate page.
Click here for information on how to configure the Pivot Table Data in Excel.
CODE, LASTNAME, FIRSTNAME, MIDDLENAME, TITLE, ADDRESS1, ADDRESS2, SUBURB, STATE, POSTCODE, PHONE, MOBILE, FAX, EMAIL, GENDER, COMPANY, OCCUPATION, MARITALSTATUS, DOB, DOB2, NEXTOFKIN, CONTACTNO, COMMENTS1, COMMENTS2, TYPE, PASSWORD, MAILOUT, ACCOUNT, CREDITLIMIT, PRICELEVEL, ABN, POINTS, SCAN, SALESPROMPT, UDTEXT1, UDTEXT2, UDTEXT3, UDTEXT4, UDTEXT5, UDTEXT6, UDTEXT7, UDTEXT8, UDTEXT9, UDTEXT10, UDYESNO1, UDYESNO2, UDYESNO3, UDYESNO4, UDYESNO5, TYPEDESCRIPTION.
Below is a visual example of the text file that will be created by the export.
This function enables all new and modified items to be exported to a Digi Scale Software format.
Code, ScanCode, Price1, Description, WeightType
Price will be overwritten with any current Special Prices otherwise Price 1 is used.
WeightType is 1 for Fixed Price items, 2 for items with KG or LB in the Unit field.
Go to Setup > POS Terminals > Modify > Import/Export > Automatic Export Settings > Export Stock Items: Digi Scale Export.
This function allows for a large amount of Stock Items and Stock Item Sales to be automatically imported as soon as the file is present.
This usually happens within about a minute of the file being placed in the folder.
Go to Setup > POS Terminals > Modify > Import/Export > Automatic Import Settings.
Select if you want the files to be deleted automatically after a set period of days.
Browse to a location on your network or PC where you would like the export to be saved to, or where the Import will be pulled from.
Delete files older than # days - To delete files older than a specified number of days, enable the checkbox and specify the number of days that you want files deleted from the Import folder.
Delete files after Importing - To delete files after they have been imported into Idealpos, enable this checkbox.
Enter the name of the file you want to import.
If Imported items exist, update selling prices - Enable this checkbox to update Selling Prices if the Imported Items already exist in the system.
Enter the filename of the promotions file that you want to import.
The file format/filename extension supported for promotions is CSV or TXT; ensure that you specify the filename extension within the filename field.
In order for the promotions file to be imported successfully, the data within the file needs to be formatted as per the format that is outlined on the Import Promotions page.
An example of an Import Promotions Filename would be 'PROMO.TXT', 'PROMO.CSV'.
When a file matching this filename is dropped into the Import Folder location, it will be processed and imported automatically by Idealpos.
This function is used to configure the importing of Supplier Invoices into Idealpos.
Automatically Import Supplier Invoices - Enable this checkbox to automatically Import Supplier Invoices into Idealpos.
Supplier Invoices will be imported from the Import Folder location that has been configured in the Import Folder under Automatic Import Settings.
Retrieve Location from Filename: Most Invoice filenames will consistently have a similar filename format where the Location and Supplier will reside in the same place within the filename.
Therefore, the below settings can be used to configure Idealpos so that it will retrieve the Location and Supplier from the Invoice filename.
Example Filename: BCM - ABC Inv 12345.xlsx
In this filename, the Location is BCM and the Supplier is ABC.
So in order to retrieve these details from the filename, we need to configure the settings as follows (note that any setting listed below without a value is simply a field that has been left blank and also take note of settings which contain a hyphen "-").
Retrieve Location from Filename - Right of:
Retrieve Location from Filename - Left of: -
Retrieve Supplier from Filename - Right of: -
Retrieve Supplier from Filename - Left of: Inv
If a Supplier is linked to the Generic2 type, the below rules will apply when importing Stock Items from an Invoice via the Import Items Only Folder.
If the Supplier is linked to the Generic type, then the Description, Department and Price 1 are updated regardless.
Update Description: If a Stock Item is imported via the "Import Items Only Folder" and this checkbox is enabled, then the description will be overwritten by what is in the invoice.
Update Department: If a Stock Item is imported via the "Import Items Only Folder" and this checkbox is enabled, the Stock Item Department will be updated with what is in the invoice.
Update Sell Price: If a Stock Item is imported via the "Import Items Only Folder" and this checkbox is enabled, the Stock Item Sell Price will be updated with what is in the Invoice.
Note that if a POS Terminal is locked to a specific Price Level, only the locked Price Level will be modified, otherwise all Price Levels will be set to the Imported Price.
Automatically Process Invoices after Import Complete: Enable this checkbox to Automatically Process Invoices after the Import is completed. If this is option is unchecked, invoices can be manually processed by going to Transactions > Stock Control > Stock Purchases
Import Items Only Folder: This function is used when you only want to import items from an invoice without processing the invoice itself. Place the invoice into the location that is configured in this setting, then Idealpos will skip the importing of the Invoice and will only import the items from the Invoice.
This function allows you to set the Sales Export Time for Liquology.
Note that the PriceBook Interface can also be used to Import Special Prices.
In order to use the PriceBook function to import Special Prices, the Liquorfile module needs to be added to the licence.
See PriceBook Interface - Import Special Prices for more information about using this function.
This function allows you to configure Idealpos to download invoices from Metcash Retail Web Services (such as ALM v8 XML Invoices).
The entire process for configuring this functionality is outlined in the ALM v8 XML section within the Stock Purchases topic.
Enter the credentials supplied by Metcash into the following fields:
Note!
Once an invoice has been downloaded from Metcash Retail Web Services, it will be marked as being downloaded on the Metcash servers and will not download a second time.
If all Metcash Invoices need to be re-downloaded for any reason, the User-Defined Option outlined below can be created.
Warning!
Creating this User Defined Option should only be temporarily done and will result in ALL PREVIOUSLY DOWNLOADED INVOICES BEING RE-DOWNLOADED AGAIN FROM METCASH RETAIL WEB SERVICES!
All previously downloaded invoices will be re-downloaded at the interval configured (Daily at HH:MM or every X minutes).
Use caution when using this User-Defined Option!
Go to: Back Office > Setup > POS Terminals > Select POS Terminal > Modify > POS Settings tab > User-Defined Options:
Description: METCASH-DOWNLOADALL
Setting: 1
This functionality is only available for use when the IBA registration is in the registration of the terminal.
Note!
When using the IBA Interface, the output folder for exported data is hard-coded as:
ProgramData\Idealpos Solutions\Idealpos\IBA
Go to Setup > POS Terminals > Modify > Import/Export > IBA Interface.
Daily Import/Export Time:Enter the time to perform the function in 00:00 format.
Username: IBA will issue you a username.
Password: IBA will issue you a password.
Import Promotions:Select to have the promotions imported. In Idealpos v8 Build 12 and newer, if an IBA Promotion is imported that contains promotions which already exist in Idealpos, those promotions in Idealpos will be overwritten (e.g. if a Promotion file is imported with a set of Promotion Start Dates/End Dates, Prices, etc. then another IBA Promotion file with the same promotions but different Start Dates/End Dates/Prices is reimported again, those changes will overwrite the existing promotion records in Idealpos).
State Code:Enter the code given by IBA.
Store Code: Enter the code given by IBA.
Zone:Enter the details given by IBA.
POS Range: Enter the range of POS terminals the promotions will affect. E.g. 1,3,5-7, 10.
Promotion Group:Enter the Promotion Group used in Idealpos.
Exclude Batch:Allows you to exclude specific zone areas when importing promotion files from IBA. You need to add the characters that designate which zone areas you want to exclude. You can exclude from either Z1, Z2 or any other zone areas specified by IBA. If you need to exclude multiple zone areas/batches, this can be done by listing the areas you want to exclude separated by a semicolon. E.g. Z1;Z2. This field can also be used to exclude Promotion Program Groups (e.g. PLAT to exclude Platinum Program Promotions).