--- title: Updating Item Prices in Sage 300 to Reflect US & Canadian Tariff Changes description: Learn how Canadian tariffs impact your pricing strategy & how Sage 300 can help you adjust item prices efficiently to protect margins and stay competitive. image: https://www.equationtech.us/hubfs/Equation%20Blog%20-%20Tariffs.png --- [866.436.3530](tel:+8664363530) | [** Customer Portal Login](https://na.myconnectwise.net/support/index.htm?Company=equationtech) [Speak With an Expert](https://www.equationtech.us/speak-with-an-expert) [![Equation Technologies - Sage Business Partner | San Diego](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?width=230&name=logo.png "Equation Technologies - Sage Business Partner | San Diego")](https://www.equationtech.us/) - [Sage Services](https://www.equationtech.us/sage-services) - Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage Payroll](https://www.equationtech.us/sage-services/sage-payroll) - [Sage HCM](https://www.equationtech.us/sage-services/sage-hcm-software) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - Services We Offer - [Software Selection](https://www.equationtech.us/software-solution-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Cloud](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) - [Extend Sage](https://www.equationtech.us/sage-integrations) - [Magento eCommerce](https://www.equationtech.us/sage-integrations#magento) - [ADP](https://www.equationtech.us/en/sage-300-sage-intacct-payroll-powered-by-adp) - [Aloha POS](https://www.equationtech.us/sage-integrations#aloha) - [Salesforce](https://www.equationtech.us/sage-integrations#salesforce) - [TimeClockPlus](https://www.equationtech.us/timeclockplus) - [Other Solutions](https://www.equationtech.us/other-solutions) - Industries - [Distribution](https://www.equationtech.us/distribution-management-software-solution) - [Education Nonprofit](https://www.equationtech.us/education-nonprofit-accounting-software) - [Financial Services](https://www.equationtech.us/financial-services-software) - [Franchise](https://www.equationtech.us/franchise-management-software) - [Healthcare](https://www.equationtech.us/healthcare-finance-software) - [Hospitality](https://www.equationtech.us/hotel-restaurant-accounting-software-solutions) - [Metal Processors & Distributors](https://www.equationtech.us/erp-for-metal-industry-businesses) - [Nonprofit](https://www.equationtech.us/nonprofit-accounting-software) - [Professional Services](https://www.equationtech.us/professional-services-software) - [SaaS & Technology](https://www.equationtech.us/erp-software-for-technology) - [Resources](https://www.equationtech.us/sage-software-resource-library) - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Online Videos](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) - [About](https://www.equationtech.us/about-us) - [Meet The Team](https://www.equationtech.us/management-team) - [Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. # Updating Item Prices in Sage 300 to Reflect US & Canadian Tariff Changes ![technology blog](https://www.equationtech.us/hubfs/Equation%20Blog%20-%20Tariffs.png) **twitter **linkedin **facebook   Tariffs aren’t just a behind-the-scenes accounting concern - they directly affect the prices you charge customers, much to everyone’s dismay. Especially in North America, as costs fluctuate due to shifting US & Canadian tariff rates, it's important for Sage 300 users to keep their item pricing in sync. Fortunately, [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) provides flexible tools to help you do just that, whether you need to adjust prices for a few items or a few hundred. ## **Why Update Prices Due to Tariffs?** Not that anyone wants to, but when US & Canadian tariffs increase your product costs, you need to adjust your prices in order to maintain your profit margin. Although less common, but always appreciated by the customer, if tariffs are lifted or reduced, you may want to pass on savings to stay competitive. Making sure to adjust your pricing appropriately, and not randomly, helps maintain transparent communication with your clients, continues a healthy margin for business growth, and let’s you maintain accurate cost-plus pricing. ## **Price Update Options in Sage 300** There are three main options in how to update pricing in Sage 300 depending on how many items you need to adjust. Sage has a manual price edit ability for a small number of items, a bulk update for larger edits, and an Excel export/import that is great for more granular control or collaborative editing with pricing teams. We’ve created the following chart to make it a little easier to know when we recommend which method: | **Use Case** | **Recommended Method** | | --- | --- | | Fewer than 10 items | Manual edits | | 10-100 items, same increase rate | Update Item Pricing tool | | 100+ or mixed adjustment types | Excel Export/Import or automation | If you’re not sure which would be the most appropriate for managing US & Canadian tariffs for our organization, or if you run into any hiccups along the way, please feel free to reach out to our [Sage 300 experts](https://www.equationtech.us/speak-with-an-expert). We’ve been helping clients with this for a long time! **1. Manual Price Edits** - Navigate to **Inventory Control > Item Pricing** - Select an item and manually change its base price in the appropriate entry for the price list(s) needing update. - Best for small numbers of items (under 10) 2. Bulk Updates with "Update Item Pricing" - Use Inventory Control > Update Item Pricing to make broad changes - Filter by:  - Price list code - Item number range - Category - Optional field (e.g.: an HS or Harmonized System Code) - Choose how to update: - Fixed amount - Percentage markup or markdown Example: Apply a 25% price increase to all items with HS Code 6459. Tip: Use Optional Fields to Target Items If you’ve already assigned a Harmonized Tariff Schedule (HTS) code to your items using optional fields, you can use this to filter the affected items in bulk updates. 3. Excel Export/Import Method - Export item pricing to Excel - Edit prices in a spreadsheet - Re-import into Sage 300 What to Watch for with This Method: - Sage 300's default export has multiple tabs and many columns - Use the **Pricing Details** tab to modify prices - Remove unused columns before reimporting If this seems like too much, don’t worry, a lot of companies work with a Sage partner to simplify this with a custom import template tailored to their business. If you would like help, our team can provide you with a template that has a simplified column structure, and multi-currency options. #### **Pro Tip: Automate Price Changes** Using [Orchid Extender](https://youtu.be/RVVaxRR0AWE) or custom scripts, it’s possible to auto-adjust prices based on cost changes from tariff updates. This helps your cost-plus margins stay intact without manual intervention. Orchid products are well tested throughout the Sage 300 ecosystem and we’ve worked with them for years. If you would like more information, please reach out. #### **Final Thoughts** Whether we’re dealing with a new round of US & Canadian tariffs or preparing for ongoing trade shifts, updating customer pricing in [Sage 300](https://www.equationtech.us/sage-services/sage-300-cloud) is essential. By using Sage’s built-in tools or working with a partner for automation, you can ensure that your margins stay healthy and your pricing stays fair.   ### Related Articles ##### [Thinking About Moving from Sage 300? Here’s What Nonprofits Need to Know](https://www.equationtech.us/sage-accpac-blog/thinking-about-moving-from-sage-300-heres-what-nonprofits-need-to-know) Sage 300 ERP for nonprofits has served organizations well, but requirements have changed. For a... ##### [Sage 300 & Windows 10 End of Life: What You Need to Know](https://www.equationtech.us/sage-accpac-blog/sage-300-windows-10-end-of-life-what-you-need-to-know) There’s been a lot of conversation lately around Windows 10 end of life and what that means for... ##### [From Start-Up to Quarter Billion – How Sage 300 Scaled Success](https://www.equationtech.us/sage-accpac-blog/from-start-up-to-quarter-billion-how-sage-300-scaled-success) We also have a [video version](https://drive.google.com/file/d/1ssdM9iHt6Wz86A-VDvAER03NdXkAodg9/view?usp=sharing) of this article, where you can hear directly from one of our ERP... ## Need Help Now? [![Request a Call](https://hubspot-no-cache-na2-prod.s3.amazonaws.com/cta/default/41683/0d27fa16-1614-41b4-9caf-f9597d262c41.png)](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/41683/0d27fa16-1614-41b4-9caf-f9597d262c41) Products We Support - [Sage 300](https://www.equationtech.us/sage-services/sage-300) - [Sage Intacct](https://www.equationtech.us/sage-services/sage-intacct/) - [Sage CRM](https://www.equationtech.us/sage-services/sage-crm) - [Sage HRMS](https://www.equationtech.us/sage-services/sage-hrms) - [Sage FAS](https://www.equationtech.us/sage-services/fixed-assets) - [Sage Intelligence](https://www.equationtech.us/sage-services/sage-intelligence) - [Sage Enterprise Intelligence](https://www.equationtech.us/sage-services/sage-enterprise) - [Sage Financials](https://www.equationtech.us/sage-services/sage-live) Services We Offer - [Software Selection & Licensing](https://www.equationtech.us/sage-services/erp-software-selection) - [Implementation](https://www.equationtech.us/sage-services/erp-implementation) - [Customization](https://www.equationtech.us/sage-services/customization) - [Support](https://www.equationtech.us/sage-services/support) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Hosting](https://www.equationtech.us/sage-services/hosting) - [Upgrades](https://www.equationtech.us/sage-services/upgrades) Resources - [Technology Blog](https://www.equationtech.us/technology-blog) - [Training](https://www.equationtech.us/sage-services/sage-training) - [Sage Software Video Tutorials](https://www.equationtech.us/sage-300-erp-accpac-tutorial) - [Case Studies](https://www.equationtech.us/case-studies) About - [Meet The Team](https://www.equationtech.us/management-team) - [Certifications & Partners](https://www.equationtech.us/partners) - [Careers](https://www.equationtech.us/careers) - [Contact](https://www.equationtech.us/contact) - [San Diego Location](https://www.equationtech.us/sage-300-support-san-diego) - [Orange County Location](https://www.equationtech.us/sage-300-support-orange-county) - [Seattle Location](https://www.equationtech.us/sage-300-support-seattle) [![Equation Technologies - Sage 300 Authorized Partner](https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo-footer.png?width=220&name=logo-footer.png "Equation Technologies - Sage 300 Authorized Partner")](https://www.equationtech.us/) **Equation Technologies** United States: 533 2nd Street Encinitas, CA 92024 Canada: #301 - 220 Brew Street Port Moody, BC V3H 0H6 Phone: 866.436.3530  •  E-mail: [info@equationtech.us](mailto:info@equationtech.us) Equation Technologies ©2016 [Contact Us](https://www.equationtech.us/contact)  | [Privacy Policy](https://www.equationtech.us/privacy-policy) ```json { "@context" : "http://schema.org", "@type" : "Article", "author" : { "@type" : "Person", "name" : "EQ Tech" }, "dateModified" : "Mon, Jun 16, 2025", "datePublished" : "Mon, Jun 16, 2025", "description" : "Sage 300 (formerly Sage Accpac) blog with informative articles in reference to financial software processes and procedures including payroll taxes, training, product information, custom development.", "headline" : "Updating Item Prices in Sage 300 to Reflect US & Canadian Tariff Changes", "image" : { "@type" : "ImageObject", "height" : 800, "url" : "https://www.equationtech.us/hubfs/Equation%20Blog%20-%20Tariffs.png", "width" : 800 }, "mainEntityOfPage" : { "@id" : "https://www.equationtech.us/sage-accpac-blog/updating-item-prices-in-sage-300-to-reflect-us-canadian-tariff-changes", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "height" : 60, "url" : "https://www.equationtech.us/hs-fs/hubfs/Redesign_Images/logo.png?t=1474998725496&width=230&name=logo.png", "width" : 600 }, "name" : "Equation Technologies Inc." } } ```