06-11-2020 12:35 PM - edited 02-03-2024 6:48 PM
"#% impex.setTargetFile( ""Catalog.csv"" , true );" ISERT_UPDATE Catalog; pk; shortdescription; code; price; qv; cv; wholesale; "#% impex.exportItemsFlexibleSearch(""SELECT {c.pk}, {p.shortdescription}, {p.code}, {pr.price}, {pr.qv}, {pr.cv}, {pr.wholesale}, {pr.taxableprice} FROM {CATALOG AS c JOIN PRODUCT AS p on {c.pk} = {p.catalog} JOIN PRICEROW as pr ON {p.pk} = {pr.product} JOIN CATALOGVERSION as cv ON {p.catalogversion} = {cv.pk} JOIN USERPRICEGROUP AS ug on {pr.ug} = {ug.pk} JOIN CATEGORY as ct ON {c.pk} = {ct.catalog}} WHERE {c.id} = 'usProductCatalog' AND {cv.version} = 'Online' GROUP BY {p.code}"");"
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.