I’m trying to import a list of products but Im getting the “store” not defined error. What I did was: I create one product with the Magento interface and I export using Import/Export Profiles after I open the CSV with Excel and I fill the file after this I try to import everything with Import/Export Profiles without any success :(
I read that you need to map the fields this is necessary if I use the profiles? And the mapping thing how works? any examples?
It is possible that someone can upload a CSV file with the files and the maping thing that we should use for that specific file in Magento?
I cannot successfully import a batch of products. Here are the steps I’ve taken so far.
I did the one click install on Media Temple (mt) Grid Server.
added a category
added a product
exported a csv file so as to get the proper format for the import.
taken my original csv file with my products and copied my sku, price, description, short description to the appropriate columns in the magento export template
changed the values in the store column for all of my product rows to default (all lower case and no quotes)
modified the Import All Products profile to accept my .csv file
ran the profile after saving it
pressed run profile in popup
I get Processed 0% 0/10 records and it just hangs there
My products file has 9000+ records. I’ve tried importing them all, I’ve tried just ten at a time and in both cases I get the same screen with the processing message.
I feel like I’m so close yet so far… I’m not getting any errors when attempting the import (like I was before I added the default to each row in the store column) but it just hangs.
1) Exported products from Magento to get the CSV file format;
2) Created a new CSV file based on the exported one
3) Using ‘default’ (no quotes) for the ‘store’ column
4) Getting an error: {"savedRows”:0,"errors":["Skip import row, required field \"store\" not defined"]}
I have tried everything to import a csv file, default in the store column etc. First I tried 443 records and 258 imported fine except the images. Then I cut it down to ten products and only three would import.
Anyone have any clues?
I have looked at every shopping cart there is to look at and this one is the one I want to use.
well , it seems that there are some fields which is must be filled, for example the weight ,
i manage to upload , to a particular store , with all records,
current upload record 5,000 products ,
tomorrow will try 45,000 products
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?
Having the same issue. Probably missing something simple. Please see attached file & copy from failed import:
pre> <strong>Notice:</strong> <i>unserialize() [<a href=’function.unserialize’>function.unserialize</a>]: Error at offset 7 of 27 bytes</i> in <strong>/home/shopme5/public_html/store/app/code/core/Mage/Dataflow/Model/Batch/Abstract.php</strong> on line <strong>52</strong><br/>[0] in <strong>unserialize</strong>("a:1:{s:785:"PK!X") in <strong>/home/shopme5/public_html/store/app/code/core/Mage/Dataflow/Model/Batch/Abstract.php</strong> on line <strong>52</strong><br/>[1] in <strong>Mage_Dataflow_Model_Batch_Abstract->getBatchData</strong>() in <strong>/home/shopme5/public_html/store/app/code/core/Mage/Adminhtml/controllers/System/Convert/ProfileController.php</strong> on line <strong>232</strong><br/>[2] in <strong>Mage_Adminhtml_System_Convert_ProfileController->batchRunAction</strong>() in <strong>/home/shopme5/public_html/store/app/code/core/Mage/Core/Controller/Varien/Action.php</strong> on line <strong>341</strong><br/>[3] in <strong>Mage_Core_Controller_Varien_Action->dispatch</strong>("batchRun") in <strong>/home/shopme5/public_html/store/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php</strong> on line <strong>141</strong><br/>[4] in <strong>Mage_Core_Controller_Varien_Router_Admin->match</strong>(Mage_Core_Controller_Request_Http) in <strong>/home/shopme5/public_html/store/app/code/core/Mage/Core/Controller/Varien/Front.php</strong> on line <strong>147</strong><br/>[5] in <strong>Mage_Core_Controller_Varien_Front->dispatch</strong>() in <strong>/home/shopme5/public_html/store/app/Mage.php</strong> on line <strong>424</strong><br/>[6] in <strong>Mage::run</strong>("default") in <strong>/home/shopme5/public_html/store/index.php</strong> on line <strong>40</strong><br/> </pre>{"savedRows”:0,"errors":["Skip import row, required field \"store\" not defined"]}
ok - just did the update. removed all products, added a new one, exported csv file, added 5 more products and tried to import, getting this:
Starting profile execution, please wait…
Warning: Please don’t close window during importing/exporting data
Starting Mage_Dataflow_Model_Convert_Parser_Csv :: parse
Found 6 rows
Starting catalog/convert_adapter_product :: parse
Skip import row, required field “store” not defined
Skip import row, required field “store” not defined
Skip import row, required field “store” not defined
Skip import row, required field “store” not defined
Skip import row, required field “store” not defined
Skip import row, required field “store” not defined
Processed 100% 6/6 records
Imported 0 records
Finished profile execution.
Trick is that the store column is defined with “default” (no quotes)
am getting this error as well ...am trying out the earlier recommendation of adding a product manually and then exporting this. Retaining the order of the field headers that got exported and trying an import...will keep you posted ...