Update Prices Using the Import Tool
This how-to explains how to update Item Prices in 10X ERP using the Import Tool. You’ll learn how to select the correct Import Type, understand required columns, set the proper Calculation Method, and structure your file for List Price updates. The guide also covers how the system creates new pricing rules versus updating existing ones and how to confirm your changes after import. Following these steps ensures accurate, efficient Price Rule management.
- Navigate to Admin > Import File and change the Import Type to Price before uploading your file.
- Click the Info (I) Icon to review Required Columns, Calculation Methods, and Import Rules specific to Price Updates.
- Set the Correct Calculation Method by using P for List Price, L for Multiply List Price, or C for Multiply by Inventory Cost (as applicable).
- Download the Sample Template to view all Available Fields and ensure your Column Headers are an Exact Match to avoid errors.
- Prepare Your Import File with at minimum Item ID, Multi/Price, and Calculation Method (P) when updating standard List Prices.
- Include Item Group, Customer, or Customer Group (If Needed) when creating Pricing Rules for Specific Items or Customer Segments.
- Keep Item ID as the First Column and ensure all headers match exactly, even if optional columns are left blank.
- Upload the File Using Choose File and Click Import, then wait for the system to process the Price Rules.
- Review the Import Results to confirm the number of Rules Created or Updated and verify there are No Errors.
- Refresh the Item Record to confirm the new List Price appears and that the correct Calculation Method was applied.
- Re-import Updated Prices as Needed in the future; existing Pricing Rules will be updated rather than duplicated.
- Use Quantity Breaks or Multipliers (Optional) by referencing the Sample Template if more advanced Pricing Structures are required.
- Contact Support for Assistance if you encounter Errors or have questions about Pricing Rule configuration.