cancel
Showing results for 
Search instead for 
Did you mean: 

Importing products not working - Mag 2.2.3

SOLVED

Importing products not working - Mag 2.2.3

 

I'm trying to import products on Magento 2.2.3 via the System > Data Transfer > Import method.

 

I've selected 'Add / Update' from 'Import Behaviour' and the file imports successfully.

But, none of the products are showing on the frontend, backend or in the database.

What could be wrong?

 

I downloaded the sample file it gives you and filled it in with our products.

 

If you want me to supply my excel sheet, can you point me in a place to where I can host it for you?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Importing products not working - Mag 2.2.3

I have managed to get it working.. it looks like my excel isn't saving to UTF 8 properly.

 

What I done is saved it as a CSV (Comma delimited) as standard, opened it up using notepad and re-saved it as a .csv using UTF 8 encoding.

 

Thanks for all the help on this matter.

View solution in original post

15 REPLIES 15

Re: Importing products not working - Mag 2.2.3

Hello @callam_kidsaw

 

Check the following thing:- 

go to DB and check catalog_product_entity table for same.

check that SKU exist into a table that is added into CSV 

 

if SKU exist then do reindex and check into backend site.

if SKU does not exist not exist then need to debug more 

 

Hope it will help you.

 

if it will work then mark as solution.

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: Importing products not working - Mag 2.2.3

Hi,

 

I have tried the steps you've outlined above.

 

The products don't appear on the frontend, backend or in the database after re-indexing.

 

I have also tried creating a new csv (to make sure the sample one isn't corrupt) but still get the same issue... successfully imports but nothing is being shown. 

Re: Importing products not working - Mag 2.2.3

hello,

 

try to add new sku and check into catalog_product_entity.

 

Is that sku exist or not?


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: Importing products not working - Mag 2.2.3

Yes, adding a single product via the backend works and appears in the database.

 

I've made a video of the import method

 

https://youtu.be/cDYjMxeky5Y?t=3s

 

The video cuts off at the end, but after the re-index they still didn't appear.

Re: Importing products not working - Mag 2.2.3

@callam_kidsaw

 

After CSV import, please check into table any sku added.

 

Or share the screenshot of catalog_product_entity table.

 

Also, check the log file, is there any log into var/log folder.

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: Importing products not working - Mag 2.2.3

The only errors in the log file are:

[2018-04-20 11:01:28] main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 5000; Allocated memory size: 4000000 bytes; InnoDB buffer pool size: 16777216 bytes. [] []

[2018-04-20 11:39:09] main.INFO: Broken reference: the 'product.reviews' element cannot be added as child to 'product_tabs', because the latter doesn't exist [] []

And a picture of the product in the database:

 

database.PNG

Re: Importing products not working - Mag 2.2.3

Still not working, kind of stumped on what to do now as the log isn't throwing errors.

 

I'm not sure if it matters but this is on XAMPP, Windows 10. Database: 10.1.31-MariaDB - PHP 7.0.28

Re: Importing products not working - Mag 2.2.3

Hello @callam_kidsaw

 

can you please check wamp64\bin\mysql\mysqlversion\my.ini and check the innodb_buffer_pool_size value and try to incrase, restart server and  check it.


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: Importing products not working - Mag 2.2.3

I have done that but now the error message has changed:

 

[2018-04-23 10:37:39] main.WARNING: Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size. Please update innodb_buffer_pool_size or decrease batch size value (which decreases memory usages for the temporary table). Current batch size: 100000; Allocated memory size: 20000000 bytes; InnoDB buffer pool size: 33554432 bytes. [] []

The default values were:

innodb_buffer_pool_size = 16M

innodb_additional_mem_pool_size = 2MB

 

I changed them to:

 

innodb_buffer_pool_size = 32M

innodb_additional_mem_pool_size = 8MB

 

Products still aren't importing / appearing in the database Cat Frustrated