I need to add an extra field to the product page in OpenCart 3, but it is not retrieving data from the SQL.

In OpenCart 3, I need to add an extra field to the product page, but it's not retrieving data from the SQL database. I need to add a barcode and an additional product name, and each product should have a unique barcode. I've made the additions, but they're not displaying in the catalog/product/edit section. Where exactly is the issue, and how can I fix this?

OCMOD File: https://we.tl/t-xnl6u2Sa25

Not very convenient to read a mod file.

nonnedelectari wrote: ↑

Sun Nov 10, 2024 11:38 pm

Not very convenient to read a mod file.

I don't quite understand, where is it not appropriate to read? Is it from SQL?

How can I get it from SQL?

I believe that nonnedelectari is suggesting that if you want assistance it should be convenient and easy to help, not via a paid service that requires agreement of terms, sign ups and other unnecessary effort when copy and paste using the </> tab or uploading the file would be so much easier. No, I have not wasted my time trying to open the file either.

That said -:
There is one field in products - location - that is unused.
You can also follow how it is done for all other fields in products.
The forum rules require an OC version that includes all four digits.
This has been asked an answered so many times - did you try googling? That has got to be quicker than the effort in posting and retrieving your ocmod code https://www.google.com/search?q=how+to+ ... s+opencart
maybe this one will assist you - http://www.php-dev-zone.com/post/how-to ... n-opencart
and the Opencart marketplace has many https://www.opencart.com/index.php?rout ... t%20fields

by mona wrote: ↑

Mon Nov 11, 2024 12:26 am

I believe that nonnedelectari is suggesting that if you want assistance it should be convenient and easy to help, not via a paid service that requires agreement of terms, sign ups and other unnecessary effort when copy and paste using the </> tab or uploading the file would be so much easier. No, I have not wasted my time trying to open the file either.

That said -:
There is one field in products - location - that is unused.
You can also follow how it is done for all other fields in products.
The forum rules require an OC version that includes all four digits.
This has been asked an answered so many times - did you try googling? That has got to be quicker than the effort in posting and retrieving your ocmod code https://www.google.com/search?q=how+to+ ... s+opencart
maybe this one will assist you - http://www.php-dev-zone.com/post/how-to ... n-opencart

Yes, I know. I sent it this way because the file is a bit long. I've already applied most of what you've mentioned. I've tried to carry out all the necessary actions. I couldn’t succeed, which is why I felt the need to reach out to the community. I searched on Google, but I couldn’t reach any solutions. None of the data-type values are getting parsed, and there’s no error shown. Up until now, I’ve done everything on my own. If I hadn’t gotten stuck, I would have continued on my own. I reached out for help because I’m stuck here and thought there might be a simpler way.

Just for curiosity I have checked the file you published.

The whole OCMod could be made better and easier.
1. unneeded code in it
2. seems that some code is missing - or is there no output in the shop

Anyway, either you contact the developer of that extension, or hire another paid developer, or check the marketplace (where enough extension are available for such):
https://www.opencart.com/index.php?rout ... ch=barcode

OSWorX wrote: ↑

Mon Nov 11, 2024 1:25 am

Just for curiosity I have checked the file you published.

The whole OCMod could be made better and easier.
1. unneeded code in it
2. seems that some code is missing - or is there no output in the shop

Anyway, either you contact the developer of that extension, or hire another paid developer, or check the marketplace (where enough extension are available for such):
https://www.opencart.com/index.php?rout ... ch=barcode

The names of a product may be different and each code will have a barcode. I looked at the plugins.


What do you call unnecessary code?


Actually, I was wondering why the data was not coming to the inputs, where did I make the mistake?

For the barcode you could adopt this extension to work for you if you are after free solutions
https://www.opencart.com/index.php?rout ... load_id=64

MaviATES wrote: ↑

Mon Nov 11, 2024 2:38 am

What do you call unnecessary code?

Basically the whole "extension" is a grap.
E.g. why adding code to install.sql when this file is never called?
Second, everything could be easier achieved with simple events.
Third, my assumption is, that this changes cannot be all to display the code.

So - as already written - either code ist by yourself, or if you are not able to do so hire a developer.
Or use another - better - extension.

MaviATES wrote: ↑

Mon Nov 11, 2024 2:38 am

Actually, I was wondering why the data was not coming to the inputs, where did I make the mistake?

Not you are making mistakes .. but you make your life much harder than it could be ..

OSWorX wrote: ↑

Mon Nov 11, 2024 6:17 pm

Not you are making mistakes .. but you make your life much harder than it could be ..

Well said ditto