Questions tagged [import]
Denotes questions related to imports
1,048
questions
0
votes
1answer
767 views
Magento 2 Customer Grid index is locked by another reindex process. Skipping
I am importing Customer Main file details, I imported 30,000 records and about to reindexing ended up with reindexing issue.
On the first reindexing I got the following error:
PHP Fatal error: ...
5
votes
2answers
4k views
Magento 2 Import categories using csv
I have around 500+ categories in my csv.
I'm trying to import only categories using csv.
Can anyone knows how to import only categories in magento 2 using csv?
0
votes
1answer
867 views
getConfigurableAttributesAsArray causes fatal error
I am trying to write a script that creates configurable products. Ive been using this as a guide: http://inchoo.net/magento/programmatically-create-a-configurable-magento-product/
When I get to this ...
0
votes
0answers
9 views
Convert XML via XSLT
I want to convert & compatible the below XML file structure with Magento 2 via XSLT,
I start handling it but cannot complete it.
product.xml
<products>
<product>
<id>234234&...
2
votes
1answer
795 views
Import Product Data w/ CSV from command line (not dataflow)
I've updated a development version of my store to 1.9.2.4 from 1.7.0.2. I noticed that a plugin I used to handle inventory updates from the command line no longer works. I have over 15K products and ...
0
votes
0answers
4 views
RapidFlow Product Import Issues
Yesterday during training when I tried to import a file into RapidFlow, it errored out and wouldn’t take the import. Specifically, the 3rd column keeps getting the error.
So here’s what I did to try ...
0
votes
2answers
1k views
Import Database Error: #1062 Duplicate entry '3-13-70-0' for key
I am attempting to export the Magento database from my current installation to a test installation before I have the test installation go live. Both installations are version 1.9.2.1. I can ...
0
votes
0answers
8 views
Magento2: Bulk Import Products section; adding a new custom user_id selection Drop down
I need to add a dropdown for showing user list against which I will upload bulk products.
the dropdown should appear when the admin selects Product upload from first dropdown.
Please guide me how can ...
0
votes
2answers
763 views
Images not display both frontend and backend after import
I have try to import bulk images, after i import i got successful message, right after check front and back end there is no image,
excel format :
https://www.dropbox.com/s/ruh3bg6htuirybp/ready.csv?...
2
votes
0answers
17 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 ...
3
votes
3answers
2k views
Magento Import using Google Docs
How would you approach this?
The scenario I am looking at is:
a user creates/makes some changes to a Google Docs Spreadsheet (in a format quite similar to the one needed by Magento)
a script takes ...
0
votes
1answer
1k views
Rapidflow importing issues
I am having the following issues with using rapidflow for importing products into Magento and I was hoping someone could advise.
After uploading configurable products, the inputs in the configurable ...
2
votes
1answer
938 views
Magento 2: Importing Virtual products URL key
I'm trying to upload a configurable product with product variations. This did work fine for a while, but now I get this error:
1. Specified URL key already exists in rows: 3
If I analyze the ...
0
votes
2answers
158 views
Magento2 : Import/Export is not visible in Admin section
I am having an issue in Magento Admin. The import/export menu is not visible. When I open the URL directly, It shows a blank page.
Please help, it's urgent.
0
votes
0answers
7 views
MySQL core_config_data entries matching (Regex)
Magento 2 makes it hard for me to handle configuration settings for system_config area.
Since I have not received any answers there yet, I need to try something else to solve the issue.
(Assuming I ...
0
votes
0answers
16 views
Magento 2 app:config:import does not import system section into database
I know that app:config:import is supposed to import data from config files (env.php and config.php) into database
and app:config:dump is supposed to do the opposite: export data from database into ...
0
votes
0answers
17 views
Magento 2 - Update Images
I'm updating the images of my products. I'm using Import menu to do it.
I would need to replace the old image by the new. The new image is indicate in a csv file by product sku. The name of the images ...
1
vote
1answer
1k views
Import csv issue (product.php on line 1407)
I just install the magento 1.9.2 and try to import my csv file through System -> Import - > Import.
I received the following error message:
Notice: Undefined index: _attribute_set in /app/code/core/...
9
votes
14answers
24k views
Magento 2 product import won't import images
I am importing products using the built-in CSV import (System - import - products)
All my data is imported fine, but I get an error
"Imported resource (image) could not be downloaded from an ...
0
votes
0answers
16 views
How to create import csv option in admin configuration of Magento 2.3
I want to create a configuration for may custom module where i need to add import csv field. Once i upload my csv it should upload all the data to my custom table.
Below is the code I have added to ...
0
votes
1answer
3k views
Magento 2 : Need to import product image from external url
I just need to import all product images from external url , can i able to do this using default functionality in magento 2.
If yes, how can i use this product images external url during import csv ...
0
votes
0answers
23 views
Magento 2 - While Importing product CSV its gives “503 - Unavailable” error {Magento-2}
When I import product in bulk above-300 it gives error.
{ Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try ...
8
votes
1answer
2k views
How to change programmatically product stock status when product sku doesn't appears in provider data feed?
I'm using Magento CE 1.9.1
I made an import script to import products from a provider xml feed.
This feed is update everyday at 3 a.m .
My profider send me in his xml only products where are in stock ...
0
votes
2answers
731 views
Extract rar file with SSH using php
I need to extract rar file for my custom import extension.
i have used shell_exec() and exec("unzip/path/images.rar", $result, $returnval);
but not working.
Any one knows how to extract rar file ...
4
votes
1answer
3k views
Importing Configurable products With color and size
Importing Configurable product with color and size but only size are visible on site.
What i followed here:
I exported all sample data of site.
Copy one configurable product with its associated ...
5
votes
3answers
13k 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 ...
2
votes
2answers
5k views
Which strategy for fixing: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '25061-1' for key
I've a problem with my product import extension that is returned the "classic" violation integrity error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'25061-1' for key
...
2
votes
4answers
6k views
Import only the products from magento 1.9 to Magento 2.1.8
I am creating a new site with Magento 2.1.8. I need to import only the products from an old site that is running on Magento 1.9. I want my old site to still be fuctional even after copying the product ...
0
votes
1answer
21 views
Magento 2 product import website id not updating
I'm importing products using csv. Using default method of magento. My csv file is below.
sku,store_view_code,attribute_set_code,product_type,categories,name,description,short_description,weight,...
0
votes
2answers
2k views
Magento 2 : Cannot set product stock status to “Out of stock” using csv
I tried to import a product using CSV with is_in_stock value to '0' and after the import, the stock status still shows "In stock"
CSV looks like this :
sku,is_in_stock
DC3508BR,0
What am I ...
2
votes
2answers
2k views
Configurable product price is zero in the front-end
I am probably missing somtheing obvious. When I import configurable products the price in the front-end is zero. Beneath is a examples of one product and the columns that I believe is necessary to get ...
0
votes
2answers
3k views
Magento 2 : How to Import Color and Size Swatch Attributes Using CSV
How to import color and size swatch attributes using csv.
0
votes
0answers
23 views
skip/ignore field magento 2 csv import
For an import file that has some records with new data for category column and others that don't need updating. Is there a skip/ignore field word I can put into those fields like magmi's "...
0
votes
1answer
41 views
How to skip or ignore field in a Magento 2.3.4 import
I would like to update some products in Magento 2.3.4 admin>system>import. My import file doesn't have category info for items that are already in the database where they are assigned to a ...
0
votes
1answer
987 views
Magento2 : Additional images import programmatically
I'm trying to add additional images in products using custom script and below code i'm using. I have put product images in "additional_images" column of my csv and $image_directory is my path where ...
0
votes
0answers
30 views
Magento 2.4 Import grouped product with custom relation
I'm using this module https://github.com/50x/Boolfly_ProductRelation
to create custom additional relation in grouped products.
It works well except for the import functionality.
I've tested import ...
0
votes
0answers
25 views
Magento 2: How can I use “import product data” functionality though REST API/Postman?
I want to use import functionality in magento 2 (image below) from POSTMAN or my application.
Is there any endpoint available for the same?
3
votes
1answer
3k views
Magento2 Product import (image filenames)
I'm not sure that this is a bug, as it's intentional from the looks of it, but ...
I'm working on a migration from Zencart and the original site's media folder has been downloaded and we've written a ...
0
votes
1answer
906 views
How Importing Images with Labels using addImageToMediaGallery in magento2?
Magento2.1.x
I had a problem adding a product Image Label programatically. Here's the code I used:
$imageLabel1 = 'Test1';
$imageLabel2 = 'Test2';
$imageLabel3 = 'Test3';
$product-&...
2
votes
1answer
3k views
Magento tax_class_id not importing
I want to import bulk products using csv template in Magento.
I am unable to import a column tax_class_id.
I have given the value as eg: MA001234.
The datatype used in backend is 'int'.
2
votes
2answers
2k views
Imported image roles are lost on update in Magento 2
I use an import script to create products with associated images that are assigned to roles thumbnail and small image.
It works well, products and images are imported and they display as thumbnail ...
0
votes
0answers
19 views
Magento 2.3 SOAP envelope update stock qty - Postman
I am trying to update my stock qty via SOAP using Postman. I have no experience using SOAP.
Can anybody tell me what I am doing wrong here?
https://mydomain/soap/default?wsdl&services=...
0
votes
1answer
21 views
Magento2 importer importing only 400 rows everytime
I need to import 19000 price list in Magento system. My client break it into bunch of 5000 each.
While importing we noticed a weird behaviour that everytime when importing every batch only 400 ...
0
votes
1answer
18 views
Imported configurable products
I have imported Configurable products
But It is showing like this
The parent product price and quantity is not imported only their variations price and quantity is imported
Can any suggest me why Is ...
2
votes
2answers
1k views
Error 500 internal server error validate key magento
I'm new to Magento which makes me a big newbie. I have recently set up a localhost store using XAMPP. Now I want to import 500 products with my CSV file. I've looked up the CSV file structure and I ...
2
votes
1answer
2k views
Magento 2: `magento app:config:import` doesn't import system configuration
I'd like to import system config through the app:config:import command.
I have update app/etc/config.php file with described customer/captch/enable config path:
<?php return array (
'system' =&...
0
votes
3answers
722 views
Export products from Magento 1.6 and import products in Magento 2.0.9
I need to import lots of configurable products to my new Magento 2. But if I export a CSV File and import in Magento 2 I get 1000s of errors.
The File is different than a CSV I export from Magento 2....
0
votes
0answers
54 views
Issue with Magento2 and redis during customer import
There is a very strange issue on our Magento site. We are running a cron job to import product/customer, which runs every second. These work fine for some order but it breaks sometimes.
Notice: Redis::...
0
votes
1answer
158 views
Magento 2.3 - How to bulk import attributes values?
What is the best practice to bulk import attributes values. How to do it by hit tables?
0
votes
0answers
9 views
Downloadable products csv - unable to set links_purchased_separately = 0
I have a csv for downloadable products. I need to set links can be purchased separately to 0/false.
In my csv file, field downloadable_links is set as url=https://www.feedbooks.com/book/81.epub,...
