Shop owners will often already have data that they wish to use with their PrestaShop installation.  Fortunately, there is a built in option for importing this data using Comma Separated Value (CSV) files.  The following tutorial will show you how to use the import option which is in the Advanced Parameters section of the PrestaShop 1.5 administrator. 

How to use the CSV Import Option in the Advanced Parameters in PrestaShop 1.5

  1. To get to the Performance section of the Advanced Parameters for Prestashop, first login to the Administrator as an Administrator
  2. Hover over menu bar where it says ADVANCED PARAMETERS - click on CSV IMPORT when it appears in the drop-down menu.
  3. You will see something similar to this screenshot:

    prestashop15-advparams-csvimport-1


    Before you can go to the next step you have to import a CSV file.  Note that PrestaShop actually provides examples of the CSV files.  Click on UPLOAD next to the field labeled Your CSV file (0 file):

    prestashop15-advparams-CSVimport-2

    Each of the samples above can be click on with your mouse.  The CATEGORIES sample file was selected for this tutorial.  Note that per the instructions above you can upload a specific type of file in a specific location.  This information is summaried below:

    - Upload the file via FTP to the path indicated under the BROWSE button above
    - Upload either a UTF-8 or ISO-8859-1 encoded file

    To see the Sample in action, simple click on one the listed Sample files, then click UPLOAD button to load the file.
  4. The next section is labeled What kind of Entity would you like to import?  This option gives you a drop-down menu with the following options:

    CATEGORIES

    CUSTOMERS
    PRODUCTS
    COMBINATIONS
    CUSTOMERS
    ADDRESSES
    MANUFACTURERS
    SUPPLIERS

    prestashop15-advparams-csvimport-3

    As the screenshot above indicates, the Available Fields to the right changes as you choose a different entity to import in the drop down menu.
  5. Language of the file is the next option.  It is selected by clicking on the drop-down menu.  The instructional text indicates that the locale must be installed.  This means that if the locale is not loaded that matches with the language that you are using, then you must go into LOCALIZATION and select the country to load (see How to Add Countries in PrestaShop 1.5). 

    Select the Language in the drop down menu and then move to the next item below.
  6. This check box asks if you're using the ISO-8859-1 encoding.    ISO-8859-1 is the default character set for most internet browsers.  You can see a much more complete definition of this standard here:

    W3Schools.com HTML ISO-8859-1 Reference

    Select the check box if you are using this encoding. 
  7. The next two steps indicates the FIELD SEPARATOR and MULTIPLE VALUE SEPARATOR that you may be using in your CSV file. 

    Field Separator

    Typically, you would think that the field separator in a CSV file would be a comma, but it can actually be a variety of characters.  This option lets you designate the character used to separate the values.  Click on the field and then type in the character used to separate the values in your import file.

    Multiple Value Separator

    Occasionally multiple values are grouped within a CSV, but they are separated with a secondary symbol such as a period or dash.  The example below is copied from the screen:

    Ipod; red.jpg, blue.jpg, green.jpg;129.90

    This  example gives you the category, and three image options separated by commas.  This is the multiple value separator.  If you do not have one, leave it blank, or use a character not being used by the main field separator.
  8. The next category is the last option to select before you actually adjusting the values of your import to complete the process.  This option is called DELETE ALL CATEGORIES BEFORE IMPORT?  This option lets you decide if you wish to remove all of the categories that may already be saved in your database BEFORE you import a new set of data.  Carefully consider if this is required and then click on the check box in order to enable it.

    After this option has been selected there is a button at the bottom of the screen that says NEXT STEP and warning below it.  Here's a screenshot:
    prestashop15-advparams-csv-nextstep

    Before clicking on the NEXT STEP, please note the warning in the yellow box.  CATEGORIES CANNOT BE THE SAME NAME.
  9. Click on NEXT STEP to go to the final step before you import the data is to look at the data being imported and adjusting it to make sure that there are no problems before committing the import.  Here's a screen that shows an example of what you may see:
    prestashop15-advparams-CSVimport-main


    Note the options that are labeled in the screenshot. Here's a summary list:

    Save and load your matching configuration - option lets you save the configuration you designate for the file you are importing

    Skip ## lines - option lets you skip a specific number of lines before importing

    << and >> - used to navigate back and for through the columns of the table

    IMPORT CSV and CANCEL buttons - allows you to initiate the actual import of the data into your PrestaShop data


    The main purpose of this screen is to adjust the value of each column so that it matches up with the field definitions of the PrestaShop table.  Since the order of the values is most likely NOT the same as the PrestaShop table, you simply need to go to each column and select the drop-down field in order to select the matching value.  Note that the NAME value has an * by it indicating that it is the primary field for the table.  The values in the drop down menu will vary depending upon the entity you selected in Step 4. 

  10. Match the values, then select IMPORT CSV in order to complete the process.  If needed, click on CANCEL to stop the import at any point. 

Importing data is one of the most sought after features for e-commerce programs because the data for stores may often be coming from another application.  Care should be taken with this feature in that it immediately affects your entire store in terms of the languages used, the format of the data placed in the database, and the size of the data.  Take these factors into account when setting up your shop and optimizing for performance issues. The customer will see the effects of your imports primarily based on the imported content that you show in your store.

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.