Editing rates in bulk can be useful when you need to change prices at specific times, whether due to cost changes or promotions. With bulk editing of products, you can make these changes more quickly and efficiently from the product listing, without having to go to the product page.
There are different types of price editing: fixed price, margin based on cost, and percentage based on current selling price.
Requirements for editing rates in bulk
- The user must have the role of OWNER, STORE MANAGER, WAREHOUSE MANAGER, or PRODUCT EDITOR. We can see the different types of roles in the section Create or edit a user.
- Have more than one product created; we can see how to create a product in the section Create product.
Initial steps for all rates will be the same
- Go to the side menu and enter the PRODUCTS section, within the CATALOG module.
- You will see the list of products, from which you select those you want to apply the profit margin to.
- ⚠️ Note: you can use filters to speed up the location/selection of products).
- Once you have the selected products, click on the "Pencil" icon, where it says bulk editing, at the top right of the product list.
- By clicking on the "Pencil" icon, a window with 3 different tabs will open. For more details on what each one represents, go to Bulk editing of products.
Steps to define the fixed price
You can have different rates such as wholesale rate, in-store rate, ecommerce rate (if the prices are different from the store because it is in another country), outlet rate, etc.
- Go to the Rates tab.
- Inside, you will find "Type of price editing".
- Select Fixed price.
- If you want to apply the rate change to product variants, you must select the "Also apply to product variant price" checkbox.
- Below, you will find the same table as the one for product rates, where you must fill in one of the columns with the price change you want to make.
- ⚠️ Note: you can only edit one price per row at a time to prevent errors.
- Once the bulk editing margin is defined, click the "Save" button to apply the changes. If there are many products, the process may take a few seconds to complete.
Steps to define the margin based on cost
The profit margin of a product is a crucial measure for evaluating the profitability of a product and obtaining that benefit for your company. This measure is the difference between the selling price and the cost of production or acquisition, expressed as a percentage of the selling price.
Profit margin = [(Selling price - Cost) / Selling price] x 100
- Go to the Rates tab.
- Inside, you will find "Type of price editing".
- Select Margin based on cost.
- If you want to apply the rate change to product variants, you must select the "Also apply to product variant price" checkbox.
- Enter the % if you want to calculate the margin on the price with or without taxes.
- Finally, select the "Rounding type" you want to apply:
- No rounding: the selling price will be set automatically without any rounding.
- Round up: adjusts the price to the nearest higher figure. (45.32 → 46.00)
- Round up to ,99: adjusts the price to the next highest cent, commonly used when setting a psychologically more attractive price. (45.32 → 45.99)
- Round down: adjusts the price to the nearest lower figure. (45.32 → 45.00)
- Round down to ,99: adjusts the price to the next lowest cent, often used in sales pricing strategies. (45.32 → 44.99)
- Once the margin is defined in Bulk Editing, click the "Save" button to apply the changes. If there are many products, the process may take a few seconds to complete.
Steps to define the percentage based on the current selling price
- Go to the Pricing Tiers tab.
- Inside, you'll find "Type of price editing."
- Select Percentage based on current selling price.
- If you want to apply the rate change to product variants, you should select the checkbox "Also apply to the price of product variants."
- Enter the % whether you want to apply the percentage to the price with or without taxes.
- Lastly, choose the "Rounding Type" you wish to apply:
- No rounding: the selling price will automatically be set without any rounding.
- Round up: adjusts the price to the nearest higher figure. (45.32 → 46.00)
- Round up to ,99: adjusts the price to the next highest cent, often used when setting a psychologically more attractive price. (45.32 → 45.99)
- Round down: adjusts the price to the nearest lower figure. (45.32 → 45.00)
- Round down to ,99: adjusts the price to the next lowest cent, commonly used in sales pricing strategies. (45.32 → 44.99)
- Once the percentage is defined in Bulk Editing, click the "Save" button to apply the changes. If there are many products, the process may take a few seconds to complete.
Comments
0 comments
Please sign in to leave a comment.