If I already have the function (last 30 minutes order cron job)below to get sales_order_grid table data, how can I join table to get sales_order_address table and get country_id, city and postal_code? public function getSalesOrderGrid() { try { $itemData = $this->salesCollectionFactory->create(); $currentDate = date("Y-m-d H:i:s"); // Y-m-d h:i:s $newDate = […]
Magento
Im relatively new to Magento and could need some advice. I have 2 Products wich has to rely on the same stock but with different stock-values. For example: Product A is 4 times in stock (value of 1 each) Product B is only 2 times in stock (with a value […]
Magento 2.4.2-p1 Smartwave Porto theme We had some trouble setting up multi-domain/websites on Magento 2.4.2-p1. That was finally sorted by our hosting company but shortly after, we started getting the Circle of Death on the Product page of our 2nd store only. It also appears to be intermittent. I pulled […]
I have a strange problem in our Magento 2.4 installation. In a product category you are able to specify the position of a given product by entering a value in the position column. This helps to display the products in the order you want. In our 2.4 updated installation entering […]
Magento 2.4.3 I have an installer class which has this code: $eavSetup->addAttribute( Category::ENTITY, 'xyz_image', [ 'type' => 'varchar', 'label' => 'Navigation Image', 'input' => 'image', 'backend' => Image::class, 'required' => false, 'sort_order' => 9, 'global' => ScopedAttributeInterface::SCOPE_STORE, 'group' => 'General Information', ] ); I cant use the class, so I […]
I want to show custom text on category pages based on query string on category pages. for example : for category shirt with urls like category/shirts.html?color=red category/shirts.html?color=blue i want to show different text on top of both pages based on color in query string. What i tried i was able […]
i want to change order title in the phtml file, but I can’t find it ever in vendor, can anyone help me please ?
I want to prevent customers from changing their first and last name once they’re registered but I want to allow them to change the password in customer account. I added disabled = "disabled" to first and last name input field: app/design/frontend/Vendor/ctr/Magento_Customer/templates/widget/name.phtml <div class="field field-name-firstname required"> <label class="label" for="<?= $block->escapeHtmlAttr($block->getFieldId('firstname')) ?>"><span><?= […]
How could I zip all my Magento files excluding non-required to a local setup? I usually run this command below to get all the files but it takes too long and the files are too heavy. zip -r magento2.zip ./* Do you have any suggestions to improve it?