Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
1
vote
1answer
56 views

how to Import CSV in magento 2 and insert in database Table

Here am added import custom upload drop down to magento backend succesfully. while am importing data its not getting insert into database, its showing Please enter a correct entity model. error class ...
1
vote
1answer
810 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
1k views

Import products and keeping the current id

Has anyone tried importing products from another store and keeping the same ID? I'm not sure how to do identity inserts with Magento. I'm sure there has to be a way.
0
votes
0answers
33 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
40 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
152 views

Magento 2.3.1 import images with external link still not working

trying to pull image from external url during import but get: "1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 2" here is ...
0
votes
0answers
22 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
22 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
26 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
1
vote
1answer
585 views

Upload csv file with products. not working

i have a job of making a new shop for a client. He has an existing shop in another platform - Dandomain The client has over 1000 products, so clearly i want to make an product import. Dandomain have ...
1
vote
1answer
596 views

How to update data if product sku already available in magento using custom script for product import?

I have created custom import script for simple product csv import in magento. It is working fine for the newly products. But I want to update the products if sku already exists. How can I achieve ...
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 ...
1
vote
3answers
136 views

2.3 to 2.3.1 Upgrade showing sales_order_grid already exists

So far the upgrade went pretty smooth but now I have a few outdated modules and it's asking me to run the setup:upgrade on CLI but I keep getting an SQLSTATE general error: 1813 Tablespace for table '...
0
votes
0answers
20 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 ...
0
votes
0answers
31 views

Configurable Products Import Issue

I am trying to upload this CSV file for the configurable products. https://docs.google.com/spreadsheets/d/1yJBI_rS7miln6yATN6TYgoh3H4RSyty4WKJI9zNz1aw/edit?usp=sharing Unfortunately, the error I'...
0
votes
0answers
36 views

Can't import cross-sell when cross-sell sku contains space

In "System, Import/Export, Dataflow Advanced Profiles" I have a profile for importing Cross-sell. It works fine; however when the cross-sell SKU contains space it is not imported. The product itself ...
0
votes
0answers
58 views

Magento2.3.0 Getting error, when Import Group product via CSV

I am using magento2.3.0 when I import CSV through group product with associate product getting an error in back end side. If anyone has an idea please share your inputs. {"error": "Invalid file ...
1
vote
1answer
720 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) -&...
1
vote
2answers
157 views

How to transfer WooCommerce Orders to Magento in Real Time

I would like to transfer orders I get from WooCommerce into Magento. The reason is that I want to have one-click upsells/downsells and I can't find a module or anything for Magento that has this ...
1
vote
0answers
31 views

Import new database after category description not showing in magento 2

Hello I have import new database and category description no showing. Description.phtml no working. But in old Database everything is good. is that import Database issue? Where i find error in ...
0
votes
2answers
740 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 ...
0
votes
1answer
650 views

Import new categories via CSV and assign categories to existing products by SKU

I need to be able to import new categories via a CSV file and then in another column have SKUs separated with commas to not only create the new category but also assign it to those products. For ...
0
votes
1answer
43 views

Undefined index: category_id in Magento 2 Import

I'm trying to import some data into magento for some custom atributes, it seems to get some far through the sheet and then errors with the following message: Notice: Undefined index: category_id in /...
0
votes
0answers
24 views

Special price set with schedule date : M2

In magento2 enterprise edition, we need to set a schedule for the special price for a particular product from the product edit page. I have tried to import special price with schedule date but the ...
3
votes
1answer
684 views

Custom csv Import not working in magento 2.3

While doing importing from backend for custom table its trowing following error systemException Additional data: Error in data structure: entity values are mixed but its correct validated in ...
0
votes
0answers
26 views

Import customers without e-mail notification?

How can I import all our customers from Magento 1 to Magento 2 without any e-mail notification? Is this possible with the default importer from Magento 2?
1
vote
2answers
632 views

Update custom attribute when product data updated through import

We import product data using a feed we get from a wholesaler - one full import a week that merges product data and a daily import that only updates price and stock data. I have created a custom ...
6
votes
3answers
8k views

Read input csv file and convert it to array

I have an input file form in phtml to import data from csv file type like this: <div class="import-shipping"> <div class="header"> <h4>CSV File:</h4> </div> &...
4
votes
6answers
11k views

