Order export with information on LineItem level

[carlosD47]

Hi,
Could you please allow exporting the following attributes on a LineItem level? In case you can't implement the export for all the attributes at once, they are listed already prioritized, you can start with customerGroup and we step by step cross them out of the "to do list".

• customerGroup
• shippingMethod
• mastersku
• taxonomyId
• targetGroup
• brandName
• color
• events
• locations
• channel ( any information that identifies the Merchant project to which the order belongs )

When we fire the export request on impex using headers that refer to LineItem level, the the entire information on the .csv should be on LineItem level.
For Order # 140721PDE5200005908, for example, we should have 3 rows on the exported csv, as we have 3 items inside the order, but instead we have only one. We don't really get any information from the LineItem. Can you add the LineItem level precision to the Order Export?

Thank you!

[mmoelli]

Hey Carlos, please provide us the csv which you currently use so that we can check it directly with the input. Posting the header here would sufficient.

[carlosD47]

Hi Martin, the list of headers that I used is huge, I went through the documentation and tried to come up with combinations that might return a value (or not). I first wanted to check if the information that I requested was already somehow available.

The entire list of headers is:
id,articleNumber,billingAddress,billingAddress.additionalAddressInfo,billingAddress.additionalStreetInfo,billingAddress.apartment,billingAddress.building,billingAddress.city,billingAddress.company,billingAddress.country,billingAddress.department,billingAddress.email,billingAddress.firstName,billingAddress.lastName,billingAddress.mobile,billingAddress.phone,billingAddress.pOBox,billingAddress.postalCode,billingAddress.region,billingAddress.salutation,billingAddress.state,billingAddress.streetName,billingAddress.streetNumber,billingAddress.title,channel,country,createdAt,customerEmail,customerGroup,customerId,customLineItems,inventoryMode,lastMessageSequenceNumber,lastModifiedAt,lineItem,lineItem.brand,lineItem.id,lineItem.locations,lineItem.mastersku,lineItem.name.de,lineItem.name.en,lineItem.price,lineItem.productId,lineItem.quantity,lineItem.state,lineItem.supplyChannel,taxonomyId,lineItem.variant.attributes.GTIN,targetGroup,lineItem.variant.id,lineItem.variant.images,lineItem.variant.sku,locations,merchantAndBatch,orderNumber,orderState,paymentState,returnInfo,ReturnPaymentState,ReturnShipmentState,shipmentState,shippingAddress,shippingAddress.additionalAddressInfo,shippingAddress.additionalStreetInfo,shippingAddress.apartment,shippingAddress.building,shippingAddress.city,shippingAddress.company,shippingAddress.country,shippingAddress.department,shippingAddress.email,shippingAddress.firstName,shippingAddress.lastName,shippingAddress.mobile,shippingAddress.phone,shippingAddress.pOBox,shippingAddress.postalCode,shippingAddress.region,shippingAddress.salutation,shippingAddress.state,shippingAddress.streetName,shippingAddress.streetNumber,shippingAddress.title,shippingInfo,shippingMethod,shippingMethod.name,syncInfo,targetGroup,taxedPrice.taxPortions,taxedPrice.totalGross,taxedPrice.totalNet,totalPrice,totalPrice.centAmount,totalPrice.currencyCode,version,brand,color

The header which I specifically mentioned that should be on a LineItem level precision is "orderNumber".

Cheers!

[mmoelli]

Hey Carlos,

• "customerGroup" will be supported soon
• shippingMethod is already accessible using "shippingInfo.shippingMethodName"
• to get lineItem information please use "lineItems.*" (with s)
• channel is no valid information on order level. please use "lineItems.supplyChannel"
• all other requested information are custom attributes and will be accessible using "lineItems.variant.attributes.*" ==> this is a bigger issue we will challenge soon.