Magento: Import product prices for an additional website?

Magento: Import product prices for an additional website?

September 12, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento: Import product prices for an additional website?

Magento: Importing Product Prices for an Additional Website

If you’re looking to import product prices specifically for your Trade website while keeping default prices on your Retail site in Magento, you’ve come to the right place. In this guide, I’ll walk you through the process of mapping SKUs to specific websites and importing prices for those products.

Understanding Magento’s Price Scopes

Before we dive into the import process, let’s quickly review how Magento handles pricing:

  1. Default prices: By default, all imported prices are assigned to the Main website view.
  2. Website-specific prices: Each product price can be scoped to a specific website (e.g., Trade) under Custom Design.

Mapping SKUs to Websites

First, you need to map your SKUs to their respective websites in Magento’s backend. Here’s how:

  1. Log into your Magento admin panel.
  2. Navigate to “Catalog” > “Manage Products.”
  3. Click on the product you want to update.
  4. Scroll down to the “Design” tab.
  5. In the “Website” dropdown, select “Trade.” Leave other fields as is.
  6. Click “Save Product.”

By mapping products to the Trade website under Custom Design, Magento will recognize that these prices should only apply there.

Importing Website-Specific Prices

Now let’s import those special trade prices for your mapped SKUs:

  1. Prepare a CSV file with columns: sku, price.
  2. Ensure the first row contains headers exactly as written above.
  3. Populate the rows with SKUs and their corresponding Trade prices.

For example, if you have two products:

  • Product A (SKU: 001) - Retail price: $10
  • Product B (SKU: 002) - Retail price: $5

And you want to set their Trade prices as follows:

  • Product A (Trade price): $8
  • Product B (Trade price): $4

Your CSV should look like this:

sku,price
001,8.00
002,4.00
  1. In your Magento admin panel, go to “System” > “Import/Export” > “Import.”

  2. Click on “Choose File,” select your prepared CSV.

  3. Set the following:

    • Entity Type: Catalog Product
    • Import Behavior: Add/update (this will keep existing data if SKUs already exist)
    • Export Settings:
      • Disable All (we only need to import prices)
  4. Click “Import.”

  5. Once finished, verify all products were imported successfully.

Testing Your Import

To ensure the prices are correctly applied:

  1. Go back to your Magento admin panel.
  2. Navigate to “Catalog” > “Manage Products.”
  3. Click on one of your mapped products (e.g., Product A).
  4. Under the “General” tab, check that its price under Trade website is now $8.00.

Conclusion

Importing website-specific prices in Magento requires a two-step process: mapping SKUs to their respective websites and then importing prices for those mapped products only. By following this approach, you can maintain different pricing structures for your Retail and Trade sites without manual intervention.

Remember to always validate your import data and test it thoroughly before going live with any changes. To learn more about Magento’s advanced import/export features, check out Laravel Company’s Magento development services.

Catalog Admin Pricing Import/Export

Our network