Magento integration

When trying to sync orders and customers with magento i get allways 0 entities found. The magento system has over 1000 orders. I’ve tried to switch stores in channel but happens the same. What am i doing wrong ? How to integarte orocrm and magento the proper way ?

Topic

[Alexandr SmagaParticipant]

Hello.

So as understood, you created the channel with some store, did sync and after that change the store in the settings ?

It seems known issue, when you run sync it saves the last success date and next time starts from last sync date.
Try to remove the channel and create new one with correct store.
This issue will be fixed soon.

[Dima MakarukParticipant]

Hi,
not really
nothing is syncronized. I can see store name in the dropdown. If i try to sync i’m getting nothing. And it doesn’t metter which store view i choose.

[Alexandr SmagaParticipant]

Hmm.. It’s strange, can you please give more detailed information. Which version of magento are you using ? Have you tried sync with Oro Bridge extension installed on magento side or without? How did you run sync from CLI or from UI ? If you run from UI, have you checked that daemon for job queue started ?

[shameedParticipant]

Hi,

Thanks for wonderful software, i connected with basic installation of magento which works perfect with orocrm, then i connected with exiting Magento store, i got below output,

[notice] Run sync for "Flash Store" channel. [info] Start processing "customer" connector [info] Looking for batch 1[info] found 17 entities Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 1 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 2 Array ( [originId] => 3 ) [info] Loading entity by id: 3 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 4 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 5 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 7 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 8 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 11 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 12 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 13 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 14 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 16 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 21 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 22 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 23 Array ( [website_id] => 0 [code] => admin [name] => Admin [store_id] => 0 [originId] => 0 ) [info] Loading entity by id: 24 Array ( [store_id] => 1 [code] => en [website_id] => 1 [name] => English [originId] => 1 ) [info] Loading entity by id: 25 [info] Looking for batch 1[info] found 0 entities [error] Errors were occurred: [error] An exception occurred while executing 'INSERT INTO orocrm_magento_store (store_code, store_name, origin_id, website_id, channel_id) VALUES (?, ?, ?, ?, ?)' with params [null, null, 3, 16, 2]:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157

[notice] Run sync for "Flash Store" channel. [info] Start processing "customer" connector [info] Looking for batch 1[info] found 17 entities Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 1 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 2 Array (     [originId] => 3 ) [info] Loading entity by id: 3 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 4 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 5 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 7 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 8 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 11 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 12 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 13 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 14 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 16 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 21 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 22 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 23 Array (     [website_id] => 0     [code] => admin     [name] => Admin     [store_id] => 0     [originId] => 0 ) [info] Loading entity by id: 24 Array (     [store_id] => 1     [code] => en     [website_id] => 1     [name] => English     [originId] => 1 ) [info] Loading entity by id: 25 [info] Looking for batch 1[info] found 0 entities [error] Errors were occurred: [error] An exception occurred while executing 'INSERT INTO orocrm_magento_store (store_code, store_name, origin_id, website_id, channel_id) VALUES (?, ?, ?, ?, ?)' with params [null, null, 3, 16, 2]:

Please Provide Solution.

---

Thanks/Regards
Shameed

[Author]

Replies