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. Thanks again.Kurt
@RyanBrownXBYTE We had proposed the same solution, but with over 20,000 items across 6 locations the performance would be severely impacted because the client needs live availability information on the website. Thanks for the suggestion! Kurt
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:Is there anyway to show inventory availability in Big Commerce by warehouse? So each customer would see inventory separately for Florida and California. Is there anyway to force the sales order line warehouse to only use the customer locaiton warehouse? Right now when a customer places an order in Big Commerce if there is no inventory in the customers default warehouse the sales order line warehouse will list the other warehouse. For example, if Customer1 orders an item that is not in stock in Florida the sales order will assign California as the warehouse. Thanks,Kurt
@simonliang91 Sorry if I wasn’t clear, but every price for every stock item in Big Commerce was $0. That was why I didn’t provide a specific item. I’m not sure what kinds of steps I can provide since this occurred when we upgraded to 116.Thanks,Kurt
@simonliang91 We have uploaded a database backup for case 182009 if you need access to it.Also, we have advised the client to upgrade to 2020R2 since the connector customization in 20R1 is no longer getting updates or fixes.Thanks,Kurt
@simonliang91 the client is using Big Commerce and the Base Sales Price entity doesn’t have any configuration options. The issue occurred after we upgraded to 116, but went away when we reverted back to 115 of the connector a couple days later.Thanks,Kurt Bauer
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.