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 ...
0 votes
1 answer
368 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?
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 ...
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> &...
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 ...
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 ...
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 ...
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 ...
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 .
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 "...
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 ...
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 ...
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 ...
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('...
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 ...
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.
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...