Magento

@anand k - Have you tried out Ben’ MYSQL configuration

not yet,
maybe i should try that

can i use ben’s configuration for ver 1.0 ?

I seem to have a different issue with importing, not sure if any of you have experienced it.  I can import products fine (I use the slash before the image, put them in the correct file, set the store to ‘default’—all the tricks of the trade).  After import, I see all the products in the admin, all assigned to the correct stores.  But when I load the store—particularly pages containing the What’s New block—my browser hangs and often can’t load the page.  I delete out all the newly imported products and then manually add a few and I’m good—my site loads fine.  I only seem to get a hanging browser after bulk imports.

Thoughts?

ok . manage to upload 8445 products until it stopped moving,
Will try again today.

I hate to be the one to have to revisit this subject.  But I downloaded the most recent version of magento-1.0.19870.1 , and am having problems with importing images.  The Media file structure is not the same as in this original post, and I haven’t been able to find the PHP file that directs the DataFlow where to grab the photo from.

I can import and export products to CSV no problem, it seems only the the /xyz.JPG is not the correct path anymore when used to import.

I’m developing locally on WAMP.

The image path that gets exported is /M/M/MML-199.JPG from a manually input product and product image.

My current file structure is: wamp/www/magento/....

And the media file structure to the import is: magento/media/import

And to the “M” file where the image is stored is:  magento/media/catalog/product/m/m/

Please let me know if you need more information than I’ve given or any ideas that any of you may have.

Many thanks!

PS-I posted this on another thread as well.  If that is not ok with people let me know.  Both threads are pertinent to my problem.

This is what I’ve gathered so far.

1.  Create all your categories
2.  Create one product
2.  Admin> System>Export> Profiles -Export all products –use “Default Store View” It will give you a CSV file found in var/export/export_all_products.csv
3.  Use that file as a template. Here are some notes:
-images should be uploaded to media/import/ folder loose (no directories within import)
-Can use same image for all three spots (base, small, thumb)
-Add a / infront of the image name for ALL THREE images (base, small, thumb)
-Get category numbers from Admin> Catalog>URL Rewrite Management
-Save as: CSV windows
4.  Upload to import.csv to Var/Import
13.  Admin> System>Import> Profiles -Import all products - Use “Default store view”, CSV
14.  The system will take the first two letters of the image name and put in in media\catalog\product\fist letter\second letter this is were the browser will locate the image when requested.

My problem is that when I had previous attempts, there’s residual product information in my database and I’m getting an error saying that I have multiple instances of keys.  So far, this is what I’ve managed to figure out to delete all my old product info. Please add if you know anything else that should be in here.

To delete:
1. Delete media\catalog\product\ contents
2. Run SQL:
TRUNCATE `catalog_product_website`;
TRUNCATE `catalog_category_product`;
TRUNCATE `catalog_product_entity`;
TRUNCATE `catalog_product_entity_datetime`;
TRUNCATE `catalog_product_entity_decimal`;
TRUNCATE `catalog_product_entity_gallery`;
TRUNCATE `catalog_product_entity_int`;
TRUNCATE `catalog_product_entity_media_gallery`;
TRUNCATE `catalog_product_entity_media_gallery_value`;
TRUNCATE `catalog_product_entity_text`;
TRUNCATE `catalog_product_entity_tier_price`;
TRUNCATE `catalog_product_entity_varchar`;

ALTER TABLE `catalog_product_website` AUTO_INCREMENT =1;
ALTER TABLE `catalog_category_product` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_datetime` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_decimal` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_gallery` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_int` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_media_gallery` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_media_gallery_value` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_text` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_tier_price` AUTO_INCREMENT =1;
ALTER TABLE `catalog_product_entity_varchar` AUTO_INCREMENT =1;

siridyal - 08 June 2008 05:10 PM

I hate to be the one to have to revisit this subject.  But I downloaded the most recent version of magento-1.0.19870.1 , and am having problems with importing images.  The Media file structure is not the same as in this original post, and I haven’t been able to find the PHP file that directs the DataFlow where to grab the photo from.

I can import and export products to CSV no problem, it seems only the the /xyz.JPG is not the correct path anymore when used to import.

I’m developing locally on WAMP.

The image path that gets exported is /M/M/MML-199.JPG from a manually input product and product image.

My current file structure is: wamp/www/magento/....

And the media file structure to the import is: magento/media/import

And to the “M” file where the image is stored is:  magento/media/catalog/product/m/m/

Please let me know if you need more information than I’ve given or any ideas that any of you may have.

Many thanks!

PS-I posted this on another thread as well.  If that is not ok with people let me know.  Both threads are pertinent to my problem.

I had a problem with same of the image imported by “csv”. after do a analyses i realize that the problem (image doesn’t show) append on image with extension .JPG (upper case). I renamed all the image extension to .jpg (lower case) and its worked.

Good Post Karma…

This one was helpful. Did not realize that Magento was trying to move the image file from media/import to media/catalog. I can deal now.