Backoffice - export script timeout [504:GAtway time out]

[Former Member]

I used the below query. Total Variant Products: 60K, Price Rows: 30 Lac, Store: 100

% impex.setTargetFile( "TestVariantProduct.csv" );

nsert_update TestVariantProduct;&Item;Europe1PriceFactory_PDG(code,itemtype(code));Europe1PriceFactory_PPG(code,itemtype(code));Europe1PriceFactory_PTG(code,itemtype(code));allergenTypesList(&Item);approvalStatus(code,itemtype(code))allownull=true;baseProduct(catalogVersion(catalog(id),version),code)allownull=true;brandCode;brandName;buyerIDS(key(code,itemtype(code)));c4CategoryCodeallownull=true;catalog(id)allownull=true;catalogVersion(catalog(id),version)unique=true,allownull=true;codeunique=true,allownull=true;consumerAvailabilityDateallownull=true,dateformat=dd.MM.yyyy hh:mm:ss;contentUnit(code);countryOfOrigin(isocode);creationtimeforceWrite=true,dateformat=dd.MM.yyyy hh:mm:ss;data_sheet(catalogVersion(catalog(id),version),code);deliveryTime;deptIdallownull=true;detail(catalogVersion(catalog(id),version),code);ean;endLineNumber;erpGroupBuyer;erpGroupSupplier;europe1Discounts(code);europe1Prices(&Item);europe1Taxes(&Item);familyIdallownull=true;fullDescriptionEndDatedateformat=dd.MM.yyyy hh:mm:ss;fullDescriptionStartDatedateformat=dd.MM.yyyy hh:mm:ss;fullDescriptionVisibility;galleryImages(catalogVersion(catalog(id),version),qualifier);gtinallownull=true;imageName;logo(catalogVersion(catalog(id),version),code);lowestUoMUnit(code)allownull=true;manufacturerAID;manufacturerName;maxOrderQuantityallownull=true;minOrderQuantityallownull=true;modifiedtimedateformat=dd.MM.yyyy hh:mm:ss;multipleOrderQuantityallownull=true;normal(catalogVersion(catalog(id),version),code);numberContentUnits;offlineDatedateformat=dd.MM.yyyy hh:mm:ss;onlineDatedateformat=dd.MM.yyyy hh:mm:ss;order;orderQuantityInterval;others(catalogVersion(catalog(id),version),code);owner(&Item)allownull=true,forceWrite=true;packageSizeallownull=true;percentOfAlcoholByVolume;picture(catalogVersion(catalog(id),version),code);priceComparisonUoM(code)allownull=true;priceComparisonValueallownull=true;priceQuantity;productNotInPieces;productOrderLimit(&Item);sequenceId;specialTreatmentClasses();startLineNumber;stockPackageSizeallownull=true;subFamilyIdallownull=true;supplierAlternativeAID;taxes(productCode,taxAgency(code,itemtype(code)));thumbnail(catalogVersion(catalog(id),version),code);thumbnails(catalogVersion(catalog(id),version),code);unit(code);untypedFeatures(language(isocode),product(catalogVersion(catalog(id),version),code),qualifier,unit(code,systemVersion(catalog(id),version),unitType),valuePosition);valueAddedTaxRateallownull=true;variantType(code);xmlcontent #% impex.exportItems( "TestVariantProduct" , false );