This Help Article Covers:

General/Overview:

When formatting a Supplier Quoted Contract Price File for Importing, saving as a MS Excel Workbook makes it easier to format. You can use MS functions or manually colour cells to keep track of your formatting, and should you need to stop, you can save and retain your formatting tracking so when you open the MS Workbook next time, you know what you have done and what is to be done.

💡 TIP: Most J.A. Russell Limited Supplier Quoted Contract Pricing is available on on2site to download as an Excel file: on2site > Quotes

The 3 Column headers required for a Supplier Quoted Contract Price File are:

💡 TIP: Column Headers can be keyed in OR, Copy & Pasted from the Import price file Template, from the Quote Window, Press the "More" (3 dots) Menu and Select option Import price file, then from the Import Price File Popup, Press [DOWNLOAD TEMPLATE], then from the download file you can Copy & Paste the Column Headers into the CSV file you are formatting.

Quick Flow:

Save file as MS Excel Workbook (if not already, and you want to)

Save the Supplier Quoted Contract Price File as a MS Excel Workbook to make formatting easier. For more information on Saving as an "Excel Workbook (*.xlsx)" file, see the Help Article "MS Excel Functions"

Insert a new Row "1"

Insert a new Row "1" to provide a place to Add the Katipolt Column Headers. For more information on inserting a Row, see the Help Article "MS Excel Functions"

Add Katipolt/Delete Original Column Headers

In the new Row "1", Add the Katipolt Column Headers to the appropriate Columns, then Delete the Row with the Original Column Headers

Check the Column Headers

Column Headers must be Spelt correctly and have no unseen spaces. Work across the Column Header Cells, Clicking in each, checking the Spelling, then from the Text Entry field, Click past the end of the text and swipe Left to see if there are any unseen spaces, Deleting any unseen spaces as required

Delete Unwanted Columns

Delete any unwanted Columns so that only the Columns needed for the import remain

💡 TIP: The Columns to be Deleted should not be displaying Column Headers.

Position the Columns

Position the Columns in the Order required for the Import, ensuring that Column “A” is: Product Code. For more information on Moving Columns, see the Help Article "MS Excel Functions"

Add Column Filters to Row "1"

Add Column Filters to Row "1" so that Column "A" "Product Code" can be filtered. For more information on Adding Column Filters, see the Help Article "MS Excel Functions"

Filter Column “A”

From Column "A", Click the Filter Dropdown to display the Options Menu, then Click Option Sort A to Z

Check Column “A” for Duplicates

Column “A” "Product Code" cannot have duplicate values and must have the Product Code changed to a Non-Duplicate Code OR the Row deleted, either: Visually check Column "A" Cells, OR use the MS Excel Conditional Formatting function. For more information on using the Conditional Formatting function, see the Help Article "MS Excel Functions"

💡 TIP: When the MS Excel Conditional Formatting function is used, Duplicate Values in Column "A" will be highlighted by the cells being coloured Light Red.

Check Cells for Excess Characters

There are limitations on the Characters of Katipolt Fields. When importing a file, if the cell Character Count exceeds the Character limit of the Katipolt field it is to populate, this will break the import. Excess Character Cells must be found and the Character Count reduced to suit, either: Visually check the Cells, OR use the MS Excel Character Count function "=LEN(XX)". For more information on using the =LEN(XX) function, see the Help Article "MS Excel Functions"

Character limits:

Check Cells for Unwanted Characters

Import files cannot contain certain Characters. Unwanted Characters must be found and removed, either: Visually check Cells, OR use the MS Excel Find function. For more information on using the Find function, see the Help Article "MS Excel Functions"

Examples of Unwanted Characters:

💡 TIP: File Number Cell's Format Category needs to be "General".

Save file as CSV

For the import, the Supplier Quoted Contract Price File must be a "CSV (Comma delimited) (*.csv)" file. For more information on Saving as a "CSV (Comma delimited) (*.csv)" file, see the Help Article "MS Excel Functions"