How-To Guide
7 min read

How to Export Products from OpenCart (2026 Guide)

Follow these steps to export your OpenCart products as a CSV file. Once exported, you can use any of our converter tools to transform the data for your target system.

Export Steps

1

Log in to the OpenCart admin panel

Navigate to your OpenCart admin URL and sign in with administrator credentials. You need admin access to manage the product catalog and export data.

2

Navigate to Catalog > Products

In the left sidebar, click on Catalog and then Products. This opens the product list page showing all your store products with their names, model numbers, prices, quantities, and status.

OpenCart admin Catalog Products page showing the product list with name, model, price, quantity, and status columns
The OpenCart product list displays all products with their key details.
3

Check for a built-in export or install a free extension

Some OpenCart versions include a built-in Export/Import Tool under System > Maintenance that supports product export in spreadsheet format. Check if an Export button is visible at the top of the products page. If not, search the OpenCart Marketplace for a free product export extension.

Tip: You can also export product data directly from the database using phpMyAdmin if you have hosting access. Export the oc_product table as CSV.
4

Configure export settings

If using an export extension, navigate to its settings page to configure which product fields to include. Select fields such as product ID, name, model/SKU, description, price, quantity, weight, categories, images, and status. Choose comma as the field delimiter for standard CSV format.

5

Select products and export

To export all products, ensure no filters are applied and click the Export button. To export specific products, use the filter options to narrow by category, status, or price range, then select the filtered products and click Export. Enter a filename for your export file when prompted.

OpenCart product export dialog showing export options with file format selection and Export button
Click the Export button to generate the product CSV file.
6

Download and save the CSV file

Click the Export or Download button to save the CSV to your computer. The file will contain one row per product with all the fields you selected during configuration. Products with multiple categories may have category paths separated by the greater-than symbol.

7

Verify the exported product data

Open the CSV in Google Sheets or a spreadsheet application. Check that product IDs, names, model/SKU codes, prices, and stock quantities are correct. Verify that image paths or URLs are properly formatted if you plan to use them in another system.

Tip: OpenCart uses the model field as its primary product identifier for import matching, similar to SKU in other platforms. Keep this field intact if you plan to re-import updated data.

Required Products Fields

Field Type Description Example
product_id Number Product ID 101
name Text Product name Blue Widget
model Text Product model/SKU WIDGET-BLUE-001
price Currency Regular price 49.99

Your OpenCart export must include these fields for successful conversion.

Next Step Once you have exported your products, use one of the converter tools below to transform your file.

Frequently Asked Questions

OpenCart exports products as a CSV (Comma Separated Values) file, which can be opened in Excel or Google Sheets.
The file is usually downloaded to your browser's default Downloads folder. Check your Downloads folder or look for the download notification.