Questions tagged [importexport]

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

0
votes
1answer
21 views

Invalid value for Attribute Set column (set does not exists?) in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,

I have a products exported file from Magento 1.14 EE and I want it to import in magento 1.9 CE. When I am trying to upload that I'm getting following error: Invalid value for Attribute Set column ...
0
votes
0answers
49 views

Magento 2: How to import export Categories in csv via backend using Entity Type catalog_category

I have to need import export categories in csv same as product, in Magento 2 provided same thing for product. I have tried below code but facing issue in Model file path Vendor/CategoryImportExport/...
1
vote
0answers
25 views

Updating Magento 2 product attribute, Import Add/Update feature always create a duplicate new item, instead of updating

i'm trying to update a custom product attribute called is_eol, but when i use the system->data transfer->import -> import behavior (add/update), it always created a duplicate item with same sku number....
0
votes
0answers
27 views

No valid data sent magento product export

Trying to export products from Magento using system import-export function and getting the error no valid data sent Initially, I was trying to export a few thousand products I then tried to export ...
0
votes
0answers
14 views

Magento 2 configurable product import issue

I have uploaded configurable products using csv and it works fine when all the simple products have the same price. However when the simple products are each having a different price within 1 ...
2
votes
0answers
17 views

Magento 2.3 - Products URL key regenerate on import functionality

I update the products with no url_key header present (only sku,description) using the import functionality The import should only update the fields which are mentioned in the CSV file. The import ...
0
votes
0answers
10 views

How to import dimensions? M2.1.5 -> M2.3.1

Hi I am currently doing a fresh install of magento 2.3.1 as our last dev really fucked up the 2.1.5 environment. I'm working on importing products at the moment but can't for the life of me seem to ...
1
vote
1answer
16 views

How to collect admin phrases?

I am using i18n:collect-phrases command but seems that it collects only frontend phrases. I need to collect only admin panel phrases! For example, I have downloaded some language pack, but it does ...
0
votes
0answers
15 views

“General system exception happened” Error when doing the import process

I have had problems when importing, I get that error, I attach the file I used at the time of import Does anyone know how to solve the problem? My version of magento is 2.1.6 https://drive.google.com/...
1
vote
0answers
46 views

Tier Pricing import/export

Very new to Magento and need some guidance. We are running a promotion and need to remove tiered pricing however we want to re activate it after the promotion. Is there a way I can export all ...
0
votes
0answers
22 views

Magento 2 after exporting products csv products id does not match back end product ids

After exporting products in csv file products ids does not match magento 2 backend ids please help this matter. Any help would be appreciated. Thanks in advance..!
2
votes
0answers
135 views

Magento2 - fastest way to save product after several calls to addImageToMediaGallery() method

We had several issues when trying to build a catalog for a customer using native Import/Export functionality. Unfortunately it seems Magento2 has some difficult to download & process cloudfront....
2
votes
0answers
22 views

Create import entity for attributes

I'm trying to implement a new import entity to be made available through the ImportExport module (which is actually extended by Firegento_FastSimpleImport2, but that's not relevant for this question) ...
1
vote
1answer
24 views

Improved import export extension magento 2

I want to try this extension https://firebearstudio.com/blog/improved-import-export-2-0.html so i found this link on github : https://github.com/firebearstudio/importexportfree but when i installed it ...
1
vote
1answer
29 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
28 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
75 views

Value for 'msrp_display_actual_price_type' attribute contains incorrect value

When i try to import my early exported export i get a error regarding msrp_display_actual_price_type but the DB tells me the input must be 4. "1. Value for msrp_display_actual_price_type attribute ...
0
votes
2answers
14 views

Magento 2 Customer import fails

I had exported customer from local machine and i am importing on server. When i tried to import on server it gives me an error saying "Sorry, but the data is invalid or the file is not uploaded." I ...
1
vote
0answers
32 views

Import only the customer from magento 1.9 to Magento 2.2

I am creating a new site with Magento 2.2 I need to import only the customer from an old site that is running on Magento 1.9. Any option can be import customer details using .csv file.Please help.
1
vote
1answer
80 views

