API: Return orderId in get goal items by SKU

Description

Contributor guide

Tech stack

phpmysql

Domain

apianalytics

Issue type

feature

DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.

2

Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.

1-3 hours

Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.

stale

ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.

clear

Prerequisites

PHPMatomo APIDatabase schema

Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.

75

Research direction

Start by examining the API method `getItemsBySku` in the Goals plugin, likely in `plugins/Goals/API.php`. Identify where the response array is constructed and add the `orderId` field. Check the database query to ensure the `orderId` column from the `log conversion` table is included. Look at the forum reference for additional context. Test the change by calling the API and verifying the response includes `orderId` for existing goals.