Questions tagged [import-products]

Denotes question regarding Magento Import Functionality specifically Import products

51 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
88 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 /...
3
votes
2answers
722 views

Key constraint error while importing simple products

I am getting an error when I am importing simple products in Magento 2.2. The error is : Category " has not been created. URL key for specified store already exists. in row(s): 1 General ...
2
votes
0answers
58 views

Magento2.2 product import using Magmi

Is Magmi import is compatible with Magento2.2? Is it compatible with grouped and simple products import? Where I can find the Latest version of Magmi?
2
votes
1answer
69 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): ...
1
vote
0answers
31 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....
1
vote
0answers
15 views

Connect external product API to Magento

An external API contains 250K products. I am setting up a new online store and would like to import all products, categories, product variables, prices into Magento. How long would a job like this ...
1
vote
0answers
37 views

Magento 2.2 any issue will arise if we truncate import export history?

If I truncate import_history table from database in Magento 2.2 version. But thing is that some of the values in execution_time column it's showing as In Progress which seems to that product import ...
1
vote
0answers
60 views

Update description for product with csv for one store only magento 2

I want to update some fields of product only in one store (magento2), but all stores are updated Any ideas ?
1
vote
0answers
20 views

Facing error when importing virtual product in magento2

I want to import virtual product when i was importing catalog_product.csv it's giving me below error: 1.Data validation failed. Please fix the following errors and upload the file again. 2....
1
vote
0answers
38 views

Add products via REST API to Magento 2 webshop

I want to add products to my webshop via a REST API. I have the following API documentation available. Ofcourse, I also have a API token and Test API token. My question is, how can I import the ...
1
vote
0answers
103 views

How to import product include entity_id?

I want to import products with the existing id. ex: I have products which id start from 200. How can I import those products to magento product table which will start from 200 also?
1
vote
0answers
195 views

Magento 2: FastSimpleImport Integrity constraint violation

I'm trying to import some products with Firegento FastSimpleImport https://github.com/firegento/FireGento_FastSimpleImport2 https://github.com/firegento/FireGento_FastSimpleImport2_Demo When I run ...
1
vote
1answer
104 views

import images are default to exclude on dataflow

I am importing images with dataflow, and all looks fine, however after I import they are all pre-selected as excluded: I am uploading a csv file with sku and image and it should have one more column ...
1
vote
1answer
218 views

Importing products takes too long on a fresh install of Magento 2 v2.2.4

Backstory: Suddenly, my MySQL database for Magento 2 has failed and been corrupted (This is a development installation and used to enter products data) and I don't have backup of the database except ...
1
vote
0answers
167 views

How to skip missing additional images and continue to import products?

I am importing more than 10000 products to my Magento 2 store and got the following error codes: Imported resource (image) could not be downloaded from external resource due to timeout or access ...
1
vote
0answers
388 views

general system exception happened additional data: class name and class type already exists

while importing in magento 2 getting this error general system exception happened additional data: class name and class type already exists. when i check in var/import_history/filename_error.csv ...
1
vote
1answer
1k views

Magento 2: Products images are not showing on category page

I have a huge catalog and imported images for them by csv file. Unfortunately images are not showing on category page but they are showing on view page. I executed all the commands such as: php ...
1
vote
1answer
735 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 ...
1
vote
1answer
258 views

Products import successully with dataflow profiles but won't show on frontend

Magento Version 1.9.3.6 I am able to import products using Dataflow profiles successfully. All Cache is disabled. Tried re-index all after import. but still products don't show up in frontend. If I ...
1
vote
1answer
433 views

Import Module to allow for multiple CSV imports in a batch setting

