Questions tagged [import]

Denotes questions related to imports

Filter by
Sorted by
Tagged with
0
votes
0answers
24 views

Database import Error in Migration Magento 1.9 Store

I am migrating a Magento 1.9 store to another hosting. While I am importing previous database to new phpmyadmin I am getting below error.
1
vote
0answers
28 views

import date format correct in magento 2

i'm tring to import a date field correct into the special_from_date and special_to_date field of products however for some reason the result is not correct. I have this -<Item> <sku>...
3
votes
3answers
7k views

Magento 2 Update Prices with CSV

I want to update just the prices of all products in my Magento 2 store and to do this quickly and easily i have a CSV with sku and price and was hoping price could be updated using sku as an ...
4
votes
4answers
8k views

Magento 2 product import error

I get: General system exception happened Additional data: URL key for specified store already exists. error when trying to import products with csv. my csv file is passing check data process ...
1
vote
0answers
170 views

Import products via command line using Magento\ImportExport\Model\ImportFactory in Magento 2.3

I want to import products from .csv file using command line. Referring to this link: https://www.thirdandgrove.com/insights/importing-products-magento2-part2/ everything is working fine, except ...
0
votes
1answer
610 views

Import a csv file in Bo magento 2

We have prepared a script that convert the csv of product that belong to our customer then we converted to the format that magento accepted (mapping of attributs with some condition on attributs to ...
2
votes
1answer
42 views

How do you update/change a product's store/website via Magento's CSV importer?

Using Magento 1.9.2. I'd like to be able to re-assign products between stores by uploading a CSV containing product SKUs and store names or IDs. How can this be done?
1
vote
1answer
36 views

Magento2: Category URL rewrite issue

I am trying to import product from magento but when I try import I will get below errors. I have flushed all category then update the new category. Got the error message below: General system ...
0
votes
0answers
237 views

Magento 2 Error: Base table or view not found: 1146 Table 'dbname.table_name' doesn't exist, while database import

I have a fresh setup of Magento ce 2.3.2, while importing the database with sample data in fresh database and I faced this error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not ...
1
vote
0answers
14 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 ...
1
vote
0answers
40 views

Magento 2 I am trying to upload CSV file for the configurable products. getting error like attribute code does not exists

I am trying to upload this CSV file for the configurable products. Unfortunately, the error I'm facing is Column configurable_variations: Attribute with code "rom" does not exist or is missing ...
2
votes
4answers
635 views

2.3 to 2.3.1 Upgrade showing sales_order_grid already exists

So far the upgrade went pretty smooth but now I have a few outdated modules and it's asking me to run the setup:upgrade on CLI but I keep getting an SQLSTATE general error: 1813 Tablespace for table '...
1
vote
1answer
626 views

How to update data if product sku already available in magento using custom script for product import?

I have created custom import script for simple product csv import in magento. It is working fine for the newly products. But I want to update the products if sku already exists. How can I achieve ...
4
votes
1answer
534 views

504 gateway timeout while import customer address CSV In Magento2

http://website.com/admin/admin/import/validate/key/40cc16dabfa0d1fb09a6cb9e62433b9880e4f3f0e024eb1c517d832fa47c225d/?form_key=s235x0mqERyjXLqX 504 (Gateway Timeout) `validation.js:185 while ...
2
votes
4answers
570 views

Can't import database Magento 2.3.3

I have created a backup database by command line: php bin/magento setup:backup --db Then I import it to my new PHPMyAdmin, But it shows a bug: Static analysis: 4 errors were found during ...
0
votes
1answer
18 views

M2 - How to fix wrong customer import

I have a live webshop and imported user from the old webshop. The amount of accounts is around 6500. The was something wrong with the import so everyone has a wrong address in their account. So I made ...
0
votes
0answers
24 views

Magento 2 - Keep csv data description spaces while creating programatically

I am trying to create a new product using CSV custom script for which I refer Programmatically create a simple product in magento 2 Which is creating a product but it removes all spaces when we set an ...
0
votes
0answers
63 views

Magento 2 Custom Import Not updating the exists data

In Magento 2.3, I am using this link to import the custom csv data. Adding, deleting, replacing are working fine. But the data is not updating with existing data. Anyonce came across this issue, ...
0
votes
1answer
35 views

Export Magento 2 Orders

How can I export Magento 2 orders and then import them on a new system? The new system has the same products in front-end and as far as customers are concerned. However, the way it works in the back ...
0
votes
0answers
26 views

Image import errors (csv)

I'm trying to import 500 images (at a time, 13000 total) using a csv. I keep getting the following error: Imported resource (image) could not be downloaded from external resource due to timeout ...
0
votes
1answer
283 views

Magento 2.3.3 - Import Newsletter subscribers along with email, Name, Type, Website, Store, Store view from CSV

I run a multi website and store setup, on PHP 7.1 I'm trying to import newsletter subscribers from a CSV as follows, which is in a CSV file called subscribers-import.csv in the root dir. I'm using ...
0
votes
1answer
180 views

Magento 2.3.3 - import newsletter subscribers from CSV

Running a multi website and store setup. Example Website - Japan Store - JP Store View - JP I'm trying to import newsletter subscribers from a CSV. I'm using the following code in a file called ...
6
votes
2answers
9k views

How to import product content different for each store view (translations/multilingual)?

In Magento 1.x you could import different content for each store view by having each store data in new line and empty sku field. Unfortunately this seems not to work in Magento 2 and I could not find ...
0
votes
2answers
727 views

Importing from CSV to salesrule_coupon. Notice: Undefined index: sku

I've added on System > Data Transfer > Import another option in order to populate the table salesrule_coupon and i got on my csv the following: rule_id,code,usage_limit,usage_per_customer,times_used,...
0
votes
1answer
1k views

Magento 2.2.1 Product Import Not Updating Assigned Categories

When updating my products via the add/update import process, the assigned product categories are not being updated. If I update by selecting "replace", it works. Example Product-A currently has the ...
0
votes
0answers
16 views

Magmi image processor import issue

I am using Magmi to import my date, have remote image addresses. The problem is when I import them, all images are same! I am Using version magento 2.1
0
votes
0answers
25 views

products csv import categories not updated in magento2

I'm importing product sku and category ids using product import in magento2. but not working please anyone help me. eg: sku,category_ids test_123,2,5,12 thanks
0
votes
1answer
87 views

Magento 2: import product with many other data fields

I want to import many products with many custom fields. How can I do that, I hope anyone helps me, Thank in advance. Here is notice when I import product with many custom field
0
votes
0answers
23 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 ...
1
vote
1answer
102 views

Magento 2 : Import product with custom csv

I have a custom product csv file https://drive.google.com/file/d/1f9t4REhn8-Ant58zRB6S0yRx1Rh1PctX/view?usp=sharing how can I import it in Magento 2. Do you have any idea?
0
votes
1answer
75 views

Magento 2 : Import product image with sku

I have a CSV file product image with SKU, I did import all product SKU in admin but not have an image. here is the CSV file I need import.
0
votes
0answers
72 views

Magento 1.9 product import xlsx to csv

I am trying to write a module that converts the given Xls file to default Magento CSV format? Is there any better way to do this?
1
vote
1answer
650 views

RapidFlow Import Error: Empty or invalid product type for a new product

I'm trying to do a product import of some downloadables into Magento via RapidFlow. Their documentation is less than stellar, and I can't seem to figure out how to get rid of this error: Empty or ...
1
vote
0answers
44 views

Magento2 error while updating product URL keys

Getting this error while importing produdct for updating product URLs SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (...
0
votes
1answer
21 views

SQL Error when importing bulk data. Product_id goes out of sync with Entity_id

When importing about 12000 rows of products from a .csv file, it suddenly gives me the following error: General system exception happened Additional data: SQLSTATE[23000]: Integrity constraint ...
0
votes
1answer
953 views

WooCommerce product&category import to Magento

I want migrate all product and category data from WooCoomerce to Magento. I have an woocommerce .csv export file, which contains all of necessary data. How can I convert this csv file to magento ...
0
votes
1answer
653 views

Magento 2: How to import csv to add more value to product attribute's dropdown options in admin?

I have created admin grid with layout and block now I need to know how to import CSV and use its value as array, for adding values I have written Controller: <?php namespace Vendor\OptionImport\...
0
votes
1answer
2k views

Magento 2 : Import product from csv configurable product error

I am working on Magento 2.1.3 product import with CSV. I am getting a error while using following CSV file. download csv Error is "General system exception happened"
0
votes
1answer
37 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.
1
vote
3answers
1k views

uRapidFlow Force Images Import

We have updated our source images and need to reimport them into Magento. Does anyone know how to force uRapidFlow to import all images?
2
votes
1answer
59 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 ...
0
votes
0answers
37 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 ...
4
votes
3answers
10k views

Copy product data from one store to another

Due to some changes in website I need to copy product data (name, description, price, etc.) from one store, to another. The setup is simple. There is a product which has some default values and then ...
0
votes
1answer
102 views

Magento 2: Problem with Product Links

During an Import to Update Product prices, I made a mistake. I leave the value for the Product Link empty. After the Import all Product URL change and got the value from the Product name. To face this ...
0
votes
1answer
599 views

How to Import Orders Programmatically with all the product type in Magento2?

I am Looking for the Order Import Programmatically with capable of importing all the product types and multiple products able to import that also I need specific billing details to be included.
2
votes
3answers
2k views

M2 Importer: Value for 'visibility' attribute contains incorrect value

If the importer runs with cronjob I get always the same errors on all lines: Value for 'visibility' attribute contains incorrect value, see acceptable values on settings specified for Admin in ...
1
vote
1answer
721 views

How to Import Products, Categories and Custom Attributes from database?

As the question says. I want to import products, categories and custom attributes on database level. What tables do I need to take with me? For the curious among you: The reason is that I had a ...
1
vote
1answer
262 views

Configurable variation is unidentifiable - Magento 2.3.1

I'm getting the Configurable variation is unidentifiable error when trying to import the configurable items to Magento 2.3.1. I think I have the correct format for the csv, using the defined format, ...
0
votes
0answers
209 views

Magento 2.3.2 - Product import duplicates images

Running Magento 2.3.2 on PHP 7.2 CSV being uploaded has one image for base_image, small_image, thumbnail_image, swatch_image, additional_images. When products are imported, product images are ...
0
votes
1answer
10 views

Magento2.1 image importer

I want to import images into magento2.1 with default importer. My problem is that I added image folder into pub like this: pub/media/catelectronicpic/mobile/1.jpg pub/media/catelectronicpic/laptop/1....

1 2
3
4 5
21