3 | Import/Export Supplier Contract Price File

This article covers Import/Export Price File in Supplier Contract Pricing within Backoffice. Importing and Exporting Price File can be done either an XML file or CSV file. Supplier Contract Pricing is available from Bepoz v4.7+.

This article covers Import/Export Price File in Supplier Contract Pricing within Backoffice.

Importing and Exporting Price File can be done either an XML file or CSV file.

Supplier Contract Pricing is available from Bepoz v4.7+.

Prerequisite

To access to the Supplier Contract Pricing Settings; the applicable Operator privileges will need to be enabled:

Import/Export File Format

Filed	Type	Description
ProducID(Bepoz)	Long int	The existing Bepoz ProductID (if exists)
SupplierID	Long int	The Bepoz SupplierID (if exists)
Supplier Name	Text 100	The Supplier Name (if exists)
Supplier Code	Long int	The Supplier Product code (if exists)
Product Description	Text 200	The product description (if exists)
Cost Ex	int	$0.00
Start Date	Date	* DD/MM/YYYY - the date that the pricing becomes valid * This field should be blank when Price file is exported
End Date	Text	* DD/MM/YYYY - the date that the pricing is no longer valid This field should be blank when Price file is exported
Order Size		1 = Unit 2 = Case *This field should be blank when Price file is exported
Order Size Barcode	Long int	Barcode number for quantity (i.e unit or case) This field should be blank when Price file is exported
Price Type		S = Standard P = Promotion * This field should be blank when Price file is exported
Preferred Supplier	Boolean	Yes = Change No = No Change * A product can only have a single preferred supplier record per store or globally * This field should be blank when Price file is exported

Import/Export Price File

In Supplier Contract Pricing, Operators can Import/Export Price File from a local storage file
The Price File can be imported either using an XML file or a CSV file
To Import a Price File using a CSV file, follow the below steps:

Select 'Import Price File' option on the top header of Supplier Contract Pricing.
A Supplier List window will display for you to select a Supplier. Select a Supplier and click 'Select Supplier' button
Select the CSV file from the local storage file
Once its imported and no error messages displayed, the price file record will be categorised into four different categories

Record Type	Description
Matched Products	Price file product is linked to the selected Supplier in the Price file and linked to a Bepoz Product A product is a matched product when Supplier, Supplier Code and ProductID (Bepoz) match
Un-matched Products	The Price file Product is linked to the selected supplier in the Price file and NOT linked to a Bepoz Product
Linked Products	The Price file product doesn't have a Price file entry but has a link to the selected supplier
Un-Linked Products	The Price file product neither has a price file entry and nor a linked supplier

You can select the key function to display the legends that the colours represent

Import Processing Window

Reprocess records and displays further errors for these records or hides them from the screen if no longer in error state

Operators can also manually action Price file records before the import process is completed; these options are:

Where a ProductID (Bepoz) exists, creates a Supplier pricing record in Bepoz, then creates a Supplier Link and sets the Preferred Supplier

N.B Not all Actions are available for all error record types which means an error record may only have an action type of Discard.
To Export a Price File, you would need to select the Venue and Store first and then select the supplier

You can select multiple products from different suppliers if you wish, it would create an export file per supplier

Select the 'Export List' button to export the selected products
Save the file either in CSV or XML
From there you can send the Exported file to your Supplier and they can fill in the File using the File Format above