@ReymondO I would like to explain what I need to achieve so you can point me in the appropriate direction.
I buy fabric by the bolt. For this example, we will say a bolt consists of 50 yards of fabric. I set my purchase orders as if I bought this by the .5 (half) yard to allow me to sell at this increment. Thus, my fabric bolt was broken down to "units" where each unit = .5 (half) yard.
At first I was selling the fabric in these "units" so the customer had to do what I thought was simple math: 1 unit= .5 yard, 2 units = 1 yard, 3 units = 1.5 yards, and so on. I was wrong on the simplicity of the calculation.
Therefore, I have then been forced to offer two options. You can buy by the .5 (half) yard or by the whole (one) yard. In my WooCommerce store, I created two Attributes (calling it "Length") that are used to create "variations." Variation #1 is HALF yard. Variation #2 is FULL yard. When a customer wants to buy fabric they must choose between these options meaning, they no longer have to do the math. With the help of a WooCommerce plugin, I can maintain accurate stock on hand because the plugin enables these two variations to share ONE STOCK (which I set as .5 (half) yards which is how I calculated my cost in Quickbooks). Basically creating a Parent-Child relationship for my items. The children both take away from the parent (funny, mirrors life...).
The problem: because I assigned different SKUs to each "variation" and these two variations share one stock from the parent product, when an order from WooCommerce is imported, Quickbooks needs to understand this relationship the same way WooCommerce does.
Therefore, I need to have the Parent Product (with a SKU) and ASSIGNED QTY with children products (with their own SKU) that each deduct different quantities from the product. Think of it like a multiplier. Variation #1 deducts one "unit" from the Parent, Variation #2 deducts two "units" from the Parent multiplied by the quantity ordered (meaning, if a customer ordered 2 YARDS (using Variation #2)), inventory from the Parent is reduced by four "units" (2 yards = 4 units).
Which level of QuickBooks (online or desktop) will allow me to handle this type of inventory management?
Thank you!
