Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [import]

Denotes questions related to imports

343 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
723 views

How to add product reviews progmatically to add data on custom field

$review = Mage::getModel('review/review') ->setEntityPkValue(intval($pressquote->product_id)) //product id ->setStatusId(intval($pressquote->status)) ->setDetail($pressquote->text) -&...
1
vote
0answers
43 views

Unable to find the row no causing an error in product csv

While importing product csv file in magento 1.8.1 I am getting below error SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'attribute_id' cannot be null I want to find out the row ...
1
vote
1answer
552 views

Admin URL adding index.php twice

I am facing some wired issue after importing my database file. After importing when I try to access my admin login page(http://example.com/admin) its redirection to 404 error and url is changing (...
1
vote
1answer
597 views

RapidFlow Import Error: Empty or invalid product type for a new product

I'm trying to do a product import of some downloadables into Magento via RapidFlow. Their documentation is less than stellar, and I can't seem to figure out how to get rid of this error: Empty or ...
1
vote
0answers
107 views

Problem with importing configurable products, associated products not shows up

I have the problem, that the "Associated Products" not shows up under the configurabel product. We are using Magento 1.9.1, I did the import over Import, then choose the file. Here is the file, ...
1
vote
1answer
930 views

Import csv issue (product.php on line 1407)

I just install the magento 1.9.2 and try to import my csv file through System -> Import - > Import. I received the following error message: Notice: Undefined index: _attribute_set in /app/code/core/...
1
vote
2answers
632 views

Update custom attribute when product data updated through import

We import product data using a feed we get from a wholesaler - one full import a week that merges product data and a daily import that only updates price and stock data. I have created a custom ...
1
vote
1answer
86 views

Customer Import - Welcome Email

I have around 1500 customers which I need to import into Magento from another CMS. The passwords in the old CMS are hashed therefore we have no idea of what they are. Does anyone know of a way or an ...
1
vote
1answer
101 views

Storeviews not showing the same product image after import

Hi have a issue with the following issues which are connected to one and other. I cannot delete images programatically from my products. Images do show on 1 view and not on the other (same store/...
1
vote
2answers
27 views

Magento csv import category error

When import gives error Category doesn't exist _category -> category name Error not showing in log file.
0
votes
0answers
17 views

Import custom related products through CSV

I have created a custom tab for Alternative Products and have to import SKU's through CSV like _links_related_sku in CSV. I am unable to import my products in custom alternative products tab in ...
0
votes
0answers
14 views

Magento 1.9 product import xlsx to csv

I am trying to write a module that converts the given Xls file to default Magento CSV format? Is there any better way to do this?
0
votes
1answer
24 views

Magento 2 : Import product with external image URL

I have a CSV file with image field is external image URL, how can I import it, hope anyone help me.
0
votes
1answer
16 views

SQL Error when importing bulk data. Product_id goes out of sync with Entity_id

When importing about 12000 rows of products from a .csv file, it suddenly gives me the following error: General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint ...
0
votes
0answers
16 views

Magento 2 : Change column title when import product csv file via programmatically

I have a product CSV file when I import it in Magento admin, I want to change column title eg : in the original file: NAME, CATEGORY...etc and I want to change to: name, categories...etc, hope anyone ...
0
votes
2answers
48 views

Magento 2: import product with many other data fields

I want to import many products with many custom fields. How can I do that, I hope anyone helps me, Thank in advance. Here is notice when I import product with many custom field
0
votes
1answer
19 views

Magento 2: Problem with Product Links

During an Import to Update Product prices, I made a mistake. I leave the value for the Product Link empty. After the Import all Product URL change and got the value from the Product name. To face this ...
0
votes
0answers
14 views

Getting import errors from csv even though data is valid

When I try to import products via csv, I get import errors on valid fields. For example, I have a color column, and sometimes it'll randomly throw an error for Black or White. Is there a place that I ...
0
votes
0answers
29 views

Bulk Image Import

As the title says, I've ~5k images to import. What's the best approach? I'm not thinking in using CSV file, so what should I do? I'm thinking in coding a module that iterates through all my products ...
0
votes
0answers
24 views

Magento 2.3.2 - Product import duplicates images

Running Magento 2.3.2 on PHP 7.2 CSV being uploaded has one image for base_image, small_image, thumbnail_image, swatch_image, additional_images. When products are imported, product images are ...
0
votes
1answer
10 views

Magento2.1 image importer

I want to import images into magento2.1 with default importer. My problem is that I added image folder into pub like this: pub/media/catelectronicpic/mobile/1.jpg pub/media/catelectronicpic/...
0
votes
0answers
16 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 ...
0
votes
1answer
30 views

URL key for specified store already exists. When importing

M 2.3.1 We are importing via Firebear. When I import I am getting success.. the product imports but I get this error: URL key for the specified store already exists. Whenever I try and SAVE ...
0
votes
0answers
33 views

How to import configurable product in Magento 2 using custom CSV file

I want to import configurable product in Magento 2 using a custom CSV file. My CSV file like this How to import it with this file? Please help me! UPDATE I can import by this CSV but it not show in ...
0
votes
0answers
41 views

Magento 2: Categories import via CSV not updated same name child category as assign in different parent categories

I am importing categories via CSV and it is working. After updating categories data like description, is_active, etc. But same name categories are not updating in different parent. I want to update ...
0
votes
0answers
22 views

Magento stop when will import products

I'm start using magento few days, I have imported product from a csv file and was ok. But now, when I setup to import products from a csv file they stop and not work more. I already reindex and ...
0
votes
0answers
23 views

Line break into Magento CSV import description field

I need some help because I don't know how to fix this problem. On my import CSV, I have a description field but when I go to the front office after the import, the line break is not taken into ...
0
votes
0answers
26 views

Magento 2 programmatically order import is not working with multiple product only one item price display in order details

Magento 2 programmatically order import is not working with multiple product only one item price display in order details and other product price and qty 0
0
votes
0answers
20 views

Cron job image import issue - Magento 2.3

In Magento 2.3, I am importing data from the .xml file. The product name, SKU and product description i can import via cron job but I cannot import the product image. Can you help me? Thanks in ...
0
votes
0answers
10 views

How do stores with large catalog map item image to swatch colors?

So I have thousands of items (all config products) that have a few different colors (simple products) and have about 8 different swatch colors and the only data that have the only relation to color is ...
0
votes
0answers
32 views

Configurable Products Import Issue

I am trying to upload this CSV file for the configurable products. https://docs.google.com/spreadsheets/d/1yJBI_rS7miln6yATN6TYgoh3H4RSyty4WKJI9zNz1aw/edit?usp=sharing Unfortunately, the error I'...
0
votes
0answers
59 views

Magento2.3.0 Getting error, when Import Group product via CSV

I am using magento2.3.0 when I import CSV through group product with associate product getting an error in back end side. If anyone has an idea please share your inputs. {"error": "Invalid file ...
0
votes
0answers
36 views

Can't import cross-sell when cross-sell sku contains space

In "System, Import/Export, Dataflow Advanced Profiles" I have a profile for importing Cross-sell. It works fine; however when the cross-sell SKU contains space it is not imported. The product itself ...
0
votes
1answer
49 views

Undefined index: category_id in Magento 2 Import

I'm trying to import some data into magento for some custom atributes, it seems to get some far through the sheet and then errors with the following message: Notice: Undefined index: category_id in /...
0
votes
0answers
24 views

Special price set with schedule date : M2

In magento2 enterprise edition, we need to set a schedule for the special price for a particular product from the product edit page. I have tried to import special price with schedule date but the ...
0
votes
0answers
26 views

Import customers without e-mail notification?

How can I import all our customers from Magento 1 to Magento 2 without any e-mail notification? Is this possible with the default importer from Magento 2?
0
votes
1answer
117 views

Magento 2 - Import Product .csv via CLI

Actually, the desired requirement is quite simple. I would like to control and execute the import from the backend of the Magento 2 system via the CLI. This question was asked some time ago (2016) ...
0
votes
0answers
29 views

Take by Magmi a Magento attribute value

I would like to add to a price I have in CSV a percentage that I have on an attribute (when I update the product). For example, in my CSV I have: sku price xx 18,08 On Magento I have a ...
0
votes
0answers
79 views

Magento 2.3.1 error when importing stock - Cannot get auto increment value

I have installed fresh magento 2.3.1 and tried to import stock, but every time I got error "Cannot get autoincrement value". The product is added to store, but Quantity is empty, and Salable Quantity ...
0
votes
0answers
37 views

Can't edit custom options via CSV import - Magento 2

I'm trying to update custom option values using the Import/export function. I have exported products as CSV and edited the values in custom_options column. When I try to import the spreadsheet back ...
0
votes
0answers
45 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 ...
0
votes
0answers
11 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 ...
0
votes
1answer
38 views

Import reviews from Amazon

[M1] We are selling some products on Amazon that we are selling on our website. We have plenty of reviews on multiple items, and we'd like to import those reviews on our Magento site. I have ...
0
votes
0answers
26 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/...
0
votes
2answers
49 views

Magento2 : Get Category Ids from product import csv

product import csv containing category data which is given as below Default Category/Diagrams/Business,Default Category/Diagrams/Strategy,Default Category/Diagrams/Planning,Default Category/...
0
votes
0answers
71 views

Update products from CSV using import behavior Update only not add new

Can we update products from CSV but skip new products just update products that already exist. Like I have a CSV which has data with SKUs some already exist some are new but I want to update products ...
0
votes
0answers
161 views

Magento 2.3.1 import images with external link still not working

trying to pull image from external url during import but get: "1. Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s): 2" here is ...
0
votes
1answer
39 views

Magento 2.1.17 product imported but product images not show

I want to import product in Magento 2.1.17 product imported but images show error - Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
0
votes
0answers
26 views

Create custom module to import CSV of custom table M2

I created a custom module to import a CSV of custom table but when importing the CSV I get the loader always and the 500 error that say invalid data or file did not upload. Here is my table structure:...
0
votes
0answers
37 views

What is best way to move database from Magento 2 to Magento 1

I wanna move product category order from Magento 2 to Magento 1. what is the best way for this? I create export from product and import to Magento 1 by default tools on manage but I get some error ...