Selling Multiple Quantities of Same Item with Different Prices
Hello, my name is Zach - I work with a hardware store out of Tennessee. I have been helping with everything IT-related and helped to get the point of sales system going, including uploading and managing the inventory.
We have run into issues trying to sell certain items, due to limitations. I guess I am making this post as a suggestion and/or asking for some sort of help or solution.
One of the big issues we're currently having is trying to sell doors. Doors, for the most part, are special order items. They contain many attributes, such as Glass Types, Glass Styles, Grid Styles, Lite Styles, Heights, Door Types, Door Series, Left-Hand, Right-Hand, etc. I have tried to create these items as a matrix, combining multiple door attributes into one of the three available matrix attributes. (Ex: Using the Glass Type, Glass Style and Grid Style in Attribute 1, Using the Lite Style, Door Height in Attribute 2, Using the Door Type in Attribute 3). With the doors being so complex and with so many different combinations, we still run into issues when applying these doors to purchase orders and sales.
As mentioned previously, each door is a special order. Additionally, they all have their own serial numbers. Although this is the case, it doesn't separate the doors when added to a sale. (For instance, two of the same door with separate serial numbers cannot be listed with different prices)
I've been trying to think of some sort of work-around/solution to this. I'm assuming the matrix attribute limitation is to prevent the system from getting bogged down, which is understandable. So, adding additional available attributes probably wouldn't be possible.
Another solution would be to make it possible to sell more than one of the same item at different prices. (Or possibly be able to store cost/prices for each individual serial number. When the serial applied at the sale screen, it would apply the cost/pricing for that serial) Currently, if an item is added to the sale screen multiple times, the quantity is incremented. It doesn't allow for two separate lines for the same item
With this being implemented, a single item could be made for each type of door (ex: Single Steel Exterior Door), then the door information could be entered with the serial attributes, as well as the pricing. Once added to the sale, the door specifics would be there from the serial attributes and the pricing would be included for each serial.
We've run into the same issue with other items as well. I'm not sure if anyone else has had this sort of trouble, or if there is a different way we should be going about it. Any solutions would be appreciated!