Visibility and Status attribute are null

 Hi,
 

  • I have already buy Data Migration pro 3.1.5 ( work with magento 2.2.5), we run migrate, it can migrate some field but with visibility and status they are null http://prntscr.com/kd9tjq. We have already check in eav_attribute table the attribute_id = 97( status), = 99 ( visibility) and we check in catalog_product_entity_int with attribute id = 97 and 99 they are null

 

  • Please tell me how to fix this?

Thanks

16 answers

Profile photo of Mall Staff 178940.00 $tone August 1, 2018
Public

Hi there,

we run migrate, it can migrate some field but with visibility and status they are null http://prntscr.com/kd9tjq. We have already check in eav_attribute table the attribute_id = 97( status), = 99 ( visibility) and we check in catalog_product_entity_int with attribute id = 97 and 99 they are null

What is the version of your Magento 1? It seems your M1 database has a special setting on the attributes ‘visibility’ and ‘status’ which are not the default settings of Magento core). 

I need a closer look to debug further, please provide me the following credentials:

  • Admin URL of your M2 instance
  • Admin and SSH credentials of your M2 instance
  • Let me know the path of your Magento 2 web root folder
  • phpMyadmin credentials of your M1 and M2 databases.

I will help to check further and get back to you then.
PS. Please make sure you mark your reply as a private reply, then you’re safe to provide your site credentials here. Only you and our technical team can access.
Regards,
Mall.

#1
Profile photo of itsthyme 130.00 $tone August 1, 2018
Public

Hi,
What is the version of your Magento 1?
=> magento 1.9.3.7
It seems your M1 database has a special setting on the attributes ‘visibility’ and ‘status’ which are not the default settings of Magento core). 
=> i see they are default setting http://prntscr.com/kdekws
 
-Now we are doing a test on localhost. Can you please tell me some case which you think that’s cause and we will check more by ourself first
 
Thanks
 
 

#2
Profile photo of Mall Staff 178940.00 $tone August 1, 2018
Public

Hi there,

-Now we are doing a test on localhost. Can you please tell me some case which you think that’s cause and we will check more by ourself first

Let’s capture for me the screenshots of the two product attributes  ‘visibility’ and ‘status’ in table ‘eav_attribute’ in Magento1 database.
Regards,
Mall.

#3
Profile photo of itsthyme 130.00 $tone August 1, 2018
Public

Hi
Let’s capture for me the screenshots of the two product attributes  ‘visibility’ and ‘status’ in table ‘eav_attribute’ in Magento1 database.
=> https://prnt.sc/kdfb6m
-why other fields are ok only 2 field have problem
 
Thanks
 

#4
Profile photo of Mall Staff 178940.00 $tone August 2, 2018
Public

Hi there,

https://prnt.sc/kdfb6m

I have checked but didn’t see any special settings on those attributes. As the issue you mentioned is strange, please  move your instance to a live staging server and provide me your site credentials as my previous reply.
I will help to check further and get back to you then. 
Regards,
Mall.

#5
Profile photo of Mall Staff 178940.00 $tone August 3, 2018
Public

Hi there,

  • after install on live system got error http://prntscr.com/kdw12s, on localhost run ok but on my hosting is error, please check why

Here is root of that issue: http://i.prntscr.com/R7w3WqdhTOKSnO1THyFdEg.png
Do you have see the source code folder of our tool at below paht path?
pub/ub-tool/
Does your server is Nginx? If yes, you must do some extra settings for Nginx server as indicated in the guide of our tool in Readme.html.
If you still couldn’t solve the issue, let’s provide me more the SSH credentials of your M2 instance. I will help to check further and reply you more later.
Regards,
Mall.

#8
Profile photo of Mall Staff 178940.00 $tone August 3, 2018
Public

Hi there,
I have checked further into your instance and saw the root of issue you mentioned as per the screenshots below:
http://i.prntscr.com/DZm7oJLIQAGkeFZFw2_0wQ.png
http://i.prntscr.com/oy1GSRJpQ3SzcdHolD5lAQ.png

As you see, your M1 database has a large number of product attributes, but your server has limited max_input_vars setting.
As a result, you have not migrated all product attributes in the step #3 of our tool, and the ‘visibility’ and ‘status’… attributes were missing.

To solve that issue, please do steps below:
+ Contact to your hosting provider to increase the value of the PHP param named ‘max_input_vars’ to:
max_input_vars = 10000
+ And restart web server after updating such change.
+ Then, reset and restart data migration from step #3.
Once done, the issue should be resolve.

Regards,
Mall.
 

#11
Profile photo of Mall Staff 178940.00 $tone August 3, 2018
Public

Hi there,

i set max_input_vars = 10000 http://prntscr.com/ke6jvm and the problem didn’t 

Did you reset and restart data migration from step #3 of our tool as my suggesting?
After changed that PHP setting. You must reset data migration in steps :#5, #4, #3
And then, restart data migration in these steps.
You could find how to reset step by step in the guide of our tool in Readme.html
php -f bin/ubdatamigration reset --step=5
php -f bin/ubdatamigration reset --step=4
php -f bin/ubdatamigration reset --step=3
Or you could do reset all steps by run below CLI command:
php -f bin/ubdatamigration reset

Regards,
Mall.

#13
Profile photo of itsthyme 130.00 $tone August 3, 2018
Public

HI,
 

  • I reset, please see old image: https://prnt.sc/ke3jan 312 records  new image 200 records http://prntscr.com/ke6w47

after change max_input_vars = 10000, everything the same. Please check again

#14
Profile photo of Mall Staff 178940.00 $tone August 3, 2018
Public

Hi there,
Yeah, lets continue with other steps of data migration. And contact me if you need further assistance.
Regards,
Mall.

#16

Please login or Register to Submit Answer

Written By

Comments