Page 1 of 1

Inventory Styles

PostPosted: Tue Nov 24, 2020 4:08 pm
by SBarnes
We have a customer with an existing product range where they want to link certain existing products as styles in terms of colours and sizes, obviously I realise we can't do this through the front end but we were looking to populate the data behind the scenes is this possible and how could we go about it?

Re: Inventory Styles  Topic is solved

PostPosted: Fri Dec 04, 2020 4:20 pm
by DannyC
As per our off-forum chat I have been able to do it via a custom stored proc which is passed a PartNo, StyleCode, StyleDesc, Colour, Size.

I then just populate IN_Styles, IN_Colours, IN_Sizes, IN_StyleColourSizeMatrix.

Whilst it works a treat, it would be nice to have a more kosher way of doing it via the Jiwa GUI and possible using Jiwa's objects. Note: it assumes that PartNo already exists in Jiwa.