Importing products not working - Mag 2.2.3

[callam_kidsaw]

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?

[Sunil Patel]

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.

[callam_kidsaw]

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. 

[Sunil Patel]

hello,

try to add new sku and check into catalog_product_entity.

Is that sku exist or not?

[callam_kidsaw]

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.

[Sunil Patel]

@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.

[callam_kidsaw]

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:

[callam_kidsaw]

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

[Sunil Patel]

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.

[callam_kidsaw]

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