Questions tagged [import]
Denotes questions related to imports
1,054
questions
0
votes
1answer
407 views
Re-import images for multi-store with maintained image roles
I have an existing web site with thousands of products. I have several storefronts and all products are available on all stores using the same product images with the same image role settings (i.e. ...
0
votes
1answer
105 views
Magento2: Error in data structure: job_id values are mixed
During import products to magento 2.3.4 after few minutes I get issue:
Configure variations for SKU:98010
Configure variations for SKU:98009
In Data.php line 120:
Error in data structure: job_id ...
0
votes
0answers
89 views
Undefined Offset Error Product Import Magento 2.3.2
Magento is returning this error on Product import:
Notice: Undefined offset: 4 in /app/vendor/magento/module-catalog-import-export/Model/Import/Product.php on line 2630
What is Offset Error and how ...
0
votes
0answers
14 views
i am trying to import the custom price attributes
When i'm trying to import the custom price attributes my file is read to import , but after clicking import button it is keeping on rotating , can anyone help to know after clicking import button ...
0
votes
0answers
25 views
In magento 2 How to import image from ftp server having restricted access
The ftp can be accessed only through credentials can Iget images from that ftp for magento.
Is that Possible?
0
votes
0answers
27 views
Magento2 How to upload cache images to Amazon s3 server while importing product from beckend
i have upload images to amazon s3 server and it is uploaded images to amazon s3 server while importing products. but i am not able to view images in product view page , and i have check cache folder ...
0
votes
0answers
29 views
Import button + File browse field in custom admin page in Magento 2
I have created a custom admin page on Magento 2. Now I want to show Browse file after browsing when click on Import button it should go to a controller to process the file data.See the below ...
0
votes
0answers
24 views
How to import customers and orders from magento 1 to magento 2 [duplicate]
We are talking about migration to an already created store. At the moment, he is not only created. He already works and has different orders and users registered through magento 2.
How to export ...
0
votes
0answers
33 views
Magento 1.9 - How to update table values using CSV?
I want to add alt tags to my all 50K products so that i plan to update table catalog_product_entity_media_gallery_value. After created csv
and directly imported to the table ...
0
votes
0answers
176 views
Magento 2 Read data from json file
I want to import products from a json file. How can I read the data from the json file as array?
Here is my sample json
[
{
"id": 632910392,
"title": "IPod Nano - 8GB",
"...
-1
votes
1answer
135 views
Import in Magento Products from 2.1.5 to magento 2.3.4
I get the below error in log file
PHP Fatal error: Uncaught Error: Call to a member function getFrontendInput() on boolean in vendor/magento/module-catalog-import-export/Model/Import/Product.php:...
0
votes
4answers
51 views
Magento CE 2.3.1 Product Import issue
I am facing issue import Magento stock source importing. please check the snapshot
Upload CSV:
https://prnt.sc/ranqvc
and getting error snapshot:
https://prnt.sc/ranr13
Below my CSV ...
0
votes
0answers
259 views
Importing Date Attributes in DD/MM/YYYY format
When importing products with date fields in format dd/mm/YYYY it throws this error:
Value for 'special_to_date' attribute contains incorrect value in
row(s): 1, 2, 3
From reading around I see ...
0
votes
0answers
12 views
Magento2 Import csv without required attribute like attribute_set_code and product_type
Magento2 Import CVS without required attribute like attribute_set_code and product_type
Note: we can add run time while CVS running
0
votes
1answer
302 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
28 views
Set custom attribute value for a product programatically in magento 2 [duplicate]
I have created custom attributes for a product. I am doing product import programmatically.
How to set value for the custom attributes programmatically in magento 2.
0
votes
1answer
159 views
How to import 20.000 coupon codes in Magento 2 without paid
I want to import 20.000 coupon codes on my website, and for this reason, I created the following script:
<?php
use Magento\Framework\App\Bootstrap;
/**
* If your external file is in root folder
...
1
vote
1answer
43 views
Import categories programatically in magento 2
I have 250+ categories and sub categories with me. I want to import it in my magento 2. It is not possible to manually add it. Can anyone help me with some scripts or code to import categories from ...
1
vote
1answer
29 views
What is the folder where the images need to be for mass importing products?
What is the folder where the images need to be for mass importing products ?
I seen there in import admin panel that is var/import/images/products_images but no is not working
0
votes
0answers
30 views
How to import data into magento 2.3 using scripts
I want to import data into my magento 2.3 from JSON.. Data means everything i.e products, customer, category, order etc.
I want to do this by writing script. Is there any document or any post which ...
1
vote
0answers
34 views
import date format correct in magento 2
i'm tring to import a date field correct into the special_from_date and special_to_date field of products however for some reason the result is not correct.
I have this
-<Item>
<sku>...
1
vote
0answers
356 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 ...
2
votes
1answer
71 views
How do you update/change a product's store/website via Magento's CSV importer?
Using Magento 1.9.2.
I'd like to be able to re-assign products between stores by uploading a CSV containing product SKUs and store names or IDs.
How can this be done?
1
vote
1answer
37 views
Magento2: Category URL rewrite issue
I am trying to import product from magento but when I try import I will get below errors.
I have flushed all category then update the new category. Got the error message below:
General system ...
0
votes
0answers
410 views
Magento 2 Error: Base table or view not found: 1146 Table 'dbname.table_name' doesn't exist, while database import
I have a fresh setup of Magento ce 2.3.2, while importing the database with sample data in fresh database and I faced this error:
Uncaught PDOException: SQLSTATE[42S02]: Base table or view not ...
1
vote
0answers
17 views
Magento 1 Import - If “Use Default Value” checked, skip to default view?
I'm starting to learn a bit about Magento import / export tool.
The problem I'm having is that our store consists from 2 stores:
- Default View
- Canada
- USA
The way that we set it up is ...
1
vote
0answers
62 views
Magento 2 I am trying to upload CSV file for the configurable products. getting error like attribute code does not exists
I am trying to upload this CSV file for the configurable products.
Unfortunately, the error I'm facing is
Column configurable_variations: Attribute with code "rom" does not exist or is missing ...
2
votes
4answers
986 views
Can't import database Magento 2.3.3
I have created a backup database by command line:
php bin/magento setup:backup --db
Then I import it to my new PHPMyAdmin, But it shows a bug:
Static analysis:
4 errors were found during ...
0
votes
1answer
18 views
M2 - How to fix wrong customer import
I have a live webshop and imported user from the old webshop. The amount of accounts is around 6500. The was something wrong with the import so everyone has a wrong address in their account. So I made ...
0
votes
1answer
38 views
Export Magento 2 Orders
How can I export Magento 2 orders and then import them on a new system?
The new system has the same products in front-end and as far as customers are concerned. However, the way it works in the back ...
0
votes
0answers
26 views
Image import errors (csv)
I'm trying to import 500 images (at a time, 13000 total) using a csv.
I keep getting the following error:
Imported resource (image) could not be downloaded from external
resource due to timeout ...
0
votes
1answer
448 views
Magento 2.3.3 - Import Newsletter subscribers along with email, Name, Type, Website, Store, Store view from CSV
I run a multi website and store setup, on PHP 7.1
I'm trying to import newsletter subscribers from a CSV as follows, which is in a CSV file called subscribers-import.csv in the root dir.
I'm using ...
0
votes
1answer
258 views
Magento 2.3.3 - import newsletter subscribers from CSV
Running a multi website and store setup.
Example
Website - Japan
Store - JP
Store View - JP
I'm trying to import newsletter subscribers from a CSV.
I'm using the following code in a file called ...
0
votes
0answers
33 views
products csv import categories not updated in magento2
I'm importing product sku and category ids using product import in magento2.
but not working please anyone help me.
eg: sku,category_ids
test_123,2,5,12
thanks
0
votes
1answer
119 views
Magento 2 : Import product image with sku
I have a CSV file product image with SKU, I did import all product SKU in admin but not have an image.
here is the CSV file I need import.
0
votes
0answers
87 views
Magento 1.9 product import xlsx to csv
I am trying to write a module that converts the given Xls file to default Magento CSV format? Is there any better way to do this?
1
vote
0answers
61 views
Magento2 error while updating product URL keys
Getting this error while importing produdct for updating product URLs
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or
update a child row: a foreign key constraint fails
(...
0
votes
1answer
41 views
Magento 2 : Import product with external image URL
I have a CSV file with image field is external image URL, how can I import it, hope anyone help me.
0
votes
1answer
24 views
SQL Error when importing bulk data. Product_id goes out of sync with Entity_id
When importing about 12000 rows of products from a .csv file, it suddenly gives me the following error:
General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint ...
1
vote
1answer
126 views
Magento 2 : Import product with custom csv
I have a custom product csv file https://drive.google.com/file/d/1f9t4REhn8-Ant58zRB6S0yRx1Rh1PctX/view?usp=sharing
how can I import it in Magento 2. Do you have any idea?
0
votes
1answer
144 views
Magento 2: import product with many other data fields
I want to import many products with many custom fields. How can I do that, I hope anyone helps me, Thank in advance.
Here is notice when I import product with many custom field
0
votes
1answer
171 views
Magento 2: Problem with Product Links
During an Import to Update Product prices, I made a mistake. I leave the value for the Product Link empty. After the Import all Product URL change and got the value from the Product name. To face this ...
0
votes
0answers
333 views
Magento 2.3.2 - Product import duplicates images
Running Magento 2.3.2 on PHP 7.2
CSV being uploaded has one image for base_image, small_image, thumbnail_image, swatch_image, additional_images.
When products are imported, product images are ...
0
votes
1answer
10 views
Magento2.1 image importer
I want to import images into magento2.1 with default importer.
My problem is that I added image folder into pub like this:
pub/media/catelectronicpic/mobile/1.jpg
pub/media/catelectronicpic/laptop/1....
1
vote
0answers
80 views
Magento 2 Column names: “_super_attribute_price_corr” are invalid
I'm trying to do a Magneto 1 to magneto 2 import, using the built in Magento 2 importer. I keep receiving the error "Column names: "_super_attribute_price_corr" are invalid". Did the attribute name ...
0
votes
2answers
463 views
Magento 2: Other required columns in CSV to update Name, Quantity & Price
I want to update products on my Magento 2 Website with csv bulk import. I have downloaded the export file but it has too many columns.
I will only update the Product name, Quantity & Price. ...
0
votes
2answers
76 views
URL key for specified store already exists. When importing
M 2.3.1
We are importing via Firebear.
When I import I am getting success.. the product imports but I get this error:
URL key for the specified store already exists.
Whenever I try and SAVE ...
0
votes
1answer
843 views
How to Import Orders Programmatically with all the product type in Magento2?
I am Looking for the Order Import Programmatically with capable of importing all the product types and multiple products able to import that also I need specific billing details to be included.
0
votes
0answers
61 views
Cron job image import issue - Magento 2.3
In Magento 2.3, I am importing data from the .xml file. The product name, SKU and product description i can import via cron job but I cannot import the product image. Can you help me?
Thanks in ...
1
vote
0answers
17 views
help with importing customers into magento 2.2.7
I have tried to import the attached listed using the example CSV sheet from Magento. But I keep getting an error that the headers are wrong. I attached the two files can you tell me what I am doing ...