import/export error - magento 2.0.1

Firstly I export csv file from admin and keep only one row and delete the remaining row, after that I will change product name,category name and then import the file.I am getting the result in ...
4
votes
3answers
3k views

Magento 2: Import multiple select attribute values using CSV

How can we import multiple select attribute values using CSV ? For example SKU "test" has two values for attribute "xyz" - "val1" and "val2". When I use both value as val1<space><comma>&...
2
votes
0answers
28 views

How to create system configuration for fileds of the custom table which is imports that fields using csv via import in admin configuration? Magento2.3 [closed]

I have created the module to import CSV to a custom table. the columns of table should dynamically be added to the import.xml and not by code to import the CSV and not by code.in Magento 2 for example,...
1
vote
1answer
795 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 ...
1
vote
1answer
68 views

Best practices/methods for adding 100k products in Magento 2?

I have to add 100k products by the end of this week. Most of them are simple products but 30% are configurable products which each have 8 simple products, total 100,000 SKUs. I used Magmi (in Mage 1) ...
3
votes
1answer
1k 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?
2
votes
1answer
725 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
1answer
883 views

Magento 2.2.1 Product Import Not Updating Assigned Categories

When updating my products via the add/update import process, the assigned product categories are not being updated. If I update by selecting "replace", it works. Example Product-A currently has the ...
2
votes
1answer
879 views

1.9.0.1 dataflow import customers. Different results when ran from browser or shell

I'm magrating to Magento, and I have a large amount of customers to import. I am using the dataflow profiles because more fields are available. The problem of importing dozens of thousands of ...
2
votes
1answer
372 views

Magento 2 - Custom module file upload configuration and save in custom module table

File upload in Magento 2 store configuration <section id="custom_section" translate="label" type="text" sortOrder="301" showInDefault="1" showInWebsite="1" showInStore="0"> <label>...
0
votes
0answers
66 views

Magento2 : Import/Export is not visible in Admin section

I am having an issue in Magento Admin. The import/export menu is not visible. When I open the URL directly, It shows a blank page. Please help, it's urgent.
6
votes
3answers
135 views

How to keep products synchronized in two shops

How can I transfer all products from one shop to another after clicking a button? We have a shop which is a copy of our real shop. We need to keep the products, prices, etc. synchronized in both ...
2
votes
3answers
1k views

Magento 2 : Customer import not working and gives “Import successfully done”

I have around 1000 customer to import when I try customer import using magento2 default customer import. Validation works perfectly and when I start import it gives me the message "Import successfully ...
2
votes
1answer
470 views

Customer login does not work after customer import via CSV (Hash not same)

I successfully exported my customers from Magento 1 into a CSV and then used the import tool in Magento 2 to import them. On the backend everything looks fine and all customers and addresses are ...
0
votes
0answers
1k views

How to upload and read csv file import into database in magento 2?

How to upload the csv file and read import into the database magento 2? <?php /** * XXXX_ProductImport extension * @category * @package XXXX_ProductImport * @copyright Copyright (c) 2018 * @...
0
votes
1answer
110 views

Magento 2 - Import Product .csv via CLI

Actually, the desired requirement is quite simple. I would like to control and execute the import from the backend of the Magento 2 system via the CLI. This question was asked some time ago (2016) ...
0
votes
0answers
29 views

Take by Magmi a Magento attribute value

I would like to add to a price I have in CSV a percentage that I have on an attribute (when I update the product). For example, in my CSV I have: sku price xx 18,08 On Magento I have a ...
0
votes
1answer
292 views

Magento 2.3 what is "Empty attribute value constant' in import

Is anyone know in Mageno 2.3 product import a new field is introduced i.e "Empty attribute value constant" field. What is the use for
0
votes
0answers
77 views

Magento 2.3.1 error when importing stock - Cannot get auto increment value

I have installed fresh magento 2.3.1 and tried to import stock, but every time I got error "Cannot get autoincrement value". The product is added to store, but Quantity is empty, and Salable Quantity ...
1
vote
1answer
37 views

Problem with importing from Cludes ERP System to Magento backend

I am importing products from Cludes ERP System, but Product base image is not set in Magento backend: