Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
1
vote
1answer
263 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 ...
0
votes
2answers
2k views

Skip import row, is not valid value “” for field “type”

I know there are a few issues with this already, but I have tried some of the solutions.But they dont seem to work. Is there a default set of fields that the CSV must have. I have checked my CSV and ...
2
votes
1answer
116 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 ...
2
votes
3answers
662 views

after configurable product being imported, on editing it shows attributes to make configurable(like you are creating first time)

I have successfully imported a configurable product with all it's simple products. But on editing the configurable product from backend, it shows global attributes to make configurable product like ...
3
votes
2answers
799 views

How to display errors for product imports

When I import product using the Import functionality in Magento (2.2.1), I sometimes get an error saying "Maximum error count has been reached or system error is occurred!". According to the Magento ...
0
votes
1answer
375 views

Magento 2: CSV Importing issue ,import successfully and did't show any products

While importing product CSV Magento didn’t give any error and import successfully. but didn’t show any products on customer view. If products already added it didn’t update the product content. I ...
1
vote
0answers
32 views

Imported products and categories system urls return 404

We are setting up import of products and categories from suppliers XMLs. The idea is to have it automatic and we have successfully imported products and automatically generated categories using this ...
1
vote
0answers
201 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 ...
3
votes
5answers
2k views

Bulk product import error SKU not defined

I have a product sheet with some 200 odd products. When I am trying to import these product I get an error saying "Skipping import row, required field SKU not defined", even though all the SKUs are ...
2
votes
1answer
151 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): ...
0
votes
1answer
132 views

Importing product images in specific sequence / order

I import images into Magento as described here https://docs.magento.com/m2/ee/user_guide/system/data-import-product-images.html and here Product import csv images not getting imported : I upload the ...
2
votes
1answer
1k 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 ...
1
vote
0answers
559 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
1answer
179 views

Magento 2 Import/Export Options Missing

I've installed Magento 2 and under System -> Data Transfer there are no options. Do I have to enable them somehow?
0
votes
3answers
156 views

Set programmatically added attributes to product

I'm writing cron module to import products (Magento 2). In this module I'm adding attribute, attribute value and assign this new attribute value to product. It sounds easy but new added attributes and ...
1
vote
1answer
179 views

Magento 1.9: Massive set customer confirmation attribute

I imported over 3000 customers in magento, I need to set them all as confirmed. How can I do?
2
votes
1answer
159 views

General System Exception Magento 2 UTF-8 BOM

I have been uploading products to Magento 2 for some time using import via CSV. The first chunk worked fine and the second is throwing a general system error. UTF-8 BOM is being used... very ...
2
votes
1answer
586 views

Insert product id into custom table while importing products in Magento from csv

I have created a custom admin module using module creator with entity type "Flat" and it created 2 table in my database. Now I need to insert product id in one of table when importing products from ...
2
votes
1answer
693 views

Import Product Dimensions (Length, Width, Height) in Magento 2

I am trying to import dimension data to a Magento 2.2.6 store. The Magento attributes are present on the product, but I cannot figure out how to import to these fields. I have tried length and ...
2
votes
0answers
195 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 ...
5
votes
1answer
3k views

Magento 2 replace product images via CSV import

I'm following this tutorial http://docs.magento.com/m2/ce/user_guide/system/data-import-product-images.html to upload and assign images to product. I have successfully completed this process but i ...
19
votes
12answers
13k views

What is the most common process for importing the products?

What is the most common process for importing products? Does everyone use the product import/export tool? The CSV file format is not something that the client is likely to fill in and if they try it ...
3
votes
0answers
29 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 ...
1
vote
0answers
22 views

How can I import products from external programs CSV every day?

I have external "offline" program that runs database of products. I would like to create a script or something to automaticaly update product inventary. Another problem is that headers don't mach, so ...
1
vote
1answer
195 views

Make tier_price behave/replace normal price Magento 1.7

I'm looking for a way to display my Tier_pricing as a normal price. Because I use SOAP to import prices for different groups. I've managed to let magento show the tier_prices on list page; <?php ...
0
votes
0answers
234 views

Getting Errors after MySQL database import

I took a MySQL dump of my live website and imported the data to a fresh database for my development site. However, only the homepage is working, other links bring an error There has been an error ...
0
votes
1answer
304 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
1answer
1k views

Number of columns does not correspond to the number of rows in the header in row(s) Magento 2

I am trying to upload products in Magento 2.2.6 from default import using CSV. I am getting this error while checking data on CSV. I have double check my CSV file has accurate columns and values in ...
4
votes
0answers
42 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 ...
3
votes
0answers
169 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
2answers
43 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
2answers
897 views

