Add new comment

Submitted by Annie on Tue, 01/26/2021 Permalink

Hi, this is a great script but I am having problem in the sense that each order is appearing multiple times because of options name and option value. I have tried the pivot table method in Excel (as you described above) but that just creates another sheet which does not help.

You mentioned above: Each line of the Excel file represents one order item or item option. You may group options for the same item by using the column product_item. I am not good with SQL queries so I would be grateful if you could help me add some code in your script so that option names and values are concatenated and there is a single entry for each order in the final spreadsheet?

 

The content of this field is kept private and will not be shown publicly.

Markdown