query to insert more products -> execute several times. 
For each execution, we need to modifify the "value" column, modifiying the value:
 substring(value, 0, 10)||'1'||row_number() OVER (ORDER BY value)
 increasing the string '1' 
 Example, 2nd execution:
  substring(value, 0, 10)||'2'||row_number() OVER (ORDER BY value)
 Example, 2nd execution:
  substring(value, 0, 10)||'3'||row_number() OVER (ORDER BY value)
  
insert into m_product
select get_uuid(), ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, substring(value, 0, 10)||'1'||row_number() OVER (ORDER BY value) , name, description, documentnote, help, upc, sku, c_uom_id, salesrep_id, issummary, isstocked, ispurchased, issold, isbom, isinvoiceprintdetails, ispicklistprintdetails, isverified, m_product_category_id, classification, volume, weight, shelfwidth, shelfheight, shelfdepth, unitsperpallet, c_taxcategory_id, s_resource_id, discontinued, discontinuedby, processing, s_expensetype_id, producttype, imageurl, descriptionurl, guaranteedays, versionno, m_attributeset_id, m_attributesetinstance_id, downloadurl, m_freightcategory_id, m_locator_id, ad_image_id, c_bpartner_id, ispriceprinted, name2, stock_min, enforce_attribute, calculated, ma_processplan_id, production, capacity, delaymin, mrp_planner_id, mrp_planningmethod_id, qtymax, qtymin, qtystd, qtytype, stockmin, attrsetvaluetype, isquantityvariable, isdeferredrevenue, revplantype, periodnumber, isdeferredexpense, expplantype, periodnumber_exp, defaultperiod, defaultperiod_exp, bookusingpoprice, c_uom_weight_id, m_brand_id, isgeneric, generic_product_id, createvariants, characteristic_desc, updateinvariants, managevariants, prod_cat_selection, product_selection, print_description, returnable, overdue_return_days, ispricerulebased, unique_per_document, relateprodcattoservice, relateprodtoservice, islinkedtoproduct, quantity_rule, allow_deferred_sell, deferred_sell_max_days, m_product_status_id, ismodifytax, relateprodcattaxtoservice, copyservicemodifytaxconfig, em_obpos2_no_standard_sale, em_obpos2_imageclass, em_obpos2_color_id, em_obpos2_pickupptype_id, em_obpos2_deliveryctype_id, em_obpos2_notificationptype_id, em_obpos_scale, em_obpos_groupedproduct, em_obpos_showstock, em_obpos_show_ch_desc, em_obpos_proposal_type, em_obpos_ismultiselectable, em_obpos_allowanonymoussale, em_obpos_printservices, em_obpos_editable_price, em_obrdm_delivery_mode, em_obrdm_delivery_mode_lyw, em_obrdm_isdeliveryservice, em_obpos_maxpriceassocprod, em_obpos_minpriceassocprod, em_obpos_skipapplypromotions
from m_product
where ad_client_id='39363B0921BB4293B48383844325E84C';


- query to insert m_productprice
insert m_productprice:
insert into m_productprice select get_uuid(), '9E4C6F91C917450AA8DF6590E3D350A5', m_product_id, ad_client_id, '0', 'Y', now(), '100', now(), '100', 10, 10, 10, 0, 'S', null, 'UnitPrice', 'UnitPrice', null, 'N', 'UnitPrice' from m_product p where ad_client_id='39363B0921BB4293B48383844325E84C' and not exists (select 1 from m_productprice where m_product_id = p.m_product_id) and p.ad_client_id='39363B0921BB4293B48383844325E84C';

- in assortment, click in "ALL PRODUCTS" button