Questions tagged [importexport]

Questions about the Import/Export core feature of Magento (`Mage_ImportExport`)

Filter by
Sorted by
Tagged with
0
votes
1answer
79 views

Bulk Import Error

I have tried to csv import just 40 products. But there was an error like keep buffering like the image. Then I have uploaded the same content with 10 products per csv file and it was successfully ...
0
votes
2answers
876 views

Product SKU requirements. What characters are restricted from a product SKU and can there be spaces in the middle of the SKU?

For product SKU's can there be spaces in the middle of the SKU? Are there any character restrictions that can not be used for a SKU ?
1
vote
0answers
81 views

How to skip some column to write csv data

I would like to skip some column to write data in CSV when it generate. Here is my code to generate CSV in magento. it would be start writing from column no 20 for first row only then continue with ...
3
votes
1answer
3k views

How to get order shipping address data

I'm trying to collect shipping address from order $order = Mage::getModel('sales/order')->load($order_id, 'increment_id'); ....... $order_Address= $order->getShippingAddress()->...
0
votes
1answer
440 views

Magento 1.9: Product Export all categories in single line

Single product has multiple categories. Within CSV Export file only one category is listed. Does anyone know why only one category is exported? I need an export that has all categories listed by ...
0
votes
2answers
388 views

Magento 2: Exclude category from magento product export not working?

I and trying to export the product from specific categoty. I am using following method to filter category id. I have included all categories except 9. So i am expecting export result includes ...
3
votes
0answers
177 views

Magento 2 : Email on customer Import

I have to import customers from Magento import customer feature and at the time of import there should be the email sent to customer and template should be registered_no_password so customer can set ...
1
vote
0answers
26 views

Shipment section in admin pannel is not shown

In admin panel under sales > order while trying to create shipment , no tabs under the Items to Ship is shown. After enabling and disabling every module one by one i found that one of custom module ...
1
vote
1answer
189 views

Import, Cannot get autoincrement value

I've been running a csv import into magento and getting the error Cannot get autoincrement value Currently I've done the following to try and resolve the problem: Gone into the database and make sure ...
1
vote
1answer
80 views

products gallery not export in magento 1.9.1.0

I have exported all products from Import/Export >> Dataflow profiles. but products gallery images are not exported in csv file. Is there any setting in magento?
1
vote
0answers
39 views

Simple products detached from configurabe products after import

I imported a simple spreadsheet into Magento 2.1.3 with stock updates and image updates. However, what this export seems to have also done is detach the simple products from the master configurable ...
1
vote
2answers
423 views

Why are there duplicate products exported with a different store view?

Why are duplicate product entries are exported from a magento 2 install that's data was migrated from magento 1? The duplicate entries of products don't have names and some other attributes but they ...
0
votes
1answer
397 views

Issues after Export & Import

I perform Export Products from one Magento 2 Store and Import that CSV file in another Magento 2 Store. I am facing some issues like below. Category list is displaying below Product image is not ...
0
votes
2answers
416 views

Magento2 import csv file get error interity constraint

Im upload bulk products successfully afterthat im delete all products use this command in my catlog DELETE FROM catalog_product_entity; afterthat im try to re upload products im getting an ...
3
votes
3answers
2k views

Magento 2: import large CSV file was not successful

Magento2 large CSV file was not successfully imported. I am trying to import 20 Mb products CSV file but was not imported successfully. Still it says "please wait" only. I have also changed ...
0
votes
1answer
67 views

Import Product from other stores

I have 2 different websites A and B. Now I want to show some product from B to A. Which means, some Product in A website will be the same as in B website. Now I want to import these products from B ...
1
vote
0answers
317 views

Magento 2 product import by PHP (Configurable,Categories)

In Magento 1 I use http://avstudnitz.github.io/AvS_FastSimpleImport/ for product/category tree import.For Magento 2 I found https://github.com/firegento/FireGento_FastSimpleImport2 but seems like it ...
0
votes
1answer
111 views

How to change the product image position using CSV?

I'm trying to update Product's image position using CSV file. I've already uploaded images in Products. So how to change already inserted product image position using CSV file?
0
votes
1answer
56 views

Magento2 - Multistore/domain export one website import in fresh install

I was wondering if it is possible to export a whole website (Including blocks, widgets, products, etc. which are enabled for that specific website) Lets say you have a multistore/domain setup which ...
0
votes
1answer
222 views

MAGMI_RUN unable to find .CSV file

MAGMI has been successfully set up on my Magento environment (and Magento was set up via MS's web platform installer and is kicked off via MS's Webmatrix), and I can use it quite happily to import ...
2
votes
3answers
961 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 ...
0
votes
1answer
137 views

How to change the CSV column position

Due to some reason client asked me to change the position of csv columns. They need necessary fields at starting of csv and blank fields(mostly) at end of csv so that they can easily fill the csv ...
0
votes
1answer
930 views

export all product fields with custom options

I need to import products in Magento 1.9 through .csv Simple products which I need to import all have custom options. Can you tell me where should I find the structure of the csv with the correct ...
0
votes
1answer
50 views

Product Import > URLs missing “.htm” extension even after re-indexing.

I am uploading a large number products. The upload runs perfectly but Magento is not adding the file extension to the url_key. So none of the products uploaded have the “.htm” file extension. Even ...
3
votes
1answer
376 views

Magento : Product Import to 1.9.3

We have magento website which is in version2. We are developing a website which is in version to 1.9.3. Can we export product data from admin panel of magento 2 and directly export to 1.9.3 site?
0
votes
1answer
2k views

programatically import csv - magento 2

