Sage Barcode, EPoS > Warehouse Management > Q-trix – Stock Code Generation Matrix for SAGE 50

Q-trix

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 Stock Records, 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! 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 values for each segment. Then all you need to do is to enter one stock record into SAGE – it doesn’t matter which one. Once that’s done you 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 you can tell Q-trix to ignore them – 34″ Reg Trousers don’t come in blue for example.

 

 

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 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.

 

 

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

 

 

Pricing

  • 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-trix

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