Custom fields in Admin on Product page

At the moment I used the SKU and other fields in Admin in the product page as a custom field, which I think it was a mistake as Im messing up the logic of LiteCart.

I couldnt find a vmod or anything, but whats the safest way adding custom fields in Admin for product pages incl Mysql update?

e.g:

Custom field 1:
Custom field 2:
Custom field 3:
etc...
I personally need 10 fields of these.

So I can place the content of these wherever I want in my template.

Also its important that these fields to ve searchable, when using the main search bar.

I always thought of writing a meta key vMod for this. Tell me more, is this translatable content for the frontend or raw values (no translations) for backend use only? Printed on the order or not? Etc. A use case example would be helpful.

See attached.
So basically you include with code wherver you ant the custom field or/and textarea to appear on your page.

In my case I am using for many things such as:

• My own poduct code
• Information that is not appearing at all in the front (like suppplier's code, and notes that I need to know about the product but I dont want to show customers
• information that I only want to appear for certain user IDs. For example Registered user ID 1, is for our staff, they log in and they can see certain additional information on the product when they help customers over the phone with details or registered user ID 2 is for resellers, if they log in they can see certain infromation on that product that is not visible for the public, but ID 2 cant see info on ID 1.

FEATURES:

• at least 10 custom fields and 5 custom text area
• custom html fileds to allow inline css
• hidden in front or not
• show after log in or not if so...
  ...adding more registered customer IDs with comma separation would be preferable
• also printable or not printable
• defining the PHP STRING for echo
• showing the echo php code that needs copies into the template page's code

(I turned my SKU, MPN, TIN fileds for all these as described above, which probably I should not do it as there are codes for these in the back and will mess up shipping labelling etc.
A VQMOD would be nice for this)