Questions tagged [import]

Denotes questions related to imports

353 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
76 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
475 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
128 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
1answer
275 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
306 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
102 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', '...
1
vote
1answer
34 views

After updating only product price through Csv using Sku code, it changes quantity to 0 in magento 1.6.0

We have updated only the price using Magento CSV import functionality, but it automatically changes my product quantity as well. Below is the CSV file format Can anyone suggest why this is ...
1
vote
1answer
113 views

Data success then “URL key for specified store already exists” error

Having received 100% success, ready for import, the next page then denies the upload, why? I have tried making the document smaller, only 700 entries, but receive the same OK then the same error. ...
1
vote
0answers
919 views

Import Prices for different store views in Magento 2

I am importing the prices through CSV for different store views. It does not import the prices properly. Can you please give me the solution for it?
1
vote
1answer
320 views

Magento223: How to Import CSV during module installation

I have custom module in which i am importing csv file upon button click. I want to import the csv during module installation, i don't know how to implement it in install data file. Any help will be ...
1
vote
0answers
122 views

Magento 2: Missing entity types in CSV import

I have a fresh instance of Magento 2.2. In the Import tab, there are only "Products" entity types. Should I enable anywhere rest? Like e.g "advanced pricing"? Edit. SOLVED -> Module "...
1
vote
0answers
452 views

Converting M1 password hash to M2 password hash

I imported around 6000 customers from Magento 1.3 to a magento 2.2 through csv. Of course when i try to login to magento 2 with an account from magento 1, it doesn't work probably because of the ...
1
vote
0answers
162 views

Magento 1.9.2.2 Datwflow Import Product Price Update CSV

i need to update some prices in the shop and made this many times in the last years. But now i have the problem that magento kills my product descriptions on update. My CSV file has only two fields. ...
1
vote
0answers
63 views

Importing CMS pages from Homestead to Magento 2.0

We are using Magento 2.0. Our previous website was on Homestead CMS. We want to bring all the pages from homestead to Magento 2.0. Please help
1
vote
0answers
34 views

Base table or view not found: 1146 - While importing products from one DB to another DB

I have a site in magento 1.9.2, I installed a new magento 1.9.2 on my localhost which is blank. I export all products by going into system->dataflow->exports and download file as a csv. Now I am ...
1
vote
0answers
120 views

How to call Admin Backend Controller via cron job in Magento 2

I want to automate the import in magento 2. How can I call vendor/magento/module-import-export/Controller/Adminhtml/Import/Validate.php via cron?
1
vote
0answers
86 views

Multiple CSV Automation - Distributors product feeds for ecommerce importing

I am looking for a way to merge / automate 3 CSV files which each have different headings, i need to import these files automatically into Magento but they need to be mapped to attributes that Magento ...
1
vote
0answers
132 views

How to Import new categories and products from one site to another without overriding the existing

I want to export the categories from live site and import into the development site in Magento. I have followed the method to import through the default import/export via dataprofiles but it ...
1
vote
0answers
88 views

My import for products images doesn't show the one from server, but old ones - Magento 2

I made an import with new images and now the images that are located in public/pub/media/import are the correct ones, so the import was succesfull. But in site are displayed the old ones. I applied ...
1
vote
1answer
1k 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
0answers
313 views

Automatic import csv

Is there a way to automatic import product wholesale csv to magento2 I know some extensions has column mapper but my csv doesnt have the requered headers like productype etc, so the import fails. ...
1
vote
0answers
44 views

Import shows changes on product, but not front of site

Trying to upload an excel sheet to update products for upcoming sales, and the changes are being placed on the product, but not on the front end. I have one product that I set to have a 15% discount....
1
vote
1answer
550 views

Import Module to allow for multiple CSV imports in a batch setting

