Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
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 ...

1
2
3 4 5
22