Home > Forum Home > Excel Invoice Template > Can't get it to give me the report I want > Attributes saved format Share

Attributes saved format

Excel Help for Attributes Saved Format in Excel Invoice Template


Forum TopicLogin

Attributes Saved Format

Rate this:
(3/5 from 1 vote)
Oops The current reporting functionality does not allow to report by product attribute.  This information is saved under 'Discounts' column in the 'Orders' tab after the '|' character, attributes offsets are separated by the '#' symbol as attribute title offset then ':' and value offset.

Therefore, to analyze this data, you will need to use the 'Text to columns' function in Excel and match the offsets to the attribute values in order to create a custom report by attribute. 

Having this as pert of the reporting functionality will require development which we will consider for a future version release.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Attributes saved format in the