Thank you

* Starting profile execution, please wait…
* Warning: Please don’t close window during importing/exporting data

* Starting Mage_Dataflow_Model_Convert_Parser_Xml_Excel :: parse
* Found 0 rows
* Starting catalog/convert_adapter_product :: parse

and then it stops and nothing is imported

I was importing product with ‘store’ set as ‘default’ and everything was fine. Now when I tried to update the description, I observed that the frontend shows the change and the backend doesn’t. On looking at the import process further, understood that Magento imports all data as ‘Admin’ during the first import and then on it looks at the store field passed through import. Since in my case this is set to ‘default’, the front end reflects the change in description and backend doesnt as it still shows the first imported data (as admin).

This is a bit confusing as the ‘default store view’ gets shown only if we create one more store view. Wonder what the difference is between ‘default’ store view and the admin store view?

roco

There has been an error processing your request.
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘store_id’ in ‘order clause’

ever since I have no access to the static blocks area. BTW I have no problem accessing other parts such as categories and or manage pages.

any ideas on how to fix it?

* Starting profile execution, please wait…
* Warning: Please don’t close window during importing/exporting data

* Starting Mage_Dataflow_Model_Convert_Adapter_Io :: load
* Loaded successfully: /mnt/gs02/herd03/28239/domains/supplements4.com/html/var/import/product.csv [125717 byte(s)]
* Starting Mage_Dataflow_Model_Convert_Parser_Csv :: parse
* Finished profile execution.

There appear to be no errors but the products did not appear in the catalog. Can anyone explain if there is an error.

Also does anyone have a sample spreadsheet with the standard columns that I could use as a template. I guessed the column headers from the mapping filed drop-down.

I’m currently migrating a CRE Loaded (osCommerce) store with over 22,000 items - all with pictures, and manufacturers associated with them.  All of these items were entered in manually over the course of about 2 years with the help of one full-time person and about 3 other people when we “had time” (yeah right!).

First, I exported all my products using Easy Populate that was included with CRE Loaded.  Then, imported that text file into FileMaker Pro to edit and clean up the files.  Excel can’t handle a “cell” with over so many characters, and often my descriptions go way above the limit, so I’m left with a bunch of descriptions that read and export as “#####.”

I uploaded one product to my Magento installation, then exported it.  I imported that csv file into FileMaker Pro.

Then using my magento.csv file, I imported my edited CRE Loaded database, used FileMaker’s import tools to align the old tables with the new ones, and volia!  I’ve got a nice file to import into Magento.  Or so you would think....

For some reason, I had to export the file as an Excel XML file before I could get ANYWHERE at all.  I don’t know why.  I’m just satisfied I got something to work.

I split the file up by manufacturers, so the import would actually work.  The problem with 22,000 items means I have about 1,000+ categories.  Until the powers that be make the Category system more user friendly, I have to manually create the categories, and add the products.  This is very undesirable, as we have over 100 manufactures.

Once imported, I had the same problem as everyone else.  The products didn’t show up until they were opened from the backend and then saved again.  I did however figure out that all you have to do is…
1) go to products > manage products
2) click “select all”
3) next to “Actions” pull down the box and select “Change Status”
4) pull down the new box that pops up, select “Enable”
5) click “Submit”
That’s it!  It takes care of all your products, so for those if you in my situation with tons of products, it’s a huge time saver.

Next, I created the Category and was able to mass assign the imported products to that category.  Wohooo I’m lovin this stuff.

Ok, so here’s my problems.  Images don’t work!  I zipped all the images from CRE Loaded, dropped them in the /media/import folder in magento and made sure that i had /image.jpg for all three images in my XML file.  I learned this was how to get images to work from Anna’s post (http://www.magentocommerce.com/boards/viewthread/7018/).  Anyone else find this dosen’t work for them?  When I click on the products that have been imported through the product manager, then click “Images” I find that there are no images assigned.  For some reason the Import is ignoring my instructions.. *grrrr*

Next thing I have issue with is Manufacturers. From what I understand I’m going to have to insert my manufacturers manually, then import the products.  Talk about nightmare!  I’ll need a serious supply of Starbucks and about 36 hours to get this done.  I know it’s possible, but it somehow doesn’t seem worth it.  Manufacturers is a pretty important deal to retailers.. I’m surprised its not an easier feature to deal with.  Maybe in the next release… unless anyone has figured out a workaround.

So I’ve sort of halted my imports until I can get the issues I have fixed.  It seems I may be putting in maaaaaany hours to get things up and going, and I’d rather just do it once!  Any input on my issues are much appreciated!!

For now, I’m stuck with the unreliable, customers-get-pissed-off-and-call-freaking-out CRE Loaded!

Thanks!
Mark