Questions tagged [import]

Denotes questions related to imports

349 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
239 views

Load products in grid serializer after CSV import through AJAX

I want to use import feature like attached screen-shot in my custom module. please refer the attached screen-shot. Actually I want to load the products in grid which are mentioned in CSV after import ...
2
votes
1answer
882 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
249 views

Import Products Dataflow Profile - 500 server error in console

I've successfully exported my products. I made a few changes to the file (new sku, new product name), saved the file with a new filename and want to import the csv file. This is what it shows my on ...
1
vote
0answers
11 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
16 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 ...
1
vote
0answers
29 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 (...
1
vote
0answers
24 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 ...
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
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 ...
1
vote
1answer
101 views

Configurable variation is unidentifiable - Magento 2.3.1

I'm getting the Configurable variation is unidentifiable error when trying to import the configurable items to Magento 2.3.1. I think I have the correct format for the csv, using the defined format, ...
1
vote
0answers
41 views

Magento 2.3.0 URL keys regenerate on import

This is a serious issue that is occurring on numerous Magento 2.3 builds (I have tried) If we use the import function from a CSV with the "name" header, Magento automatically updates the URL key to ...
1
vote
1answer
195 views

Import csv in magento 2 is not working and show error “invalidAttributeName”

Import csv in magento 2 : Duplicates found in column names I want custom import data to custom table " profilers " but it not working and show this error. I followed http://www.blogtreat.com/how-to-...
1
vote
0answers
31 views

Import users/customers in Magento 1.9 without overwriting users/customers users passwords

As per title, I'm exporting users/customers from a previous Magento installation via the Dataflow functionality. I've a problem with the import: the new installation already has some users/customers, ...
1
vote
0answers
32 views

Imported products and categories system urls return 404

We are setting up import of products and categories from suppliers XMLs. The idea is to have it automatic and we have successfully imported products and automatically generated categories using this ...
1
vote
0answers
149 views

Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s)

I'm importing products via csv and get the following error: Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s) what I've noticed ...
1
vote
1answer
85 views

Magento 2 Import/Export Options Missing

I've installed Magento 2 and under System -> Data Transfer there are no options. Do I have to enable them somehow?
1
vote
0answers
22 views

How can I import products from external programs CSV every day?

I have external "offline" program that runs database of products. I would like to create a script or something to automaticaly update product inventary. Another problem is that headers don't mach, so ...
1
vote
1answer
54 views

While import product custom options throws error in magento 2

While trying to import custom options for product throws the below error. Please provide me a solution SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4953' for key '...
1
vote
1answer
37 views

Image not optimizing for product page

I import products from CSV file. I added base_image, small_image, thumnail_image, swatch_image and additional_image column. In backend it had been updated. But in front-end shows default magento icon. ...
1
vote
0answers
15 views

Data Collection and Preparation: 15,000+ products for Magento 2

We're at the early stages of a reasonably large Magento project that will have a catalog of over 15,000 products. The big problem is that the customer doesn't have any information on the products ...
1
vote
0answers
50 views

Magento 2: Importing Customer information shows validation error 1. Please enter a password with a valid length. in row(s)1

I am importing customer information in magento 2 with password 4 characters, I have also changed the password length to 4 in Stores->Configuration->Customer Configuration. But still shows the same ...
1
vote
0answers
75 views

Update description for product with csv for one store only magento 2

I want to update some fields of product only in one store (magento2), but all stores are updated Any ideas ?
1
vote
0answers
52 views

Php script for import configurable products from csv

I need to import a lot of products. So i want to use a script. So if you have any script to do that can you share the whole php file?
1
vote
0answers
161 views

Programmatically import multiple products with same image name in 1 transaction - Magento 2.2.6

I'm running into an error while importing multiple products with the same image name in one transaction. The file "/var/www/magento/pub/media/tmp/catalog/product/t/e/test.jpg" doesn't exist or not ...
1
vote
0answers
44 views

magento 2 in how to products value will be imported?

I have three csv files 1).products attributes. 2).products details files. 3).products attributes values files . first 2 files will be imported but attributes csv files not imported. Error: ...
1
vote
0answers
140 views

Import Customers Without Password

I am migrating a website from another shopping cart to Magento CE 2.2.6. I have been able to use the import function in the admin without an issue. The problem is that I won't be able to import any ...
1
vote
1answer
988 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' =&...
1
vote
0answers
138 views

Magento2: Import custom options from product programmatically

I want to import custom options from existing product programmatically.My custom options are copied but options having values are not imported.It throws invalid option value error. I am using below ...
1
vote
0answers
24 views

