this more of mysql query question, experience working woocommerce might have valuable insight.
i'm trying create stored procedure , running syntax issues. mysql error message states syntax error on line 60. after commenting out line line, seems not declare line. appreciated.
delimiter $$ drop procedure if exists sp_addproduct$$ create procedure sp_addproduct ( in postdate datetime, in postparent int, in sku varchar(10), in weight int, in price decimal(5,2), in size varchar(10), in guid varchar(250), in menuorder int ) begin insert wp_posts ( post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count ) values ( '1', postdate, postdate, '', '', '', 'publish', 'open', 'open', '', '', '', '', postdate, postdate, '', postparent, guid, menuorder, 'product_variation', '', 0 )$$ /* set postid = postid generated above insert*/ declare postid int$$ set postid = last_insert_id()$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sku',sku)$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_thumbnail_id',0)$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_virtual','no')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_downloadable','no')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_weight',weight)$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_length','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_width','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_height','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_manage_stock','no')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_stock_status','instock')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_regular_price',price)$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sale_price','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sale_price_dates_from','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sale_price_dates_to','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_price',price)$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_download_limit','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_download_expiry','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_downloadable_files','')$$ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_attribute_pa_size',size)$$ end$$ delimiter ;
try apply following changes:
delimiter $$ drop procedure if exists sp_addproduct$$ create procedure sp_addproduct ( in postdate datetime, in postparent int, in sku varchar(10), in weight int, in price decimal(5,2), in size varchar(10), in guid varchar(250), in menuorder int ) begin declare postid int; insert wp_posts ( post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_type, post_mime_type, comment_count ) values ( '1', postdate, postdate, '', '', '', 'publish', 'open', 'open', '', '', '', '', postdate, postdate, '', postparent, guid, menuorder, 'product_variation', '', 0 );/*$$*/ /* set postid = postid generated above insert*/ -- declare postid int$$ set postid = last_insert_id();/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sku',sku);/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_thumbnail_id',0);/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_virtual','no');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_downloadable','no');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_weight',weight);/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_length','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_width','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_height','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_manage_stock','no');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_stock_status','instock');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_regular_price',price);/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sale_price','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sale_price_dates_from','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_sale_price_dates_to','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_price',price);/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_download_limit','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_download_expiry','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_downloadable_files','');/*$$*/ insert wp_postmeta(post_id, meta_key, meta_value) values (postid,'_attribute_pa_size',size);/*$$*/ end$$ delimiter ; 
Comments
Post a Comment