Plugin to create and manage a simple custom database table?

bernard

BuSo Pro
Joined
Dec 31, 2016
Messages
2,587
Likes
2,298
Degree
6
I want to create a custom database table in Wordpress with a list of product names.

These product names should be referenced when doing feed imports, so that if the product name is in that list, then it checks a custom field.

I used to do this with hardcoding in the WP All Import plugin, but that is obviously not a good idea. I assume that I would be able to reference such a table in WP All Import custom functions?

What I intend to do is create a plugin that creates this custom table, like shown here:

https://premium.wpmudev.org/blog/creating-database-tables-for-plugins/

and here:

https://jacobmartella.com/2018/01/15/create-custom-table-wordpress/

Then the second part is to create a Wordpress form, where users can add, edit, delete, the list and then update that in the database.

Do you know of any good guide that shows you how to do this?

Edit:

I think I would rather prefer for this database to be updated from a Google Sheet. Would it be better to create the lookup product titles as custom posts and then reference those? Could import with WP All Import from Google Sheet.
 
Last edited:
Back