Pixi API documentation

Unofficial · by koempf24.de

Postman collection
Items Read

pixiCanConvertBundle

Checks whether an item can be converted to or from a bundle and returns its key data together with a `CanConvert` flag.

Identifies an item and checks whether it is already in use, which would prevent converting it (changing its bundle status).

Identifying the item (empty strings are treated as NULL):

  1. If ItemKey is passed, ItemNrInt and EAN are ignored.
  2. Otherwise, if ItemNrInt is passed, the item is looked up in the item codes (code type 2 = internal item number); EAN is then ignored.
  3. Otherwise, if EAN is passed, the item is looked up in the item codes (code type 1 = EAN).

If several items match a code, the first match found is used.

Check: CanConvert is 0 if the item is referenced in at least one of the following, otherwise 1:

  • order lines (Orderlines)
  • bundle order lines (BundleOrderlines)
  • bin location stock records (InvBinItem)

Result: one row with the item's key, internal item number, EAN, bundle flag and the CanConvert flag. If no item is found, the result set is empty.

Notes

  • The call only checks; it does not convert anything.
  • All reads use NOLOCK, so the result may reflect uncommitted data.
  • If the item was found via EAN, the EAN column returns the passed EAN (which may be an additional EAN code) instead of the item's main EANUPC.
  • An unknown ItemNrInt does not fall back to EAN; the result is then empty.
  • There is no error row: an empty result means the item was not found.

Tables used

ItemCode · Read Orderlines · Read BundleOrderlines · Read InvBinItem · Read items · Read
SQL object:
dbo.pipiCanConvertBundle
Updated at 2026-10-30