Insert product into database with SQL
 

I would like to manually insert a product into the database.

I have determined that I need to enter values into the following tables:
xc_products
xc_product_translations
xc_inventory
xc_category_products

I can insert the product, but when I go to the X-cart administration page, the product isn't listed.

I tried rebuilding the cache, but it still didn't appear.

What am I missing?

Re: Insert product into database with SQL
 

Hello @mhuckaby!

I just tried to insert values into these tables and the product showed up in admin area. Could you please let me know what exactly MySQL queries you ran? Then, I will be able to say how to fix the problem.

Tony.