I have read discussions on this topic and am not seeing where a complete solution is in place or available.
To explain, we sell pre-packaged meat products. Example would be 1lb packages of ground meat. We sell this both through online store as well as direct POS at markets, etc. As an example, we would charge $6.67 per pound for ground beef. At the POS, an individual package weighs .89lbs. I need to be able to charge the customer .89 of the $6.67 per lb price point. I also need for when the sell transaction completes, the customer’s receipt displays that they purchased .89 lbs of ground beef as well as have a manner in which Shopify Inventory understands that I just sold 1 “unit” of ground beef to make inventory adjustment. So instead of having 347 “1 lb” packages of ground beef, I now only have 346.
For online sales, the customer makes selections of packages and different items into their cart where prices are represented on “average package weight” of each item and makes the purchase. Now I am faced with the dilemma of trying to find individual pkg weights that best match the advertised presumed weights because I have no way to charge the customer the actual weights of the packages picked.
My current work around method is creating separate POS products in my store (tagged POS and only available in the POS sales channel and does not track inventory) and my unit value for charge and cost are 1/10th lb product units. From my example above, in the POS sales channel, I have ground beef with a unit charge of .67 If a customer purchases a pkg weighing .89 pounds, the receipt will show they purchased 8 units (rounding down so customer doesn’t overpay but at same time, we are losing money because I have no other way to accurately charge). The second issue is that we now have 2 “ground beef” products in our store with online sales channel “ground beef” being tracked for inventory. We have to manually track POS sold items and manually update Online inventory.
Please respond and timely. We have literally lost $350 in the last 4 weeks because we can not accurately charge to the 1/100th decimal value. We also spend several hours trying to reconcile inventory totals each week.
The ideal solution for POS sales channel would work 1 of 2 ways: option to create a separate line item for each unit sold regardless that they are the same product (i.e. - ground beef) capturing the weight for each pkg., or 2) ask how many units(pkgs) of 1 product are being purchased and then capturing the pkg. weight of each unit or total weight of all pkgs (receipt would show 3 units(pkgs) for total of 2.95lbs). The pkg totals would then subtract from appropriate inventory product.
For online purchases, a perfect solution would be - customer places order and credit card purchases are placed on “hold/reserve” until order is finalized or “fulfilled” so that accurate charges by weight can be calculated. Like in the above POS scenarios, unit weights would be input and final bill would be based on actual unit weights.
I have seen many posts and much need for a solution to this problem. I will gladly work with any developer who wants to provide a total solution package for a very common sales need.