Post by jzm » Sun Jan 20, 2008 1:01 pm

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

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by JNeuhoff » Sun Jan 20, 2008 10:23 pm

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jzm » Mon Jan 21, 2008 1:23 am

How should I have the .xls layed out

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by JNeuhoff » Mon Jan 21, 2008 3:20 am

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jzm » Mon Jan 21, 2008 3:22 am

could you please do me an example of the spreadsheet

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by silverpenhouse » Mon Jan 21, 2008 9:03 am

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


Posts

Joined
Thu Jan 03, 2008 1:47 pm

Post by jzm » Mon Jan 21, 2008 9:14 am

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

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by jzm » Wed Jan 23, 2008 2:09 am

I have now got:

Part Number Description Sale price Brand Cat Images

But I still would like an example

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by broose » Wed Jan 23, 2008 6:08 am

:)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.

Newbie

Posts

Joined
Sat Jan 19, 2008 2:46 am

Post by jzm » Wed Jan 23, 2008 6:10 am

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

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by broose » Thu Jan 24, 2008 4:42 am

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.

Newbie

Posts

Joined
Sat Jan 19, 2008 2:46 am

Post by broose » Thu Jan 24, 2008 4:53 am

Check your email.

broose

Newbie

Posts

Joined
Sat Jan 19, 2008 2:46 am

Post by jzm » Wed Jan 30, 2008 4:38 pm

broose wrote: Check your email.

broose
Replyed

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by jzm » Sun Feb 03, 2008 10:27 am

is broose around

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by JNeuhoff » Sat Feb 09, 2008 4:57 am

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jzm » Sat Feb 09, 2008 5:02 am

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

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by jzm » Sat Feb 09, 2008 6:00 am

jzm wrote: am I able to get a spreadsheet with how it all should be laid out
also where should I upload this 2

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am

Post by bruce » Sat Feb 09, 2008 1:16 pm

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

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by jzm » Sat Feb 09, 2008 1:19 pm

bruce wrote: That is great. Very nice of you to share it.  ;D
bruce how do you upload it were to i mean

jzm
New member

Posts

Joined
Mon Jan 14, 2008 11:38 am
Who is online

Users browsing this forum: No registered users and 3 guests