Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
0
votes
0answers
16 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
7 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
0answers
21 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
17 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
25 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
28 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
23 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
25 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 ...
0
votes
0answers
23 views

Database import Error in Migration Magento 1.9 Store

I am migrating a Magento 1.9 store to another hosting. While I am importing previous database to new phpmyadmin I am getting below error.
1
vote
0answers
18 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
40 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
25 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
34 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
44 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
12 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
21 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
172 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
17 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
0answers
13 views

Magento 2 - Keep csv data description spaces while creating programatically

I am trying to create a new product using CSV custom script for which I refer Programmatically create a simple product in magento 2 Which is creating a product but it removes all spaces when we set an ...
0
votes
0answers
58 views

Magento 2 Custom Import Not updating the exists data

In Magento 2.3, I am using this link to import the custom csv data. Adding, deleting, replacing are working fine. But the data is not updating with existing data. Anyonce came across this issue, ...
0
votes
1answer
25 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
24 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
82 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
85 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
15 views

Magmi image processor import issue

I am using Magmi to import my date, have remote image addresses. The problem is when I import them, all images are same! I am Using version magento 2.1
0
votes
0answers
18 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
0answers
21 views

Import custom related products through CSV

I have created a custom tab for Alternative Products and have to import SKU's through CSV like _links_related_sku in CSV. I am unable to import my products in custom alternative products tab in ...
0
votes
1answer
45 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
44 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
34 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
32 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
18 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 ...
0
votes
0answers
22 views

Magento 2 : Change column title when import product csv file via programmatically

I have a product CSV file when I import it in Magento admin, I want to change column title eg : in the original file: NAME, CATEGORY...etc and I want to change to: name, categories...etc, hope anyone ...
1
vote
1answer
65 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
72 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
44 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
88 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/...
1
vote
0answers
34 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
104 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
1answer
37 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
232 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
38 views

How to import configurable product in Magento 2 using custom CSV file

I want to import configurable product in Magento 2 using a custom CSV file. My CSV file like this How to import it with this file? Please help me! UPDATE I can import by this CSV but it not show in ...
0
votes
0answers
45 views

Magento 2: Categories import via CSV not updated same name child category as assign in different parent categories

I am importing categories via CSV and it is working. After updating categories data like description, is_active, etc. But same name categories are not updating in different parent. I want to update ...
0
votes
0answers
24 views

Magento stop when will import products

I'm start using magento few days, I have imported product from a csv file and was ok. But now, when I setup to import products from a csv file they stop and not work more. I already reindex and ...
0
votes
0answers
27 views

Line break into Magento CSV import description field

I need some help because I don't know how to fix this problem. On my import CSV, I have a description field but when I go to the front office after the import, the line break is not taken into ...
0
votes
0answers
28 views

Magento 2 programmatically order import is not working with multiple product only one item price display in order details

Magento 2 programmatically order import is not working with multiple product only one item price display in order details and other product price and qty 0
0
votes
0answers
28 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 ...
0
votes
0answers
10 views

How do stores with large catalog map item image to swatch colors?

So I have thousands of items (all config products) that have a few different colors (simple products) and have about 8 different swatch colors and the only data that have the only relation to color is ...
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 21