Questions tagged [import]
Denotes questions related to imports
372
questions with no upvoted or accepted answers
7
votes
2
answers
8k
views
Magento 2 Import categories using csv
I have around 500+ categories in my csv.
I'm trying to import only categories using csv.
Can anyone knows how to import only categories in magento 2 using csv?
- 797
6
votes
0
answers
154
views
Magento 1.9x - Include Dataflow Profile Functionality for Import operation into my custom module
I have created custom module for import operation by uploading csv, xls and ods files. It is working good, but now i need to include Dataflow Profile Functionality into my module.
That means I have a ...
- 735
5
votes
0
answers
436
views
Magento2 import stock sources successful but no changes made and not showing in import history
Preconditions (*)
Magento ver. 2.3.4
About 10000 skus, this process has worked many times previously, suddenly stops working.
No new modules or configurations have been done since last time the ...
4
votes
0
answers
45
views
Importing from Custom E-Commerce Platform to Magento 2 (MySQL to M2)
I need to import Products, Customers and Order History from a custom e-commerce platform into a new Magento 2 implementation. Ideally the extension or cloud service would allow us to connect directly ...
- 41
4
votes
0
answers
461
views
Advanced Pricing Import Export issue
I am having an issue with the Advanced Pricing import.
I am importing a new pricing file and I selected Replace as the action, but it is not replacing the file. There are 9,219 line items in the file ...
4
votes
1
answer
4k
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 ...
- 4,707
3
votes
1
answer
97
views
Import CSV for products with new sub categories
I'm importing a CSV file with new subcategories not already created.
Some times products imported correctly and others it gives me:
general system exception
Asymmetric transaction rollback
Anyone ...
- 603
3
votes
0
answers
390
views
Import products not escaping forward slash in category
I'm trying to import products into v2.2.7 but apparently this has been a problem since 2016 and has not been resolved until v2.3.x.
When importing to magento, some categories are like Socks/types a /...
- 261
3
votes
0
answers
244
views
Run native csv import product magento 2, no way to set csv file in custom module
I followed steps in this topic Magento 2 run native product csv import programtically, but it didn't work. When I try to import product through a CSV file in back-office, the check data is correct and ...
- 53
3
votes
1
answer
2k
views
on Magento2.1 how to import product with multiple category
Now i try
Default Category/Main/sub ,
Default Category/Main2/sub2
Default Category/Main/sub is working fine
but in Default Category/Main2/sub2 can't import product
Error Category Default ...
- 51
3
votes
0
answers
414
views
Magento 2.0.7 Product import inserts duplicate entry of stock item
I am using the FireGento_FastSimpleImport2 module to import simple products into my store using the command line. This module passes the array to Magento's core import models. I am facing some issues ...
- 1,576
3
votes
0
answers
41
views
Adding new products to a store with a template, without changing other products in the store
I have recently taken over a store at work that I did not build, nor do I have enough experience with Magento to be truly confident yet.
I have a .csv product template, to add 195 new products to a ...
- 31
3
votes
2
answers
2k
views
Error 500 internal server error validate key magento
I'm new to Magento which makes me a big newbie. I have recently set up a localhost store using XAMPP. Now I want to import 500 products with my CSV file. I've looked up the CSV file structure and I ...
- 31
3
votes
0
answers
414
views
Magento import bulk products
I am trying to import bulk products in magento using System -> Import/Export -> Dataflow – Profiles -> Import All Products and after uploading .csv file and clicking on run profile in popup i get a ...
- 707
3
votes
1
answer
3k
views
Magento tax_class_id not importing
I want to import bulk products using csv template in Magento.
I am unable to import a column tax_class_id.
I have given the value as eg: MA001234.
The datatype used in backend is 'int'.
- 2,639
2
votes
0
answers
121
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
2
votes
0
answers
462
views
Slow async bulk import via RabbitMQ, no multiple threads?
I really hope someone can help me out here. We have setup a RabbitMQ and a Magento 2.3.4. RabbitMQ runs and get about 83k messages via an import by our external product management software. There are ...
2
votes
0
answers
276
views
Magento 2.2.4. Product Import additional_attributes Error Issues
I have a problem with Magento 2.2.4. when I try to Import new products into a website, even when I try to Import the Exported products I already have on the website, I get this kind of error.
Those ...
- 21
2
votes
1
answer
249
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 ...
- 21
2
votes
0
answers
35
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) ...
- 21
2
votes
1
answer
133
views
Magento 2 dimensions attribute code changed
Currently I am trying to import products from Magento 2.1.15 store to Magento 2.3.1.
I have noticed i cannot import my dimensions like height, length, width.
apparently magento changed the ...
- 51
2
votes
0
answers
488
views
Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s)
I'm importing products via csv and get the following error:
Imported resource (image) could not be downloaded from external resource due to timeout or access permissions in row(s)
what I've noticed ...
- 603
2
votes
1
answer
320
views
Error when importing configurable product programmatically
I am programming a custom import system with Magento libraries, but when I import configurable products I get an SQL error.
This is my configurable product function (only a part of my code):
...
2
votes
1
answer
1k
views
Magento 2: Assign existing image to product with position
I'm looking to attach size charts to products in my store using the Magneto data import. I want to use the same image for each of them, and it's already on the server. So I've got a twofold issue.
...
- 31
2
votes
2
answers
146
views
Get product, with 0 quantity, by attribute (sku)
I'm importing products and I want to get product by its sku. This is the code:
$product = $this->productFactory->create();
$record = $product->loadByAttribute('sku', '1234');
It works but ...
- 121
2
votes
0
answers
171
views
php -f bin/magento customer:hash:upgrade not works | Magento 2
I have import customers from magento 1 to magento 2 with admin tool
System > Import
after import i run php -f bin/magento customer:hash:upgrade to upgrade password_hash from md5() to sha256() but ...
- 931
2
votes
1
answer
1k
views
Configurable Product CSV Import - Simples not associating
I've been trying to import some configurable products via the csv importer in magento ce 2.2.3.
After running the import all products appear in the admin, however if I edit the configurable product, ...
- 193
2
votes
0
answers
219
views
Why can't I import attribute values?
I've created a new attribute - GTIN.
All I want to do is import my barcodes into the GTIN field per SKU.
sku,additional_attributes
AM0005930-34,gtin=08033546253915
I've created the above .csv, but ...
- 21
2
votes
0
answers
414
views
Magento 2 Import - Advanced Pricing + 1000s of Products
Coming over from using MAGMI and Magento CE1.9, I suppose I was spoiled, as their import was able to have one product per row, with all the tiered pricing having their own row.. making it very easy ...
- 111
2
votes
0
answers
42
views
Product image import through csv throws required sku error
Ive multiple images for single product and Im trying to import it through csv as shown below.
when I`m importing this csv file it gives me required sku error. So am i missing something here or my ...
2
votes
0
answers
2k
views
Import Prices for different store views in Magento 2
I am importing the prices through CSV for different store views. It does not import the prices properly.
Can you please give me the solution for it?
- 71
2
votes
0
answers
202
views
Magento 2: Missing entity types in CSV import
I have a fresh instance of Magento 2.2. In the Import tab, there are only "Products" entity types. Should I enable anywhere rest? Like e.g "advanced pricing"?
Edit. SOLVED -> Module "...
- 737
2
votes
0
answers
88
views
Magento 2 : Any Script or Extension to Attach Product Images to SKU
I am looking a script or extension to do this:
I upload products via CSV, then run script or extension and attach product images (multiple) to the SKU, easy and fast and don't have to write in csv ...
- 41
2
votes
0
answers
234
views
Magento2 : Add Simple Products to bundle product selection
I have a bundle product created from Admin Section. Now I am updating inventory of simple products i.e adding products to Magento Catalog Programmatically via CSV file.
I want to add those simple ...
- 41
2
votes
1
answer
580
views
magento 2 import logs
i'm having a problem importing additional_attributes for products. i have them formatted the way the export file looks, but when i import them, it shows import completed fine but does not update any ...
- 31
2
votes
0
answers
193
views
Add video url in Import magento2
Is there any way to add video url in magento2 bulk import.
if that is not possible how can i add product video programmatically in magento2
- 579
2
votes
0
answers
1k
views
Magento 1.9.3 Deadlock found when trying to get lock in pdo.php
I have created a script to import inventory from CSV file. The script is ran with a cronjob that runs every 3 hours. It worked fine until I have a csv file that contains 11000 lines, and I got the ...
- 2,074
2
votes
0
answers
799
views
Custom csv import using data flow profile not working in magento-1.9.3.1
I want to custom import csv in a model using data flow profile. For that i have followed below steps :
1) Created a customimport.csv under var/import
2) Under admin > system >Import/Export >...
- 8,833
2
votes
0
answers
39
views
Import programatically images in Magento issue
I have created a custom script to import products from csv.
I succesfully imported image, thumbnaill, and small image like this:
# media gallery initialization
->setMediaGallery (array('images'=&...
- 2,672
2
votes
0
answers
535
views
Magento import hangs
I am having some problems with base import on a Magento website. Problem is that the import hangs and remains stuck on the Please wait message.
I checked, the var/importexport has all the necessary ...
- 169
2
votes
0
answers
385
views
Magento 2 Modify data on Product Import
I'm looking for ability to check all data before validation on products import in Magento 2.
I found class Magento\ImportExport\Controller\Adminhtml\Import\Validate but I can't find entry point to ...
- 922
2
votes
0
answers
36
views
How to re-create rewrites in Magento 2?
How can I remove all the url rewrites in Magento 2 and then re-create them? Can I empty the table and then re-import the product url's via default product import? Is that safe?
- 1,613
2
votes
0
answers
727
views
Magento 2.1.2 "Invalid option value" when importing configurable products
I'm trying to import configurable products into Magento 2.1.2. I have already imported the simple products.
When trying to import the configurable products, it seems to happen randomly. In total I ...
2
votes
0
answers
1k
views
Magento 2 import customer script
Does anyone have a script for importing custom customer list form a csv or xml ?
i found the next script for magento 1: https://gist.github.com/peterjaap/5955852, but for magento 2 i can't find ...
- 45
2
votes
2
answers
2k
views
Imported image roles are lost on update in Magento 2
I use an import script to create products with associated images that are assigned to roles thumbnail and small image.
It works well, products and images are imported and they display as thumbnail ...
- 387
2
votes
0
answers
55
views
Media image cron upload is failing to upload any images to my simple products
Front image should only load for configs and this works fine. Simples should load front and back and all other angles. It looks for F (front) and B (back), sets those to 1 or 2, everything else is ...
- 40
2
votes
0
answers
184
views
Magento2 How to setup cronjob to automatically start magento2 import?
There should be a possibility to setup a cron, which does the system -> import. I want to automatically start an import which I normally start from the magento2 admin GUI. The import is getting it's ...
2
votes
0
answers
96
views
The problem with importing Product Sheet in the category, the title that has a comma
When importing faced such problem. If the path search has regular commas after each comma creates a new category.
Example:
Default Category/Event,Music and Image/
need to create a single category("...
- 21
2
votes
1
answer
127
views
Product Import - Websites
Having a few issues with Product import
I have 3 websites each with 1 store eg:
UK: Store: Admin, Website: Base
DE: Store: de, Website: de
IT: Store: it, Website: it
I do my initial import:
...
2
votes
0
answers
2k
views
Magento2 - Product import extremely slow
I created a product (catalog) import module for magento2. I know there is a import module out of the box in magento2 but this does not serve my needs. All my data is stored in sepperate csv files (...