Rate the update for the action "Upload products/categories/filter/characteristics to opencart (via DB)"
Hello!
you need to add the ability to write the value of an additional field to the oc_url_alias table.
maybe it makes sense to add the ability to specify a table in the same way as a column?
Original question is available on version: ua
you need to add the ability to write the value of an additional field to the oc_url_alias table.
maybe it makes sense to add the ability to specify a table in the same way as a column?
Answers:
Good afternoon. We now write a link to the product in the keyword field and in the query product_id = product ID. Do you want the keyword to be taken not from the product link, but from the add-on field?
12.10.2022, 12:10
Original comment available on version: ua
bu
OneBox production wrote:
Good afternoon. We now write a link to the product in the keyword field and in the query product_id = product ID. Do you want the keyword to be taken not from the product link, but from the add-on field?
now this field is not loaded at all in the OpenCart client. if the URL-prefix field is filled in the product, will it be transmitted as you write?
12.10.2022, 13:10
Original comment available on version: ua
sure, but it doesn't fit. it is necessary from the field. how many hours will it take to complete?
12.10.2022, 14:04
Original comment available on version: ua
bu
OneBox production wrote:
Do you want the keyword to be taken not from the product link, but from the add-on field?
12.10.2022, 14:28
Original comment available on version: ua
bu
OneBox production wrote:
Do you want the keyword to be taken not from the product link, but from the add-on field?
we need not only the keyword from the field, but also the product ID. how much will this modification cost?
12.10.2022, 17:05
Original comment available on version: ua
It's a bit strange here, since in oc_url_alias every product is recorded. Or do you take the id of the product itself when transferring it to openkart, too, from the field and not from the external id?
13.10.2022, 10:30
Original comment available on version: ua
we are currently synchronizing products by SKU (item). the external ID does not suit us at all, there is a Promo code.
therefore, if this transfer scheme suits the client (it depends on the price), then we will take from the additional field.
previously, the client worked with MoiSklad and says that it worked like this: a field was filled in MoiSklad and it was filled in OpenCart
some more details:
the product is created on OpenCart with an empty SEO URL field, and if the product is saved manually, it is automatically filled.
OpenCart support has not yet answered if they can fix the save on build.
maybe you can tell me how to implement it better?
therefore, if this transfer scheme suits the client (it depends on the price), then we will take from the additional field.
previously, the client worked with MoiSklad and says that it worked like this: a field was filled in MoiSklad and it was filled in OpenCart
some more details:
the product is created on OpenCart with an empty SEO URL field, and if the product is saved manually, it is automatically filled.
OpenCart support has not yet answered if they can fix the save on build.
maybe you can tell me how to implement it better?
13.10.2022, 10:48
Original comment available on version: ua
Yaryna
The integrator wrote:
we are now synchronizing products by SKU (item)
if you have the product id on the open card in the article, then the data will be transferred to oc_url_alias by the same id. You just need to fill in something in the url box
Yaryna
The integrator wrote:
the product is created on OpenCart with an empty SEO URL field, and if the product is saved manually, it is automatically filled.
OpenCart support has not yet answered if they can fix the save on build.
no, they won't be able to. We insert the product directly into the database.
13.10.2022, 11:35
Original comment available on version: ua
bu
OneBox production wrote:
if you have the product id on the open card in the article, then the data will be transferred to oc_url_alias by the same id. You just need to fill in something in the url box
no, in the article we have the SKU of the product on OpenCart.
if the IDs are formed there sequentially, then we can form them ourselves in the box and record them in the field. but these are not very comfortable crutches)
13.10.2022, 12:02
Original comment available on version: ua
it is not important how the goods are related. If your transmission works, then the id will be inserted into oc_url_alias
13.10.2022, 12:04
Original comment available on version: ua
bu
OneBox production wrote:
If your transmission works, then the id will be inserted into oc_url_alias
perfectly! that's how it works, thanks for your help
13.10.2022, 12:28
Original comment available on version: ua
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
