- Posts: 846
- Thank you received: 92
relation beetween alias and id product product_code
9 years 10 months ago - 9 years 10 months ago #256217
by lionel75
relation beetween alias and id product product_code was created by lionel75
-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.5
Hi
what is the relation beetween id product_code product_name . I think my question is relative to the inter relation that xist in the rdbms ( mandatory unique ...) .
I import a csv file of products and see i miss t oset tthe quantity of product t oa value ( 0 in the csv )
So I try to use mass action to update some product quantity value and see some don't product value are not update .....
So I try to update the quantity manually but after update the quantity value i have this message !!
When i search cat501 in hikashop only one item appear !
Thank's
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.5
Hi
what is the relation beetween id product_code product_name . I think my question is relative to the inter relation that xist in the rdbms ( mandatory unique ...) .
I import a csv file of products and see i miss t oset tthe quantity of product t oa value ( 0 in the csv )
So I try to use mass action to update some product quantity value and see some don't product value are not update .....
So I try to update the quantity manually but after update the quantity value i have this message !!
When i search cat501 in hikashop only one item appear !
Thank's
Attachment not found
Last edit: 9 years 10 months ago by lionel75.
Please Log in or Create an account to join the conversation.
9 years 10 months ago #256218
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic relation beetween alias and id product product_code
Hi,
The "product alias" and the "product code" are two different fields..
Regards,
The "product alias" and the "product code" are two different fields..
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Please Log in or Create an account to join the conversation.
9 years 10 months ago - 9 years 10 months ago #256341
by lionel75
Replied by lionel75 on topic relation beetween alias and id product product_code
Hi
Ok i see this field is inside *_hikashop_product table name
product_alias varchar(255) Null ( no)
As always with some time to read the documentation and go deeper :
- alias is a joomla concept and not hikashop .
- since it is joomla that create this alias .....it should like id ; check that this value is unique but not the reality
- joomal check the value only during edit the product . and then alert us .
direct import in rdbms avoid joomla check
don't know if mass action take care of this
So in some context when import csv ; you have to check by yourself than product_alias value is unique !!
Ok i see this field is inside *_hikashop_product table name
product_alias varchar(255) Null ( no)
As always with some time to read the documentation and go deeper :
- alias is a joomla concept and not hikashop .
- since it is joomla that create this alias .....it should like id ; check that this value is unique but not the reality
- joomal check the value only during edit the product . and then alert us .
direct import in rdbms avoid joomla check
don't know if mass action take care of this
So in some context when import csv ; you have to check by yourself than product_alias value is unique !!
Last edit: 9 years 10 months ago by lionel75.
Please Log in or Create an account to join the conversation.
9 years 10 months ago #256366
by nicolas
Replied by nicolas on topic relation beetween alias and id product product_code
Hi,
You also have the possibility to leave the product alias field empty. That way HikaShop won't bug you with that check and will generate the alias automatically out of the product name when needed to construct the URL of the product page.
You also have the possibility to leave the product alias field empty. That way HikaShop won't bug you with that check and will generate the alias automatically out of the product name when needed to construct the URL of the product page.
Please Log in or Create an account to join the conversation.
Time to create page: 0.164 seconds