casstick.blogg.se

The header column values will be parsed and the resulting XLSX file will contain corresponding attribute values of the exported products. This can be done by specifying the -input flag Example $ -language "en,de,fr" -projectKey -input -template -output CSV Parser TemplateĪ parser template defines the content of the resulting parsed XLSX file, by listing wanted product attribute names as header row. This module also accepts products to be read from a JSON file. projectKey -template -output Pass products from a file More information on pipe streams can be found here Example $ -projectKey | \ In this scenario, the products are parsed directly after export. This ideally works with the commercetools product exporter. The products to be parsed from JSON to XLSX can be passed to this module in one of two ways: logFile Path to file where logs should be saved prettyLogs Pretty print logs to the terminal logLevel Logging level: error, warn, info or debug multiValueDelimiter, -m Used CSV delimiter in multiValue fields. delimiter, -d Used template CSV delimiter. Can contain multiple languagesĭelimited by comma "," language, -l Language(s) used for localised attributes such asĬategory names. onlyMasterVariants Export only masterVariants from products. fillAllRows Define if product attributes like name should be

referenceCategoryOrderHintBy Define which identifier should be used for theĬategoryOrderHints column. referenceCategoryBy Define which identifier should be used for theĬategories column. input, -i Path from which to read product chunks. template, -t CSV file containing your header that defines what you authUrl The host URL of the OAuth API service apiUrl The host URL of the HTTP API service Npm install -global CLI Usage: product-json-to-xlsx Ĭonvert commercetools products from JSON to XLSX json file or directly piped in from the product exporter. The products to be parsed can either be read from a. A package that parses commercetools products JSON data to XLSX.