I want to have a custom table in the database called ‘Products’. The user will be able to add/edit/delete products using the back end interface. All updates and changes will be made to this ‘Products’ table. I tried doing this in WordPress using custom post types. I created a ‘Product’ custom post type and then a plugin to detect when a post is published. However, custom post types will automatically save all posts to the database wp_posts, which is not what I want. In doing this, i will be having duplicate information.
Is there a way to stop wordpress from saving this to wp_posts? Or is it not advisable, which in other words means WordPress isn’t the right CMS for what I’m trying to do?
Thanks!