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 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 tutorial- ...

• 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.

• Can I use the products photographs for marketing? Will there be any copyright issue?

  As we source products legally from the trusted manufacturers, there will be no copyright issues for the products or the photographs. You may use those anywhere seem fit. In case you find any issue, you can always write to our support team for quick ...

• Are the products branded or non-branded?

  Most of our products are non-branded ones and below are the benefits of dropship selling non-branded products. Non branded products gets you highest profit margin. You do NOT require any kind of brand authorization letters. No complications in ...