How Do I Discount Multiple Products at a Time?

Step 1

Go to ‘System’ in the left-hand side menu

Step 2

Select ‘Export’

Step 3

Set Entity Type to ‘Products’

Step 4

Select a brand to narrow down the export to those products

Step 5

Scroll down and set Enable Product to ‘Enabled’

Step 6

Scroll down and press ‘Continue’

Note: If you are updating special pricing across multiple brands, you will need to export multiple files OR you can export one file of the entire product base and delete the rows of products that do not apply.

Step 7

When your export appears, select the dropdown and press ‘Download’

Note: It might take some time for your export to appear. Refresh the screen until it appears.

Important: It’s very important that you open up the CSV in Excel properly so it does not lose data quality

Step 8

Open a new blank Excel spreadsheet

Step 9

Go into the ‘Data’ tab

Step 10

Select ‘Get Data’

Step 11

Select ‘Text/CSV’

Step 12

Upload the CSV export from Magento

Step 13

Press ‘Next’

Step 14

Make sure you select the options as indicated in the screenshot below

Step 15

Press ‘Load’

Step 16

Select all of the cells (⌘A) or (Ctrl + A)

Step 17

Go to the ‘Home’ tab

Step 18

Change the dropdown from ‘General’ to ‘Text’

Step 19

Delete the columns you do not need leaving SKU, special_price, special_price_from_date, and special_price_to_date

Note: You can leave the ‘Price’ column in temporarily if it helps you calculate the special price. Make sure you delete the ‘Price’ column before you upload the CSV back into Magento.

Step 20

Select the price and special_price columns

Step 21

Set these two columns to ‘Number’ in the dropdown

Step 22

Input the discounted price for each SKU

Note: Round the number to two decimal places and do not include a dollar sign

Step 23

Insert the date to begin the sale

Note: Make sure the date is in the following format: MM/DD/YY

Step 24

Insert the date to end the sale

Note: Make sure the date is in the following format: MM/DD/YY

In the screenshot below, the sale will begin at 00:00 24/10/2022 and will end at 23:59 25/10/2022

Step 25

Delete the price column if you kept it in

Step 26

Select the data (⌘A) or (Ctrl + A)

Step 27

Go to the ‘Table’ tab

Step 28

Select ‘Convert to Range’

Step 29

Press ‘OK’ on the alert popup

Step 30

Delete the first row

Step 31

Save the file as a .csv

Note: If you export multiple files, you can combine them into one CSV with the correct headers to make importing back into Magento easier.

Step 32

In Magento, go to ‘System’ in the left-hand side menu

Step 33

Select ‘Import’

Step 34

Set the Entity Type to ‘Products’

Step 35

Set the Import Behavior to ‘Add/Update’

Step 36

Upload the CSV file

Step 37

Once the file has been uploaded, press the ‘Check Data’ button in the top right-hand corner

Step 38

If no error message appears, your data has been checked and is ready for import

Step 39

Press the import button at the bottom of the page to import your file and update the special price fields