Import Manufactures list

Hi,

Is it possible for me to import a manufacturers list? I have over 800 manufacturers, and that could take some time.

I have all manufacturers in a .csv or tabbed delimited format, how do I import that?

I'm looking at the easy populate mod, but for now it does not seem to be an answer...

Actually, I have a database from a Cold Fusion site. When I open the csv files and flat files in Excel, it looks like a monkey on crank garbled up all the data.

:shocking:

EasyPopulate doesn't do this.

You could compile a SQL query that looks like this:-

INSERT INTO `manufacturers` (`manufacturers_id`, `manufacturers_name`, `manufacturers_image`, `date_added`, `last_modified`) VALUES
(1, 'Casio', 'manufacturers/casio.jpg', '2008-05-20 09:00:00', '2008-05-20 09:00:00'),
(2, 'Hitachi', 'manufacturers/casio.jpg', '2008-05-20 09:00:00', '2008-05-20 09:00:00'),
(3, 'JVC','manufacturers/casio.jpg', '2008-05-20 09:00:00', '2008-05-20 09:00:00'),
(4, 'Kenwood', 'manufacturers/casio.jpg', '2008-05-20 09:00:00', '2008-05-20 09:00:00');

My example shows just 4 entries, but this should not take long if you use Excel and make use of it's capacity to:-
add an incremental number in a cell (for the Manufacturer's ID)
CONCATENATE text in fields (if needed, will help create image file path, AND bring all the text together for each reference)
EXPORT file as TXT file

With Excel, a lot of the data is duplicated (see my dates), so use excel to copy and paste.

With 800 manufacturers, this method should take about 30 minutes...

This query only works partially. I cannot see the new manufacturers on my home page- i.e. under "manufacturers" list scroll down box.

However, I can see the new manufacturers when I go to admin > catalog > manufacturers

Suggestions? :ohmy:

Add some products for them? :smile:

Or, check the Configuration ... Maximum Values ...

Manufacturers List - Verify Product Exist
Verify that at least 1 product exists and is active for the manufacturer name to show

Note: When this feature is ON it can produce slower results on sites with a large number of products and/or manufacturers
0= off 1= on

NOTE: A dropdown box of 800 manufacturers can really be a problem to navigate ... you may want to come up with a different method of accessing them, if proves to be a problem ...

Yes, adding products for them works!