Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
31
votes
8answers
20k views

Is Magento the right platform for 1M products?

I need to see how Magento will perform with 1M SKUs; but I'm struggling to find a large data set of sample data to download - or find a feasible method of generating the feed for import (and the ...
19
votes
12answers
13k views

What is the most common process for importing the products?

What is the most common process for importing products? Does everyone use the product import/export tool? The CSV file format is not something that the client is likely to fill in and if they try it ...
17
votes
3answers
16k views

Importing orders from a CSV into Magento programmatically

We're switching from an old, outdated point-of-sale system to using Magento 1.7 as our POS exclusively. Not unexpectedly, one of the challenges we're facing is how to get almost 20 years of records ...
15
votes
7answers
4k views

Fatal Error in Admin Pages

I have magento 1.7 installed and it worked fine till now. I import products on daily basis. If there is any new manufacturer, I add it in drop down based Manufacturer attribute. Today, I have added ...
12
votes
2answers
12k views

Import/Export CMS Pages / CMS Blocks

Does anyone know any modules that can be used to import/export cms pages (and blocks) in CE? The scenario I am looking at now is: users (content editors) create pages/blocks with content on a ...
12
votes
7answers
24k views

how to import gallery images with csv

Importing gallery images seems like such a fundamental function, but I cannot find any column in my csv exported file where I would do this. I created a single product with gallery images through ...
10
votes
4answers
35k views

Adding images with CSV import

I have been running into problem after problem with the CSV export/import functions. My currently problem is that I cannot seem to assign 'image', 'small_image', and 'thumbnail' attributes to any ...
9
votes
4answers
14k views

Import: Column names have duplicates

Import shows error message "Column names have duplicates" but I don't have any duplicates. Who can I fix this? "_type","sku","has_options","name","image","small_image","thumbnail","url_key","...
9
votes
1answer
7k views

How to import related products in normal import process?

How to import related products in normal import process? How can I achieve this? Is there any method available for import related products?
8
votes
8answers
11k views

Magento 2 product import won't import images

I am importing products using the built in CSV import (System - import - products) All my data is imported fine, but I get an error "Imported resource (image) could not be downloaded from external ...
8
votes
4answers
386 views

State of the Art in Magento 2 Product Imports

Now that Magento 2's been out for a year plus -- what's "state of the art" in getting product information into the system? i.e. Are people still writing one-off import scripts? Is the native import/...
8
votes
5answers
9k views

Magento 2 Import Error

Upon importing our product database I encounter the following error when pressing "Check Data" General system exception happened My image file directory is point to: pub/media/import/images Has ...
8
votes
2answers
5k views

Can i use dataflow import to update products

I am really sorry for asking this. I feel like this is a stupid question, but honestly I have googled until the term googling has lost all meaning. I just want to do a bulk update of product ...
8
votes
3answers
20k views

Skipping import row, required field “sku” is not defined

