Insert article into table oxarticles

I try to insert article data into the table oxarticles directly with SQL. the statement works fine, but the articles are not display within the article administration.

I’am using the following statement:

insert into oxarticles
set OXSHOPID = 1,
OXID = (SELECT MD5(‘Test Artikel Name 1’)),
OXINSERT = (select date_format(sysdate(),’%Y-%m-%d’)),
OXARTNUM = 22342423,
OXMPN = 22342423,
OXACTIVE = 0,
OXSUBCLASS = ‘oxarticle’,
OXTITLE = ‘Test Artikel Name 1’,
OXSHORTDESC = ‘Detail’,
OXTITLE_1 = ‘Test DE’,
OXSHORTDESC_1 = ‘Detail DE’,
OXPRICE = 20.5,
OXPIC1 = ‘test.jpg’,
OXSTOCK = 0,
OXSTOCKFLAG = 4,
OXISSEARCH = 1,
OXORDERINFO = ‘’;

What am I doing wrong? Is an attribute missing?

for EE related problems you need to contact oxid professional support, this forums mailny covers CE related topics

  1. OXACTIVE = 0, Must be 1
  2. You have assign articles to actions, categories etc. before they are shown (in all shop-versions).
  3. If EE(?), you have to assign the article to the table “oxarticles2shop” too.

OXACTIVE has to be 1, if you would like to see the article directly in the shop front end.

The categories must be set, that’s right.

The problem was the assignment in table “oxarticles2shop”, becaus we have the OXID EE version.

Many THX for your help.