I am looking to automate my ordering process using the PO feature, however my unit ordering quantity is not the same multiple as my selling quantity. I run a personalized vitamin subscription service out of Woo Commerce/Wordpress and this is an example of how my inventory is managed:
- I purchase vitamins by the bottle, but each sku comes in a different size stock bottle (eg. 30 capsules, 90 capsules, 180 capsules). So, when I order 1 bottle for example, I may get 180 capsules
- I sell vitamins by the month, but each sku is sold in a different daily dose (eg. 1 capsule per day or 4 capsules per day) and is always multiplied by 30 days
- The sales unit in woocommerce is entered so that a quantity of 1 = 30 capsules
So, if I sell 6 subscriptions of product A that is dosed a 1 capsule per day, I would need to replenish with 1 stock bottle of 180 capsules. But, if I sell 6 subscriptions of product B that is dosed at 2 capsules per day, I would need to replenish with 12 stock bottles of 30 capsules.
I am currently managing this conversion calculation within a spreadsheet, but it is very manual and I would like to automate the process using the stock thresholds and PO generation tool. Is that possible?