During article import of a custom import profile (Dataflow - Profiles) I get this error for all rows: Skipping import row, required field "sku" is not defined. I have mapped "sku" => "artnr" (Field ...
8
votes
1answer
2k views

CSV Import: How can I import related products in Magento 2?

How can I import related products via csv in Magento 2? In my csv file I have a row with attribute related_skus with example data "11-111,22-222" for a product. But in admin Products->Catalog in this ...
8
votes
1answer
2k views

How to change programmatically product stock status when product sku doesn't appears in provider data feed?

I'm using Magento CE 1.9.1 I made an import script to import products from a provider xml feed. This feed is update everyday at 3 a.m . My profider send me in his xml only products where are in stock ...
7
votes
1answer
10k views

What is the difference between Import/Export vs Dataflow

So, I'm using Magento 1.6.2.0 on a project and I'm seeing I have options for import, export, and dataflow profiles. In previous versions I've used the interface has been like the dataflow profiles. ...
7
votes
3answers
19k views

MySQL error while importing database

I want to upgrade Magento. Therefor I first want to transfer the live production system to a development workspace. I am trying to import the production database into a clean database. But I can't get ...
7
votes
3answers
2k views

How to import product name with ™ and ® symbol?

I have products where it is important to have symbols like ™ and ®, as these are necessary to be with product name. When I tried to import such products, it says "General system exception happened" on ...
7
votes
4answers
26k views

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

I am migrating a custom e-commerce site over to Magento. We have well over a hundred thousand products. Many are drop shipped from a number of suppliers. Several suppliers can provide the same ...
7
votes
1answer
536 views

How to import not confirmed customers via CSV import?

I'm trying to import customers via CSV Import: System > Import/Export > Import > Customers > Append Complex Data I'd like to import customers which are "not confirmed" after import. ...
7
votes
1answer
2k views

Run Import Product from CLI

it's possibile to run the Magento standard Import from CLI? I have to import product every night with that standard format.
7
votes
2answers
1k views

How to Delete attribute VALUES?

Importing blank columns using "Replace" action does not result in deletion of attribute values. Magento 1.5, 1.7 E.g. a csv containing a list of skus whose sale end date has passed to try to delete ...
6
votes
3answers
122 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 ...
6
votes
2answers
4k views

Delete unused attribute values

I am using the fastsimpleimport module to create my custom import. This has a setDropdownAttributes() function to automatically create needed attribute values but it does not remove unused values. ...
6
votes
2answers
3k views

Set dropdown value using text value

I have a small import script that will import product to Magento 1. It works well but there is something not work.If a product attribute happen to be a select type attribute the value will not save. ...
6
votes
1answer
6k views

How to import product content different for each store view (translations/multilingual)?

In Magento 1.x you could import different content for each store view by having each store data in new line and empty sku field. Unfortunately this seems not to work in Magento 2 and I could not find ...
6
votes
3answers
7k 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> &...
6
votes
5answers
7k views

How to improve product inventory daily updates from CSV file?

I'm working on a 10000 products Magento store. I scheduled a cronjob to run everyday at 7am to read a CSV file and update each product inventory and set it out of stock if new QTY is less than 1. ...
6
votes
2answers
3k views

Fail to import product with product images at Magento 2

I've placed a image file in the folder "pub/media/import" for product image, and run the below script, but I got an error message. $fullImagePath = "pub/media/import/icn_status.png"; echo $...
6
votes
1answer
7k views

Magento 2 : How to Import Additional Attributes and Images

I am trying to import csv in Magento 2. There are no errors given by Magento while importing, but column additional_attributes is totally ignored and additional_images is ignored if it contains ...
6
votes
1answer
4k views

Magento 2 - How can I import / export categories from M2 to M2?

I'd like to import and export using two Magento 2, among two environments. I know that I can't do it natively, so how can I do using MySQL or some free tool?
5
votes
2answers
24k views

Import products with multiple categories

Hi I am importing products in my 1.7.0.2 new setup, I already added the categories. when i import the csv product file, all go well. But the problem is the product is added to only subcategory, it is ...
5
votes
1answer
1k views

Magento 2 CSV Import: Not possible to import disabled products?

In the Magento 2 import/export, the "status" column is missing. How can I import products with status "disabled"? Adding the columns manually in a CSV for import, does not help, it's ignored.
5
votes
2answers
2k views

'X-Frame-Options' headers with conflicting values when tried to import products

I have a problem when I tried to import products with a CSV. The loading gif stay spinning and nothing happens. The page don´t show any error. I first thought that could be permissions problem, but I ...
5
votes
2answers
2k views

Magento 2 : Illegal characters on import

I'm try to import my customers from magento1 to magento2 but got a few errors on import validation. The import is aimed at a german shop so special chars like "ä, ö, ü" are pretty common, especially ...
5
votes
1answer
2k views

Error in using composer to install a module in Magento 2.0

I have used Composer for installing other modules specially from github and they worked fine. However I have problem installing the following module to Magento 2.0 . The module I want to install is ...
5
votes
3answers
1k views

Magento 2 import products with images

I'm trying to import a CSV file with new products that contain local images but I am receiving the following error: Imported resource (image) could not be downloaded from external resource due to ...
5
votes
1answer
967 views

Magento dataflow import (stop indexing on the fly)

There are, basically, two ways when importing product via csv file in Magento. a) import b) dataflow import a) option, works faster, I assume that is because this option want index all the data on ...
5
votes
1answer
629 views

Magento 2 Terminal Progress bar while uploading csv file from terminal

I want to develop progress bar in a terminal because when I import CSV file its started to import but user has no idea how many records have been imported indicator will be like when we hit php bin/...
5
votes
1answer
672 views

Magento 2: Is there a way to lock indexer programmatically?

When I run my custom import script, and during it's execution starts reindex, it causes the error : SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try ...
5
votes
3answers
669 views

Bulk import Product Tags to multiple products

I've got a list of several configurable products that need product tags added. There are about 15-20 tags per product and close to 50 separate products. Is there a way to import the tags or run a SQL ...
5
votes
3answers
761 views

Error While importing products

I am new to magento I am working on product import i have migrated my site from one domain to another but after that while importing product in my site i am getting error SQLSTATE[23000]: ...
5
votes
3answers
8k views

I'm Looking for a sample CSV product file to import into test store

I have my first Magento test site running and I'm looking for a sample CSV product file to import for testing. Does anybody know where I can download one? Ideally I'd like the file to contain lots of ...
5
votes
3answers
6k views

How to convert String password to hash

I am trying to import customers using .csv file. I did it using data flow profiles in magento. I have list of customers and passwords but I have passwords in string format. How to convert string ...
5
votes
1answer
2k views

Magento 2 replace product images via CSV import

I'm following this tutorial http://docs.magento.com/m2/ce/user_guide/system/data-import-product-images.html to upload and assign images to product. I have successfully completed this process but i ...
5
votes
0answers
127 views

Magento 1.9x - Include Dataflow Profile Functionality for Import operation into my custom module

I have created custom module for import operation by uploading csv, xls and ods files. It is working good, but now i need to include Dataflow Profile Functionality into my module. That means I have ...
4
votes
1answer
7k views

How to programatically create tax rates

I want to create a feature in an upgrade script that creates 2 new tax rates in Magento. I looked at the importPost controller in adminhtml tax rates controller, but there is a lot of work in there. ...
4
votes
6answers
13k views

Bulk Import Category With Heirachy

I'm still a Beginner in Magento and I was given a task to upload/create 600 Categories and have a hierarchy up to 4th subcategory. I've been searching for a while now, and most return paid extensions. ...
4
votes
2answers
2k views

How would you import 22.000 products to Magento?

I'm working on a Magento store and I'm looking to import 22.000 products with a single solution. I've written a Ruby wrapper for the REST API, it takes around 7 seconds to create a single product (...