Documentation

Installing CSV Price Pro import/export


System requirements:

  • OpenCart 1.5, 2.0, 2.3, 3.0
  • PHP: 5.3, 5.4, 5.5, 5.6, 7.0, 7.1
  • PHP OpenSSL support
  • IonCube loader support.

Check your hosting settings prior to buy and install the module with the automatic tool. Click here to download it.

CSV Price Pro import/export for OpenCart 1.5.x
CSV Price Pro import/export for OpenCart 2.0.x, 2.1.x, 2.2.x
CSV Price Pro import/export for OpenCart 2.3.x
CSV Price Pro import/export for OpenCart 3.0.x

CSV Price Pro import/export for OpenCart 1.5.x
The file name is csv_price_pro-3.3.8.2.zip, includes:

OpenCart PHP ionCube Loader File name
OpenCart 1.5.x PHP 5.3.x ionCube Loader 6.0.6+ csvprice_pro_oc1_php53.zip
OpenCart 1.5.x PHP 5.4.x ionCube Loader 6.0.6+ csvprice_pro_oc1_php55.zip
OpenCart 1.5.x PHP 5.5.x ionCube Loader 6.0.6+ csvprice_pro_oc1_php56.zip
OpenCart 1.5.x PHP 5.6.x, 7.0.x ionCube Loader 6.0.6+ csvprice_pro_oc1_php56.zip
OpenCart 1.5.x PHP 7.1.x ionCube Loader 6.0.6+ csvprice_pro_oc1_php71.zip

CSV Price Pro import/export for OpenCart 2.0.x, 2.1.x, 2.2.x
The file name is csvprice_pro_oc22.zip, includes:

OpenCart PHP ionCube Loader File name
OpenCart 2.0.x.x – 2.2.x.x PHP 5.3.x ionCube Loader 6.0.6+ csvprice_pro_oc22_php53.zip
OpenCart 2.0.x.x – 2.2.x.x PHP 5.4.x ionCube Loader 6.0.6+ csvprice_pro_oc22_php54.zip
OpenCart 2.0.x.x – 2.2.x.x PHP 5.5.x ionCube Loader 6.0.6+ csvprice_pro_oc22_php55.zip
OpenCart 2.0.x.x – 2.2.x.x PHP 5.6.x,  7.0.x ionCube Loader 6.0.6+ csvprice_pro_oc22_php56.zip
OpenCart 2.0.x.x – 2.2.x.x PHP 7.1.x ionCube Loader 6.0.6+ csvprice_pro_oc22_php71.zip

CSV Price Pro import/export for OpenCart 2.3.x
The file name is csvprice_pro_oc23.zip, includes:

OpenCart PHP ionCube Loader File name
OpenCart 2.3.x.x PHP 5.3.x ionCube Loader 6.0.6+ csvprice_pro_oc23_php53.zip
OpenCart 2.3.x.x PHP 5.4.x ionCube Loader 6.0.6+ csvprice_pro_oc23_php54.zip
OpenCart 2.3.x.x PHP 5.5.x ionCube Loader 6.0.6+ csvprice_pro_oc23_php55.zip
OpenCart 2.3.x.x PHP 5.6.x,  7.0.x ionCube Loader 6.0.6+ csvprice_pro_oc23_php56.zip
OpenCart 2.3.x.x PHP 7.1.x ionCube Loader 6.0.6+ csvprice_pro_oc23_php71.zip

CSV Price Pro import/export for OpenCart 3.0.x
The file name is csvprice_pro_oc3.zip, includes:

