How to Bulk change my Products Pricing?

How to Bulk change my Products Pricing?


You can set your own pricing following our picture tutorial below.
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.

Part 1: Exporting the products in bulk

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.
  • =P2+(P2*0.5)
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.

Part 3: Importing the Updated File

Step 1: Just like how exported the file, goto 'Tools > Export / Import' from the left pane.
Step 2: Click 'choose file' under the 'Import' tab from the right side and choose the updated file
Step 3: Click 'Import'.

You have updated the pricing now. 





    • Related Articles

    • How to Bulk Update Stocks Quantity in Amazon Marketplace?

      We have created a simple method that should take you approximately 1-2 minutes every day to sync our stocks in your Amazon account. Please follow the below steps: Step 1: Download the Excel Sheet "Amazon_Bulk_Stock_Update_Template" from this link: ...
    • How to Upload & Update Stocks on Shopify (By Products)

      We have made the uploading of the products and updating stock-outs on Shopify a breeze. Just follow the below steps: Log on to your reseller panel at reseller.baapstore.com and click on the 'Smart Export Tool' from the top menu. Click on 'Daily Sync ...
    • How to Add Products on Amazon

      To list your products on Amazon, please follow the below steps:  You first need to get GTIN Exemption in the name of 'Generic' or any brand name you'd like to  list as. You shall learn how to get GTIN Exemption by following this ...
    • Import/Export Errors & Fixes

      Import Fixes We have documented the common errors that you may face when you upload a products in bulk using our Import/Export tools. Browse below for the errors and fixes. Error 1: Invalid Header Solution: You'll get invalid header errors mostly ...
    • How to see the live products and categories?

      We recommend you to visit our website baapstore.com and navigate to the products page to check all our products and categories. You shall also download our Products PDF at baapstore.com.