This Help Article covers:
General/Overview:
This Help Article assumes that you are familiar with and have read the Help Article: "Products - Overview".
Product Manual Import "Basic" imports the minimum data fields to get a Supplier's Products into Katipolt.
There are other data fields available that can be imported that will affect how the products behave when: Grouping & Displaying, Ordering, Selling and on Reporting. These data fields can be add to your Supplier Product CSV Price File and imported, for more information on this, see the Help Article: "Products - Supplier Product CSV Price File (Manual Import - Extended)".
Supplier Product CSV Price File "Basic" Overview
Supplier Products CSV Price File Manual Importing is done from the Supplier's Window.
💡 TIP: Before a Supplier Products CSV Price File can be imported, the Supplier must be entered in Katipolt, see the Help Article: "Supplier (Add - Edit)".
⚠️ NOTE: Supplier Products CSV Price File Manual Imports are limited to 5,000 product lines.
⚠️ NOTE: You need to ensure the Supplier Products CSV Price File follows Katipolt’s format for product CSVs.
"Basic" Column Headers
The "Basic" Column Headers are the minimum columns needed for a Supplier Product CSV Price File Manual Import.
Exported Column Headers
"Basic" Column Headers (minimum needed for an import)
The "Basic" Column Headers:
Product Code - Compulsory field, must be a unique code to that Supplier,
Product Description - Compulsory field, used to help identify the product,
Trade Price - Compulsory field, the promoted sell price of the product, and
Cost Price - Compulsory field, your buy price for the product
💡 TIP: If you don’t have a Trade Price, use the Cost Price OR make up a Trade Price using a Margin you would be happy with.
To Format a Supplier Product CSV Price File
To get the valid Column Header's correct Names and Spelling, from the Supplier Window, Press the “More” (3 dots) menu and Select the option "Export Product CSV", then Copy & Paste the Column Headers into the CSV file you are formatting.
⚠️ NOTE: The CSV file to be imported:
Must NOT contain commas
Has restrictions on character numbers of text fields
Must NOT contain duplicates of the "Product Code"
Must have a number in Trade Price/Cost Price (I.E. NOT a "0" or "POA")
💡 TIP: To identify duplicate Product Codes: From the CSV file, Highlight column "A" > Conditional Formatting > Highlight Cell Rules > Duplicate Values... > OK (Duplicates will display highlighted).
💡 TIP: Delete any columns that do not have values entered, maintaining the Minimum Columns.
To import a formatted Supplier Product CSV Price File
Quick Flow:
Supplier Window
“More” (3 dots) menu > "Import Product CSV" Option
[Select a file]
[IMPORT]
1. From the Supplier Window, Press the “More” (3 dots) menu and Select the 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 in Katipolt but not in the CSV file will be marked as Inactive in Katipolt. 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.
⚠️ NOTE: Using the "Basic" 4 column Import, Imported Products default to Product Category "Material Unknown", this can be changed for individual products at the Product's Detail Window by Selecting the Product Category of a Pricing Rule that will apply when selling the Product. The Product Category also determines where the Product will Group & Display on a Sales Invoice, or Reporting.