024886 Ability to update/import disc%,markup% information through CSV pricelist import.
Table Of Contents
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