change product id number in database

  • Posts: 72
  • Thank you received: 0
11 years 7 months ago #141345

hi,

we recently sent out an email which had a link in it to automatically add a product with a characteristic to the cart. you can see it at the end of this link:

/index.php?option=com_hikashop&ctrl=product&task=updatecart&quantity=1&checkout=1&product_id=174

however we've since updated the characteristics of the product and this has, in turn, created a new product number. this means that the link that was sent out in the email is now broken as product '174' is now product '182'

am i able to just change the '182' value in the database back to '174' so that the link works again?

many thanks

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

  • Posts: 84243
  • Thank you received: 13686
  • MODERATOR
11 years 7 months ago #141347

Yes, but make sure that you change it both in the hikashop_product, the hikashop_variant, the hikashop_price (if you set a price for your variants) and the hikashop_file (if you set images/files for your variants) tables.
Otherwise, if you don't change it in them all, it won't work properly.

The following user(s) said Thank You: daveturner101

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

  • Posts: 72
  • Thank you received: 0
11 years 7 months ago #141422

thanks. appears to work.

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

Time to create page: 0.043 seconds
Powered by Kunena Forum