WooCommerce – How to Import and Export Prices by Country

To export and import WooCommerce prices based on country, open WP Sheet Editor > Edit Products, click Export on the top toolbar, select your regional pricing columns, and download the CSV file. After updating prices offline in Excel or Google Sheets, click Import, upload your CSV, match record_id to ID, and run the import.

Managing multi-currency or regional pricing across global WooCommerce stores often requires updating rates frequently based on exchange rates or local market strategies. The Price Based on Country for WooCommerce plugin allows store owners to set manual or automated country-specific prices. However, editing regional prices one product at a time in standard WordPress leads to high administrative overhead.

Using WP Sheet Editor, you can view all country-specific pricing fields in a single spreadsheet, export regional prices to CSV format for offline editing in Excel or Google Sheets, and re-import updated pricing structures in minutes.

Key Takeaways

• Offline Price Editing: Export country-specific pricing data to Excel or Google Sheets to update regional regular and sale prices without live site edits.
• Zone Field Detection: Automatically map custom fields created by Price Based on Country, organized clearly by pricing zone title.
• Delegate Safely: Allow virtual assistants or team members without WordPress dashboard access to adjust regional price sheets offline.
• Safe Batch Import: Match CSV rows to existing WordPress product IDs using record_id to update existing prices without creating duplicate items.

1. How to View Country-Based Prices in the Spreadsheet

To display your products and regional pricing fields in a spreadsheet, navigate to WP Sheet Editor > Edit Products in your WordPress dashboard.

The spreadsheet displays every product as a row and every database field as an editable column. When the Price Based on Country for WooCommerce plugin is active, WP Sheet Editor automatically detects the pricing zones configured on your site.

For example, if you have established pricing zones such as North America and Central America inside the Price Based on Country settings, scrolling to the right in the spreadsheet will reveal columns dedicated to each region.

Supported Country Pricing Fields per Zone

2. How to Export Prices Based on Country to Excel or Google Sheets

Exporting custom country pricing columns allows you to modify regional catalogs in bulk using external spreadsheet software.

1. Click Export on the top toolbar of the spreadsheet.
   
2. In the What columns do you want to export field, select product ID, Title, and your specific regional pricing zone columns (e.g., Regular Price, Sale Price for each zone).
3. Check the I understand it will export all the rows from my current search checkbox.
4. Select your editing software in What app will you use to edit this file? (optional).
5. Optionally enter a label in Name of this export for future exports.
6. Click Start New Export to download the CSV file.
   

Open the CSV file in Microsoft Excel or Google Sheets to adjust regional pricing values offline.

3. How to Import Updated Country Prices from a CSV File

Once you finish updating your country prices in Excel or Google Sheets, import the updated CSV file back into WooCommerce.

1. Click Import on the top toolbar of the spreadsheet.
   
2. Set Source to CSV file from my computer.
3. Click Choose File, select your CSV file, and click Next.
   
4. Click Import all the columns.
   
5. Set Do you want to update or create items to Update existing items, ignore new items.
6. Map CSV Field record_id to WordPress Field ID to ensure prices update on the correct products.
7. Click Next.
   
8. Review the preview screen, then click The preview is fine, start import to execute the price updates.
   

After the import finishes, all updated regional prices will reflect in the spreadsheet and across your live WooCommerce store.

Related Guide: WooCommerce – How to Bulk Edit Country Price Based on Country

Frequently Asked Questions

Can I import prices for specific pricing zones without overwriting default WooCommerce prices?

Yes. When exporting your CSV, select only the ID, Title, and specific pricing zone columns you intend to modify. During import, WP Sheet Editor updates only the columns present in your CSV file, leaving default WooCommerce prices untouched.

How do I switch between manual prices and automated exchange rate pricing during export/import?

Export the {Pricing Zone Title} Price Method column alongside regular prices. In your CSV editor, enter manual or auto depending on whether you want Price Based on Country to calculate the price automatically or use a fixed custom rate.

Does importing country-specific prices work for product variations?

Yes. If your store uses variable products, export both parent products and variations. WP Sheet Editor includes variation rows with unique record_id values, allowing you to import distinct country prices for each product variation.

Can I schedule sale prices for specific country zones via CSV import?

Yes. Include the {Pricing Zone Title} Sale Price Dates From and {Pricing Zone Title} Sale Price Dates To columns in your CSV export. Populating these cells with valid date strings activates zone-specific sales automatically during import.