Bulk Supplier Buy Price Amendments

Bulk Supplier Buy Price Amendments

Question/Problem

Requirement to update all stock buy prices from a specific supplier.

Solution

This is something likely to affect all businesses from time to time and can be completed by following the steps:
  1. Go to [Reports | Ad-Hoc Reports] and select the System - Products followed by System - Stock Suppliers.
  2. Open the Products report.
  3. Delete all columns except the following:
    1. CONTROLLED
    2. STOCK_CODE
    3. SHORT_DESC
    4. STOCK_TYPE1
    5. STOCK_TYPE2
    6. BUY_PRICE
    7. SELL_PRICE
    8. TAX_CODE
  4. Add 2 new columns (Case sensitive)
    1. Supplier:COMPANY_CODE
    2. Supplier:PURCHASE_COST
  5. Open the Stock Suppliers report.
  6. Filter this to only show the suppliers you are interested in.
  7. Use this filtered information and use the STOCK_CODE field as the cross reference.
  8. Update the Supplier:COMPANY_CODE & Supplier:PURCHASE_COST columns on your products sheet as required.
  9. When you have finished editing prices save your Products report as "Text (Tab Delimited)" and you can then import it in to KCC as normal using the Stock Data Import feature.

    • Related Articles

    • Bulk Update Supplier Availability for my Stock Items

      Overview The below will show you how to import your supplier stock levels into your KCC system. Usage There are two parts this process and both will be covered here. Part 1 Getting your data from KCC. This process will export your stock file from KCC ...

    • Add a Buy Price and Sell Price to a Stock Item

      Overview The following explains how to add the buy and sell price and stock value to a stock item. The buy price is the price we pay when purchasing the stock items from the supplier. The sell price is the default price the customer is going to pay ...

    • Bulk update stock lead time

      Overview Sometimes stock items from a single supplier may need their lead time adjusting. Usage This solution will bulk update the lead time of the products. Go to the [Stock Items] list and filter to only show products supplied by the supplier in ...

    • Update a Stock Item After the Initial Data Import

      Overview An example where you may want to do this, is when there has been a recent change in your buy/sell price of a stock item. Step By Step In order to update the details of a stock item after the primary data import, you can follow the ...

    • Bulk Update Stock Items

      Overview Steps Open up the Stock List screen. Green select the items you wish to update. Click on the Actions button. Select Update Stock Items. In the dialog you can see all the attributes you can update. In the attribute(s) you wish update, add the ...