All Questions

Tagged with
6
votes
3answers
105 views
+50

How to keep products synchronized in two shops

How can I transfer all products from one shop to another after clicking a button? We have a shop which is a copy of our real shop. We need to keep the products, prices, etc. synchronized in both ...
0
votes
0answers
37 views

What is best way to move database from Magento 2 to Magento 1

I wanna move product category order from Magento 2 to Magento 1. what is the best way for this? I create export from product and import to Magento 1 by default tools on manage but I get some error ...
0
votes
2answers
72 views

2.3 to 2.3.1 upgrade (commerce/enterprise)

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 a SQLSTATE general error: 1813 Tablespace for table '...
1
vote
1answer
33 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?
0
votes
0answers
54 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 ...
4
votes
0answers
40 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 ...
0
votes
1answer
61 views

Import Magento1 admin users to Magento2

I have done data migration using data migration tool from magento 1.9.x to 2.2.4, but it doesn't import admin users as mentioned in the docs, and we need to manually copy the admin users. What I have ...
0
votes
0answers
320 views

Import database error - magento 1

I have copied all the files from a live magento 1.7 to my localhost on WAMP and I exported the database fromt the live. When I import the database in MySQL conslose by: source path/to/db.sql it ...
1
vote
1answer
43 views

Magento in maintenance mode after importing database from live to test

I created a dump of my live database and imported it into staging by using n98-magerun. ./n98-magerun.phar db:import live.sql But now my website is in maintenance mode, even though there is no ...
1
vote
1answer
34 views

magmi : I need to import (and assign) 7000+ attribute_code Values through csv

magmi : I need to import (and assign) 7000+ attribute_code Values through csv. My issue is that the format of magmi csv is Attribute names should be horizontaly column wise(7000+ cols) and values ...
0
votes
1answer
113 views

Magento 2: Not able to import store table

I have exported database. The size of database approximately 10GB. I imported the database in my local server, but Few tables like store & store_group is not installed. I imported store_group but ...
1
vote
1answer
357 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
0answers
43 views

Update product programatically

I wrote a script for adding products programatically from a CSV. It's working fine. Now I need to update it to do followings, Check if product is already available (using SKU ) and if not, add new ...
1
vote
0answers
32 views

Base table or view not found: 1146 - While importing products from one DB to another DB

I have a site in magento 1.9.2, I installed a new magento 1.9.2 on my localhost which is blank. I export all products by going into system->dataflow->exports and download file as a csv. Now I am ...
1
vote
0answers
823 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 ...
0
votes
1answer
569 views

Product import csv images not getting imported

I have been trying to import products CSV to my magento store. I did import the products without the images and it was successful. But now when I try to import the product with image column I am ...
-1
votes
2answers
416 views

How to import live site into localhost - DB size - 1.4GB & Root Folder Size - 1.2 GB [duplicate]

I need to import my Live site into localhost for testing, DB size - 1.4GB & Root Folder Size - 1.2 GB How can I import large size of SQL file into DB? DB Import Error: You probably tried to ...
1
vote
1answer
232 views

M2: Useful SQL scripts to convert a “production” copy to dev? [closed]

I'm just wondering if people have any useful SQL scripts/queries to "flip" a copy of a production site environment into a development environment? I actually have my production copied to the ...
1
vote
4answers
2k views

how to import 800 mb sql file in localhost using xampp [closed]

I have been trying to import my magento website database which size is 800 mb in phpmyadmin xampp and having error ''You probably tried to upload a file that is too large. Please refer to ...
0
votes
1answer
105 views

Missing product ID: Magento tries to add an ID that it has jumped before

I have to mass import all products of a given website by script using models. My client has made some errors while building the configurables in his ERP and we had to flush all the products using this ...
0
votes
1answer
512 views

Import Database to phpmyadmin from live server

I download/export the database file from live server and change domain name i.e localhost/foldername ao when i import the database to my local server phpmyadmin it gives sql import errors in queries ...
3
votes
1answer
1k views

Magento 2: Data Migration From Non Magento Database to Magento Database

I already have One MySQL database which is not in Magento. I need to Map field 1 by 1 & put into Magento 2 Database. Need to perform Data Migration from Non Magento DB to Magento 2. There may be ...
1
vote
1answer
44 views

How verify customer presence in database during the import

I've to import custumers from a txt file but I don't know what I have to use like univocal attribute to verify the customer presence into database. For example, for the products import I use the sku ...
1
vote
1answer
21 views

Products in Magento DB but not Magento Admin

I created a script that imports simple products programatically. However, it appears 49 products are stuck in "limbo." They appear in the DB table "catalog_product_entity" but not within Magento's ...
1
vote
2answers
860 views

Restore Magento catalog

We have a Magento 1.9.0 and a recent data upload messed up a lot of our product data. We have a backup database from earlier this morning. We don't want to restore the entire database as we have had ...
0
votes
2answers
838 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.
1
vote
1answer
188 views

Running Import profile works through admin panel, but as cron job does not

I'm using below cron.php to run the import profile for updating the price field only (the csv file containds the sku and price). but it does not make any changes in db (source https://gist.github.com/...
0
votes
1answer
31 views

Import Data… Loading 99% fail. Help

I have problems when importing data. What can I do to fix it ? 99% loading.... fail :(
1
vote
0answers
43 views

Unable to find the row no causing an error in product csv

While importing product csv file in magento 1.8.1 I am getting below error SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'attribute_id' cannot be null I want to find out the row ...
1
vote
1answer
269 views

How can i Import Magento Site All category? [closed]

I export all category with tree path my Magento site using following script: //Import Magento All category script define('MAGENTO', realpath(dirname(__FILE__))); require_once MAGENTO . '/app/Mage....
1
vote
2answers
563 views

Magmi Import - Error Messages

I'm trying to import products from a CSV file and keep getting errors. The following 2 errors appear for each row in the CSV file. Seems (at least to me) that it could be a category issue?!?! Can ...
3
votes
3answers
1k views

Magento Error after transferring onto a different computer localhost

after importing my magento project to a different localhost, i've received the following error: There has been an error processing your request Item (Mage_Core_Model_Store) with the same id "0" ...
0
votes
2answers
830 views

Import Database Error: #1062 Duplicate entry '3-13-70-0' for key

I am attempting to export the Magento database from my current installation to a test installation before I have the test installation go live. Both installations are version 1.9.2.1. I can ...
2
votes
0answers
2k views

How to Move Products, Attributes, Images, and Customers From One Magento Installation to Another

I have Magento 1.9.2.1 installed and I also installed a test Magento installation in a subdomain. Basically, the theme I have installed on my current Magento installation was designed for an older ...
1
vote
0answers
349 views

Magento Mysql database import fails in the end of the process [closed]

I trying to import Magento store Mysql dump file via Navicat for Mysql to the new VPS Cannot add or update a child row: a foreign key constraint fails CONSTRAINT ...
0
votes
2answers
175 views

Product page fails to display some product specific information

Simple problem description I imported products they are displayed on the homepage. When the user wants to enter the product page the "there has been an error" error message pops up. Long problem ...
0
votes
2answers
99 views

Efficient & Productive Way of Uploading Products

I am looking for some advice and tips on how to go about uploading hundred of thousands of products onto a Magento store in my lifetime. Today, I discovered Magmi which is a godsend for uploading ...
0
votes
1answer
130 views

Magento product import category mismatch

we have export the product in magento admin panel and changed the products details and import to products. its working fine. But some category id not inserted to table. We have checked with the excel ...
0
votes
1answer
2k views

Magento import a foreign key constraint fails

I am trying to import(with bigdump) my live database to an test database. While importing the tables to the test database im getting the following error. MySQL: Cannot add or update a child row: a ...
-1
votes
1answer
201 views

Magento change hosting

Today I changed one magento to another server. But I have one problem: In the new server, all my products have automatically set: special price to 0.00 all data fields to: 30/11/2000 In categories ...
2
votes
1answer
339 views

Importing 1.7 orders into 1.9

I am currently working on a new website design and planning to upgrade our current shop. The main bases will be the old database, but on "moving day" I want to import the latest orders/stock values ...
0
votes
2answers
18k views

Import 1.2 GB database to phpmyadmin xampp and having error

I have been trying to import my magento website database which size is 1.2 gb in phpmyadmin xampp and having error ''You probably tried to upload a file that is too large. Please refer to ...
2
votes
2answers
3k views

Export database through mysqldump, or Magento admin?

I was looking at this doc: http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/restoring_a_backup_of_a_magento_database which says to add a few lines to your dump file or the ...
7
votes
3answers
19k views

MySQL error while importing database

I want to upgrade Magento. Therefor I first want to transfer the live production system to a development workspace. I am trying to import the production database into a clean database. But I can't get ...
1
vote
1answer
285 views

Importing orders to Magento - product_options

I've been tasked with importing from a non Magento store into Magento 1.9. We have over 236k orders that need to be imported. So far I've successfully written services (c#) to manage importing ...
0
votes
1answer
318 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 ...
2
votes
1answer
574 views

Import problem: What is the importance of the table 'importexport_importdata', can i truncate it and what is it good for anyhow?

i have a problem with a clients Magento DB while trying to replicate it on my computer. Needless to say that i was not able to export the DB via the Magento Backend (using 1.6 Community version), ...
1
vote
3answers
2k views

Can't re-index after product import

I have a client call and say he could not re-index after importing 100 products. I attempted to re-index in shell and received this error exception 'PDOException' with message 'SQLSTATE23000: ...
3
votes
1answer
3k views

Importing attributes to a new magento installation

What are the tables I need to dump to be able to import them in a new installation? I need this to avoid reinserting all the custom attributes for every new Magento installation. thanks
1
vote
1answer
431 views

Load Configurable Pricing Adjustments

I'm trying to import configurable products with the price corrections. The products and the relations are already in, but I can't seem to get the price corrections working. This is what the ...