Ttdfjt

I've been searching the web on how to create an order attribute (if thats whats called), essentially I just want a new database column to appear in the sales_order database, obviously I could create it manually but is there a way I can create it via an upgrade script/programmatically?

Practically, there are two main ways to add an order attribute (a new column) to order via an upgrade script.

--Using $setup->getConnection()->addColumn()

app/code/Vendor/SalesOrder/Setup/UpgradeSchema.php

<?php

namespace VendorSalesOrderSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupSchemaSetupInterface;
use MagentoFrameworkSetupModuleContextInterface;

class UpgradeSchema implements UpgradeSchemaInterface

 /**
 * Upgrades DB schema for a module
 *
 * @param SchemaSetupInterface $setup
 * @param ModuleContextInterface $context
 * @return void
 */
 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 $setup->startSetup();

 $quote = 'quote';
 $orderTable = 'sales_order';

 $setup->getConnection()
 ->addColumn(
 $setup->getTable($quote),
 'custom_attribute',
 [
 'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
 'length' => 255,
 'comment' =>'Custom Attribute'
 ]
 );
 //Order table
 $setup->getConnection()
 ->addColumn(
 $setup->getTable($orderTable),
 'custom_attribute',
 [
 'type' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
 'length' => 255,
 'comment' =>'Custom Attribute'
 ]
 );

 $setup->endSetup();
 

--Using Quote and Sale Setup Factory

app/code/Vendor/SalesOrder/Setup/UpgradeData.php

<?php

namespace VendorSalesOrderSetup;

use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;
use MagentoFrameworkSetupUpgradeDataInterface;
use MagentoQuoteSetupQuoteSetupFactory;
use MagentoSalesSetupSalesSetupFactory;

class UpgradeData implements UpgradeDataInterface

 /**
 * @var QuoteSetupFactory
 */
 protected $quoteSetupFactory;

 /**
 * @var SalesSetupFactory
 */
 protected $salesSetupFactory;

 /**
 * @param QuoteSetupFactory $quoteSetupFactory
 * @param SalesSetupFactory $salesSetupFactory
 */
 public function __construct(
 QuoteSetupFactory $quoteSetupFactory,
 SalesSetupFactory $salesSetupFactory
 ) 
 $this->quoteSetupFactory = $quoteSetupFactory;
 $this->salesSetupFactory = $salesSetupFactory;
 
 /**
 * Upgrades DB for a module
 *
 * @param ModuleDataSetupInterface $setup
 * @param ModuleContextInterface $context
 * @return void
 */
 public function upgrade(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
 
 /** @var MagentoQuoteSetupQuoteSetup $quoteInstaller */
 $quoteInstaller = $this->quoteSetupFactory->create(['resourceName' => 'quote_setup', 'setup' => $setup]);

 /** @var MagentoSalesSetupSalesSetup $salesInstaller */
 $salesInstaller = $this->salesSetupFactory->create(['resourceName' => 'sales_setup', 'setup' => $setup]);

 $setup->startSetup();

 //Add multiple attributes to quote 
 $entityAttributesCodes = [
 'custom_attribute' => MagentoFrameworkDBDdlTable::TYPE_TEXT,
 'custom_attribute1' => MagentoFrameworkDBDdlTable::TYPE_TEXT

 ];

 foreach ($entityAttributesCodes as $code => $type) 

 $quoteInstaller->addAttribute('quote', $code, ['type' => $type, 'length'=> 255, 'visible' => false, 'nullable' => true,]);
 $salesInstaller->addAttribute('order', $code, ['type' => $type, 'length'=> 255, 'visible' => false,'nullable' => true,]);
 $salesInstaller->addAttribute('invoice', $code, ['type' => $type, 'length'=> 255, 'visible' => false, 'nullable' => true,]);
 

 $setup->endSetup();