Questions tagged [import-products]
Denotes question regarding Magento Import Functionality specifically Import products
94
questions
0
votes
1answer
8 views
Decoding Failed: Syntax error
Hi i use csv file to "import" bulk products. Checking Data with no error.
but when i import the csv file, " Decoding failed: Syntax error"come out if anyone know why ?
0
votes
0answers
22 views
Custom import script addImageToMediaGallery error
i have custom import script which i use to import products(from excel sheets), it works just fine, although on some products it gives error regarding image. Script runs as cronjob since manufacturers ...
1
vote
1answer
33 views
Import options for simple products CSV - pros vs cons (Magento 2.2.8)
Currently I'm using magento 2.2.8 and so far I know about 3 main options to import simple products (using csv file).
a) csv import (Magento seems quite slow on this end) and only allows batches of ...
1
vote
0answers
11 views
Magento 1 Import - If “Use Default Value” checked, skip to default view?
I'm starting to learn a bit about Magento import / export tool.
The problem I'm having is that our store consists from 2 stores:
- Default View
- Canada
- USA
The way that we set it up is ...
2
votes
0answers
21 views
Value for '*' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s):
Not sure what is causing this problem.
The previous line which has the same value is valid. But this line is invalid.
1
vote
1answer
22 views
import products using fast_simple_import
Anyone know a stable way to import thousands of products to magento using fast_ simple_import and syncing updates from external POS without relying on SKUs?
Thanks,
Rob
0
votes
0answers
43 views
In Magento 2 Product Update via Import CSV file
Need to update the product data via CSV file through import action.
I am facing an issue to display the bundle product in front-end of the website after updating the product via import action.
...
0
votes
0answers
19 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
1answer
31 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
0answers
20 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 ...
1
vote
0answers
28 views
Magento 2 : Import product error
I have a product csv file and when I import it in admin then is the result https://prnt.sc/pf3rhl Thank in advance.
update:
I did change all ” to " and this is the result:
0
votes
0answers
36 views
Magento 1.9 : Product importing not working
I have tried both Import/Export and the Dataflow method for importing the products in Magento 1.9.
In both cases, it's giving a success message. But the product not importing to the backend.
Can you ...
1
vote
1answer
75 views
Magento 2: Is there a way to import more than 200 products at a time?
My import is only addressing the first 200 parts, is there somewhere to change this setting?
I am using the built in import function
My inventory is 8870 lines but it only is importing the first ...
0
votes
0answers
27 views
Import product from csv error Missing Column: sku
I'm using Magento 2.3.2, I tried to update product stock with my CSV that looks like this:
It's separated by comma, first column is for sku and second column for qty, but when i tried to import it ...
0
votes
0answers
26 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
27 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
84 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
20 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
27 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
106 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 ...
1
vote
0answers
44 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....
0
votes
0answers
55 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
397 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 ...
1
vote
1answer
40 views
On Import, why did Magento delete products?
I did a product import with behaviour REPLACE using the backend.
The original reason to do this is, that we get duplicated images when importing a CSV file with same products again.
If I understand ...
2
votes
1answer
96 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?
1
vote
1answer
160 views
Update Product Attribute through Import Tool using csv - ERROR: keep creating new same sku number - magento 2
I'm try to update a product attribute called "custom_stock_status". I have put together a csv file, with 2 columns like this, and import the file using import behavior "add/update", but it keeps ...
2
votes
1answer
116 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
1answer
494 views
Magento 2 - Import custom product attributes through csv, can I import them using individual columns?
I was able to export the custom filterable product attributes into individual columns in CSV file using BSSCommerce export extension. Now I have a large amount of data need to update.I have searched ...
2
votes
1answer
86 views
Magento2 : Unable to serialize value while importing product description from CSV for configurable products
Hi, I was trying to add description to products using CSV file for configurable products but when I tried to import the CSV i got the error regarding Unable to serialize value but if I tried to import ...
4
votes
2answers
381 views
Exporting / importing products
I'm having difficulties in exporting all products with their categories from Magento v2.1.9 installation for importing them to Magento v2.3.0.
Because I don't need all other tables I don't want to ...
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 ...
0
votes
1answer
219 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 ...
3
votes
0answers
129 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 /...
1
vote
1answer
175 views
How to Import Product Meta Title for Multi Store Website in magento 2
I have multi store website in Magento 2. I want to import different different Meta Title as per store by CSV file.
i am using bellow format but its not working for me.
SkU store_view_code ...
0
votes
0answers
248 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
18 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
67 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
1answer
179 views
Is it necessary to upload product images into the “media/import” folder before importing products from 1.9.1 to 1.9.4?
Magento 1.9.1 to Magento 1.9.4
I am exporting products from Magento 1.9.1 into Magento 1.9.4 and I read the following here:
Before the import put image files in media/import and in the .csv file ...
0
votes
0answers
63 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
143 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?
1
vote
0answers
90 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
78 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 ?
0
votes
1answer
152 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
68 views
Is it possible to import decimal quantity while products imports for some of the products magento 2?
I am thinking to allow decimals quantity to some of the products while products import Magento 2.
If anyone have idea please guide me.
3
votes
1answer
921 views
Magento2.3 and Magmi
I'm working on one module. module does read CSV file from var/import and making a call to Magmi to import.
RunQuickImport.php
namespace Test\Import\Controller\Adminhtml\Customimport;
class ...
0
votes
1answer
303 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.
1
vote
0answers
29 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....
0
votes
1answer
210 views
Attributes error on importing Magento 2 products
Im tryin to import products.csv on my Magento 2.2.6 website, but i receive the below error.
1. Value for 'news_to_date' attribute contains incorrect value in row(s): 1, 2, 3, 8, 18, 19, 20, 21, 22, ...
0
votes
2answers
2k 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 ...
1
vote
0answers
40 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 ...
