Update Custom Field via Title

  • Posts: 147
  • Thank you received: 9
  • Hikashop Business
4 years 5 months ago #312020

Hello,

I would like to update one custom field from title. To be more precise, in title I have product_name + MPN, so I would like to copy that mpn to a custom_field_mpn. Can I do that with operation? Copy just the number, ignoring the letters?

Thank you in advance.

Last edit: 4 years 5 months ago by Giscard.

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

  • Posts: 81378
  • Thank you received: 13037
  • MODERATOR
4 years 5 months ago #312024

Hi,

You would have to add a function to your MySQL database via your phpmyadmin and then run a MySQL query using that function to do the work on all the products:
stackoverflow.com/questions/37268248/how...from-string-in-mysql
You can't do that via HikaShop's interface.

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

  • Posts: 147
  • Thank you received: 9
  • Hikashop Business
4 years 5 months ago #312051

Goodmorning,

Ok, I will read that.

Thank you for pointing me to the right direction nicolas.

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

Time to create page: 0.058 seconds
Powered by Kunena Forum