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?
Help with Option Name and Option Value
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?