I've made a third party application to add automatically items to my k2 product catalog, items are inserted into database but not visible in frontend.
First i've tested this in phpMyAdmin - same problem, the script is working fine but items stil not displayed.What i am doing wrong? How to add items correctly?
First i've tested this in phpMyAdmin - same problem, the script is working fine but items stil not displayed.
INSERT INTO `jos_k2_items` (
`title`, `alias`, `catid`, `published`, `introtext`, `fulltext`, `image_caption`, `image_credits`,
`video`, `video_caption`, `video_credits`, `gallery`, `extra_fields`, `extra_fields_search`,
`created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `publish_up`,
`publish_down`, `checked_out`, `checked_out_time`, `trash`, `access`, `ordering`,
`featured`, `featured_ordering`, `hits`, `metadata`, `metadesc`, `metakey`, `params`,
`plugins`, `language`
) values (
'Product Item Title', 'product-item-title-alias', 15, 1, '', '', '', '', NULL, '','',NULL, '[{"id":"2","value":"23"},{"id":"5","value":"0"},{"id":"4","value":"0"},{"id":"6","value":"1"},{"id":"7","value":"5404"}]', '', "2012-05-12 19:00:00", 62, "", "0000-00-00 00:00:00", 62, "2012-05-12 19:00:00", "0000-00-00 00:00:00", 0, "0000-00-00 00:00:00", 0, 0, 0, 0, 0, 1, '', '', '', '', '', ''
)