Magento 2 import adds info but the import process doesn't end

it's basically what the title says, and I'm only facing this issue when adding prices to products via csv import. I've already checked memory_limit, post_max_size values and they are good, because I ...
1
vote
1answer
574 views

Magento 2 Product import error :. Value for 'product_type' attribute contains incorrect value

I'm using Magento 2 Version 2.1 . I have migrated data from magento 1.9 to magento 2.1. The csv looks like, this: sku,product_type,additional_attributes 123,simple,brands=APPLE,...
1
vote
0answers
83 views

php -f bin/magento customer:hash:upgrade not works | Magento 2

I have import customers from magento 1 to magento 2 with admin tool System > Import after import i run php -f bin/magento customer:hash:upgrade to upgrade password_hash from md5() to sha256() but ...
1
vote
1answer
38 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:
1
vote
0answers
89 views

Magmi importing product attributes with custom made group not taking values https://ibb.co/hUmVY9

Magmi product attributes in "custom made group" not taking values even after clearing cashes and reindexing. https://ibb.co/hUmVY9
1
vote
0answers
128 views

Magento Bulk Import Functionality Best Approach

We are developing a multi vendor module . In this module vendor will upload an excel sheet to import simple and configurable products. I have a few questions here to proceed. I need a better approach ...
1
vote
0answers
13 views

How to get Each product's import starttime and import end time in magento2?

I want to get each product's import start time and import end time in magento2. How to get it?
1
vote
1answer
206 views

Single store multi-currency setup issue with import rate Magento2

I am having issue in import rate for currency. Default currency is US Dollar and the other currency what I want is Indian Rupee. Import Rate options are not working.
1
vote
1answer
102 views

Magento PIM integration, how best to handle attribute set

Having to import products from a PIM solution and seeking recommendation on the best way to handle attribute_set. Would this typically be mastered in PIM and extracted or is there any other ...
1
vote
0answers
26 views

Adding multiple products (csv files taking too much time)

So we have a CRM/Accounting/Sales/Inventory system called BrightPearl. This is used as our product database and we can import and export data into it using CSV. Files. I say product database and use ...
1
vote
0answers
13 views

Can you re merchandise categories through import on CE 2.2?

We are on Magento 2.2 CE and so have no way of merchandising categories without going into the categories and re merchandising by changing their numbers manually. Is there a way to change the ranking ...
1
vote
0answers
80 views

Running simple Data Flow import profile deletes records

I encountered a very weird issue. I am trying to run a very basic import data flow profile (done it a hundred times before) by using selected Magento columns: sku, category_ids and status which looks ...
1
vote
0answers
34 views

Ngnix issue caching image with magmi importing

I have used magmi tool to import product images on Magento 2.0.6. There is one option is to replace the images if it exists. I have check that option, it uploads the file successfully physically (I ...
1
vote
0answers
107 views

Best way to bulk update stock and price for 50+ thousands of products?

We have well over a hundred thousand products in our magento CE 1.9.2.4. Many are drop shipped from a number of suppliers. Several suppliers can provide the same product. Naturally they will all have ...
1
vote
2answers
172 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
44 views

Update product programatically

I wrote a script for adding products programatically from a CSV. It's working fine. Now I need to update it to do followings, Check if product is already available (using SKU ) and if not, add new ...
1
vote
0answers
72 views

Update procusts and customer data in csv

I need to add a functionality to import products and customers periodically (lets say once a 6 hours), from a given csv files. Can I write an external script for those imports? I tried to import ...
1
vote
0answers
328 views

Import products and customer data programatically

I needed to programatically export and import customer data, product data and order details. I've successfully created my exports. I'm having problems with my import. I need to do this using an ...
1
vote
1answer
118 views

import images are default to exclude on dataflow

I am importing images with dataflow, and all looks fine, however after I import they are all pre-selected as excluded: I am uploading a csv file with sku and image and it should have one more column ...
1
vote
0answers
197 views

Having issue importing tablerates.csv on Magento 2 with custom Region/State

I have added New Region/States for the Country Malaysia in the table directory_country_region and also directory_country_region_name.. see screenshot: as you can see from the screenshot.. country ...
1
vote
1answer
247 views

Importing products takes too long on a fresh install of Magento 2 v2.2.4

Backstory: Suddenly, my MySQL database for Magento 2 has failed and been corrupted (This is a development installation and used to enter products data) and I don't have backup of the database except ...
1
vote
0answers
85 views

How to import custom address attribute?

I added this code to my InstallData script: $eavSetup->removeAttribute('customer_address', 'erp_address_system_id'); $eavSetup->addAttribute( 'customer_address', '...