Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Importing the following data from a .csv file


Recommended Posts

I have a rather large list of products which i wish to import into oscommerce.


I have the data in .csv format


here is a snippet of the file



1,ANISE STAR,10ml,£3.99,Anise Star – seed (Illicium verum)

2,BASIL,10ml,£6.25,Basil - leaves (Ocimum basilicum) An uplifting oil and helpful during times of concentration. It has a warm and spicy aroma. Use in moderation.

3,BAY,10ml,£5.99,"Bay – leaves (Pimenta racemosa) Known for its qualities as a hair and scalp tonic. It has a light, sweet and delicately spiced aroma."

4,BENZOIN,10ml,£3.85,Benzoin – resin (Styrax benzoin) Useful for chapped skin and inhalations. It has a sweet warm aroma reminiscent to vanilla.

5,BERGAMOT,10ml,£5.99,"Bergamot – fruit peel (Citrus aurantium) A most refreshing oil and one of the oils that has a deodorizing quality. A calming oil, which is also uplifting."

6,BLACK PEPPER,10ml,£6.50,"Black Pepper – peppercorns (Piper nigrum) A strengthening and stimulating warming oil, is excellent to use for sports massage or for muscle fatigue. It has a smooth and delicate sweet aroma reminiscent to soft fruits."


My question is, how do i import this data into oscommerce and how do i make it compatible to be imported.


I have phpmyadmin, is there a way to import the data into the database directly, if so how?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...