We are buying and selling our products under different Order Codes.
Daily, Weekly and Monthly.
This depends by the situation if the clients needs those products urgent or places an order for stock with longer delivery time.
How can we do this in Manager?
Manager, as for today, can have only one static price and cost for each product. So you have to think some “ploy” in order to achieve what you want.
A few questions:
Is the standard price fixed or does it change frequently?
How is calculated the surplus on the selling price?
Is it fixed or a percentage?
Is it different for each product?
Is it different for each client?
You can use a custom field on your sales orders with a dropdown list offering your three options. See Manager Cloud.
If you have that many line items, I am not sure that Manager is the accounting software you need. It is quite versatile, but not to that extent
I think you can reach a good result with batch create and update starting with a well structured excel file that does all the permutation you need with specific rules.
You cannot have multiple pricing tiers for the same inventory item in Manager. The program is not that sophisticated. Purchase and sales prices entered for inventory items are only shortcuts. They prefill a transaction, but can be edited.
I agree with @Joe91. If you are managing two and a half million inventory items, you will inevitably have accounting needs Manager cannot handle. Yes, the program would accept that many items, but you will need a full-blown enterprise resource planning (ERP) system. Your case of multiple pricing tiers based on order urgency is just one example.