magento

// Adding OR condition to the query

$collection->addFieldToFilter(
    array('sku', 'id'), // columns/field of database table
    array( // conditions
        array( // conditions for 'sku' (first field)
            array

in case we want to change this configuration

«Stores» → «Configuration» 3 → «Advanced» → «Developer» → «Static Files Settings» → «Sign Static Files»

we can execute this query

disable

The easiest way to make the tax/vat id mandatory in the checkout page is to change the is_required in the eav_attribute table

you can use this Query to change the value from 0 => 1

UPDATE `eav_attribute` SET `is_required` = '1' WHERE `eav_attribute`.`attribute_code` = 'vat_id';

or you can use this code when you want to use a custom extesnion

$installer->updateAttribute('customer_address', 'vat_id', 'is_required', true);

in this wiki we will provide a simple form with Validation that we can use in Magento2, hope this will be helpful for all readers

you can use the below code in phtml file

To add a new comment to existing order and change the order status you can use this endpoint

/rest/V1/orders/{order_id}/comments

and the json data is

{
    "statusHistory": {
        "comment": "Your Comment Here",
        "created_at": "2018-06-05  15:22:04",
        "parent_id": {order_id},
        "is_customer_notified": 0,
        "is_visible_on_front": 1,
        "status": "pending"
    }
}

Most of Magento developer want to know exactly how they should apply the security patches on their websites

in this article we are going to talk about *.patch files

There are two ways to do this

1- using  git command

git apply patch_filename.patch

or

2- using patch command

patch -p1 < patch_filename.patch

I hope this will be useful for you

with standard parameters, you can use this command after you are in Command line (SSH)

bin/magento setup:config:set --session-save=redis --session-save-redis-host=127.0.0.1 --session-save-redis-log-level=3 --session-save-redis-db=2

References

To backup your store using the command line please login to your root magento server (SSH), then execute this command

magento setup:backup --code --media --db

Imagine that some of your team cancel an order in Magento by mistake, What is the solution?
By the below code you can restore the cancelation, hope it will help you

You can create an invoice programmatically for an order by using the below code