OpenCart PHP ionCube Loader File name
OpenCart 3.0.x.x PHP 5.3.x ionCube Loader 6.0.6+ csvprice_pro_oc3_php53.zip
OpenCart 3.0.x.x PHP 5.4.x ionCube Loader 6.0.6+ csvprice_pro_oc3_php54.zip
OpenCart 3.0.x.x PHP 5.5.x ionCube Loader 6.0.6+ csvprice_pro_oc3_php55.zip
OpenCart 3.0.x.x PHP 5.6.x,  7.0.x ionCube Loader 6.0.6+ csvprice_pro_oc3_php56.zip
OpenCart 3.0.x.x PHP 7.1.x ionCube Loader 6.0.6+ csvprice_pro_oc3_php71.zip

Unlike normal PHP files, ionCube-encoded files may need to be uploaded with your FTP program set to “binary” mode, not “ASCII” or “text” mode. You may need to manually override your FTP program’s settings while uploading to do this. The instructions for your FTP program should explain how to change the mode.

For installation read the file docs/english/INSTALL.txt

  1. Unzip the archive file (example csvprice_pro_oc23_php53.zip) and find upload folder;
  2. Via FTP manager (like Filezilla or WinSCP – download here: http://filezilla-project.org/) upload to you main directory the files and folders in the upload folder;
  3. Change read, write and execute (full access) permission on a directory “system/csvprice_pro” for all (for OpenCard 2.x-3.x, see the tab General);
  4. In Admin go to MENU > Extensions > Module;
  5. Install CSV Price Pro import/export;
  6. Edit CSV Price Pro import/export;
  7. Copy your licence key into “License” field and press “Save” button;
  8. That is all – The module is ready to work;

Updating CSV Price Pro import/export


  1. In Admin go to MENU > Extensions > Modules;
  2. Delete CSV Price Pro import/export
  3. Unzip the archive file (example csvprice_pro_oc23_php53.zip) and find upload folder;
  4. Via FTP manager (like Filezilla or WinSCP – download here: http://filezilla-project.org/) upload to you main directory the files and folders in the upload folder;
  5. Change read, write and execute (full access) permission on a directory “system/csvprice_pro” for all;
  6. In Admin go to MENU > Extensions > Modules;
  7. Install CSV Price Pro import/export;
  8. That is all – The module is ready to work;

 The CSV-file Format


An example of a CSV file can be downloaded here.

  • The first record in a CSV file may be a header record containing column (field) names
    Example: _ID_; _NAME_;_PRICE_;_DESCRIPTION_
  • Each record is one line
  • Fields are separated with semicolon.
    Example: “Canon EOS 5D”;”product 3″;”80.00″;”Canon’s press material for the EOS 5D states that it..”
  • Fields with embedded semicolon must be delimited with double-quote characters.
    In the above example. “Canon EOS 5D; Orginal” had to be delimited in double quotes because it had an embedded semicolon.
  • A field that contains embedded line-breaks must be surounded by double-quotes
    So:
    Field 1: Canon EOS 5D
    Field 2:
    Canon’s press material for the EOS 5D states that it ‘defines (a) new D-SLR category’,
    while we’re not typically too concerned with marketing talk
    this particular statement is clearly pretty accurate.
    Field 3: 80.00
    would convert to:
    “Canon EOS 5D”; “Canon’s press material for the EOS 5D states that it ‘defines (a) new D-SLR category’,
    while we’re not typically too concerned with marketing talk
    this particular statement is clearly pretty accurate.
    “;80.00;…
    Note that this is a single CSV record, even though it takes up more than one line in the CSV file. This works because the line breaks are embedded inside the double quotes of the field.
  • Fields may always be delimited with double quotes.

openoffice_open_file

Open CSV-file


CSV-file should be opened in OpenOffice (OpenOffice – download here: https://www.openoffice.org/) with parameters:

OpenOffice: Open CSV-file

Save CSV-File


Save CSV-file you need the following parameters:

OpenOffice: Save AsOpenOffice: Save As Settings

How to concert the CSV file into the right CSV format


Please open your file in Notepad and then go to Edit → EOL Conversion → UNIX/OSX Format.

How to concert the CSV file into the right CSV format

How to concert the CSV file into the right CSV format