Sometimes, it may become necessary to bulk-update your product prices in Open Cart. You might find that your supplier raises all prices by a specified percentage, for example. Updating all product prices manually can be impractical when you've got hundreds or even thousands of products, but thankfully it can be achieved quickly and painlessly through MySQL.

In this article we'll examine importing your products, categories, and manufacturers from a CSV file into OpenCart using MySQL. The process is surprisingly simple, and can be performed quickly and painlessly with simple MySQL statements.This article assumes you have some basic knowledge of MySQL and OpenCart in general.