eStore category, relational and product table column names

[gncook50]

I am trying to set up website to allow emembers to sell their digital content. I am creating a frontend form to add products to the database which I have working. I have looked at the eStore_installer.php file for the database set up which hasn’t helped yet. I want to allow the customer to specify a category name. I understand how the category table and the relational table determine the association between the category and product.

When I have added a product from my front end form, then manually added a category to that same product in the eStore backend, it looks like the wp_eStore_tbl is updated too, specifically the column names t1, t3 and p3. How do these columns relate to the category update or do they. Also, are there any fields in the wp_eStore_tbl that are affected by selecting categories for a product.

Thanks.

gncook50

[Peter]

column names t1, t3 and p3. How do these columns relate to the category update or do they

No these fields have no relation to category. Those fields are for subscription payment.

Look in the file called eStore_product_management.php and if you are a developer you should be able to piece together how the DB is updated with respect to category.

Hint: there is another table called wp_eStore_cat_prod_rel_tbl which gets updated.

[gncook50]

Thank you so much for your quick response. I’ll check it out.

[Author]

Posts