Stock Code Generation Matrix For SAGE 50

If you have products that have many variants it can be a real chore creating each of the SAGE 50 Stock Records individually, especially if you have seasonal stock that changes frequently. Q-trix does the job that could be taking you hours in seconds!


For instance, if you sell trousers that are available in seven waist sizes, three leg lengths and four colours that’s 84 possible Stock Numbers that you will have to enter into SAGE 50! And that’s just one product line – if you have, say, six different products with the same variants that’s almost 500 possible Stock Numbers!


Q-trix Main Menu


With Q-trix you define the structure of your Stock Number and the possible variants for each segment. Then all you need to do is to enter one stock record into SAGE 50 – it doesn’t matter which one. Once that’s done you simply run the ‘Generate’ function, identify the Matrix that you want to use, quote the stock number that you entered and Q-trix generates the rest!


If there are any invalid variants (e.g. 34″ Reg Trousers don’t come in blue) you can tell Q-trix to ignore them.



Building a Stock Code Generation Matrix

The first thing that you define is the number of characters that identify the product range.


In this example the first four characters of the stock number denotes the product


Then you define the other parts of the code and the possible values for each part:


Two characters denote the Waist Size


The next character denotes the Leg Length


And finally the last two characters denote the colour


Press the ‘Add’ Button to add the Matrix. The Matrix is now ready for use.



Using the Matrix to generate SAGE 50 Stock Records

Select the Matrix that you wish to use.


Select the Matrix to use



Create one stock code in SAGE 50 e.g. 770432M01 Kiwi Trouser 32″ Reg Black.


Enter the stock number into Q-trix – it knows that the first four characters of the stock number denote the Product.


Trim all but the Product Name from the description.


Using a Matrix


If there are any variants that you do not wish to create simply click them to tell Q-trix to ignore them. When you’re ready press the Contunue button and Q-trix will generate all of the variants.


All of the variants are generated


If you notice any variants that you don’t want to create in SAGE 50 you can still click them to remove them from the list – when you are ready to continue press the Update button and Q-trix will create the remaining Stock Records in SAGE 50.




  • The overall system price will depend on requirements, we will be happy to provide a written quotation on request
  • The software is provided with installation, configuration and training at extra cost
  • All prices will include first year support
  • Support is provided upon condition of a suitable remote link (such as a VPN – virtual private network) to all sites; cover is for a 12-month period and includes all updates
  • All prices are subject to VAT



Q-tron reserves the right to alter Product Specification and pricing without prior notice. E&OE.



Product Features

Quick and simple to use

A job that is currently taking you hours can be done in seconds

Encourages the creation of structured Stock Numbers

Especially useful if you have seasonal stock that changes often (i.e. fashion)

You create one variant and Q-trix creates every other possible variant for you!

Contact us about this Product