Same item, different prices based on warehouse

  • 12 February 2024
  • 2 replies

Userlevel 7
Badge +16

I have a client who has a need for items that are refurbished to be priced differently in Big Commerce and Acumatica.

Ideally, the item would be a pencil and if the pencil was sharpened, it would have the same SKU but be priced lower based on a location in a warehouse. 

Does anyone have an idea on how to achieve this?

I’m pretty sure it’s a limitation with Big Commerce but couldn’t hurt to ask with so many smarter than me here! 😁


Best answer by Yuri Karpenko 12 February 2024, 22:37

View original

2 replies

Userlevel 7
Badge +16

Thank you @Yuri Karpenko


I appreciate the response. It was as I expected also!

Userlevel 7
Badge +6

@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!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved