magmi-git icon indicating copy to clipboard operation
magmi-git copied to clipboard

Magento 2.0 + Magmi

Open mstern07 opened this issue 8 years ago • 32 comments

Hi, Does anyone know if Magmi works with Magento 2.0.

Thanks!

mstern07 avatar Nov 19 '15 01:11 mstern07

currently i havent tested it. the magento configuration seem very different in the last 2.0 beta i downloaded, i will try to find some time to evaluate the work to be done in order to have it compatible with magento 2.0. My feeling is raw import may not need much adaptation but "easing" code like using "local.xml" in 1.x or getting magento info might need total rewrite as well as indexing.

dweeves avatar Nov 19 '15 18:11 dweeves

Hi dweeves,

I tried magento 2.0 and last version of Magmi. But is following trouble:

SKU 1530 - 1 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1fitkopotrav.core_store' doesn't exist -
SKU 1530 - 2 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'c1fitkopotrav.core_store' doesn't exist - ERROR ON RECORD #1
Trace not found

If you want test it, I will send access to admin and FTP.

Regards Petr

petrjiricek avatar Nov 20 '15 11:11 petrjiricek

@petrjiricek the backend configuration between the two major releases is very different, this is to be expected right now. if you want to experiment with your store on 2.0 in Magmi's current state you can try to replicate these tables to mirror the format it is expecting, but that seems like a lot of extra work for a solution so unreliable.

sammarcus avatar Nov 20 '15 11:11 sammarcus

@dweeves would you be willing to make a checklist of things that you believe need to be done to get Magmi to a compatible state with Magmi? I would be willing to help get Magmi to that point as I'm sure others would help in any way that they can.

jerrylopez avatar Nov 21 '15 04:11 jerrylopez

A list of what tables MagMi edits would be useful for a comparison check with the Magento 2.0 database structure.

RiccardoB avatar Nov 21 '15 09:11 RiccardoB

Some news about that?

BigBlack avatar Dec 03 '15 17:12 BigBlack

Any status for supporting Magento 2?

swhall avatar Jan 16 '16 20:01 swhall

is there any plan to support Magento 2?

Krapulat avatar Jan 21 '16 12:01 Krapulat

Peers, hi. We made update, so magmi is working with Magento 2 now. In 2-3 days, I'll copy here the link

tagesjump avatar Jan 28 '16 11:01 tagesjump

Great news

mserbanoiu avatar Jan 28 '16 20:01 mserbanoiu

@tagesjump would love to see the pull req in the meantime! :smiley: I have also been working on some changes but haven't been able to get it functioning 100%.

sammarcus avatar Jan 28 '16 20:01 sammarcus

@tagesjump waiting your link :)

sebfie avatar Feb 01 '16 12:02 sebfie

Any update on this?? I am going to be forced to write my own importer :/ I can't wait much longer.

miketsl avatar Feb 04 '16 17:02 miketsl

@tagesjump bump

samek avatar Feb 09 '16 13:02 samek

@tagesjump bump

PedroDiaz avatar Feb 22 '16 09:02 PedroDiaz

@tagesjump bump

jerrylopez avatar Feb 22 '16 13:02 jerrylopez

@tagesjump bump

grasdaggel avatar Feb 23 '16 10:02 grasdaggel

very interesting feedback. ) One person wrote to us - we gave a feedback on this. magmin for m2 is working. when we have time we push it on github

tagesjump avatar Feb 23 '16 11:02 tagesjump

Hi guys! Is there any update on the matter? As a possible release date or eta?

Nick

HuygeNick avatar Mar 10 '16 09:03 HuygeNick

Peers, hi. yes it is on github. the next update will be next week

tagesjump avatar Mar 10 '16 09:03 tagesjump

This ? https://github.com/tagesjump/magmi-m2

sebfie avatar Mar 10 '16 09:03 sebfie

Hi guys! I've installed the most recent git from the post above. Everything installed correct and is usable... When i import a CSV with a Sku and qty column to update the stock the update runs. Only after indexing and cache the catalog show a duplicate id error. And no products are shown.

When checking the calog_product_entity in the database the stocks have been updated as they should. After removing the updated products and indexing the productsshow again in the catlog...

Does annyone had the same issue or an idea where to look for a sollution?

Nick

HuygeNick avatar Mar 13 '16 15:03 HuygeNick

Update:

I've noticed in the cataloginventory_stock_item that the updated product has been "duplicated with a new item_id but with the same product_id... Anybody an idea?

HuygeNick avatar Mar 23 '16 08:03 HuygeNick

Hi I have uploaded magmi folder to my magento root directory, but I still get 403 error Forbidden

"You don't have permission to access /magmi/ on this server.

Possible causes of this error include:

The request was forbidden by rules in the .htaccess file.
The directory you requested does not have an index.html or index.php file.
The permissions on the file or directory are incorrect.

For details about why the request was forbidden, see the Apache error log at:

/srv/users/SYSUSER/log/APPNAME/APPNAME_apache.error.log"

and the content of my apache error log

"xxx.xxx.xx.xx- - [24/Apr/2016:18:44:39 -0400] "GET / HTTP/1.0" 302 - xxx.xxx.xx.xx - - [24/Apr/2016:18:44:41 -0400] "GET /?SID=a73e8a5c68d631cf8c7b2e5f2e3d4c7b HTTP/1.0" 200 382177 xxx.xxx.xx.xx - - [24/Apr/2016:18:44:47 -0400] "GET /HNAP1/ HTTP/1.0" 404 68729"

Can anyone tell me how can I Install Magmi in Magento 2 and fixing this 403 error? Many thanks in advance :)

januaryrain77 avatar Apr 25 '16 11:04 januaryrain77

magmi-m2 -> requires a few patches to get categories creater to function -> plus you need to disable foreign key checks for the catalog_inventory updater - otherwise works pretty well with magento2 :) 80 error(s) found Hide Details

This is caused because there is a new FK Constraint and the "INSERT INGORE" command ignores primary key constrains - but throws exception to FK constraint- you can insert a sql call in front of the INSERT IGNORE $sql="SET foreign_key_checks = 0;" - or rewrite the INSERT to first do a select and skip the insert ignore completely!

see here: https://gauravsohoni.wordpress.com/2009/03/09/mysql-disable-foreign-key-checks-or-constraints/

SKU CRX-4039457-E6 - 59869 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '28334-1' for key 'CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_WEBSITE_ID' - 

Other than that Catalog_* tables have all dropped entity_type_id - so you just have to remove a few of those references from category importer module and that's as far as i've got!

southerncomputer avatar May 03 '16 21:05 southerncomputer

any news about configurable products? i can import simple products very well and also categories and his values on the fly. but unfortunately have big problem on configurable products. is any body imports configurable product in magento 2 by magmi?

kordzadeh avatar Jul 20 '16 07:07 kordzadeh

Hello,

Is there any work on-going for magmi for Magento 2?

Thanks, Paras.

paras89 avatar Dec 08 '16 13:12 paras89

Hello,

What about magmi for Magento 2?

ksiamro avatar Jan 26 '17 08:01 ksiamro

I’m looking if there is an official roadmap or a fork of Magmi for Magento 2.x too.

RiccardoB avatar Jan 29 '17 22:01 RiccardoB

Magento 2 Import by default have lot of direct SQL to make it much more faster that it was on Magento 1. Another features like mapping, create attributes and values, scheduled cron jobs and much more we trying to implement in our extension Improved Import for Magento 2 https://github.com/firebearstudio/importexport

biotech avatar Jun 06 '17 14:06 biotech