import

Auto Added by WPeMatico

Import products 2.4.6-p1 error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key

by magento man

We did an upgrade from version 2.4.3 to the version 2.4.6-p1 and we started to have a problem on cloud environments (production and staging, but mostly on production) but not locally. So, the steps to reproduce are being these: Go… Read More »Import products 2.4.6-p1 error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key

Update SKU using entity ID in import

by magento man

I am trying to update sku using entity id and it’s working but issue is when i try to order that product from the front-end it shows “There are no source items with the in stock status”. What to do?… Read More »Update SKU using entity ID in import

SQL Error when importing stock csv

by magento man

Since we have updated to magento 2.4.6 when we want to import stock via csv we now receive an error. systemException Additional data: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the… Read More »SQL Error when importing stock csv

How to use differnt config location while running app:config:import command?

by magento man

I would like to import Magento configurations other than app/etc/ path while running app:config:import. for e.g my configs are located at var/config/{config,env}.php.

Magento 2.4.5 uiComponent imports not working

by magento man

I have upgraded my store from Magento version 2.3.5-p1 to 2.4.5-p1. In one of the extension there is a uiComponent that is using the value of another uiComponent using the importds. ‘imports’ => [ ‘inputType’ => ‘${$.parentName}:inputType’, ], The above… Read More »Magento 2.4.5 uiComponent imports not working

How can I create redirects from old URL keys to new ones using a CSV import in Magento 2.3.5-p1?

by magento man

I have updated the ‘url_key’ column in my Magento CSV file and imported it successfully. However, the old URLs are still returning a 404 error, even though the new URL keys have been updated correctly. On the other hand, when… Read More »How can I create redirects from old URL keys to new ones using a CSV import in Magento 2.3.5-p1?

Default attribute values for products imported via API

by magento man

When importing products, sometimes some attributes are not set, or have no value (for example, weight sometimes is not sent through the API). Especially weight sometimes gives us issues, since it’s used by UPS to calculate the shipping price. I… Read More »Default attribute values for products imported via API

Read excel sheet data in javascript file

by magento man

I need to read the excel sheet data from magento 2.4 javascript file. I have overridden Magento_Sales/web/order/create/scripts.js. I can read csv file data without any issue but can’t read excel file data. How can I use the following script and… Read More »Read excel sheet data in javascript file

import product data programmatically using csv

by magento man

I am new in magento 2 I am trying to import product data programmatically using csv file. The Error is shown below My Folder and code structure are following. This is My registration file. Vendor/Modulename/regis.xml use MagentoFrameworkComponentComponentRegistrar; ComponentRegistrar::register(ComponentRegistrar::MODULE, ‘vendorName_moduleName’, __DIR__);… Read More »import product data programmatically using csv

How to transfer products from Magento 2.4.2-p1 to Magento 2.4.4 which give Errors during export and then import?

by magento man

We have a live production Magento ver. 2.4.2-p1 with 2224 products but have a lot of problems which stem from me using the official Magento Migration Tool to migrate from Magento 1.x. Because of this, I have decided to built… Read More »How to transfer products from Magento 2.4.2-p1 to Magento 2.4.4 which give Errors during export and then import?