OsCommerce Practice – How to Import Products Base to OsCommerce

OsCommerce Practice – How to Import Products Base to OsCommerce Shopping Cart

I have managed to find an application which makes product import more simple than all the rest. It is called Store Manager for osCommerce. This software enables import of products to csv file and its export back to osCommerce.

It requires some skills to perform product import. But if you carefully follow the instructions of Import Wizard most likely it will be a success. Import is rather complicated procedure and it may be destructive if performed incorrectly. Thus, you have to create database backup before osCommerce products import especially if you do it for the first time.

First thing you need to do is to prepare csv file for import. Make sure it contains all necessary fields and all data you are going to import is listed in tables. After your csv file is ready choose import from the options provided. Then specify the csv file path and name or use browse button to select one. You can also load import settings to avoid reconfiguring each time you want to import products from a csv file.

Source file preview shows a part of csv file selected to import. What you should pay attention to here is delimiters and enclosure. Usually it is enough to look through the first line of the file to see whether some words are enclosed in quotes (“) and are separated by comma (,) symbol. It is important as you will need to set up these settings in the next step.

Select fields delimiter and quote character. Delimiter character is used to separate one column from another. If you specify incorrect delimiter, file will not be parsed properly and products will not be imported. Quote string values delimiter will be used to separate strings in csv file. It can be disabled if none are used. Category delimiter character is used to separate category names and specify full category tree path for given category. E.g.: every directory separated by backslash () character. Please note that if you specify the wrong values import may not work.

The next step – Link columns from csv file to appropriate database fields. You should check the box if the first row of your csv file contains not values but field names. Select the corresponding Products Identification Method – import wizard will search for a product using selected method of identification. The product will be modified if found, if not – new product will be added. Please note that it is recommended to use Product Name + Model to identify your products.

Here you can see two panes Database fields and csv File Columns. “Database Fields” pane shows the list of fields in your database that can receive import data. It is required to assign csv columns to key fields. To assign csv column to database field you should select a field at the left pane and then click a column at the right pane. You can use “Auto set…” option to set correspondence automatically for all fields. This option will work only if csv column name is the same as database field name. When you are done proceed to the next step – Base Formats and Separators.

This step allows you to convert text values from csv file to numerical and date values. You can just set default values using appropriate button. On Import Preview page you can see how csv file was processed using import settings, which you specified at previous steps. Columns that were not assigned will not be imported whereas empty values will overwrite existing.

Import Options – please pay attention to these settings as they may influence import results. You should select import method, can save import settings, etc. When you are done – press Import and the import process will start. When the process is complete you can see database details and whether any errors took place during product import.

As you can see it is really not as complicated as it seems. All you need to do is carefully pay attention to the details as you proceed to each step. This way you can be sure that products import will be successful and all your data will be imported accurately.