Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Insert product into database with SQL

 
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)
 
Thread Tools Search this Thread
  #1  
Old 03-07-2015, 01:50 PM
 
mhuckaby mhuckaby is offline
 

Newbie
  
Join Date: Dec 2014
Posts: 2
 

Default 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?
__________________
X-Cart Business 5.3.1.4
Abandoned Cart Reminder 5.3.1
[Unix/Ubuntu16]
Reply With Quote
  #2  
Old 03-17-2015, 12:30 PM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,431
 

Default 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.
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
Reply
   X-Cart forums > X-Cart 5 > Dev Questions (X-Cart 5)


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 11:42 PM.

   

 
X-Cart forums © 2001-2020