<?php /** * Copyright © 2013-2017 Magento, Inc. All rights reserved. * See COPYING.txt for license details. */ /** * Import model * * @author Magento Core Team <core@magentocommerce....
1
vote
3answers
1k views

Importing produtcs with images from .csv file error

When I try to import a .csv file with products and images I got this error: Imported resource (image) could not be downloaded from external resource due to timeout or access permissions In the .csv ...
1
vote
0answers
74 views

Unable to reindex product eav indexer

Unable to reindex Product Eav Indexer.. I am getting that error message SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-82-1-7.0000' for key 'PRIMARY', query was: INSERT INTO ...
1
vote
0answers
34 views

How to redirect after successful import via DataFlow import in magento 1.9.2.4

I am using System->Import/Export->Dataflow-Advanced Profiles for importing products to store. I have inherited Mage_Adminhtml_System_Convert_ProfileController class. Using this it allows me to import ...
0
votes
0answers
10 views

Price is different in front than in catalog

I ran an import script. The price was imported successfully, but some products are mispriced in the front. For example: In front: 9489 When I add to the cart: 9490 In catalog: 9490 In DB: 9490 ...
0
votes
0answers
15 views

Magento 2: sellrapido import product using brandsdistribution

When I try to import products from sellrapido to magento 2, it gives me this error on var/log/exeption.log: Next Exception: Report ID: webapi-5d24af47428bd; Message: Property "IsFilterableInGrid" ...
0
votes
0answers
21 views

Mageno 1:Store wise price import not working

I am trying to import price store wise but it did not reflect on the specific store. My CSV row looks like this. sku,_store,price msj006c-Royal Blue-L,base,230 ,website2,240 it always reflects in ...
0
votes
2answers
47 views

Show product after Import

The products after importing does not appear on Magento 2.3 on the front end. But after you click Edit and save without any modification it show,
0
votes
0answers
19 views

Magento 1 : Dataflow product import option issue

I have created one dataflow profile to import some products. I notice that when in import any file and run the profile than one entry added into below two tables: dataflow_batch_import ...
0
votes
0answers
23 views

Define Color&Text Swatches when uploading configurable products via csv?

We are trying to upload our configurable products using CSV since it seems to be the fastest way so far (much faster than using the API). We managed to create the configurable products by hand and ...
0
votes
0answers
56 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
32 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
1answer
81 views

export csv file from magento 1.9 to import product csv in magento 2.3.0

I have a task to import products from m1 to m2. I having the csv file with products(from magento 1 export) at the moment. When i try to "Check Data" on import page - it always loading. How can i ...
0
votes
1answer
131 views

Apply product to parent and child categories on import

I am trying to import products into v2.2.7. Many products have many categories like: Default Category/A1/A2/A3, Default Category/B1/B2/B3 When i check the product configuration, the product only has ...
0
votes
0answers
157 views

Magento 2.3 Importing process is really slow

I am trying to import 20,000 products from CSV in Magento 2.3 it's really slow it took 1 hour to complete it but the same file when I tried to upload in Magento 2.2.3 it just finished in 10 minutes. ...
0
votes
0answers
14 views

Additional data: Asymmetric transaction rollback. magento 2 import

I'm trying to upload csv sheet but I get Additional data: Asymmetric transaction rollback It only can upload 50 products I've ran reindex command and cleared cache and di
0
votes
0answers
53 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
38 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
1answer
79 views

How to import downlodable product on different store using csv in magento2

I want to import downloadable product in different store using csv in magento2 Can anyone help?
0
votes
1answer
131 views

How to import Configurable product from csv with custom attributes using php script

I am trying to import a configurable products in magento 2 with custom attributes using a php script. How far I got the php script to create simple product without custom attributes as a newbie i don'...
0
votes
1answer
203 views

Import product CSV to magento using cronjob

I want to update my products csv to Magento 1.9.0 using cronjob. so someone can please tell me appropriate code script, please. because I want to set it using the cronjob Thanks in advanced.
0
votes
0answers
16 views

Magento2: Create Config Product The URL key for the selected store already exists

When I try import products via cron then impossible. (Live update cron no create new products) I check in system.log return error: [2018-11-06 15:15:41] main.CRITICAL: Create Config Product The URL ...
0
votes
1answer
1k views

Magento 2 Product Import Problem

I got an Error on Magento 2 Product Import - which says: Value for 'visibility' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1 Invalid value in ...
0
votes
1answer
34 views

Products not updating with load product model by id in magento2

When I load product by below code then product name not updating. what problem in my code? foreach ($catval as $p) { $model = $p->MODEL; $NAME = $p->NAME; $product = $objectManager-...
0
votes
1answer
310 views

special price is not working fine while adding product into cart

While uploading products, special price given from Magento admin is working fine in product page. But, in cart page it's taking actual price. I had tried many answers from internet. But, still ...
0
votes
1answer
25 views

Not showing newly added products in magento

I have import products through magmi, products is imported successfully, but the products are not showing in frontend, please help me.
0
votes
1answer
562 views

images not imported through csv in magento 1.9

I tried to import products through import/export, everything gets imported but not image. What I did was: Flushed cache and re-index Media folder provided permissions to 777 Place all images in var/...
0
votes
1answer
327 views

Import default value in import product price

I have multistore in magento 1.9 site. Like au,us and ca I use following csv to import prices. No | store | sku | price au => MYSKU 20 us => MYSKU 30 ca => MYSJU 31 But this will set stores ...
0
votes
1answer
275 views

What's the field name required when save product price data in magento 2?

I have save custom product in magento 2 via my custom code. But when I save product the field qty not be save. please let me know in my data lost an field. $new = array( "product" => Array( ...
0
votes
1answer
292 views

Update Inventory and prices in Magento using a CSV

We would like to update inventory quantities and prices in our Magento store from our ERP system. We can generate CSV file in our ERP to be imported into Magento. We need CSV file format layout. ...
0
votes
1answer
64 views

Grid result not match the export result in magento 2

I created a module for some data logging with widget grid display and csv export function. Inside the collection, I added a new columns with mysql function "IF(DATE_FORMAT(updated_at,'%H:%i') = '16:...