New answers tagged

0

This is query you can use and modify, here increment_id is the order no. or order id. Please try this query and modify accordingly. $detail_query_2="SELECT a.product_id,a.weight,a.sku,a.name,a.qty_ordered,base_price,price FROM rpt_sales_order_item AS a INNER JOIN rpt_sales_order AS b ON a.order_id=b.entity_id AND b.increment_id = '$ids'"; Edit ...


1

Reindexing on MariaDB 10.4 takes more time compared to other MariaDB or MySQL versions. As a workaround, we suggest modifying the default MariaDB configuration and setting the following parameters: optimizer_switch='rowid_filter=off' optimizer_use_condition_selectivity = 1 https://devdocs.magento.com/guides/v2.4/performance-best-practices/configuration.html ...


0

You can refer to this example of mine: protected function filterOrder($payment_method) { $this->sales_order_table = ""main_table""; $this->sales_order_payment_table = $this->getTable(""sales_order_payment""); $this->getSelect() ->join(array('payment' =>$this->...


0

I'm a little late to answer :D, but it might be helpfull for others. In the controller, you have to serialize this array. app/code/Vendor/Rules/Controller/Adminhtml/Example/Rule/Save.php protected function prepareData($data) { if (isset($data['rule']['conditions'])) { $data['conditions'] = $this->_json->serialize($data['rule']['conditions']...


0

Here you go: select * from catalog_product_super_link where product_id not in (select entity_id from catalog_product_entity where attribute_set_id = 31);


0

fast solution, check this link https://webkul.com/blog/how-to-check-if-use-default-value-checked-for-a-product-attribute-value-in-magento-2/ cheers


0

Yes you can change your theme without losing products or categories as the theme is completely separate to them. You should see the exact same categories and products in the new theme.


0

I am not sure what you want to achieve. a. Restrict users from a certain region to log in. b. Restrict specific users from changing login regions . If A , it is recommended to directly restrict users from a certain region to register or access. If B, the situation is slightly more complicated and requires a plugin to complete the user's login IP to verify ...


0

Practical way for creating a table in magento 2 you should follow its rules and regulations. You need to create custom module and table schema, models and collections etc. Here is a tutorial that will help you in this process. https://bsscommerce.com/confluence/how-to-create-insert-data-into-the-table-in-magento-2/ Thanks, Vibhore


0

New version 1.4.2 has fixed this error, i guest version of this module on your site <= 1.2.5 https://github.com/facebookincubator/facebook-for-magento2/tree/master


0

I figured it out running this in mysql UPDATE `catalog_product_option_type_title` a JOIN `catalog_product_option_type_title` b ON a.option_type_id = b.option_type_id SET b.title = 'Big-Dimmable' WHERE a.title = 'little-dimmable'


0

I was also looking into this, the best I could find was the method explained in this answer - https://magento.stackexchange.com/a/321531/93665


0

Put your mysql dump file xyz.sql in pub folder and create a file with below code to import in pub folder pub\custom_import.php <?php $db_host = "localhost"; $db_user = "root"; $db_pass = "root"; $db_name = "m242ee"; $sql = file_get_contents('ktpl_bannerslider_banner_slider.sql'); $mysqli = new mysqli($db_host, $...


0

Could you provide yours docker-compose.yml? Assuming, that you have multiple service/containers for each database (like. db_1, db_2). Yours /etc/hosts file does not play any role in networking between docker containers. It does not route through your host network. That said, if you have application container and database containers in same docker network, ...


0

Add the following code to your themes default.xml file <referenceBlock name="skip_to_content" remove="true"/>


1

The following approach works fine for me to resolve below issue. "URL key for specified store already exists." Step : 1 First, I have find out the above message by using grep command. Basically below vendor core file throws this message. File Name : Magento\UrlRewrite\Model\Storage\DbStorage.php Step 2 : Added below log code in the doReplace() ...


0

Use a database for media storage On the Admin sidebar, go to Stores > Settings > Configuration. In the left panel, expand Advanced and choose System. In the upper-left corner, set Store View to Default Config to apply the configuration at the global level. Expand Expansion selector the Storage Configuration for Media section and do the following: ...


Top 50 recent answers are included