Comments (12)
FYI, I tested limiting the join (module-pimgento/Import/Helper/UrlRewrite.php:110
) with
->joinLeft(
array('u' => $urlRewriteTable),
't._entity_id = u.entity_id
AND u.entity_type = "' . $code . '"
AND u.redirect_type = 0
AND u.target_path = ' . $targetPathExpr . '
AND u.store_id = ' . $storeId,
array()
)
But it doesn't work as expected, and the url_rewrite
table is then messed up :
There is a few lines missing, maybe because some locales are used more than once ?
EDIT : I noticed a few holes in translations, this might be irrelevant... But if a translation is missing, it should use the default setting, and it doesn't look like the case...
from pimgento-2.
I don't have much time to debug right now, but it seems we have the exact same problem for products (which are created from scratch using Pimgento imports).
from pimgento-2.
facing the same issues. When a category name has changed in akeneo, urls are reported as duplicated:
Integrity constraint violation: 1062 Duplicate entry 'url.html-1' for key 'URL_REWRITE_REQUEST_PATH_STORE_ID', query was: INSERT INTO url_rewrite
(url_rewrite_id
, entity_type
, entity_id
, request_path
, target_path
, redirect_type
, store_id
, is_autogenerated
) SELECT tmp_pimgento_rewrite
.url_rewrite_id
, "category" AS entity_type
, tmp_pimgento_rewrite
.entity_id
, tmp_pimgento_rewrite
.request_path
, tmp_pimgento_rewrite
.target_path
, 0 AS redirect_type
, tmp_pimgento_rewrite
.store_id
, 1 AS is_autogenerated
FROM tmp_pimgento_rewrite
WHERE (request_path
<> old_request_path
AND url_rewrite_id
IS NOT NULL) ON DUPLICATE KEY UPDATE url_rewrite_id
= VALUES(url_rewrite_id
), entity_type
= VALUES(entity_type
), entity_id
= VALUES(entity_id
), request_path
= VALUES(request_path
), target_path
= VALUES(target_path
), redirect_type
= VALUES(redirect_type
), store_id
= VALUES(store_id
), is_autogenerated
= VALUES(is_autogenerated
)
We have 3 locales, of which 2 are Dutch/Belgium, which use the same names. The third is French.
from pimgento-2.
Thanks @shavounet for the quick leftjoin fix. I'm a little further now.
With this quick fix my categories seems to be imported ok for 4 languages.
The url_rewrite table is updated and seems to be ok, but the menuitem-urls on the frontend are still not rewrited. cache:clean doest fix it. indexer:reindex delete all category url_rewrites... strange
For product import i am using name-en_US-ecommerce as url_key.
In stores > configuration > catalog > pimgento > product i add the pim element: name-en_US with the magento attribute: url_key-en_US etcetera. Thats working ok now.
from pimgento-2.
Bump.. I'd really like a view on this from the DnD team.. are you not facing the same problems? @magentix
from pimgento-2.
+1 !!
from pimgento-2.
@peterjaap Created a pull-request, just for you.
Bit disappointing I never heard back. But grateful for the plugin, works perfect now.
from pimgento-2.
@wigman ❤️
from pimgento-2.
Thank you @wigman, I've successfully used your PR to apply a patch on Pimgento using https://github.com/cweagans/composer-patches and import my categories without failure !
from pimgento-2.
@shavounet Great, I'm glad it solved your problem:)
from pimgento-2.
Thank you @wigman i also tested your PR and it's working fine. Import categories & products 4 storeviews.
from pimgento-2.
It seems fixed in the lastest version (100.2.4)
from pimgento-2.
Related Issues (20)
- Images are not imported for configurable products HOT 1
- Warning: unlink(/data/web/magento2/magento/pub/media/): Is a directory in /data/web/magento2/magento/vendor/agencednd/module-pimgento/Product/Helper/Media.php on line 251 HOT 5
- Import Categories fail in 1 action HOT 10
- Support path setting for LOAD DATA INFILE HOT 1
- Huge catalog takes a lot of time to import
- FieldDataConverterFactory does not exist on production compilation
- Disable some attributes import
- Not compatible with M 2.3 HOT 2
- Allow user to configure the category url generation
- Product images roles are not assigned.
- pimgento-2-api installation HOT 1
- Configurable Products: Order not being respected.
- how to manage quantity_and_stock_status in magento from importing products csv file from akeneo to magento???
- How to import reference entities ? HOT 1
- Product Model Update fails HOT 3
- Does Pimgento support Grouped Products?
- Weak data validation while importing attributes HOT 1
- Family import - attributes are not assigned to any group HOT 1
- PIM > Magento 2 EE - Image name imported to Magento with filehash HOT 4
- Category csv file not recognised
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pimgento-2.