# HybrisArchitect.com Order Create Impex with additional impex examples


$productCatalog=electronicsProductCatalog
$lang=en
$catalog=Online
$catalogVersion=catalogversion(catalog(id[default=$productCatalog]),version[default='$catalog'])[unique=true,default=$productCatalog:$catalog]
$approved=approvalstatus(code)[default='approved']
$product = product(code, $catalogVersion)
$unit = unit(code[default='pieces'],unitType[default='pieces'])
$baseProduct=baseProduct(code, catalogVersion(catalog(id[default='$productCatalog']),version[default='$catalog']))
$currency = currency(isocode[default='USD'])
$priceFormat = '###.##'

INSERT_UPDATE Currency;isocode[unique=true] ;conversion ;digits ;symbol ;active[default=false];base[default=false]                      
                      ;USD                  ;1          ;2      ;$      ;true                 ;true                      

INSERT_UPDATE Catalog;id[unique=true]  ;name[lang=$lang] ;defaultCatalog
                     ;$productCatalog  ;$productCatalog  ;true

# Catalog versions for content catalogs
INSERT_UPDATE CatalogVersion ;catalog(id)[unique=true] ;version[unique=true] ;active   ;defaultCurrency(isocode[default='USD']) ;languages(isoCode)
                             ;$productCatalog          ;$catalog               ;true     ;                                        ;$lang

INSERT_UPDATE Unit;unitType[unique=true];code[unique=true];name[lang=en];conversion;;;
;pieces;pieces;pieces;1

# Create product
INSERT_UPDATE ApparelProduct;code[unique=true] ;$catalogVersion            ;varianttype(code)            ;$approved   
                            ;HW2110-0019       ;$productCatalog:$catalog     ;ApparelStyleVariantProduct   ;            

INSERT_UPDATE PriceRow;$product[unique=true];price[numberformat=$priceFormat];$unit    ;$currency;
                      ;HW2110-0019          ;100.00                      ;pieces   ;USD

INSERT_UPDATE User;uid[unique=true]
            ;mraygoza


INSERT_UPDATE Order;code[unique=true] ;user(uid) ;date[dateformat=dd.MM.yyyy HH:mm] ;currency(isocode) ;net   ;deliveryMode(code) ;calculated;status(code);totalPrice;ipAddress
                   ;101             ;mraygoza     ;10.10.2017 10:10                  ;USD               ;false ;                  ;true;CREATED;100.00;102.212.101.111


INSERT_UPDATE OrderEntry;order(code)[unique=true];product(code,catalogVersion(catalog(id),version))[unique=true];quantity;calculated ;entryNumber ;$unit;totalPrice
                        ;101                   ;HW2110-0019:$productCatalog:$catalog                            ;1       ;true      ;0       ;pieces:pieces;100.00