cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 2 products import issue with CSV

Magento 2 products import issue with CSV

Hello,

I am importing products in magento 2.1.1 . I have imported some products successfully.I want to import more products using csv but there is no products is showing in admin and database table in spite of  there is no validation error and import is also successful. 

Thanks!

5 REPLIES

Re: Magento 2 products import issue with CSV

@Om Prakash

 

A sample of your product listing + the screenshot of your Magento catalogue section will be helpful here. Do you mind sharing that? 


Secondly, make sure that you have created all the required Product Attributes (if any) before importing the catalogue. 

 

I hope that helps. 

Magento Certified Solution Specialist | Lead Magento developer
If this response was helpful to you, consider giving kudos to this post

Re: Magento 2 products import issue with CSV

Catalog.pngCatalogCSV.png

This is admin catalog section and csv file structure.I have imported previous products with same product attributes as shown in csv. Thanks!

 

 


ShoaibRehman89 wrote:

@Om Prakash

 

A sample of your product listing + the screenshot of your Magento catalogue section will be helpful here. Do you mind sharing that? 


Secondly, make sure that you have created all the required Product Attributes (if any) before importing the catalogue. 

 

I hope that helps. 


 

Re: Magento 2 products import issue with CSV

@ShoaibRehman89

Any solution why products are not created after successful import? There is no timeout error.I am importing just 10 products. 

Thanks!

 


Om Prakash wrote:

Catalog.pngCatalogCSV.png

This is admin catalog section and csv file structure.I have imported previous products with same product attributes as shown in csv. Thanks!

 

 


ShoaibRehman89 wrote:

@Om Prakash

 

A sample of your product listing + the screenshot of your Magento catalogue section will be helpful here. Do you mind sharing that? 


Secondly, make sure that you have created all the required Product Attributes (if any) before importing the catalogue. 

 

I hope that helps. 


 


 

Re: Magento 2 products import issue with CSV

@Om Prakash

 

The only issue that I can think of is the server time out. How many products are you trying to import? I can see that you already have just over 1000 products in your catalog. 


Secondly, when importing the CSV, did you select ADD/UPDATE from the action dropdown? 

Magento Certified Solution Specialist | Lead Magento developer
If this response was helpful to you, consider giving kudos to this post

Re: Magento 2 products import issue with CSV

@ShoaibRehman89

I am importing just 10 products in a single CSV file because of server timeout issue.I have already imported 1000 products successfully using 100 products in a single CSV file in ten imports.

Also, I select ADD/UPDATE from the action dropdown but i dont know why import is stopped creating products into the database. I checked "catalog_product_entity" table to ensure products are created but no more products are creating over 1016.

1016 is last ID.

 

Thanks!

 

ShoaibRehman89 wrote:

@Om Prakash

 

The only issue that I can think of is the server time out. How many products are you trying to import? I can see that you already have just over 1000 products in your catalog. 


Secondly, when importing the CSV, did you select ADD/UPDATE from the action dropdown?