The external id from opencart did not load correctly
Opencart integration configured
Enabled action
https://farfor.crm-onebox.com/admin/auto/action/hour/edit/
Import products from Opencart
Downloaded products from the site, example
https://farfor.crm-onebox.com/admin/shop/products/40617/edit/
12051 was written to the external id https://prnt.sc/xz53ty
And in opencart 12051-45 https://prnt.sc/xz54c9
Similarly for other products, the external id is not fully loaded.
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Enabled action
https://farfor.crm-onebox.com/admin/auto/action/hour/edit/
Import products from Opencart
Downloaded products from the site, example
https://farfor.crm-onebox.com/admin/shop/products/40617/edit/
12051 was written to the external id https://prnt.sc/xz53ty
And in opencart 12051-45 https://prnt.sc/xz54c9
Similarly for other products, the external id is not fully loaded.
Answers:
external id is taken from the product_id field in the table prefix_product . As far as I remember, in the basic opencart there is an int type. Can you show a screenshot of your database?
01.02.2021, 15:52
Original comment available on version: ru
Bodyako Dmitry
dev wrote:
external id is taken from the product_id field in the table prefix_product . As far as I remember, in the basic opencart there is an int type. Can you show a screenshot of your database?
I can’t access the database through the web panel, because access to the connection from the box server is registered, but there is no access to the box server to check through the terminal
Access to the database is here https://farfor.crm-onebox.com/admin/shop/integrations/opencart-1/control/
01.02.2021, 16:01
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Bodyako Dmitry
dev wrote:
Well, go through the panel
Does not let, it seems sis. the administrator configured to connect only from the ip of the box.
01.02.2021, 16:23
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Bodyako Dmitry
dev wrote:
external id is taken from the product_id field in the table prefix_product . As far as I remember, in the basic opencart there is an int type. Can you show a screenshot of your database?
Yes, int https://prnt.sc/xz9d74
01.02.2021, 16:57
Original comment available on version: ru
I did not know that the product code in the card and the product_id in the database are different fields
01.02.2021, 20:16
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Korop Vladislav Pavlovich
Employee wrote:
I did not know that the product code in the card and the product_id in the database are different fields
I did it this way:
Created an additional field product code (Opencart) and made automation according to this principle https://prnt.sc/xzmm3m
The only negative is that it generates a five-digit value. if the product code is 123, then it will be 00123, something like this
01.02.2021, 21:06
Original comment available on version: ru
Andrew
Client wrote:
Korop Vladislav Pavlovich
Employee wrote:
I did not know that the product code in the card and the product_id in the database are different fields
I did it this way:
Created an additional field product code (Opencart) and made automation according to this principle https://prnt.sc/xzmm3m
The only negative is that it generates a five-digit value. if the product code is 123, then it will be 00123, something like this
yep, went a little off the rails :)
01.02.2021, 21:08
Original comment available on version: ru
Andrew
Client wrote:
Bodyako Dmitry
dev wrote:
external id is taken from the product_id field in the table prefix_product . As far as I remember, in the basic opencart there is an int type. Can you show a screenshot of your database?
Yes, int https://prnt.sc/xz9d74
Vlad, as you can see there is really an int, and some other field is displayed in your opencart admin panel. If you find it in the database, you can import it into some additional field, for example, through the field import setting in action.
02.02.2021, 11:17
Original comment available on version: ru
Bodyako Dmitry
dev wrote:
Andrew
Client wrote:
Bodyako Dmitry
dev wrote:
external id is taken from the product_id field in the table prefix_product . As far as I remember, in the basic opencart there is an int type. Can you show a screenshot of your database?
Yes, int https://prnt.sc/xz9d74
Vlad, as you can see there is really an int, and some other field is displayed in your opencart admin panel. If you find it in the database, you can import it into some additional field, for example, through the field import setting in action.
I found something in the source code of the page, the model field, although it is visually called differently
02.02.2021, 14:32
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
in the database, it still does not hurt to look. Field names on front and back+db may differ
02.02.2021, 15:10
Original comment available on version: ru
Bodyako Dmitry
dev wrote:
in the database, it still does not hurt to look. Field names on front and back+db may differ
I turned on the export of products through the database, passed the presence of the goods, there it connects by the external id, as a result, everything was updated, which means everything is OK, the codes match.
02.02.2021, 15:13
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
