UPDATE Stock Prices

UPDATE Stock Prices

UPDATE STOCK PRICES

This allows you to update the price to a specific value
The update can do both buy and sale prices

SQL QUERY

This can be used to extract data based on Category
SELECT
--The BuyPrice will need to be multiplied by the quantity of the case
S.STKCODE, S.DES1, S.CASETYPE, B.BUYPRICE, S.SCASETYPE, P.NETPRICE, P.BAND
FROM 
ACOCMP1.STKHEAD S
JOIN
acocmp1.STKPRICE P
ON
s.STKCODE=p.STKCODE
JOIN
acocmp1.AS_CURRENTBUYPRICE B
ON
S.STKCODE=b.STKCODE
WHERE 
--ENTER THE CATEGORY CODE
S.MANCODE = 'CATEGORY'
AND S.DISCON <> 'Y'
--ENTER THE SUPPLIER CODE and remove the 2 dashes
--AND S.SUPP1 = 'SUPPLIER'

Import Stock Prices Update

  1. Create a CSV file with the following information
  1. Stkcode, Supplier, Buyprice, BuyCasetype, SalePrice , EcommPrice, SaleCaseType
    If doing both Buy and Sale then create CSV as above otherwise remove fields if only doing buy or sale
    NOTE Ecommprice can also be updated

  1.  Go to Tools>Tools Menu>Imports>Stock Prices – To change prices only
  1. Are you continuing with import from previous data load
    This question is in case these has been an import and there were some errors that needed resolving.
    By selecting yes the previous file will populate the grid to import again
  2. If not continuing select NO
  1. The form opens for the fields that are on the CSV file to be added to the right column

  1. These MUST match exactly 
    1. Select the field in the order of the csv file
    2. If, column headers are in the csv select Ignore Column Headers
  2. On the form in the top left is the word FILE from here the format that has been added to the right column can be saved so that there is no need to repeat the action
    To save a format Select FILE>Save>Enter a name SalePrice, BuyPrice, EComm etc
    To open select File>Open and select format required
    If CSV has column headers select ignore
    NOTE the saved file does remember this so check before importing
  3. A new form opens and for SALE PRICE there are 2 options NETT or GROSS.


NOTE: The date only changes for the buy price if the user wanted to have a future pricing this will not work.

  1. Select how the import needs to add the sale Price
  1. If dates are not selected the new prices will be applied from today’s date
    If dates is selected then choose when the new prices start and end






Now select import


Confirm the dates the prices start and end
The code does not let you know when it has been completed.
Check the processed field against the number of records at the top left hand corner

Select Exit to close the program.
If, future dates have been used then in the stock item maintenance screen buy price tab will have the future date recorded there but in the sale price tab, select the future price and the change is there also. These will be applied on those dates.

NOTE:
Please be aware that the price from does not get updated only the price till.
If the price from needs amending than the user will have to remove the price manually and add again which would then create a new from date.



    • Related Articles

    • Stock - Stock Import

      Stock Import Introduction In Agility there are features that enable the importing of new stock codes, updating current stock codes and changing prices. Here is a list of ALL items which can be imported but not ALL are required. Items highlighted are ...

    • Changing Prices in Agility

      INTRODUCTION There are two different ways to change prices in Agility Pro on mass: Supplier Global Pricing or Import Stock Prices Supplier Global Pricing Select link to see instructions Supplier Global Pricing Import/Update Stock Prices Select link ...

    • Update Stock Records

      In Agility pro there is an option to import an update file to update existing stock records with new information, such as barcodes, case types, etc. Go to Tools-Tools Menu-Import-Stock Records When prompted Are you continuing with import from ...

    • Supplier Global Pricing

      There are two different ways to change prices in Agility Pro on mass: 1 - Supplier Global Pricing - By Percentage Allows you to increase or decrease the price by a percentage for all stock assigned to a supplier. The update can do buy and sale price, ...

    • Stock - Browse Stock

      INTRODUCTION In Agility browse stock gives the user the ability to search for stock in many different ways: Stock Code, Description, Preferred supplier and preferred supplier code, barcode, Department, Category, Group, Type, Job/Project and Analysis ...