Import Product Information from MSSQL to MySQL (or Magento)

I have Products Information stored in MSSQL database and i want this Product Information into Magento or MySQL database.
0
votes
1answer
33 views

Problems Importing Product CSV file

I have a big issue with reading my csv file. When I do an export and open it in Google doc or Excel the price and qty not show correct. Magento 2.2.6 https://docs.google.com/spreadsheets/d/...
1
vote
1answer
54 views

While import product custom options throws error in magento 2

While trying to import custom options for product throws the below error. Please provide me a solution SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4953' for key '...
0
votes
1answer
204 views

bulk product images uploading fails

I am trying to bulk upload images for products I am getting the following error: imported resource (image) could not be downloaded from external resource due to timeout or access permissions in ...
0
votes
1answer
320 views

Mass Import problem for images [closed]

I'm using magmi to import more than 30.000 products with images. The problem is with images that they are imported but all of them are excluded. Is there any sql query that I can use and get all ...
1
vote
1answer
39 views

Image not optimizing for product page

I import products from CSV file. I added base_image, small_image, thumnail_image, swatch_image and additional_image column. In backend it had been updated. But in front-end shows default magento icon. ...
1
vote
2answers
1k views

Can't import into Magento 2.1

I've got two test products to import. One is exported from Magento and can be imported without issues. The other one appears to be almost identical but has been manually created. I can't figure out ...
2
votes
1answer
159 views

Product Page 404 - product re-save needed

After updating some products by importing csv file, there are some of them that display 404 error in frontend product view page. Saving these products manually solves the issue. Saving these ...
0
votes
0answers
73 views

Magento 1.7. - Update status attribute via Dataflow Profile

We are trying to UPDATE the status attribute via Dataflow Profiles and CSV file. The CSV is processed correctly (no error messages in the popup showing the process), so the settings in the Dataflow ...
1
vote
0answers
55 views

Php script for import configurable products from csv

I need to import a lot of products. So i want to use a script. So if you have any script to do that can you share the whole php file?
0
votes
1answer
51 views

Mass Activating Magento Categories

Thanks guys for the help in getting the cat ids in magento. Found this script to mass enable categories based on IDs <?php setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID); $file = fopen(...
1
vote
1answer
902 views

How do I import ONIX XML into Magento?

I need to get ONIX data to my Magento ebook store. I could convert it into a format that Magento understands (i.e. CSV) and then use the default import. But at times the a single feed can have a few ...
1
vote
0answers
21 views

Data Collection and Preparation: 15,000+ products for Magento 2

We're at the early stages of a reasonably large Magento project that will have a catalog of over 15,000 products. The big problem is that the customer doesn't have any information on the products ...
1
vote
0answers
63 views

Magento 2: Importing Customer information shows validation error 1. Please enter a password with a valid length. in row(s)1

I am importing customer information in magento 2 with password 4 characters, I have also changed the password length to 4 in Stores->Configuration->Customer Configuration. But still shows the same ...
0
votes
0answers
115 views

How to migrate categories from Magento 1.9.1 to 1.9.4? Also - Will EXPORT of products and customers work?

Magento 1.9.1 to Magento 1.9.4 We are setting up again and I can't figure out how to migrate categories from our old (live) Magento 1.9.1 site to the new 1.9.4? Is there a way to do that? I will ...
1
vote
2answers
358 views

“Image does not exist” Error when doing a Dataflow - Profiles import

Magento 1.9.1. --) Magento 1.9.4 I am setting up a newer version of our store on a different hosting account. I need to export PRODUCTS. I have tried to do a regular EXPORT and IMPORT but that just ...
0
votes
1answer
35 views

import categories from magento 1 to 2

I need to import categories on magento 2 that I exported from magento 1, Is it without issue, I mean is it risky for magento 2 store. Help me please if you have any proposition?
0
votes
1answer
662 views

Magento 2 Customer Grid index is locked by another reindex process. Skipping

I am importing Customer Main file details, I imported 30,000 records and about to reindexing ended up with reindexing issue. On the first reindexing I got the following error: PHP Fatal error: ...
2
votes
2answers
2k views

Magento 2 csv product import : How to escape commas in category name

I would like to import a product csv into Magento 2 through the standard admin UI. The category name contains commas Default Category/Grocery/Snacks/Fruit, Nuts, Seeds. The (abbreviated) csv looks ...

1
3 4
5
6 7
21