Questions tagged [import]
Denotes questions related to imports
371
questions with no upvoted or accepted answers
1
vote
1
answer
764
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
0
answers
19
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
0
answers
218
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
0
answers
156
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
0
answers
172
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
0
answers
63
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
1
answer
358
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
1
answer
86
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
0
answers
565
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
2
answers
787
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
0
answers
1k
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
0
answers
65
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
vote
0
answers
427
views
import shows success but products are not getting added
I am trying to import list of products. While importing I am getting success message as below
Import successfully done.
But When I check catalog->Products products are not actually imported.
...
1
vote
0
answers
479
views
How can I create and update static blocks via a module install script?
I have a number of static blocks and pages I need to create in a few shops and without doing it manually I copied the install script for the sample data for Magento2 to use a .csv to install these ...
1
vote
0
answers
283
views
update qty per store view with csv file
actually in our website we have a cron function scheduled (every morning) to update the qty of all products of our catalog and works good.
Following the code we are using now:
<?php
define('...
1
vote
1
answer
256
views
Import image from external url
I want to import a image to product.
I have:
$url = 'www.example.com/imagen01.jpg';
$product->addImageToMediaGallery($url, array('image','thumbnail','small'),false,false);
But it doesn't work. ...
1
vote
0
answers
4k
views
CSV import: Problem with comma as multiple value separator (Magento 2)
I have to import products with CSV Products Import (System->Import) in Magento 2.
But I have problems with the Multiple value separator. If I choose the standard separator comma, it doesn't import ...
1
vote
0
answers
206
views
Imported images not assigned to image, base_image and thumbnail
I am working on importing products through the dataflow profiles, as the newer import is not working for unknown reasons.
I read this article which recommended to import products and their images ...
1
vote
1
answer
602
views
Upload csv file with products. not working
i have a job of making a new shop for a client. He has an existing shop in another platform - Dandomain
The client has over 1000 products, so clearly i want to make an product import.
Dandomain have ...
1
vote
1
answer
889
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
0
answers
48
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
1
answer
862
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
1
answer
852
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
0
answers
110
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
1
answer
1k
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/...
1
vote
2
answers
760
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
1
answer
144
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
1
answer
128
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
1
answer
480
views
Magento 2 product import website id not updating
I'm importing products using csv. Using default method of magento. My csv file is below.
sku,store_view_code,attribute_set_code,product_type,categories,name,description,short_description,weight,...
1
vote
2
answers
84
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
1
answer
42
views
Magento2: Product import is not working (Static attribute)
I'm trying to update some products using the import file. I Realized that one attribute is not updating. I noticed this attributes is backend_type = static. This is related to the problem or can be ...
0
votes
0
answers
86
views
Import not working in magento 2.4.6 and category product disappeared
When i am importing a csv file in magento 2.4.6. It is giving me this error again and again
Additional data: <div class="messages"><div class="message message-error error"&...
0
votes
0
answers
40
views
General system exception happened Additional data
Getting This Error while importing the products
General system exception happened
Additional data: Error in data structure: entity values are mixed
Screenshot: https://pasteboard.co/k5dv5AQBJMCN.png
...
0
votes
0
answers
25
views
Importing Customer List fails to show
I controlled to efficaciously add the patron list within the Magento 2 backend the use of Data Transfer-Import. However, after the system reindexed, the list did not appear in the customers phase.
The ...
0
votes
0
answers
38
views
How to fix products when this comes up: Something went wrong with processing the default view and we have restored the filter to its original state
Magento 2.4.5-p1
I have exported and imported products from Magento 1 into my Magento 2. Now, when I go to:
Catalog - Products
and surf the products for example in the following way:
10 per page
...
0
votes
0
answers
13
views
Importing New List of customers via csv from orders
Need a means of adjusting large list of names on excel sheet for import on magento 2 while adjusted into customer database template without needing to adjust manually.
0
votes
1
answer
219
views
Import products 2.4.6-p1 error SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key
We did an upgrade from version 2.4.3 to the version 2.4.6-p1 and we started to have a problem on cloud environments (production and staging, but mostly on production) but not locally.
So, the steps to ...
0
votes
2
answers
53
views
Update SKU using entity ID in import
I am trying to update sku using entity id and it's working but issue is when i try to order that product from the front-end it shows "There are no source items with the in stock status".
...
0
votes
0
answers
45
views
SQL Error when importing stock csv
Since we have updated to magento 2.4.6 when we want to import stock via csv we now receive an error.
systemException
Additional data: SQLSTATE[42000]: Syntax error or access violation: 1064 You have ...
0
votes
0
answers
57
views
Deploy a magento2 existing project in a virtual machine with ubuntu to be able to run in localhost
I have an existing Magento2 project hosted on a server, and now I want to import it to my virtual machine. Here are the steps I have taken so far:
1-Created a virtual machine and installed Apache, ...
0
votes
0
answers
15
views
How to use differnt config location while running app:config:import command?
I would like to import Magento configurations other than app/etc/ path while running app:config:import.
for e.g my configs are located at var/config/{config,env}.php.
0
votes
0
answers
148
views
How can I create redirects from old URL keys to new ones using a CSV import in Magento 2.3.5-p1?
I have updated the 'url_key' column in my Magento CSV file and imported it successfully. However, the old URLs are still returning a 404 error, even though the new URL keys have been updated correctly....
0
votes
0
answers
64
views
Load external image urls
I would like to know if it's possible to import image as links when adding products to catalogs. I currently have an API setup that takes the individual images links them to the products and then ...
0
votes
0
answers
903
views
indexing not updating cataloginventory_stock_status
After upgrading to 2.4.4 or after doing a second store on same installation (dont know), the field cataloginventory_stock_status.stock_status is not updating from 0 to 1 when I import new products/...
0
votes
1
answer
11
views
modify input allow_error_count in magento import
I'm new to magento development and I find myself able to modify the allow_error_count input by backend when making an import. Some clue?
0
votes
1
answer
338
views
Can I update order statuses via CSV?
Is it possible to update order status using CSV? If so, what would be the obligatory data and columns?
0
votes
1
answer
65
views
No Import/Export Section under System->Data Transfer
In the Admin-Panel there should a "Import/Export" option under System->Data Transfer. This option is missing for me.
I have already checked Admin-Resources and the admin-user has access ...
0
votes
1
answer
28
views
Magento 2: Import will not import more than 1 product at a time
Magento 2 version 2.2.6 will not import more than 1 product at a time.
The import will not create, update, or delete.
I've checked the import history, but there are no errors. I've validated the ...
0
votes
1
answer
169
views
Is it possible to use (system -> Data transfer -> import) products csv programmatically
I want to create a cron module (in Magento) to download some CSV to the import folder, and then use the (system -> Data transfer -> import) feature to add/replace products programmatically, but ...
0
votes
0
answers
146
views
SQL error on Database Import, while setting up staging site
I have been trying to import a database to clone a production site that is working and I am receiving this error when trying to import the database.
Error
Static analysis:
2 errors were found during ...