Questions tagged [import]
Denotes questions related to imports
1,060
questions
0
votes
1answer
936 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: ...
0
votes
1answer
880 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 ...
2
votes
1answer
816 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
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 ...
1
vote
1answer
16 views
Can't change Custom Attribute when Importing Products
I have a custom attribute for my products called Designer_name. I'm trying to import products and change a Designer_name's value in the additional_attributes column, but it doesn't work. The attribute ...
0
votes
1answer
23 views
Set product in shared Catalog
For product import,
I have checked from admin (admin -> catalog -> shared catalog ) that my id for shared catalog (Default (General)) is 1.
Then I done code as below. but not works. please guide ...
2
votes
4answers
4k views
M2 Importer: Value for 'visibility' attribute contains incorrect value
If the importer runs with cronjob I get always the same errors on all lines:
Value for 'visibility' attribute contains incorrect value, see
acceptable values on settings specified for Admin in ...
0
votes
1answer
15 views
How to add Additional_attribute row when Products import using csv in magento 2
i need to set additional attribute column pragmatically using code in magento2 with import export module model file
my product custom attribute is "pre_order_qty"
if ($this->validateRow(...
2
votes
1answer
945 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
0answers
17 views
How to Add Customer Number When Any Error Occur At Customer Data Import Using CVS In Magento 2
i need to make customisation in that need customer number at row place show the customer number at error place like see the screenshot
At this place need customer number also
0
votes
0answers
10 views
Export/import base images in Magento 1,9
I would like to export ALL base images on my database in Magento 1.9 platform in order to edit them in an image editor and import them (rewrite) once edited.
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/...
5
votes
3answers
15k 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 ...
0
votes
0answers
5 views
While importing bulk product data in CSV format what will be the field separator?
Am using field separator as comma but in product categories I have -> to separate . when I am changing field separator as comma to -> its not working. What is the problem? How can I import ?
...
6
votes
3answers
10k views
How to import product content different for each store view (translations/multilingual)?
In Magento 1.x you could import different content for each store view by having each store data in new line and empty sku field.
Unfortunately this seems not to work in Magento 2 and I could not find ...
0
votes
0answers
15 views
Magento product import shows Duplicates found in column names: array
Iam trying to import product as csv in magento 2.4 and getting the following error.
Please help me to solve this issue. Thank you in advance.
Duplicates found in column names: array ( 0 => 'p20lch-...
0
votes
1answer
27 views
How to import product images programmatically with the use of custom script in magento 2?
I have all product images in one folder. Images are in path like - pub/media/Fotos/MA/{{ sku }}/
So need to import images as per SKU folder. I want dynamic script for it.
10
votes
15answers
27k 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 ...
1
vote
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 ...
3
votes
3answers
7k views
Magento 2: Import CSV File Size
When we import Product CSV from Admin it says
Make sure your file isn't more than 2M.
How to increase this size? I have 5M file size. Don't want to create multiple CSV files with each 2M
0
votes
1answer
66 views
Column 'created_at' not imported
My goal is to sort products on the frontend from newest to oldest.
The products CSV file contains the created_at column (e.g. 2020-10-31 14:05:44). Format seems to be correct.
After the standard ...
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 ...
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 ...
2
votes
1answer
821 views
Configurable Product CSV Import - Simples not associating
I've been trying to import some configurable products via the csv importer in magento ce 2.2.3.
After running the import all products appear in the admin, however if I edit the configurable product, ...
0
votes
1answer
32 views
Simplify Product Import Export in Bulk with Custom Attributes Magento 2.3.5
I have requirement to import products in bulk from CSV file which have multiple custom attributes of different type (Multiple Select, Dropdown, Text, etc.). Standard Import/Export option for Magento ...
0
votes
1answer
1k 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 ...
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 ...
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'.
0
votes
1answer
962 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
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 ...
1
vote
4answers
3k views
eBay to magento integration
I have integrated magento products to eBay using M2E pro but now we have to integrated eBay product in to magento(reverse process). Is there any way to do this.
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 ...
8
votes
2answers
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 ...
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
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.
9
votes
1answer
3k views
CSV Import: How can I import related products in Magento 2?
How can I import related products via csv in Magento 2?
In my csv file I have a row with attribute related_skus with example data "11-111,22-222" for a product. But in admin Products->Catalog in this ...
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
0answers
26 views
How do I change the code in a Magento 2 extension without editing. I need to import csv file, but it will reflect the two tables in database
How do I change the code in a Magento 2 extension without editing it's files directly. I need to import csv file, it will reflect the two tables in database.
0
votes
1answer
21 views
Importing images with special characters in path
I am trying to import a lot of images. Images for each product are placed in subfolders by product IDs and locale.
The problem is that each locale specific folder name starts with a caret (^).
Example ...
0
votes
0answers
21 views
Slow async bulk import via RabbitMQ, no multiple threads?
I really hope someone can help me out here. We have setup a RabbitMQ and a Magento 2.3.4. RabbitMQ runs and get about 83k messages via an import by our external product management software. There are ...
0
votes
0answers
10 views
CSV Import: (M2) How to assign multiple image roles to one image
I'm an issue where i want to assign multiple image roles (base, small, thumbnail) to 1 image using the CSV import.
This is what it looks like after the import
This is how i want it
How can i achieve ...
1
vote
0answers
21 views
Import related_skus in magento 2.3.5 problem
After upgrading Magento from 2.1.7 to 2.3.5, when making a manual products import through the admin, the related products are not attaching to the products, no errors are being shown.
I've tried ...
1
vote
1answer
1k views
Magento 2 Product import error :. Value for 'product_type' attribute contains incorrect value
I'm using Magento 2 Version 2.1 .
I have migrated data from magento 1.9 to magento 2.1.
The csv looks like, this:
sku,product_type,additional_attributes
123,simple,brands=APPLE,...
2
votes
2answers
5k views
Base Image, Small Image, Thumbnail Image are not selected after product images csv import
I have successfully imported product images using csv file but Base Image, Small Image and Thumbnail Image columns in Images tab, are not selected. No Image is selected by default. So products images ...
1
vote
1answer
1k views
on Magento2.1 how to import product with multiple category
Now i try
Default Category/Main/sub ,
Default Category/Main2/sub2
Default Category/Main/sub is working fine
but in Default Category/Main2/sub2 can't import product
Error Category Default ...
0
votes
1answer
397 views
Warning: Illegal string offset '__disableTmpl'
When I try to run an import job in Magento 2 I get this weird error and I can't find a solution anywhere else. We are importing with Firebear Improved Import/Export v.3.1.6. When I press "Edit & ...
0
votes
0answers
24 views
Programmatically importing images fails, but the csv file imports fine from admin in Magento 2
I'm trying to upload the following CSV file of images programmatically but it's failing to import.
The weird thing is that it works from admin
sku,base_image,base_image_label,small_image,...
0
votes
1answer
48 views
Increasing Quantity via CSV Import Magento 2
We are working heavily and daily with the Magento 2 CSV import. We use something like this
"sku","qty"
"12345","100"
In this case, the qty for 12345 is set to ...
0
votes
2answers
936 views
Error while importing a csv file in the admin
My project had an extension called webshopapps product matrix
Which was copied from another project and had been configured . But now when I replace it with the new extension by placing its files ...
1
vote
1answer
798 views
How to add product reviews progmatically to add data on custom field
$review = Mage::getModel('review/review')
->setEntityPkValue(intval($pressquote->product_id)) //product id
->setStatusId(intval($pressquote->status))
->setDetail($pressquote->text)
-&...