How to import products to.csv? 

Post By:user_18361 | Reply

 

I need to import 250 000 products to .csv… How can I do this? May be there is any software that will make this process simple?

Thank you....

user_1838Fri, 18 Jan 2013

 

That’s exactly what I’ve been looking for!

thanks!

user_565Thu, 17 Jan 2013

 

Hi!
You can use Extended Product Grid with Editor Extension for quick import of 250 000 products to .CSV. XML format is also available.

Maybe it is also helpful for you. The module allows to export products belonging to a certain category, manufacturer or based on some other characteristic. Add the necessary parameters to the products grid, filter products by the parameters and click export button.

While the Extended Product Grid with Editor Extension easily helps with your issue, it also lets you add vast majority of the product attributes to the product grid, so you can make your grid a lot more informative and functional, as it is possible to filter and sort products by the added attributes. You can edit the attribute data on the grid. 
For details, video and user guide go here http://amasty.com/extended-product-grid.html

Image Attachments
extended product grid.png

user_18362Thu, 17 Jan 2013

 

I have found a service which always helps me to import data not only from csv, but also from xml, txt and Excel files. This service is very fast and works without errors. Check out its functionality here
It is exactly what you need.

Cheers

user_18098Wed, 16 Jan 2013

 

Yes - we have a software application that integrates directly with your Magento that will handle just that.  If you’re interested email me at

Thanks,

Matt

user_4519Tue, 12 Jun 2012

 

I have looked at the import feature but my understanding is that you first need to export a product to get the mapping of the csv field, then lign up your supplier csv to match. Given the amount of products we are dealing with, this can be quite time consuming, especially because the stock values need to be updated at least once a day.

For every site I have ever done, this is pretty much required. You need to match up so Magento knows what values to use. There are also specific Magento attributes that you need to assign to those products as well.

Once the product has been created, you don’t need to keep on reimporting the same data. If you are uploading stock values. All you need to do is have a two column CSV file “sku” and “qty”.

Then there is the fundamental problem of sorting all the products.  The logical solution for me would have been to assign an attribute to a category and all products with that attribute would appear under that category. But unfortunately I’m not finding any information about this.

You just described layered navigation which is standard in Magento CE.

I’m now back to having to take that attribute value in the supplier csv file and write a script that will change the value to a store category so that it will properly import. This isn’t the prefered method but I don’t know what else to do.

I’ve never heard of this method before. Just take the products in batches. Thats what I know works. Once the initial import has been done, you don’t need to keep on importing the “description”, “name”, and other attributes.

user_3848Tue, 12 Jun 2012

 

Hi Kris,

I have looked at the import feature but my understanding is that you first need to export a product to get the mapping of the csv field, then lign up your supplier csv to match. Given the amount of products we are dealing with, this can be quite time consuming, especially because the stock values need to be updated at least once a day.

Then there is the fundamental problem of sorting all the products.  The logical solution for me would have been to assign an attribute to a category and all products with that attribute would appear under that category. But unfortunately I’m not finding any information about this.

I’m now back to having to take that attribute value in the supplier csv file and write a script that will change the value to a store category so that it will properly import. This isn’t the prefered method but I don’t know what else to do.

With your experience, what would you suggest for a scenario such as this?

Thank you

user_4519Tue, 12 Jun 2012

 

1) 250,000 products is quite a lot. You would seriously need a beefy server for that.

Magento can easily handle 50,000 products no problem. You start running into performance issues at 60,000 products. I’ve had stores with 100,000 products on a dedicated box and 1,000,000 products (they needed a cluster).

Have you tried the product import feature yet in Magento or no? Its pretty standard, and I use it everyday. Works pretty well.

Let me know…

user_3848Tue, 12 Jun 2012

 

I’m in the same situation and there doesn’t seem to be an easy way to sort products on import. When the question is asked the thread immediately dies.

So I went out and purchased Store Manager for Magento at http://www.magneticone.com and the import process was extreemly easy.

The only problem is again, you cannot sort products on import based on an attribue value. The work around MagneticOne gave me was to search for a specific field value that I am using internally for sorting and then assign them to a category, but this is done AFTER the products have been imported.. Like you, I have over 170k products and this is not a viable solution.

The other solution is to manually modify the csv file and add a column with category locations… Again not realistic when dealing with this many products.

Now I’m looking to see if there is any alternative.....

Does anyone have a program that can automate the mapping or porting of specific fields to import to magento? My supplier provides a csv file and I’m not about to manually go each day to match it up to the one I exported from Magento… There has to be an easier way.

`Reply Or Comment!
Please LogIn to Reply!