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?