Magento2

Is it possible to formulate an SQL that gets all products along with its product attributes (instead of just name, description, etc as what I have mostly seen on the internet) of a certain category?

I’m using an extension from a vendor. The vendor is doing some magento frontend manipulation adding some extra form fields to account create page. Now that module is in control/overwriting the magento version. How can overwrite/control the vendor version from my theme?

I’m trying to track my users referrer in Magento but varnish remove all utm from social media. I’ve removed the utm regex from the default.vcl file and now I get utms in my request but setting the cookies still not working. I’m sure this is a varnish issue, because everything […]

We want to add some logic when Magento saves shipping information during checkout, so we have tried using a before plugin for saveAddressInformation method This would be method definition /** * Save address information. * * @param int $cartId * @param ShippingInformationInterface $addressInformation * @return PaymentDetailsInterface * @throws InputException * […]

I am preparing to get Magento certified, doing some test questions I have found this: A client has asked you to include category url keys in product URLs. How is this done? A. Create an observer for controller_action_postdispatch_catalog_product_view B. This is not possible because products can belong to multiple categories […]

I am trying to add custom fonts in magento 2 transactional emails however, it does not work. I am using hyva theme. I have imported Sofia-pro font under app/design/frontend///web/fonts/SofiaProRegular.woff2 and app/design/frontend///web/fonts/Sofia_pro_regular.ttf Then I have added _typography.less file under app/design/frontend///web/css/source/_typography.less and added the following code in it .lib-font-face { @family-name: @font-family-name__base; […]

While I am trying to save a product, I am getting this error: SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column ‘value_id’ at row 1, query was: INSERT INTO catalog_product_entity_decimal (attribute_id,store_id,row_id,value) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE attribute_id = VALUES(attribute_id), store_id = […]