Can't Export Customers Error Please correct the data sent value

Magento 2.2.7 Trying to export customers and get the error, Please correct the data sent value. Exception log says, main.CRITICAL: Notice: Undefined offset: 14 in /home/public_html/vendor/...
1
vote
0answers
66 views

Product CSV file not exporting from admin in Magento 2

When we export Procuct Csv from admin side. Then csv not export. We get error There is no data for the export. Any one help me to solve this issue.
0
votes
2answers
36 views

Exporting a Backup of All Orders

We are currently making a major overhaul to an old website of ours, and it is still using Magento Version 1.4.1.1. I know it is very outdated. We have a lot of orders here that we want to make a ...
2
votes
1answer
39 views

How to pass data from UI Form to PHP Class

I have created a form using UI component, This form has a select dropdown which displays option related to current entity id if form is in edit mode and all options if a new entity is being added by ...
2
votes
1answer
125 views

Magento 2 - Import custom product attributes through csv, can I import them using individual columns?

I was able to export the custom filterable product attributes into individual columns in CSV file using BSSCommerce export extension. Now I have a large amount of data need to update.I have searched ...
1
vote
1answer
25 views

Magento1 to Magento2 import only catalog configuration and its associated product query

I have 2 website first is magento1 and second is magento2. so i have import only configurable(with associated product) product from magento1 to magento2 . so what table to be taken magento1 and ...
0
votes
1answer
40 views

Magento 2: URL key for specified store already exists

I have got the issue when import the category for specific SKU. General system exception happened Additional data: URL key for specified store already exists.
2
votes
0answers
19 views

Emergency - our site down for 2 days. Ready to deploy on a new server but missing custom options; any way to put same custom options on all products?

Magento 1.9.4 Our old Magento store (1.9.1) hosted at Hostforweb just stopped working (long story - first it was extremely slow = unusable; then the hosting company says they can move it to another ...
2
votes
0answers
18 views

regular Export on Magento 1.9.1 exporting custom options 12 times

Magento 1.9.1 We are exporting products from Magento 1.9.1 and importing them into Magento 1.9.4 When this regular export/import was done - I noticed that custom options showed up 12 times. I ...
1
vote
0answers
9 views

1st did Dataflow import which does not do custom options; Did a regular import after that few times - now have duplicate custom options

Magento 1.9.1 --) Magento 1.9.4 It's 2019 so you would think migrating All products from Magento 1.9.1 to Magento 1.9.4 would be smooth sailing right? I would expect to click Export on one system, ...
0
votes
1answer
443 views

Programmatically Update products attribute by sku for all store view

I am using below code to update product by sku but that is updating price for english store only , i will price of product to get updated in all store view . getObjectManager(); $state = $...
0
votes
0answers
26 views

Did a Dataflow - Profiles export/import. All is fine except NO custom options transferred. Is it possible to use regular import for custom options?

Magento 1.9.1 --) 1.9.4 I am setting up a new store on a new server Magento 1.9.4. I did the Dataflow - Profiles export/import and all is fine except we just noticed (when we were going to go live ...
0
votes
0answers
7 views

If I did a Product export/import via Dataflow - Profiles; can I now import customers via normal import?

Magento 1.9.1 --) Magento 1.9.4 So I ran the All Products export out of Magento 1.9.1 and imported them into Magento 1.9.4 and it seemed to work fine. Now I need to import All Customers and I was ...
0
votes
0answers
16 views

Problem with categories when exporting/importing products from Magento 1.9.1 to Magento 1.9.4

product migration (Dataflow - Profiles import) Magento 1.9.1 --) 1.9.4 I am having a huge problem with categories. When I tried to do the import at first - it gave me Errors saying the categories do ...
0
votes
0answers
44 views

How to import categories/work with category ID's when doing a Dataflow - Profiles import from 1.9.1 to 1.9.4

