1. Download an example of a CSV file by clicking on the test.csv link, or create file test.csv with the following code in it:
    Product code,Category,List price,Price,Weight,Quantity,Min quantity,Shipping freight,Date added,Downloadable,Files,Ship downloadable,Inventory tracking,Free shipping,Feature comparison,Zero price action,Thumbnail,Detailed image,Product name,Description,Meta keywords,Meta description,Search words,Page title,Taxes,Features,Options,Secondary categories,Pay by points,Override points,Override exchange rate,Supplier,Short description,Localizations,Status,Product URL,Detailed image
"0321294009","Books///Computers & Internet","45.00","45.0000","0.00","50","0","0.00","04 Feb 2006 10:50:02","N","","N","B","N","N","R","/var/www/html/stores/version210/images/backup/product/0321294009.01._SCMZZZZZZZ_.jpg#{[DA]:0321294009.01._SCMZZZZZZZ_.jpg,[DE]:0321294009.01._SCMZZZZZZZ_.jpg,[EL]:0321294009.01._SCMZZZZZZZ_.jpg,[EN]:0321294009.01._SCMZZZZZZZ_.jpg,[ES]:0321294009.01._SCMZZZZZZZ_.jpg,[FR]:0321294009.01._SCMZZZZZZZ_.jpg,[IT]:0321294009.01._SCMZZZZZZZ_.jpg,[NL]:0321294009.01._SCMZZZZZZZ_.jpg,[RO]:0321294009.01._SCMZZZZZZZ_.jpg,[RU]:0321294009.01._SCMZZZZZZZ_.jpg,[SI]:0321294009.01._SCMZZZZZZZ_.jpg,}","/var/www/html/stores/version210/images/backup/detailed/0321294009.01._SCLZZZZZZZ_.jpg#{[DA]:0321294009.01._SCLZZZZZZZ_.jpg,[DE]:0321294009.01._SCLZZZZZZZ_.jpg,[EL]:0321294009.01._SCLZZZZZZZ_.jpg,[EN]:0321294009.01._SCLZZZZZZZ_.jpg,[ES]:0321294009.01._SCLZZZZZZZ_.jpg,[FR]:0321294009.01._SCLZZZZZZZ_.jpg,[IT]:0321294009.01._SCLZZZZZZZ_.jpg,[NL]:0321294009.01._SCLZZZZZZZ_.jpg,[RO]:0321294009.01._SCLZZZZZZZ_.jpg,[RU]:0321294009.01._SCLZZZZZZZ_.jpg,[SI]:0321294009.01._SCLZZZZZZZ_.jpg,}","Adobe Acrobat 7.0 Classroom in a Book (Classroom in a Book)","<p>If you&#39,re like most Acrobat users--creative, business, and engineering pros who work with complex electronic documents--you can ill afford to miss a beat in your production workflow. Then again, you can ill afford being left behind when it comes to mastering the newest version of the important tool on your desktop, Adobe Acrobat 7. Not to worry: Adobe has brought the classroom to you in this handy volume, completely revised to cover all that&#39,s new and different in Acrobat 7. Through a series of self-paced lessons (each of which builds on the last and includes hands-on projects that the you can create using the files on the accompanying CD-ROM), this guide acquaints you with all of Acrobat 7&#39,s features for creating, reviewing, editing, commenting on, restructuring, and preflighting PDF files, including the newest: a tool for creating 3D objects, improved security, new tools for repairing errors in print preflight, structured bookmarks, the ability to export comments to Word docs, and more. Professional tips and techniques are scattered throughout!</p>","","","","","VAT","{4}ISBN: T[34225634890]","","","Y","N","N","","","","A","http://localhost/stores/version210/index.php?dispatch=products.view&product_id=1505","http://localhost/stores/version210/images/product/0/0321294009.01._SCMZZZZZZZ_.jpg"
"B0009IPN4Q","Apparel///Shoes","64.95","64.9500","0.00","50","0","0.00","04 Feb 2006 10:50:02","N","","N","B","N","N","R","/var/www/html/stores/version210/images/backup/product/B0009IPN4Q.01._SCMZZZZZZZ_.jpg#{[DA]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[DE]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[EL]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[EN]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[ES]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[FR]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[IT]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[NL]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[RO]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[RU]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,[SI]:B0009IPN4Q.01._SCMZZZZZZZ_.jpg,}","","Adidas Women's Daroga Mesh Casual Shoe","<b>Features</b><br /><b>&middot,&nbsp,</b>Mesh nylon upper combines light weight and breathability<br /><b>&middot,&nbsp,</b>High-traction rubber outsole<br /><b>&middot,&nbsp,</b>Unroll this open, breathable, high-traction performer to wear as a comfortable shoe or step into it like a clog around camp -- the perfect shoe to pack when pack space is limited<br /><b>&middot,&nbsp,</b>Die-cut EVA midsole for lightweight comfort, airmesh lining for comfort and breathability, Ortholite antimicrobial moisture-wicking sock liner<br /><br />","","","","","VAT","{5}(New features) Manufacturer: E[Adidas]","{698}Clothing Size: S[{2894}7.5 M,{2895}8 M,{2896}6.5 M,{2897}7 M,{2898}8.5 M]","","Y","N","N","","","","A","http://localhost/stores/version210/index.php?dispatch=products.view&product_id=1537","http://localhost/stores/version210/images/product/0/B0009IPN4Q.01._SCMZZZZZZZ_.jpg"
    NOTE: You are able to view or edit a CSV file in a spreadsheet application, for example Microsoft Office Excel.
  2. In the administration panel, go to Administration > Import data > Products.
  3. Chosse the desired Store from the drop-down menu in the left part of the upper panel:




  4. In the Import options section, specify the following settings:
    • Category delimiter - Leave /// in this field (it is entered by default).
    • Features delimiter - Leave /// in this field (it is entered by default).
    • Images directory - Do not change the value of this field.
    • Files directory - Do not change the value of this field.
    • Delete all existing product files before import - Do not select this check box.
    • Reset inventory - Do not select this check box.
    • Price decimal separator - Decimal separator for product prices.
    • CSV delimiter - Select Comma.
    • Select file - Click on the Local link and select the downloaded (or created) CSV file.
  5. Click the Import button. You will se the following notice:




  6. After that the Adobe Acrobat 7.0 Classroom in a Book (Classroom in a Book) and the Adidas Women's Daroga Mesh Casual Shoe products will be imported into your store under the Books/Computer & Internet and Shoes categories respectively. Please check them in section Products > Products.