024886 Ability to update/import disc%,markup% information through CSV pricelist import.

Overview

 

KCSL have enhanced the ‘CSV Pricelist import tool’ to allow for the import/update of pricelist ‘Disc %’ and ‘Markup %’ fields.


Specification

Requirement from the development/Reason:

The customer currently very often update their pricelists but the CSV only allows them to update the Price and nothing else so they want the ability to also import/Update the Disc % and the Base MarkUp%.

 

Workaround suggested by KCSL:

To export the pricelist via the XML export, make the changes and import the changes. the customer has tested this and provided feedback that exporting 200~ line pricelist has taken more than 5 minutes which is not efficient to use the functionality

 

Changes that KCSL will be making:

Add the ability to Import/Update the Disc % and Base MarkUp% fields through the CSV Pricelist Import tool. These fields will be optional so if not populated the tool have the same behaviour as before this development.

 

Configuration

An update will be applied as part of this development. To import/update the required files the import file should be setup as follows:

 

Column Title.

Description.

Example.

STOCK_CODE

Stock code for the stock item concerned.

SKU0001

BAND_LOW

Minimum Qty for the stock item band.

1

BAND_HIGH

Maximum Qty for the stock item band.

99999

<Pricelist Name>

Amount of the stock item for this pricelist.

38

<Pricelist Name>:Markup

Markup %.

10

<Pricelist Name>:Discount

Discount %.

20

 

Example :

STOCK_CODE,BAND_LOW,BAND_HIGH,Retail,Retail:Markup,Retail:Discount

SKU0001,1,99999,38,10,20

Usage

After applying the above Configuration, typical steps for usage would include the following.

 

- Promotion | Price Lists | Stock Item / Price Lists

- Other Actions | Import / Export | Import | CSV Stock Item Price Lists


The addition pricelist fields populated are :


Did you find this article helpful?