How to Import/Export Product Prices via CSV

Manage prices in spreadsheets and sync to Shopify

Importing and exporting product prices via CSV on Shopify is the most efficient way to manage large catalogs. OCS Bulk Product Price Editor lets you export current prices, edit them in a spreadsheet, and import the updated file with preview and validation before applying changes.

Step-by-Step Guide

1

Export Current Prices

Open OCS Bulk Product Price Editor and click Export CSV. Choose to export all products or filter by collection, type, or vendor. The CSV includes product name, SKU, current price, and compare-at price.

2

Edit Prices in Your Spreadsheet

Open the CSV in Excel or Google Sheets. Update prices in the designated columns. You can use spreadsheet formulas for bulk calculations (e.g., multiply all prices by 1.10 for a 10% increase).

3

Validate Your Changes

Review your spreadsheet for errors: no negative prices, no blank required fields, correct currency format. Save the file as CSV (UTF-8 encoding recommended).

4

Import the Updated CSV

Upload the edited CSV to OCS Bulk Product Price Editor. The app validates the file and shows a preview of all changes — old price vs new price for each product.

5

Review and Apply

Review the preview carefully. If everything looks correct, click Apply to update all prices. The previous prices are saved for one-click rollback if needed.

When to Use CSV Price Management

CSV import/export is ideal when you need to update prices based on external data (supplier price sheets), apply complex pricing formulas, share pricing with team members for review, or keep a backup of all product prices.

CSV Format Requirements

The OCS CSV format is straightforward: product handle, variant SKU, price, and compare-at price. The export file includes all required columns, so you only need to edit the price values and re-import.

Avoiding Common CSV Mistakes

Always use the exported file as your template — do not create a CSV from scratch. Ensure prices use the correct decimal format for your currency. Do not remove or reorder columns. Save as CSV, not XLSX.

Frequently Asked Questions

What CSV format does the app use?
The app uses standard CSV with columns for product handle, variant SKU, price, and compare-at price. UTF-8 encoding is recommended.
Can I use Google Sheets to edit prices?
Yes. Export the CSV, upload to Google Sheets, edit prices, download as CSV, and import back into the app.
What happens if my CSV has errors?
The app validates the CSV before importing and highlights any errors (missing fields, invalid prices). You can fix the file and re-upload.

Ready to Get Started?

Join thousands of Shopify merchants using OCS Engine apps to grow their stores.

Install Free on Shopify Contact Us

We use cookies to improve your experience. By continuing to use this site, you agree to our Cookie Policy.