Questions tagged [import]
Denotes questions related to imports
1,085
questions
0
votes
0
answers
13
views
Importing Customer List fails to show
Was able to successfully import customer list in magento 2 backend via Data Transfer-Import, however the list didn't show up in customers section when the system reindexed.
header for the list ...
- 7
-1
votes
0
answers
19
views
Imported Customer Accounts fail to show up
Imported customer accounts the other day, with the notifications mentioning it was successful but so far, no new accounts have shown in the all customers section.
Need to know what I missed
For the ...
- 7
0
votes
0
answers
8
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
...
- 128
-1
votes
0
answers
17
views
Importing Customer list errors
Was importing a file when these errors were identified, not sure what they mean exactly
Duplicates found in column names: array ( 0 => '', 1 => 'mail,_w', 2 => 'bsit', 3 => ',_stor', 4 =&...
- 7
0
votes
0
answers
12
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.
- 7
0
votes
1
answer
32
views
How to delete all records in the importexport_importdata table?
Magento 2.4.5-p1
I am doing a product's export from Magento 2.4.2-p1 and importing this into Magento 2.4.5-p1 but I get the following Error:
General system exception happened
Additional data: Error ...
- 128
0
votes
2
answers
44
views
Magento 2.4.6 - Import mutiselect attribute options from CSV
UPDATE
I've used the Firebear ImportExport Extension for now. That works without any problem. Its pricey but worth the money if magento cant get something "simple" like this working.
Good ...
- 107
0
votes
1
answer
77
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
31
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
27
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 ...
- 303
0
votes
0
answers
19
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, ...
- 1
0
votes
0
answers
13
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.
- 601
0
votes
0
answers
66
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
28
views
Default attribute values for products imported via API
When importing products, sometimes some attributes are not set, or have no value (for example, weight sometimes is not sent through the API).
Especially weight sometimes gives us issues, since it's ...
1
vote
1
answer
2k
views
import product data programmatically using csv
I am new in magento 2
I am trying to import product data programmatically using csv file.
The Error is shown below
My Folder and code structure are following.
This is My registration file.
Vendor/...
- 77
1
vote
0
answers
17
views
Upload of csv to add related products to a parent product scrambles order of skus in related_skus column
I use products that have related products (so they pull them automatically when the parent product is selected) - i need them as separate items for accounting/inventory purposes, but i sell them in ...
1
vote
1
answer
367
views
Magento2 How To Add Delete confirmation Popup on Magento default Import functionality for delete behaviour
I have Added one custom entity in default Magento import. On delete behaviour action, need to display the delete confirmation popup with message (it will delete all record) on import button click. Can ...
- 166
1
vote
3
answers
280
views
How to transfer products from Magento 2.4.2-p1 to Magento 2.4.4 which give Errors during export and then import?
We have a live production Magento ver. 2.4.2-p1 with 2224 products but have a lot of problems which stem from me using the official Magento Migration Tool to migrate from Magento 1.x.
Because of this, ...
- 128
0
votes
0
answers
58
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 ...
- 1
0
votes
0
answers
659
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/...
- 125
0
votes
1
answer
42
views
Can't import/update product, keep getting this "product_type" error
I have some issues with importing new product and updating.
2
votes
0
answers
68
views
How to import Fixed product taxes in bulk?
I tried to import FPT for all my products with an additional column to my CSV import :
wee_tax_variations
and lines like :
name=ecotax,country=FR,state=0,value=1.45,website_id=0
(My attribute name for ...
- 31
0
votes
1
answer
9
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?
1
vote
2
answers
296
views
Maagento 2 : getting error when Import database
I have run this command:-
mysql -u magento -p database < database_file.sql
I have got the error:-
ERROR 1062 (23000) at line 5447: Duplicate entry '7-41-0' for key 'catalog_category_entity_int....
- 11
0
votes
1
answer
301
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?
- 1
0
votes
5
answers
2k
views
How to export Page Builder pages or templates?
I need to export pages or templates made with Magento's Page Builder and import them to another site. Is there some way of achieving this?
- 1,581
1
vote
0
answers
93
views
Magento 1.9 / OpenMage 1.9 - Import Specific Store (or Website) Data Using Dataflow - Bug? Updating All Fields
A client has moved from Magento CE 1.9 to OpenMage LTS.
They used to operate a single store website on their .co.uk domain name. They have started to operate a multi-store website .ie and .eu version ...
- 151
0
votes
2
answers
231
views
How to migrate data from Magento 1.9.4 to Magento 2.4.3-p1 without using the Migration tool?
We had 3 stores in Magento 1.9.4. I migrated 2 of them to Magento 2.4.2-p1 using the Magento Migration tool, installed the Smartwave Porto theme and the Amasty extensions and now we have many many ...
- 128
0
votes
1
answer
56
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 ...
- 49
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 ...
- 1
0
votes
1
answer
146
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 ...
- 2,201
0
votes
2
answers
22
views
Migration from Magento 1 to Magento 2. Import tool question
Importing orders in 2 steps. Step 1 is all orders prior to migration. Step 2 is puting server in maintenance mode and importing delta orders. Will Magento import tool also update statuses of step 1 ...
- 81
0
votes
0
answers
118
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 ...
- 103
1
vote
2
answers
419
views
error on import "The source file moving process failed" magento 2
I am getting the error "The source file moving process failed." when trying to perform any type of import. I have tried catalog re-index, tried changing the file, been searching but cant ...
- 11
0
votes
1
answer
114
views
Import brand products with csv
I am using venus theme brands extension for brands management. Now I want to import the products using brands. There is an option for importing brands using the CSV but I am not able to find any demo ...
- 1
0
votes
1
answer
261
views
Multiple special prices for a single product
I've been asked about having the possibility to have multiple date ranges in the advanced pricing section at once so that my client can bulk update all the products with all of their promo periods ...
- 115
0
votes
0
answers
183
views
Magento 2: How to validate duplicate data on customer CSV import
I would like to validate duplicate data for one attribute for customer import file.
I am trying to check it in Magento\CustomerImportExport\Model\Import\Customer class with validateRow function but in ...
0
votes
1
answer
135
views
Why my CSV import worked but didn't apply the changes?
I imported a CSV file with 5 products, the CSV is successfully validated and imported, however, when I went into one of the products that I imported, the update didn't have an effect. After one hour I ...
- 12.9k
0
votes
0
answers
27
views
Magento 2 | Update products based on attribtue value
I got about 90k products from a supplier with a attribute partnumber assigned to it. I want to update our attribute delivery_time based on the partnumber attribute.
Example:
I got arround 50 products ...
- 107
1
vote
0
answers
195
views
Problem with importing products in magento 2.4.1
Value for 'size' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9
0
votes
2
answers
191
views
Magento2: Importing additional images programatically - PHP error
I am trying to set up a script to import additional images for products programatically, from the var/import/images folder. I am running it on the command line, via PuTTY. The following code works and ...
1
vote
1
answer
279
views
Import product and images when they already exist in pub/media
I'm downgrading my Magento from 2.4 to 2.3.5 because of Elasticsearch (not really relevant why). But to do so I thought it would be easier to just do a fresh install of Magento 2.3.5 database and all.
...
- 11
0
votes
1
answer
269
views
How can I set custom value in "created_in" when customer data import in Magento 2?
I need to set custom value in this field "created_in" when customer data import using admin side how can I set the custom value in that .
I need to set custom value in that can any one ...
- 501
0
votes
1
answer
805
views
How to validation CSV import in magento 2
I have Create custom CSV import functionally. But How to check which row data is blank and i want to show error like :- Required field is empty in row(s). So Please help me how to check which row is ...
- 3,671
0
votes
1
answer
28
views
Can I pass a file into a function?
I have a function from a 3rd party plugin that uploads data using a CSV. The beginning of the function in the resource model that does the work looks like this
public function uploadAndImport(\Magento\...
- 313
0
votes
1
answer
702
views
Importing existing products: Integrity constraint violation: 1062 Duplicate Entry
I have been importing existing products to a local environment through the admin dashboard. I realized that many of the products I imported didn't include their attributes, so I went back to make sure ...
0
votes
1
answer
527
views
Image not imported from CSV in Magento 2.4
I want to import some product with images with CSV so i have add my image in
var/www/html/mag/var/import/images
folder with lamptest.jpg name and added filename with
base_image , small_image , ...
- 626
0
votes
1
answer
136
views
Product import problem. Cannot be used with directory
I have a problem with import product. When i try import using this option, also import not working when i use "Advanced Pricing" but when i try use for example "Customer Addresses" ...
- 25
0
votes
1
answer
71
views
Please enter a valid region error for regions with special characters
I'm trying to import customer addresses. If the region has a name with accents, Magento v2.3.6 won't recognize it.
Example:
Country code 'RO', region 'Timiș' - doesn't work
Country code 'RO', region '...
- 51
0
votes
1
answer
178
views
How to import 3 tables dump into database using script?
I want to include 3 tables SQL dump into that database, how to add it by using a custom module or script or any best practice.
- 145