Inventory Styles  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

Inventory Styles

Postby SBarnes » Tue Nov 24, 2020 4:08 pm

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?
Regards
Stuart Barnes
SBarnes
Shihan
Shihan
 
Posts: 1617
Joined: Fri Aug 15, 2008 3:27 pm
Topics Solved: 175

Re: Inventory Styles  Topic is solved

Postby DannyC » Fri Dec 04, 2020 4:20 pm

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.
User avatar
DannyC
Senpai
Senpai
 
Posts: 635
Joined: Fri Mar 22, 2013 12:23 pm
Topics Solved: 29


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 3 guests

cron