Whether you are migrating to OpenCart for the first time, or trying to fill in your existing OpenCart store with actual data, CSV import is a great way to do that in bulk. Read on to discover how to transfer products from your current eCommerce solution to OpenCart with the help of the comma-separated value (CSV) file.
What is CSV and how to deal with it?
CSV is a comma separated values file that allows data to be saved in structured format. Traditionally CSV is plain text that can contain numbers and letters only. CSV are often used by companies to exchange data between different applications or software, especially if there is a huge amount of it.
Being a common procedure, data import from CSV files to a shopping cart still puzzles lots of merchants. Even instructed by endless web-tutorials, both textual and video ones, store owners often mess up data placement during imports, lose info, or contravisory, create unnecessary copies of it.
Import products to OpenCart via CSV
By default, OpenCart doesn't provide the facility to import products from any outer source. Therefore, there are two ways to import products to OpenCart:
- manually import a CSV file with your products to OpenCart using 3rd party modules,
- automatically import products from CSV to OpenCart with the help of a SaaS tool.
There are few plugins on the official OpenCart extension marketplace, e.g. OpenCart Product Import.Though, these add ons facilitate the process of importing products to OpenCart, they require some technical skills from you and some time input. You can always appeal to developers - but remember that will cost you a thing.
Alternatively, the easiest and safest way to perform import products to OpenCart via CSV is to make use of automated solutions (like Cart2Cart). To those looking to save time and transfer data without getting into technicalities - this service is an optimal go-to.
How to import products to OpenCart? An automated solution
Taking into account the increasing tendency to automate any possible business process, it becomes clear why automated approach is so much favoured by online retailers. Cart2Cart allows store owners to automatically import products to OpenCart with just a few mouse clicks. What is important is that there’s no coding skills required to get a full advantage of the tool. You can check the quality of data transfer by performing a free Demo import of the products to your live OpenCart store. If satisfied with what you get, you can proceed with Full products import to OpenCart.
First off, make sure you’re prepared - download our template CSV file that’s structured accordingly to OpenCart requirements and adjust your current products file appropriately.
Import CSV file automatically
Specify your Source & Target carts
- If migrating from a CSV file: select CSV file as your Source Cart. Optionally, you can enter the URL of the store your CSV was exported from.
- If you’re migrating directly from a shopping cart: choose OpenCart as Target Cart, paste its admin URL and specify the admin login and admin password.
Choose what to migrate
Just click on the Products checkbox to initiate OpenCart products import only. Upload your products CSV and the file with product images if you want to migrate them as well. If you don’t - proceed to the next step.
Perform Smart Mapping
Map the fields in your CSV file with the corresponding ones on OpenCart.
Start Free Demo
Demo data migration is a free procedure that gives you an idea of how our service functions, allows you to move a limited number of entities to OpenCart live store and only takes about 30 minutes. Thus, you’ll be able to check if your CSV is structured correctly. This procedure is optional.
Perform full-scale Opencart csv product import
Finally, if you’re satisfied with the outcome of Demo import to OpenCart, double-check the entities you’ve picked and click the “Start Full Migration” button. Import products to Opencart will start right away. After the procedure is over, you’ll get an email notification with the results.
If all the instructions were followed strictly - mistakes surely won’t happen. However, if you did miss something and now see some issues - here’s what to do:
- If you see that some product images are missing - check your mapping once again, ensure that all the image fields are valid and full URLs are placed properly.
- If SKUs are not defined and paths aren’t valid - your CSV probably contains some inappropriate characters. Open your products file and look through the description thoroughly.
- If some data got duplicated - there likely was an SKU mismatch. Ensure all your SKU fields are mapped correctly.