Importing a Catalogue File

Importing a Catalogue File

NewsXpress / GNS / ANCOL / Newspower have the ability to provide you with a catalogue file that negates the need for you to set it up manually. These catalogue files can save you tremendous amounts of time during busy trading periods such as Back to School and Christmas.

Importing a Catalogue provided by Newsagency supplier

  1. Save the catalogue file from your email to a location that is easy to access, such as Desktop.
  2. Then from the main screen of Retailer, go to Utilities → Import/Export Files → Import Catalogue File.
  3. In Catalogue, select the catalogue that you wish to import into.
    If your catalogue is not listed here, then press [Insert] on your keyboard to create a new catalogue.
    1. Enter the catalogue name in Catalogue.
    2. Enter the Catalogue Start Date.
    3. Enter the Catalogue Stop Date.
    4. You can also enter the Start Time and Stop Time for each day.
    5. Click on Save.
  4. Select the appropriate Supplier.
  5. Select the Initial Department.  This is used when a new stock item is added.
  6. Select the Initial Category.  This is used when a new stock item is added.
  7. Tick Use Pick-Up Price to use the pick-up price.
    Otherwise, leave it unticked if using the delivered price.
  8. Tick File Contains Header Information.
  9. Tick Check Barcodes are Valid.
  10. Click on Import.
  11. The Select File to Import screen will appear. Navigate to where you have the file stored and double-click on it.

Importing a custom Catalogue File

For catalogue files that you have created yourself, you can use the import catalogue feature but will need to enter settings for how to import the information.
  1. Save your Catalogue file in a location that is easy to access, such as the Desktop.
  2. Follow the steps listed above up to Step 9.
  3. Click on the down arrow ▼ at the bottom next to Tools, and then Change Catalog File Settings.
  4. A screen will ask to select the Catalogue file from the computer, so select the file that was saved earlier and click OK.
  5. Click Yes to confirm the file to be imported.
  6. The Catalog File Setup screen will appear where you can enter the various column settings.
  7. First tick the box 'This File is Comma Delimited'.
  8. If the file contains column headings (a title at the top of the column), tick the box 'File Contains Header'.
  9. In Item Match Option, choose between:
    1. Use Barcode - select this option if the file contains barcodes for the system to match against existing product.
    2. Use Supplier Stock Code - select this option if the file contains Supplier Stock Codes for the system to match against existing product.
    3. Use Both - select this option if the file contains both the Barcode and SSC for the system to match against existing product.
  10. In the column settings, set the column number for the information in the file. You can use the preview of the file in the bottom to check which column numbers contain information.
    Notes
    The option that's selected in Item Match Option above, makes that information required for the column settings. E.g. if you selected Use Supplier Stock Code, then the file must contain a column with SSC for every product, and this setting must have a column number.
    Alert
    The File must contain both a Sell Price (normal price) and Catalogue Sell Price (discounted price)
  11. Click Save and then Close when done.
  12. Back in the Import Catalogue Files screen, click Import to select the file and then import.
InfoClick HERE for detailed instructions on how to further adjust catalogues

    • Related Articles

    • Common Supplier Stock File Importing Issues

      Here are a few common issues that customers can run into when they try to import a supplier stock file into Retailer. The first thing to confirm is that the file's barcodes are not corrupt and all the data is correct. Default settings are required to ...

    • Import an Onix XML Supplier Stock File

      We have a video guide on importing a supplier stock file into Retailer - ? Importing A Supplier Stockfile A supplier stock file or price/product list can be used to quickly and easily bulk import products into the Retailer software, which has ...

    • Importing a Customer File

      The Import Customer File utility can be used to import new customers. Existing Customers cannot be updated by this utility From the Main Screen of Retailer, click Utilities -> Import / Export Files -> Import Customer File In Customer File Type, enter ...

    • Importing Centrepay file

      Setting up CentrePay From the main menu screen of Retailer, click Customers in the menu at the top and then Batch Payments. Click Import and then CentrePay Setup. In Import Payment Type select from the drop down which paytype should be used for ...

    • Importing Batch Payment file

      In Retailer 3.2, a feature was introduced that allowed you to make batch payments to customers. This can be done through the Batch Payment screen in Retailer. The file needs to be saved onto your computer first. This can be any CSV file with the ...