Note: It's very simple to change the product pricing, we made it look lengthy because to show you each step one by one. Just doing it once or twice, you'll find it simple. Try it now.
Step 1: Login to your admin dashboard
Step 2: Select Tools > Export/Import tool from the left side pane as in the below image
Step 3: In the right side settings, under the 'Export' tab, select 'Products' and click 'Export' button from the bottom.
Part 2: Changing the Products Pricing
Step 1: Open the exported file in the Excel or in other similar tools like LibreOffice or OpenOffice
Step 2: Goto 'Price' column as in below image
Step 3: Insert 2 new columns next to the 'Price' column, as in below image
Step 4: In the first new column, next to price column, enter the below formula with the percentage you want to increase the pricing to.
whereas
'P' is the column where 'Price' field is
'2'is the row number of the first pricing row.
0.5 is for setting 50% margin, if you want to set 90% margin, enter it as 0.9 and for 150% margin, it should be 1.5.
Step 5: Now select the entire column where you entered the formula and press 'Ctrl + D'. It will automatically fill all the products pricing at 50% margin.
Step 6 (Optional): Rounding off the figure. In the 2nd new column created, as given in 'step 3', enter the formula as given below. Ensure that you are in first value row of that new column.
=ROUND(Q2,0)
whereas, Q2 is the cell of pricing row
Step 7: As you did in Step 5, select the entire column where you entered the formtula and press 'Ctrl + D'. It will automatically round off all the values.
Step 8: Copy all the values from column where you applied 'Round off' formula and paste it in a separate notepad file. Again copy all the values in the notepad file and paste it over the 'Price' column. (you'll already have values in the price column, just paste over or delete all the existing values in price column and paste the values fresh, both gives same result though).
Step 9: Now delete the newly created columns and save the file.