Back Office > Administration > SQL Tools > Import & Export > Export Price Book Data
 

To Import Price Book data select Back Office >Suppliers > Supplier Electronic Trade v2

Description

This menu option is used to export Product and Pricing data, in the form of a Price Book, that can then be used at another site. For file format information ...

Export Operation

Used to export Product and Pricing data that can then be imported into another SwiftPOS database.

1. In SwiftPOS Back Office > Administration > SQL Tools > Import & Export > Export Price Book Data select Export Price Book Data. The following screen will be displayed:
    

2. The Price Book Data files generated are as follows:

1. TMPB_BARCODE.txt - Barcodes always have leading zeros, so if you open this file in Excel, you have to format the barcode file as text before you save the file, otherwise you will lose your data.
2. TMPB_CATEGORY.txt
3. TMPB_GROUP.txt
4. TMPB_MANUFACTURER.txt
5. TMPB_MASTERGROUP.txt
6. TMPB_PRODUCT.txt
7. TMPB_PROMOTION.txt
8. TMPB_SUPPLIER.txt
9. TMPB_SUPPLIERITEM.txt

3. For file format information ...
4. These can now be imported into another SwiftPOS database using Suppier eTrade v2 > Generic Import option.

Import Operation

Used to import Product and Pricing data that has been exported from another SwiftPOS database or imported from via a SwiftPOS supported Interface.

1. In SwiftPOS Back Office > Suppliers > Supplier eTrade v2:
1. Select the Folder that contains the SwiftPOS Price Book TXT files. The Folder should contain the files; TMPB_CATEGORY.txt, TMPB_GROUP.txt, TMPB_MANUFACTURER.txt, TMPB_MASTERGROUP.txt, TMPB_PRODUCT.txt, TMPB_PROMOTION.txt, TMPB_SUPPLIER.txt and TMPB_SUPPLIERITEM.txt
2. In the Generic section, select the Import (TXT) button.
3. Respond to the following prompt:
    

4. Once the import has completed, select:
    
1. The Match Products tab:
    
1. Existing Products matched as a result of the Import process will contain values in the Host ID & Description columns.
2. Existing Products NOT matched can be manually matched using the Match button and selecting one of the drop down list options or manually matching them using the drop down list in the Host ID column. Note : When importing an IBA file, it is recommended to ONLY use either the Match by Barcode or Match by Supplier code options. Do NOT use Match by Product Code.
3. Once matching has been completed, select the Commit button to commit the matched Products and ensure the SwiftPOS Product' s IBA Scan Code field updated with the matched Host ID. Note : Without the Product' s IBA Scan Code field populated, IBA Product related sales data will not be exported.
4. A prompt similar to the one below will be displayed confirming the result:
    

2. The New Products tab:
    
1. New Products will be listed in the grid. Optionally, the number of Products displayed in the grid can be reduced by using the filters available in the Header section.
2. Select individual Products using the Selected checkbox option (LHS) or by using the Select All option.
3. Once all required Products have been selected, select the Commit button to ensure that all selected new Products are added to the SwiftPOS Product range.
4. A prompt similar to the one below will be displayed confirming the result:
    

5. After importing confirm the matched Products' Host ID and ensure any Costs and Prices are updated where required.

5. Select Close to exit the Supplier eTrade v2 screen.
6. The following confirmation prompt maybe displayed:
    

Related Topics

1. Data Export
2. Import/Export Overview
3. Installation
4. Import Price Book
5. Importing Price Book data using Supplier Electronic Trade Version 1.
6. Reseller Help - For Importing Photos/Images information
7. SwiftPOS Price Book