Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
0
votes
0answers
15 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
21 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
7 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,...
0
votes
0answers
9 views

Magento 1: import products *directly* to multiple websites using csv import

We would like to import products via magento csv and add it to multiple websites in 1 go. Currently the data looks like this. sku name _product_websites PR.123 Blue socks domain.com ...
0
votes
0answers
20 views

Magento 2.3 Update Stock via Database - Multi Source Inventory

I was hoping to get a grasp on the how Stock levels(Qty of a sku in stock) are stored in the database with the changes to MSI. Now that we have stocks and sources I'm unsure what all tables we need to ...
0
votes
1answer
13 views

Magento2.3.1 : multiselect attribute values is not saving for products via magento backend

I have tried to save multiple values of an attribute for a product, but it is not saving. I have used Pipe separator and comma separator, unfortunately, both are not working Please find my csv file ...
1
vote
1answer
31 views

Error while importing products through csv in magento 2

I am trying to update my product price through csv. When I run this import, I am getting this error: -> The value specified in the URL Key field would generate a URL that already exists. https://...
0
votes
1answer
32 views

Importing orders from .csv into Magento 2

I've got some orders from M1, exported into a CSV that I need to add to Magento 2. There aren't too many so I don't mind doing it manually. I've found that adding orders through the order section of ...
0
votes
1answer
47 views

How to link simple products to configurable product?

Im building an import extention, that imports bicycles from an external Database into Magento. I managed to create working helpers, that create a configurable product and the different bikesizes as ...
0
votes
0answers
30 views

Is there any Magmi alternate for Magento 2.3.5?

Is there any extension available for Magento 2.3.5 like Magmi which can create categories and products from csv file. Regards.
0
votes
0answers
32 views

Magento 2.2.4. Product Import additional_attributes Error Issues

I have a problem with Magento 2.2.4. when I try to Import new products into a website, even when I try to Import the Exported products I already have on the website, I get this kind of error. Those ...
0
votes
0answers
54 views

Magento 2.3 - Product Import is still in In progress

I tried to import prices in Magento 2.3 backend. Checked data and saw no errors. I clicked import button, then it shows Maximum error count has been reached or system error is occurred!. But in ...
1
vote
1answer
35 views

Version 2.3 API Image Import with a path and not base64

I am using the catalogProductRepositoryV1 (/V1/products) for importing a bunch of products (about 9.000). We have a very high fluctuation of products per day/import. So I would like to import images ...
0
votes
0answers
22 views

Magento 2: Import store configuration using csv

I want to import the configurations using CSV in Store -> Config under my module. After importing, it should set in the store config fields. How can I achieve that? I have referred this link ...
0
votes
0answers
17 views

How to import magento products' data to Akeneo Pim?

I've installed the magento side connector, and found it's expensive to buy a PIM side connector to import magento data into pim, does it exist some instructions for importing products from magento to ...
1
vote
0answers
22 views

Bulk product Import examples

I am looking for some csv examples for bulk product uploads with or without images and i couldn't find any so far. Does anybody has or know any links, please share with me . Thanks in advance
1
vote
1answer
32 views

cataloginventory_stock_item - errno: 150 Foreign key constrain is incorrectly formed

I'm tranfering my magento2 website locally. Importing website database gives me the following error: ERROR 1005 (HY000) at line 636351: Can't create table 'cataloginventory_stock_item' (errno: 150 "...
0
votes
1answer
19 views

magento2 product import error : Call to a member function getData() on nul

I tried implement import by Msquare answer from here import custom csv to custom table- magento 2 But I getting this error: Fatal error: Uncaught Error: Call to a member function getData() on null ...
1
vote
0answers
33 views

Memory leak in product save loop

I'm trying to import ~5000 products from XML, but the execution time and memory usage increases in each loop, resulting in a long import process. Test code to demonstrate: <?php namespace Test\...
1
vote
1answer
72 views

magento2: can I import configurable products without their variations?

I'm trying to import some products from an ERP with a cron job and I'd like to utilize the data import functionality which is built-in with magento 2. My idea is to create a small csv file (very ...
1
vote
1answer
109 views

v2.3.4 Customer Import - Please enter a valid region

I'm having a real nightmare trying to import customers using "Single File" right now. I've been using Firebear Importer for this, but I've since noticed that this is happening using the native ...
0
votes
0answers
22 views

Import Address from CSV with multiple 'street' elements

I have some source customer/address data from an old system which needs to be imported to Magento from a CSV file. The source data has multiple Address elements (house name, address 1, address 2, ...
0
votes
0answers
30 views

Fails product import on Magento 2.3.x

I am creating new import module and I have issue with new created Product. Product doesn't want to create: In StockRegistry.php line 194: The Product with the "13.111.116" SKU doesn't exist. My ...
0
votes
1answer
186 views

Magento 2 function insertOnDuplicate()

How can we implement insert on duplicate update using non-primary key or non-key field using Magento's function insertOnDuplicate? Or is there any other way then please suggest.
0
votes
1answer
159 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
31 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
29 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
11 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
16 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
15 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
18 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
20 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
29 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
65 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
66 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
47 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
105 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
9 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
53 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
79 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
37 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
28 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
29 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
24 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
28 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
157 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
42 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
36 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
225 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
2 3 4 5
21