# Migration von Prestashop

**URL:** <https://forum.shopware.com/t/migration-von-prestashop/40967>\
**Category:** Allgemein\
**Created:** [31. Oktober 2016 um 10:45 UTC](https://forum.shopware.com/t/migration-von-prestashop/40967 "2016-10-31T10:45:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![harmonie-shop24](https://avatars.discourse-cdn.com/v4/letter/h/9f8e36/32.png) [@harmonie-shop24](https://forum.shopware.com/u/harmonie-shop24)\
**Post date:** [31. Oktober 2016 um 10:45 UTC](https://forum.shopware.com/t/migration-von-prestashop/40967/1 "2016-10-31T10:45:17Z")

</div>

Hallo, ich möchte von prestashop zu shopware bekomme aber immer wieder bei der migration folgenden fehler

**Beim Importieren der Preise ist ein Fehler aufgetreten**

**Code** : 23000  
**Line** : 234  
**File** : /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Statement/Pdo.php

**Error** : SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‚id\_product‘ in order clause is ambiguous  
**Trace** : #0 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Statement.php(303): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend\_Db\_Statement-\>execute(Array) #2 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query(’(\n\t\t\t\t\tSELECT\n …’, Array) #3 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(’(\n\t\t\t\t\tSELECT\n …’, Array) #4 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(585): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(’(\n\t\t\t\t\tSELECT\n …’) #5 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Price.php(70): Shopware\SwagMigration\Components\Migration\Profile-\>queryProductPrices(0) #6 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(465): Shopware\SwagMigration\Components\Migration\Import\Resource\Price-\>run() #7 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(502): Shopware\_Controllers\_Backend\_SwagMigration-\>runImport(‚import\_prices‘) #8 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_SwagMigration-\>importAction() #9 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‚importAction‘) #10 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Kernel.php(177): Enlight\_Controller\_Front-\>dispatch() #12 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/shopware.php(113): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main}

_OK_

kann mir jemand helfen?&nbsp;

---

<div class="post-metadata">

**Author:** ![Alex\_Voss](https://avatars.discourse-cdn.com/v4/letter/a/71c47a/32.png) [@Alex\_Voss](https://forum.shopware.com/u/Alex_Voss)\
**Post date:** [31. Oktober 2016 um 12:08 UTC](https://forum.shopware.com/t/migration-von-prestashop/40967/2 "2016-10-31T12:08:02Z")

</div>

Hallo,

&nbsp;

von welcher PrestaShop Version wollen Sie denn migrieren?

Ich konnte mei mir auf dem System die Fehlermeldung leider nicht nachstellen.

&nbsp;

Sie könnten allerdings versuchen in der Datei Components/Migration/Profile/Prestashop15 (für Versionen \> 1.4.X) bzw. in der Datei Components/Migration/Profile/Prestashop14 (für Versionen \< 1.5) die Funktionen mit dem Namen “getProductPriceSelect” zu suchen und diese Änderung vorzunehmen:

```
 ORDER BY id\_product, `from`

```

zu&nbsp;

```
 ORDER BY pr.id\_product, `from`

```

das sollte Ihre Fehlermedung beseitigen.

&nbsp;

Mit freundlichen Grüßen,

&nbsp;

Alexander Voss

&nbsp;

&nbsp;