Adding catalog number to the job ticket - xmpie-users/uStore-js GitHub Wiki

The uStore Admin application has a feature that allows you to download or print a job ticket for each item in an order:

Alt

While the job ticket includes a lot of information required for printing the job (eg properties), for dynamic products it does not list the catalog number of the uStore product.

Alt

You can modify a existing sql query and have the catalog number showing Below are the instructions:

Create a new Message Template SQL

  1. Login to uStore admin
  2. Click Presets -> System Setup -> Message Template SQL
  3. Look for the Message Template SQL ID = 124
  4. Add the value from the DB table that you want to get. In our case P.CatalogNo with a coma to separate it from the existing values. Alt This is how it could look like after the adding of "P.CatalogNo":
exec('SELECT PC.Name as ProductName , P.CatalogNo , dbo.fn_GetLocalizedText(DocType.StringID, ' + @SetupCultureID + ') as DocName , DocType.DocTypeID as DocTypeId FROM Product P JOIN Product_Culture PC ON P.ProductID = PC.ProductID INNER JOIN Doc ON P.ProductID = Doc.ProductID INNER JOIN DocType ON Doc.DocTypeID = DocType.DocTypeID WHERE P.ProductID = '+@ProductID+' AND PC.CultureID = '+@SetupCultureID)

  1. Click Present > System Table > Message Template

  2. Look for the Message Template ID = 27 (job ticket)

  3. Click on the button in the top 'Edit Localized Text'

  4. Select the edit icon on the left of the Message Template language you prefer to use.

  5. Add the following code snippet to the body where you want it to be shown: <xsl:value-of select="//Sqls/Product/Row/CatalogNo" /> Alt

  6. Done. Please try if the job ticket shows the catalog number as defined. Alt