<?php /** * Copyright © 2013-2017 Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ /** * Import model * * @author Magento Core Team <core@magentocommerce....
1
vote
0answers
147 views

Magento2 : Restrict new category creation on import products

I want to restrict magento2 import from CSV that if product has a category path and category not exist then throw error to admin. Currently magento2 allow import products and it create new categories ...
1
vote
1answer
424 views

Fail to import large file on Magento 2 from admin

I succeeded importing a csv file size 319KB with 357 products. But failed to import a csv file size 571KB with only 349 products. Please help me to fix the problem.
1
vote
0answers
605 views

import products csv file fails with 'Specified URL key already exists in row(s)' error

I have the following error "Specified URL key already exists in row(s): 99, 124, 179, 190, 194, 222, 271, 297, 326, 328, 329, 332". When I tried to import some 338 simple products with created ...
1
vote
0answers
154 views

Product import module for Magento 2

I am looking for product import module for Magento 2 which will allow me to download images and uses cron jobs. Can you recommend anything specific for me? Kacper
1
vote
1answer
182 views

“Use default value” with category in AvS/FastSimpleImport : how?

I'm trying to import a category array with AvS/FastSimpleImport where: Index 0: the default scope Index 1: values for the it store Index 2: values for the en store The goal is to set Use default ...
1
vote
0answers
177 views

Import product images via csv issue

I made a product script import and I can't add images for products. I used this to import images: $product = Mage::getModel('catalog/product'); try{ ..... ->setMediaGallery (...
1
vote
0answers
26 views

Product Import with Image Links on another website

I have a Product list with over 16,000 items in it. I followed the System>import> and successfully uploaded all 16000 items. For the images however, I have link to my distributors website for example, ...
1
vote
0answers
71 views

Magento customer import not defined issue

I want to import customers to magento via import/export profile my csv look like this: ID,Name,Company,Email,Group,Telephone,ZIP,Country,State/Province,Customer Since,Website,Controle:,Status: 1163,...
1
vote
0answers
1k views

Magento 2 Import Performance

For Magento 1 there is an informative report about the import performance in https://www.integer-net.de/produktimport-mit-magento/ For Magento 2 and a shop project with < 10 k simple products we ...
1
vote
1answer
82 views

Trying to upload images via CSV and getting an error

I'm trying to upload 1800 products using Magento import. I'm not running into any issues aside from the images. When I try to upload them I get an error: Imported resource (image) could not be ...
1
vote
1answer
626 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 ...
1
vote
0answers
303 views

How Can I Bulk Import Image Label By CSV

I need to import image label of my images, how can i do it by csv,
1
vote
0answers
233 views

Magento 2 xml/csv convert

I am trying to figure out how that an automatic feed (csv or xml) works within Magento 2. Does anyone know a page with information on how to do so? I have the xml product feed or the CSV product ...
1
vote
0answers
382 views

Magento 2 custom options title not working while csv import

I am trying to import product through CSV file in magento 2.getting some errors while importing. custom options (custom_title with comma separated not working). example: name=Custom Yoga Option,type=...
1
vote
1answer
551 views

Error while importing csv file in magento 2

When I enter AE-SH in the state/region column of csv file it shows the error "We couldn't import this file because of these errors: Please correct Region/State "SH" in the Row #19."
1
vote
0answers
14 views

During importing a previous export of products Configurable products don't have simple products any more

I exported all products and then cleared all products. When I try to import the same products, I can do this, but configurable products don't have th associated simple products any more. What happens ...
1
vote
0answers
192 views

Magento2: Updating products with CSV duplicates product_id in cataloginventory_stock_item

Any ideas why Magento 2 creates duplicate product_id into cataloginventory_stock_item table for each product that I try to update via import functionality? Thanks.
1
vote
0answers
151 views

New value to dropdown of product attribute is ignored : Magento 2.1

While uploading new product, if attribute value of dropdown is not mathces with existing dropdown values then it is getting ignored, it needs manual effort . What approach should take to achieve it ...
1
vote
0answers
170 views

Issue image mapping with magento1.9 bulk product upload in csv format

I had prepared the magento bulk product upload format in csv file and tested it. It's working fine, no issue in that. But, when i am uploading more than one product in the file 1st product image get ...
1
vote
0answers
53 views

Custom attributes for products Magento 2?

I'm trying to import around 5k products using Magento's native import. Unfortunately, I can't use third-party tools otherwise I would, I imagine this would simplify the process significantly. My ...
1
vote
1answer
266 views

Where to add margin on the original price?

I have the problem that the imported prices are the prices from the wholesale and my buying price. However I'd like to add a margin based on the price ranges and sell it accordingly. The rules are ...
1
vote
1answer
82 views

customer massive import

I am working on magento very custom. Now i have created a script for the import customers. This script does more checks. Now... into the database there are 1400 customers. My script import into ...
1
vote
0answers
559 views

Magento2: Import Export to update multiple product attribute settings?

Can I use Magento2 's Import or Export features under Settings in the Admin to make this change: "Storefront Properties - Allow HTML tags on Storefront, change to Yes" for multiple product ...
1
vote
2answers
724 views

Updating product in the catalog

I've some code to import some products: if the prodocut is new, I've insert it in the catalog, otherwise, I've to update the product if there are some changes. Code is the following: <?php ...
1
vote
0answers
838 views

Programmatically importing products are slow to save when adding images in Magento 2.1

I have a script which imports products from XML data POSTed to it from an external source into Magento 2.1. Everything works and imports fine, however when images are added to a product, the $product-...
1
vote
0answers
64 views

How can i solve bulk image import

I have try to import bulk images through system->import/export->dataflowprofiles. there is nothing changes both front end and backend excel format :

1 2
3
4 5
8