I have a bpmn tool, it will generate CSV, that CSV contains single product. I need to import that csv file programatically. Already magento admin have that feature. please can anyone point key code ...
1
vote
0answers
114 views

Magento 1.9.2.4 not exporting simple products

I've run into a weird issue where my Magento site (1.9.2.4) isn't exporting all my products. It successfully exports all my configurables, but that's it - none of the simple products contained within/...
1
vote
0answers
257 views

How to create import button in system configuration and save import CSV data in magento2?

I need like Table Rates Shipping Import / Export CSV. I have used this reference:: $_FILES in Magento2 ECG : system configuration. but it's not working for me. Anyone have idea about it?
0
votes
1answer
500 views

Solved: Mass uncheck the “exclude” option by images

We have imported a lot of products with Magmi in Magento 1 and accidentally checked all the "exlcude" options for our images, so the main image is not shown on the product page. Is there an easy way ...
0
votes
3answers
3k views

Magento2 import products attribute and attribute sets

I'm using Magento 2.1.3. Is it possible to import product attributes and attribute sets or do I have to create them manually before importing products with specific attributes?
1
vote
2answers
1k views

Magento 2.1.3 - Import products. Issue with categories

When I'm trying import eg 2 products: I have no error with Check Data but on import: Category "MAN/zakiet/zakiet" has not been created. URL key for specified store already exists. in row(s): 2 ...
0
votes
1answer
185 views

importing bulk images in Magento 1.9.3.1

I am trying to import images against my previously uploaded products but it is not going through. I read many articles and blogs on this topic but every one is suggesting to keep images in media/...
1
vote
1answer
1k views

How To add import button in custom grid?

I have to use this link for add import button in custom grid. How to add Upload Button for importing a csv file in the Custom Admin Grid Container? but I don't know how to add its action? it is my ...
0
votes
1answer
596 views

Migrate customer and order data from M2 to M1

We are migrating a Magento2 site to Magento1 What would be the best way to get customer and order data over from Magento2 to Magento1? Should we build an API bridge or are the database tables similar ...
1
vote
1answer
153 views

How to use ImportExport Import Model in Magento 2.x [closed]

I want to use ImportExport Import Model. I want to convert the code below to Magento 2. In Magento 1, it uses: Mage_ImportExport_Model_Import::getDataSourceModel()->getIterator()->rewind();
2
votes
2answers
3k views

Magento 2 - What are the native required attributes to customer and products?

When we export the sample of the basic CSV (Customers and Products) at the admin panel on Magento 2 all attributes are exported, whose are the basic attributes to put?
0
votes
1answer
431 views

Quotes inside product description

My product data has quotes (as in "This is the best album yet!") in the product description field. This data is not current smart quotes. Does this have to be converted to smart quotes in order not ...
1
vote
1answer
271 views

magento2 bin/magento indexer:reindex this command delete the data from catalog_product_index_price

I am uploading products via xls and this is working fine.I am uploading bundle/simple products After that when all process complete. then I run bin/magento indexer:reindex by script for reindexing. ...
1
vote
0answers
177 views

export and import of products problems in magento 2

I exported products from Magento 2.0.5 and want to import to Magento 2.1.1 I got the following error: Data validation failed. Please fix the following errors and upload the file again. Following ...
3
votes
1answer
1k views

Magento 2 Exported file format Doesn't work for “configurable_variations” field when import [duplicate]

I have installed Magento 2.1.3 with sample data, and export one configurable product with attribute size and color. Next, I change necessary fields and import this file but product imported with the ...
0
votes
0answers
2k views

Best way to export and import products

I am using Magento 1.9.2.4 and want to know what is the best way to export and import products from one Magento installation to another. I read a lot of things but none of them worked for me. My ...
0
votes
1answer
44 views

Import issues mystery characters

I used magestore store manager to consolidate several magento installations into a unified multi store when i did the product exports and imports toconsolidate it all i now hiow a cpl issues ...
0
votes
1answer
2k views

Magento2 - Import Product with Images Using Absolute Path

As the product images are well organized in shared folders on the server, I prefer having the absolute image path in the CSV file directly. For example this allows for simple one click (almost) ...
2
votes
1answer
142 views

password_hash convert into simple md5 format

How to export all customers in simple username , email, and simple md5 format csv.
0
votes
2answers
527 views

Unable to export product CSV “No valid data sent”

I am trying to export products using System -> Import/Export -> Export After selecting Export Settings and click on Continue, I am getting No valid data sent. Looking in the system.log It is showing: ...
1
vote
0answers
87 views

Write to CSV file in chunks at a time

I am trying to write product data to a CSV file in order to export to a third party. I need to break the operation down into chunks in order to prevent timeouts when writing large amounts of data. ...
4
votes
1answer
2k views

Importing Configurable products With color and size

Importing Configurable product with color and size but only size are visible on site. What i followed here: I exported all sample data of site. Copy one configurable product with its associated ...
2
votes
3answers
381 views

Magento2 export and import configurations instead of uploading the DB

Is it possible to move settings like product, customers and categories attributes, store settings and others that doesn't include data product, customers, orders, categories, etc ... Instead of ...
1
vote
0answers
335 views

Magento community 2.1.2 schedule product csv upload from ftp

I want to import product csv file automatically from ftp. I am using magento community 2.1.2 edition. There is no schedule import/export option available in this edition. Please suggest me a good ...
2
votes
1answer
1k views

Importing customers from Magento 1.9.1.0 to 1.9.2.3

I have a production instance of Magento which is running on version 1.9.1.0, and I have another instance of Magento which is running on version 1.9.2.3. I am trying to export customers from the ...