@Kandy Beatty , that’s a great question! I would say that sharpened vs. unsharpened pencil represent 2 different SKUs. Same with new vs. refurbished item.
The limitation actually exists in both, Acumatica and BigCommerce. There is no way in Acumatica to set a different price based on the location (warehouse - yes, but not a location). In BigCommerce, you cannot use location / warehouse for price differences (at least, not without a customization).
Finally, if you need to be able to sell both, new and refurbished items at the same time (say, I go to a pencil product in BigCommerce, and I can either buy a new one, or a sharpened one), your best approach will be to use a product with variants. In this case, you will set it up as 2 stock items in Acumatica with a template item that serves as an umbrella for them. A variant option (attribute in Acumatica) will be “Condition”, and a user can choose between “New” and “Sharpened”. Each product will have a separate SKU and a separate price.
If you need help further on this one, don’t hesitate to let us know!
Thank you @Yuri Karpenko!
I appreciate the response. It was as I expected also!