relation beetween alias and id product product_code

  • Posts: 846
  • Thank you received: 92
7 years 11 months ago #256217

-- 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

Attachments:
Last edit: 7 years 11 months ago by lionel75.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 11 months ago #256218

Hi,

The "product alias" and the "product code" are two different fields..

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 846
  • Thank you received: 92
7 years 11 months ago #256341

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 !!

Last edit: 7 years 11 months ago by lionel75.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
7 years 11 months ago #256366

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.063 seconds
Powered by Kunena Forum