Who is this feature for?
- Inventory Managers
- Sales and Purchasing Teams
- System Administrators
What progress will you accomplish?
- Enhanced Data Integrity
- Efficient Collaboration and Workflow
- Minimized Errors and Data Conflicts
Customizing or updating rates and discounts in bulk can be quite cumbersome and time-consuming as you have to manually select the items you want to update in bulk and then enter the custom rate and discount for each item individually.
Imagine a scenario if you have hundreds and thousands of items in a price list. The process will become even more challenging, and you may even require a dedicated person to handle it.
This is where the ‘Overwrite Custom Rates in Price Lists’ feature comes in handy. Using it, you can now overwrite custom rates and discounts for specific items in a price list.
How to Overwrite Custom Rates in Price Lists?
Click on the Price Lists tab under Items. Then, click on the price list for which you want to overwrite custom rates and discounts. This will open the price list’s Edit page.
Scroll down to the bottom and turn on the Import Price List for Items option. Click Export Items to export all your items in an XLS file.
Exporting items to overwrite custom rates
Now, customize the rates and discounts in the XLS file you’ve exported. You can also leverage the power of Excel formulas to update values in bulk.
Customizing rates and discounts in the XLS file
Then, check the Overwrite the custom rates only for the items in the import file option on the price list’s edit page and import the modified XLS file to update the price list.
Click the Save button and the rates of specific items in the price list will be updated with the new data in the import file.
Update price lists by importing the XLS file
After successfully updating, you’ll see a message on your screen saying, “Price list has been updated.”
What Pain Points Does It Solve?
Overwriting custom rates in price lists can solve several pain points in pricing management and sales processes. Here are some common pain points that can be addressed by the ability to overwrite custom rates in price lists:
- Flexible Pricing: Price lists often contain predefined rates for products or services. However, in certain situations, businesses need the flexibility to offer custom rates to specific customers or for specific sales scenarios. Overwriting custom rates in price lists allows businesses to accommodate unique pricing arrangements, negotiate special deals, or provide discounts based on individual customer needs.
- Negotiation and Sales Agility: Sales teams frequently engage in negotiations with customers, especially for large deals or when specific pricing terms are required. The ability to overwrite custom rates in price lists empowers sales representatives to adapt and respond to customer requests during negotiations quickly. They can adjust pricing on the spot, facilitating smoother sales processes and enhancing customer satisfaction.
- Promotional Campaigns: Businesses often run promotional campaigns or offer temporary discounts to boost sales. Overwriting custom rates in price lists allows businesses to apply promotional pricing across products or specific customer segments easily. This eliminates the need to create separate price lists for each promotion, streamlining the execution of marketing strategies.
- Contractual Agreements: In some cases, businesses may have contractual agreements with specific customers that require custom pricing terms. Overwriting custom rates in price lists enables businesses to honor these agreements accurately. It ensures that the agreed-upon rates are consistently applied, minimizing pricing discrepancies and maintaining strong customer relationships.
- Dynamic Market Conditions: Market conditions and factors such as supply and demand, competition, or changes in cost structures may require businesses to adjust prices periodically. Overwriting custom rates in price lists allows businesses to react swiftly to market dynamics and make necessary pricing adjustments. This agility helps businesses stay competitive and adapt to changing market circumstances.
- Customer-Specific Pricing: Certain customers may have negotiated individual pricing based on their buying volume, loyalty, or specific arrangements. Overwriting custom rates in price lists enables businesses to honor these customer-specific pricing agreements accurately. This ensures transparency and maintains trust between the business and its valued customers.
Businesses can address these pain points effectively by providing the capability to overwrite custom rates in price lists.
