We have a client with multiple locations/warehouses. They use Big Commerce as a B2B site where the customer needs to be setup first. They are running into a couple issues I could use some guidance.
- Is there a way to display inventory availability by warehouse instead of just one specific warehouse or all warehouses?
- When a customer places an order the customer needs to have the all the items on the sales order assigned to the customer default warehouse, but it appears the integration changes the sales order line warehouse depending on availability. Is there anyway to force the sale order line warehouse to be assigned to the customer warehouse only?
Currently the client is on 20R1, but we are looking to upgrade them to 20R2.
We have two warehouses. We have set up Acumatica to show only one warehouse on the Big Commerce B2B website. If we did not, then products from both warehouses would show up. This was a simple setting in Acumatica.
Do you mean availability in BigCommerce or in Acumatica?
If you ask about bigCommerce, than you can use Warehouse settings in BigCommerce Stores. There you can specify multiple warehouses and warehouse locations to export to BigCommerce
Currently we take default warehouse from Inventory Item, as we don’t know from bigCommerce what warehouse to take.
Do you store warehouse on customer profile?
I think the easiest way to customize it in the connector to set the warehouse. Mapping will not work, as you need it depending on the customer.
Sorry I wasn’t real clear in my original post. The client has customers across the US that are assigned to specific warehouse in the customer location. For example, Customer1 is assigned to Florida and Customer2 is assigned to California. Each warehouse maintains it’s own inventory and if a customer orders from another warehouse they can be charged a delivery fee.
Their questions are:
So far I know, BigCommerce does not have any inventory locations.
Since bigCommerce does not have any locations, there is not easy way to add it in the product. However if you know that all customers from Florida, will go to the warehouse A, you can write a customization that will choose warehouse A when State == ‘Florida’
Hope it helps.
I don’t know how much inventory changes, but you could have a customization that puts inventory into attributes of each item per location. Those could then sync with BigCommerce as item custom fields. If you used customer class to separate customers by location, you could also customize BigCommerce to highlight certain location based on that class. We have certain customers that are actually internal users and we use a customer class customization to change what they see.
Another tool to look at is skyvia. It can link directly to the BC database and may help with performance. I have never hooked it directly to Acumatica (only CSV), but it could work.
You could also look at live connection to Acumatica from BC or pushing Acumatica data to a VPS and then a live connection to that from BC.
just throwing some extra stuff out there in case it helps or makes you think of a new solution.
The skyvia tool looks interesting. I’m thinking I could create an Acumatica oData feed using INSiteStatus for live inventory by warehouse and then have skyvia update the BigCommerce custom fields using that feed and the last modified date.
No problem - I searched for a while to find that tool. It is also great to update selective inventory. We have issues trying to do an import using the BC tools and the category field.
I am part of a panel talking about BC and Acumatica today at noon ET (https://www.augforums.com/live/). You are welcome to join and ask questions or share your experiences. It will also be recorded in case you want to view later.
As a workaround, you had suggested that we can come up with a GI that displays the total inventory available by warehouse and display that information in BigCommerce. Would that be through custom fields in BigCommerce? Are there any Acumatica customers that have implemented this solution?
This got talked about on our AUGForums.com Live broadcast from May 20 as Ryan mentioned above:
@josh.fischer talking about multiple warehouses with BigCommerce:
Click here to watch Josh
@RyanBrownXBYTE talking about the Skyvia.com tool:
Click here to watch Ryan
RANDEM Retail | Click & Collect / BOPIS
BigCommerce - Click & collect / BOPIS - RANDEM Retail (randemgroup.com)
If you’re still dealing with this challenge, I can put you in touch with them.