- Posts: 72
- Thank you received: 0
change product id number in database
- daveturner101
-
Topic Author
- Offline
Less
More
12 years 8 months ago #141345
by daveturner101
change product id number in database was created by daveturner101
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:
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
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:
Code:
/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.
12 years 8 months ago #141347
by nicolas
Replied by nicolas on topic change product id number in database
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.
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.
- daveturner101
-
Topic Author
- Offline
Less
More
- Posts: 72
- Thank you received: 0
12 years 8 months ago #141422
by daveturner101
Replied by daveturner101 on topic change product id number in database
thanks. appears to work.
Please Log in or Create an account to join the conversation.
Time to create page: 0.139 seconds