?
Solved

magento import products with images from csv

Posted on 2013-11-29
13
Medium Priority
?
1,033 Views
Last Modified: 2016-03-02
Hi i've inherited a magento website. :)

The client has a stock system in his shop that has a daily backup on it.
The backup is stored as a CSV and the company that manages the stock control system then uploads this CSV to the hosting account of the magento website ready for import.


What am trying to work out is:
Does the magento import system require the images to be in a specific folder on the web hosting?

i imagine that the CSV file will have entries for where the images are located? (haven't seen the CSV yet)

what i don't want to happen is for me to upload the new CSV to the site and then magento to say that the csv cant find its product images.

do you know how the CSV knows where to look for the images that belong to each product? does it default to looking for the images in its current "root" location on the hosting?

i need to give the company that deals with the backup a FTP account and i don't know what folder on the hosting is the correct place for them to upload csv and images.

i have no experience of importing products with images on the magento platform so i hope some one here can help thanks!
0
Comment
Question by:helpchrisplz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
13 Comments
 
LVL 58

Expert Comment

by:Gary
ID: 39685486
Using Dataflow?
Images should go in /media/import - you don't need to give the path to the images, just the image name preceded by a slash e.g. /image.jpg

This is from memory as I always used Magmi for imports.
0
 
LVL 1

Author Comment

by:helpchrisplz
ID: 39685558
thanks. is Magmi just a extension for magento?

sorry am new to magento.
do i you have a link to some instructions of  Magmi?

if i didn't use Magmi and just used the built in importer would i just give the stock control company direct access to the /media/import folder so that they can put both the CSV and the images in the same folder?

thanks
0
 
LVL 58

Accepted Solution

by:
Gary earned 2000 total points
ID: 39685574
Magmi is a separate plugin (you access it separately from Magento) - uber fast - link is in the comment
http://sourceforge.net/projects/magmi/
http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Main_Page

And yes to /media/import
0
Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

 
LVL 1

Author Comment

by:helpchrisplz
ID: 39685640
it says magmi needs: InnoDB tables compatibility (using Transactions)
i just checked the database and it is not using InnoDB as default but is is available.

do i need to set it as default? not sure how to though.
0
 
LVL 58

Expert Comment

by:Gary
ID: 39685653
Are you sure its not InnoDB - that's what Magento uses. Anything else would/could cause problems.
0
 
LVL 1

Author Comment

by:helpchrisplz
ID: 39685660
i followed this guide from another website:

If you need to determine whether or not InnoDB is enabled by querying the database, you should use the INFORMATION_SCHEMA tables.

SELECT SUPPORT FROM INFORMATION_SCHEMA.ENGINES WHERE ENGINE = 'InnoDB';
Which, if InnoDB is enabled and is the default database, gives a result of

+---------+
| SUPPORT |
+---------+
| DEFAULT |
+---------+
If InnoDB is available, but not the default engine, the result will be YES. If it's not available, the result will obviously be NO.


MY RESULT when running the sql was:

SUPPORT
YES
0
 
LVL 58

Expert Comment

by:Gary
ID: 39685673
What version are you using? You can convert them.

(Hasn't this question digressed...;o)
0
 
LVL 1

Author Closing Comment

by:helpchrisplz
ID: 39688407
ty
0
 
LVL 1

Author Comment

by:helpchrisplz
ID: 39688408
version?

i can open a new question.
0
 
LVL 58

Expert Comment

by:Gary
ID: 39688422
Magento version for converting to InnoDB - there are a couple of scripts for the tables.
0
 
LVL 1

Author Comment

by:helpchrisplz
ID: 39688479
the last hosting the website was on also comes out as SUPPORT: YES

The website is Magento ver. 1.7.0.2
0
 
LVL 58

Expert Comment

by:Gary
ID: 39688497
1.Take a backup of the database
2.Take a backup of the database
3.Take a backup of the database

Run the following in PHPMyAdmin or similar changing db-name to your db

SET @DATABASE_NAME = 'db-name';

SELECT  CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE';

Open in new window


Copy the output and run it as a new sql command
0
 
LVL 1

Author Comment

by:helpchrisplz
ID: 39695354
i opened another question. i will try with the default magento dataflow importer for now.

http://www.experts-exchange.com/Web_Development/Internet_Marketing/E-Commerce/Q_28309954.html
0

Featured Post

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
The viewer will learn how to count occurrences of each item in an array.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question