Horizon Online Support
JGBM - 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 is named catalog.csv and has the following columns:
|
Column |
Description |
| A |
Product ID |
Product code |
| B |
productName |
|
| C |
productDetails |
|
| D |
productDescription |
|
| E |
Category |
|
| F |
Manufacturer |
|
| G |
Type |
|
| H |
priceExVat |
|
| I |
Weight |
|
| J |
Dimensions |
|
| K |
sort |
|
| L |
sort2 |
|
| M |
imageThumb |
|
| N |
imageFull |
|
| O |
bossCode |
|
| P |
JGID |
|
| Q |
stockLevel |
|
| R |
aText |
|
| S |
OEM_SKU |
|
| T |
Spicers |
|
| U |
Kingfield |
|
| V |
barCode |
|
Importing your catalogue file
- Save the catalogue to a folder on your computer, or to a location with a mapped drive.
- Click Setup > Catalogues then, from the toolbar, Import, or Utilities > Import Product File. The Import Files window will open.
- In the Import File list, click JGBM.
- The Import tab will already be selected.
- In the Trader list, click the JGBM supplier code. If you haven't set up JGBM as a supplier, then they will not appear in this list.
-
Select the JGBM Catalogue from the Catalogue list.
Note: The catalogue box will be completed with the default catalogue set on your JGBM trader.
- If you are importing the JGBM catalogue for the first time, click New Catalogue. If you are updating your catalogue, click Full Update Catalogue.
- Lookups are configured in the import definition. The supplied import definition includes lookups for VOW and Spicers. Under Lookups, from the supplier lists, click the corresponding supplier code.
- In File, click the Search button and browse to where you have saved the catalogue.
-
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.
- When the import has completed, a message is displayed. Click OK.
- Check the Errors and Duplicates tabs for feedback on the catalogue import.
- Close the Import Files window.
- In the Setup > Catalogues window, click the Under Test tab.
- Identify the correct catalogue by looking at the Trader column. Right-click the catalogue and click Modify. The Catalogue window opens.
- Update the boxes that were not completed by the import. Click OK.
Back To Horizon > Import Product Files