Horizon Online Support

    A Team - Main Catalogue Import

Download the latest catalogue import definitions, and copy them into the \Horizon\Importdefs\ folder.

Before you import the catalogue file, please check that the format is correct.

The file should be an .xls file (not .xlsx) with the following columns:

	Column	Description
A	Code	Product code
B	Description	Product description
C	VAT	VAT code, usually S for Standard
D	Pack	Pack size
E	Retail	Retail price in £x.xx
F	Sell price	Modify this field to set your sell price, if you want it to differ from Retail.
G	Cost price	Cost price in £x.xx
H	Trade price	The same as the cost price.
I	VOW code	Alternative product
J	Spicers code	Alternative product
K	Antalis code	Alternative product
L	BOSSF	5 digit code denoting range and group
M	Barcode	Reserved for future use
N	Brand	Usually Procopy
O	Manufacturer	Manufacturer of the equivalent OEM cartridge
P	Manufacturer code	OEM code
Q	Supplier	Your supplier code for A Team
R	Nett	Reserved for future use
S	Green	Reserved for future use
T	Page no	Reserved for future use
U	Page item	Reserved for future use
V	Discontinued	Reserved for future use
W	Non returnable	Reserved for future use
X	Lead time	Reserved for future use
Y	Dealer lead	Reserved for future use
Z	Matrix code	Reserved for future use
AA	Colour code	Reserved for future use

Importing your catalogue file

1. Save the catalogue to a folder on your computer, or to a location with a mapped drive.



2. Click Setup > Catalogues then, from the toolbar, Import, or Utilities > Import Product File. The Import Files window will open.



3. In the Import File list, click A Team.



4. The Import tab will already be selected.



5. In the Trader list, click the A Team supplier code. If you haven't set up A Team as a supplier, then they will not appear in this list.



6. Select the A Team Catalogue from the Catalogue list.

   Note: The catalogue box will be completed with the default catalogue set on your A Team trader.

7. If you are importing the A Team catalogue for the first time, click New Catalogue. If you are updating your catalogue, click Full Update Catalogue.



8. Lookups are configured in the import definition. The supplied import definition includes lookups for VOW, Spicers and Antalis. Under Lookups, from the supplier lists, click the corresponding supplier code.



9. In File, click the Search button and browse to where you have saved the catalogue.



10. Click Load Product File.

    Note: Once you’ve clicked Load Product File Horizon will start importing the file.
    It will also switch to the Progress tab to display the progression of the import.

11. When the import has completed, a message is displayed. Click OK.



12. Check the Errors and Duplicates tabs for feedback on the catalogue import.



13. Close the Import Files window.
14. In the Setup > Catalogues window, click the Under Test tab.
15. Identify the correct catalogue by looking at the Trader column. Right-click the catalogue and click Modify. The Catalogue window opens.
16. Update the boxes that were not completed by the import. Click OK.

Back To Horizon > Import Product Files