Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
1 answer
352 views

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

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 ...
Pedro H Lima's user avatar
0 votes
1 answer
365 views

Can I update order statuses via CSV?

Is it possible to update order status using CSV? If so, what would be the obligatory data and columns?
hopicuzo's user avatar
5 votes
0 answers
447 views

Magento2 import stock sources successful but no changes made and not showing in import history

Preconditions (*) Magento ver. 2.3.4 About 10000 skus, this process has worked many times previously, suddenly stops working. No new modules or configurations have been done since last time the ...
Christopher Liddell's user avatar
1 vote
0 answers
1k views

Import products via command line using Magento\ImportExport\Model\ImportFactory in Magento 2.3

I want to import products from .csv file using command line. Referring to this link: https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ everything is working fine, except ...
SebastianT's user avatar
2 votes
0 answers
204 views

Magento 2: Missing entity types in CSV import

I have a fresh instance of Magento 2.2. In the Import tab, there are only "Products" entity types. Should I enable anywhere rest? Like e.g "advanced pricing"? Edit. SOLVED -> Module "...
K. Maliszewski's user avatar
0 votes
1 answer
347 views

import parent and sub category with csv magento 1.9

I am uploading a CSV in Magento 1.9, and what i need is to import both categories and sub-categories, but now it is currently importing only sub-categories. Here is an example of how I the categories ...
Anuradha's user avatar
8 votes
4 answers
29k views

Read input csv file and convert it to array

I have an input file form in phtml to import data from csv file type like this: <div class="import-shipping"> <div class="header"> <h4>CSV File:</h4> </div> &...
simple guy's user avatar
  • 2,494
3 votes
2 answers
3k views

Magento 2 csv product import : How to escape commas in category name

I would like to import a product csv into Magento 2 through the standard admin UI. The category name contains commas Default Category/Grocery/Snacks/Fruit, Nuts, Seeds. The (abbreviated) csv looks ...
Richard's user avatar
  • 193
0 votes
1 answer
4k views

programatically import csv - magento 2

I have a bpmn tool, it will generate CSV, that CSV contains single product. I need to import that csv file programatically. Already magento admin have that feature. please can anyone point key code ...
Bilal Usean's user avatar
  • 10.1k
5 votes
3 answers
22k views

I'm Looking for a sample CSV product file to import into test store

I have my first Magento test site running and I'm looking for a sample CSV product file to import for testing. Does anybody know where I can download one? Ideally I'd like the file to contain lots of ...
Eric B's user avatar
  • 51
1 vote
0 answers
283 views

update qty per store view with csv file

actually in our website we have a cron function scheduled (every morning) to update the qty of all products of our catalog and works good. Following the code we are using now: <?php define('...
Alberto's user avatar
  • 117
1 vote
1 answer
3k views

How to import customers in magento-2 using csv?

Currently i am working on magento-2 .I have imported products successfully. Now i want to be import customers . I dont have any demo csv for import customers .
Aman Dhiman's user avatar
1 vote
2 answers
2k views

Product CSV special character issue

I have created a Category with Special character called "Home Décor" http://puu.sh/k2ZOP/0267464f46.png. Now when I trying to import the products under this category, I got "Category does not exists ...
Vick's user avatar
  • 163
2 votes
1 answer
5k views

Import of product via CSV (need to update, not replace, not append)

I'm having this situation where I need to import around 300 products with different attributes and 4-8 pictures for every products. I have created a valid csv file, within my ERP program (accounting ...
user15151's user avatar
  • 581
0 votes
2 answers
2k views

import products from csv

I'm trying to bulk import my product from a .csv. Here is my code so far: include_once "../app/Mage.php"; include_once "../downloader/Maged/Controller.php"; Mage::init(); // Set the store id //$app ...
user24287's user avatar
1 vote
2 answers
355 views

How to import Etsy products into Magento? [closed]

I have an Etsy shop I want to transfer to Magento. I've exported a CSV file from Etsy, tried to import it in Magento ut got an error message: "Can not find required columns: sku" I assume my CSV file ...
Brice's user avatar
  • 11
1 vote
1 answer
631 views

I want to create a shop with affiliate products, i need to import them from csv feed

I want to import products from csv file. But how to get product images from an url? The csv file contain the image url and affiliate link too. I need to import this two fileds in specific places.
Adrian Ionescu's user avatar
0 votes
1 answer
267 views

Unable to import more csv files into Magento

We have been importing products into Magento using multiple CSV files. There are files for each category. To overcome errors, we have in the past repeatedly imported the same CSV files (using Replace ...
user1865400's user avatar
2 votes
1 answer
953 views

Magento sets zero quantity importing csv with only _links_* column

I'm trying to update products adding related, cross sell and upsell products by importing a CSV from System->Import/Export->Import functionality. After the import process all the modified ...
hippoglollum's user avatar
2 votes
1 answer
2k views

CSV - Imported product image is not visible in admin section but shown in front end

I have imported products from CSV into my magento store using Product import section.The product images are visible in front store, but not visible in admin section. When I try to edit a product, ...
Balaji Kandasamy's user avatar
0 votes
2 answers
1k views

Export products from wp Ecommerce and import into magento [closed]

What i want to do is export all the existing products from the wordpress e-commerce and have to import it into the magento.I have used WP e-Commerce - Store Exporter for exporting the data from ...
Kalaiyarasan's user avatar
0 votes
1 answer
2k views

Dataflow Profiles

Currently im pulling my hair out trying to get Magento to import a csv file. I have followed the following steps. Exported csv from Magento to get the layout 100% correct. Opened it in OpenOffice as ...
Zac Grierson's user avatar