This Help Article covers:

General/Overview:

This Help Article assumes that you are familiar with and have read the Help Article: "Products - Overview".

Supplier Products Price File Importing is done from the Supplier's Window.

⚠️ NOTE: The Supplier Product Price File must follow Katipolt’s price file .csv formatting to enable importing. For more information on formatting the Supplier Product Price File, see the Help Article: "Products - Format Supplier Product Price File".

Quick Flow:

1. From the Supplier Window, Press the “More” (3 dots) menu and Select option "Import Product CSV" to display the Import Product CSV Window

2. From the Import Product CSV popup, Press the [Select a file] button, then navigate to where the CSV file to be imported has been saved and Select, then Press the [IMPORT] button to import
​

⚠️ NOTE: When importing, Products that are already loaded for the Supplier but not in the CSV file will be marked as Inactive when importing. If importing a part CSV file, Untick "Set products missing from CSV file as inactive...", to NOT mark Products as Inactive in Katipolt.

💡 TIP: Should a Product become "Inactive" on Import, it will not be found using the Global Search, it must be searched for from the Products List [Refine] filter search.

A Supplier's Imported Products can be found in the Supplier Window's Products Top Tab

⚠️ NOTE: Following importing, if needed, Supplier Products can have their details edited from the Product's Detail Window.

Import Error: Invalid decimal:-

This error normally displays following the attempted Import if there is an Unwanted Character(s) in a Numerical Cell (“Retail Price”, “Trade Price”, or “Cost Price” columns) such as a “0”, or a Non-Numerical character like: “TBA” or “-“,

To Resolve: Reformat the Supplier Products Price File and remove any Unwanted Characters from Numerical Cells.

⚠️ NOTE: Numbers must be Positive numbers higher than “0”.

Import Error: [STRING_TOO_LONG]

This error normally displays following the attempted Import if the character limits of a cell are exceeded. Possibly a wrong Column Header on a column.

To Resolve: Reformat the Supplier Products Price File and check that cell characters are under the cell's character limit, or that the correct Column Headers are used.

Import Error: Maximum lines exceeded...

This error normally displays prior to the attempted import when the Supplier Product Price File exceeds the Product Line limit.

To Resolve: Split your Supplier Product Price File into multiple files. Remember to Untick "Set products missing from CSV file as inactive...", when Importing the files.

Import Issue: Products not displaying some data. I.E. Pricing.

This normally happens when a Column Header spelling is incorrect or contains unseen spaces, so the column is skipped.

To Resolve: Reformat the Supplier Products Price File and check that Column Headers are Spelt correctly and don't contain hidden spaces.