To update selling prices against my own stock codes
The cost column in the terms import template is going to be used to update the stock code selling prices and the cost prices but used in different imports.
To create the template open Excel and and create 3 columns. The headings have to be exactly as below and the file saved as csv:
ItemCode CostPrice SellingPrice
1. Use the terms import template and use the cost price column for the selling prices of the stock codes
2. Drop the terms template into the import folder
3. Go to Publication > Terms and apply to the supplier
4. Go to Stock > Pricing search for all the codes you want to update the selling prices e.g. search by supplier
5. Click on to the Results tab and highlight and remove any products you do not want to update.
6. Click onto the Change tab and tick Update Selling Price by and from the drop down select Increase by THIS % from Cost and enter 0.01% and Apply. This will set the selling pricing in the product unit and pricing.
7. To update RSP to match selling price tick the option update RSP by and select Set to same as selling price click Apply
To update cost prices against my own stock codes
1. Use the terms import template and use the cost price column for the cost prices of the stock codes
2. Drop the terms template into the import folder
3. Go to Publication > Terms and apply to the supplier