Magento2 – How to Change Column Length in Table sales_order

magento2sales-order

I'm new to Magento. I want to store 3rd party order id and customer id in column ext_order_id and ext_customer_id in table sales_order.

The problem is these 2 columns have length 32, so I altered the table to set it to 50. However, every time I ran command bin/magento setup:upgrade, the column length was reset back to 32, and data in that column was truncated.

Any solution to store 50 characters in those columns?
Thanks

Best Answer

create a db_schema.xml in a module of yours and update it there example here: https://devdocs.magento.com/guides/v2.4/extension-dev-guide/declarative-schema/db-schema.html

Related Solutions

Magento 2 – Static Files Present but Showing 404 Error

First, make sure apache “rewrite_module” is enable and then restart the server.

If this hasn't worked. Then do following steps:

Edit the file /etc/apache2/apache2.conf.
Find this code:

<Directory /var/www/>
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>

Change "AllowOverride None" to "AllowOverride All".

<Directory /var/www/>
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted 
</Directory>

Restart apache2.

Magento2 – Import Product Dimensions (Length, Width, Height)

I found the correct headings to use by searching the attributes table of the database. Here are the headings to use, in case you find this searching like I was:

ts_dimensions_length

ts_dimensions_width

ts_dimensions_height

Best Answer

Related Solutions

Magento 2 – Static Files Present but Showing 404 Error

Magento2 – Import Product Dimensions (Length, Width, Height)

Related Topic