Seeking Guidance on Using MySQL Workbench for Magento Task

[hafizawani8a0d]

I am a student, and I have been assigned a task to correct wrong product tags by placing them in the right categories using the console in Magento.I have gained access to MySQL Workbench for this purpose, but I am unfamiliar with how to use it. Can anybody provide guidance on working with MySQL Workbench? Thank you.

[Wanda6123M094b · Accepted solution]

---

@hafizawani8a0dBeBallPlayers wrote:

I am a student, and I have been assigned a task to correct wrong product tags by placing them in the right categories using the console in Magento.I have gained access to MySQL Workbench for this purpose, but I am unfamiliar with how to use it. Can anybody provide guidance on working with MySQL Workbench? Thank you.

---

Hello, hafizawani8a0d

MySQL Workbench is a visual tool that allows you to interact with MySQL databases. You can use it to create, modify, and query tables, views, stored procedures, and other database objects. You can also use it to manage users, roles, and privileges, as well as backup and restore databases.

To use MySQL Workbench for Magento, you will need to connect to the MySQL server that hosts your Magento database. Depending on your hosting provider, you may need to use SSH tunneling or port forwarding to access the MySQL server remotely. You can find more information on how to do that here.

Once you have established a connection, you can use the MySQL Workbench interface to browse and edit your Magento database. You can use the Navigator panel on the left to see the list of schemas and objects in your database. You can use the SQL Editor tab on the right to write and execute SQL queries. You can also use the Table Data tab to view and edit the data in a table.

To correct wrong product tags by placing them in the right categories, you will need to work with the catalog_category_product table, which stores the association between products and categories. You can use the SQL Editor to write an UPDATE query that changes the category_id column for the products that have wrong tags.

For example, if you want to move product 123 from category 456 to category 789, you can write:

UPDATE catalog_category_product
SET category_id = 789
WHERE product_id = 123 AND category_id = 456;

You can also use the Table Data tab to edit the data directly by double-clicking on the cells and changing the values. However, this method may be slower and less efficient than using SQL queries.

I hope this helps you. 

[hafizawani8a0d]

I'm working with the Settlement Report within the FBL Advance Report section in Magento 2. I need to add a column that displays the payment method for each transaction. 

In the attached image, you can see the current columns in the report. I would like to add a new column for the payment method right after the last column (labeled "Status").

However, I only have access to MySQL and the Magento Admin Panel (no access to the full codebase or ability to modify files directly). Could you please guide me on how I can achieve this, possibly by making changes directly in the database or through the admin panel?