Uploading a .csv File

How would I do this.  Is there a easy way to upload products other then doing it manually

I hope to be able to upload the Import / Export addon to OpenCart very soon, see http://forum.opencart.com/index.php/topic,846.0.html on this. It uses the XLS format for this.

How should I have the .xls layed out

The spreadsheet file will consist of 3 worksheets:

Worksheet 'Categories': (column 'description' is optional, not in standard OpenCart database)
category_id image_name image_title parent_id sort_order date_added date_modified language_id name description

Worksheet 'Products':
product_id name categories quantity model manufacturer image_name image_title requires shipping price sort_order date_added date_modified date_available weight unit status enabled tax_class_id viewed language_id description additional image names additional image titles old option  id old option type

Worksheet 'Options':
product_id language_id option_name option_value option_price option_prefix sort_order


All date columns are of the format yyyy-mm-dd hh-mm-ss.

As I said in my previous postings, as soon as I have the 255 character limitation problem solved, I'll upload the Export/Import to/from Spreadsheet addon here.

could you please do me an example of the spreadsheet

Here is how i upload my products to phpmyadmin:

----

EXPORT:
1- click on "export" tab
2- choose "csv for MS Excel"
3- Click on "save as file"
4- Click on "Go" > Save the file

5- Open with OpenOffice Calc (or MS office) application
6- Choose Seperator option: Comma
7- Click "Ok"

8- Edit CSV file
9- Save > Click "yes" on popup

IMPORT:
1- click on "import tab" tab
2- Locate file to import by clicking "browse"
3- Click on "CSV using LOAD DATA"
4- Check "Replace table data with file" option
5- Replace "Fields Terminated by" with a comma (,)
6- Fill column names, you can find these by clicking on "structure" tab.
You must type them in order. Seperate them with commas but no spaces.
(E.g. for "product description" table column names: "product_id,language_id,name,description")

7- Click "Go"
8- Check that import occured correctly.

----

I hope that helps.

Amin

What data should I have in the csv file at the moment I have just got

Part Number Description Price  GST Price Inc GST Sale price RRP Brand Cat


Im just going to have price. and cat is the category

I have now got:

Part Number Description Sale price Brand Cat Images

But I still would like an example

Hi jzm.

I'm in the process of trying to do the same with 3000+ products.

You can find my post here http://forum.opencart.com/index.php/topic,850.0.html.

I've posted my findings so far, though I'm waiting for confirmation that I'm on the right track. If all is OK, I'll let you know how I went about it, but I dare not at this moment in case I send you down the wrong path!!!

Let me know what programs / OS you're using. I'm using Linux only.

Off to bed now, so I'll catch up with you tomorrow.

Best wishes

broose.

excel and windows xp lol ok do u have msn as we are in diffrent time zones im a kiwi here (NEW ZEALAND)

Hi jzm.

I've written a log of how I imported csv's into my shop in pdf format. Is there a way to get it to you? No I don't have / use msn (I'm cr*p at typing - very slow one finger), any other way?

broose.

Check your email.

broose

broose wrote: Check your email.

broose

Replyed

is broose around

To jzm and others:

could you please do me an example of the spreadsheet

I have now uploaded a new Export/Import module which can be used to export all the categories, products and product options to an Excel spreadsheet. The latter can be edited offline and then be re-imported to the OpenCart database.

The Excel spreadsheet consists of three worksheets: Categories, Productsm and Options.

am I able to get a spreadsheet with how it all should be laid out

jzm wrote: am I able to get a spreadsheet with how it all should be laid out

also where should I upload this 2

That is great. Very nice of you to share it. 

bruce wrote: That is great. Very nice of you to share it. 

bruce how do you upload it were to i mean