Magento 1.9.1 to 1.9.4 We setup a bit newer version of Magento on a new server. The old install still currently running is Magento 1.9.1. I am getting ready to do a Dataflow - Profiles export/import ...
1
vote
2answers
142 views

“Image does not exist” Error when doing a Dataflow - Profiles import

Magento 1.9.1. --) Magento 1.9.4 I am setting up a newer version of our store on a different hosting account. I need to export PRODUCTS. I have tried to do a regular EXPORT and IMPORT but that just ...
0
votes
0answers
46 views

“Category does not exists in rows” Error when doing a Product import from 1.9.1 to 1.9.4

Magento 1.9.1 --) Magento 1.9.4 I did a Product Export on Magento 1.9.1 and tried to import it into Magento 1.9.4. It first gave me this Error: Column names: "cube_category_Bestsellers" are ...
0
votes
0answers
32 views

Exporting Products from 1.9.1 and IMPORTING into 1.9.4 gives “Column names: ”cube_category_Bestsellers“ are invalid” Error

Magento 1.9.1 --) Magento 1.9.4 I setup a new shop under Magento 1.9.4 and we are EXPORTING Products from the old Magento 1.9.1 into the new 1.9.4 and after clicking on Check data - it gives this ...
0
votes
0answers
13 views

Export gallery image paths in the correct order from Magento 2

I tried to export the images paths from the admin panel [system]->[export], i can see all the images in [base_images] column and [additional_images] column. however, the paths in [additional_images] ...
0
votes
0answers
75 views

How to migrate categories from Magento 1.9.1 to 1.9.4? Also - Will EXPORT of products and customers work?

Magento 1.9.1 to Magento 1.9.4 We are setting up again and I can't figure out how to migrate categories from our old (live) Magento 1.9.1 site to the new 1.9.4? Is there a way to do that? I will ...
0
votes
0answers
12 views

Best way to setup an existing 1.9.1 on a new server from scratch but copy customers and products over?

Magento 1.9.1 Porto theme So many things happened to our existing Magento 1.9.1 and the existing hosting company is really bad that we decided to setup again on a new server. Initially, we were ...
1
vote
0answers
47 views

Magento 1 - How to exclude column data from export csv file?

I want to exclude Email and Billing Telephone columns data from orders export csv file for specific user. I am using Rave Infosys Order Import / Export extension. These columns data should be empty ...
0
votes
2answers
519 views

How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?

What is the best way to manually move the orders and customers to Magento 2.2.6 from Magento 1.8.1 without any third part extensions? there are around 100 records only. I was able to migrated all ...
0
votes
0answers
35 views

magento 2 product export missing columns

I did an export after migrating products from PrestaShop to Magento 2 and not all the columns are exporting. Only the last 9 columns are being exported starting from "bundle_price_type". Not really ...
0
votes
0answers
48 views

How to remigrate products and customer from M1=>M2

I have remigrated data with delta migration from magento1 to magento2 for order, customer changes in profile and reviews. But I am unable to remigrate new products, new categories and new customer ...
0
votes
1answer
117 views

bulk product images uploading fails

I am trying to bulk upload images for products I am getting the following error: imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
0
votes
0answers
45 views

Unable to export categories

I am having trouble exporting categories into a csv file when I go to system>import/export>dataflow-profile>entity type. The only options I get is products and customers. Is there a way to enable the ...
1
vote
1answer
308 views

Magento2 - issue when importing bundle products

This is a Magento 2.2.2 project... last season (it was 2.1.* then) we achieved to import this catalog using native import/export module (after several hours playing with .csv files) But this season, ...
0
votes
0answers
128 views

Magento2: How to Import and export CSV file from admin panel?

How to import and export custom CSV file from admin panel demo? I want to add the custom shipping price state and zip code wise in the database from the admin panel. Then I will apply extra the ...
1
vote
1answer
202 views

CSV Validation In magento 2

I am working on Magento 2.2.5, need to validate CSV file for import. How to skip row? like I don't want to save any data of row 2, then how to skip that row. I am using only one attribute set, so I ...
0
votes
0answers
47 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.