Retail

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.Thanks,Kurt

Hello,We are trying to understand the how the refund integration works in Shopify and why we are getting “voided payments” created instead of “customer refunds.”Our Shopify website is setup to capture payments at the sale. When we go to refund an order, we start the process through Shopify and hit the refund button (picture attached) and then we let the integration build the refund. Instead of creating a “customer refund” (which we think we want), the integration has been creating voided payments. What is the logic for how this integration is supposed to work and is there something we can do to have the integration create customer refunds instead?  

Hello Acumatica Community! Check out the latest joint case studies with BigCommerce & Acumatica:https://www.bigcommerce.com/case-study/van-cafe/ (119% growth in revenue) https://www.bigcommerce.com/case-study/ink-custom-tees/ (186% growth in revenue)  Cheers!Colleen Sheacolleen.shea@bigcommerce.com Manager, Strategic Partnerships

Shopify is hosting a webinar with Acumatica, Shopify and our customer Clive Coffee.I can’t wait for our community to see this!Registration links are below and please be sure to share with your network. Really appreciate everyone’s support and interest in what our team is building. It’s literally changing the lives of these business owners!Josh How Clive Coffee met demand after a year of record-breaking growthWhen:

Hi.Does anyone here knows:1. API to get template items attributes (color and size, with its options/values)2. API to get how the SKU was generated for product matrix Thank you.

We need to delete some ship-to locations that are attached to a specific customer but I keep getting told that I don’t have permission to delete them. What do I do?

Upgraded to 2021R2 and running through full resync of relevant entities - Sales Category → Stock Item → Non Stock Item → Template Item. Got to Product Availability, and encountered a new error I’ve not previously seen: Error: Specified argument was out of the range of valid values.Parameter name: IdentifyNoteIDSteps: Ran a ‘Full’ Prepare request for Product Availability Entity (previous automation schedules inactive since just prior to cutover to new release). Attempt to Process records. Encountered error above. The records do not appear to fail (ie, do not move to a failed or aborted status in Sync History), but just remain in the ready to process queue. I’ve approached this from both the prepare/process screens and from the sync history screen, and keep encountering the same error. Acumatica Trace from this screen:

We are having problems with exporting template items that have never been synchronised before. e.g. The item on Acumatica is called C-A892:MD with a : between the Template ID (C-A892) and the SKU code (MD). When it gets created in BigCommerce it is created as C-A892-MD which doesn’t match and gives an error on the export sync ( "The synchronization could not be completed because variant items do not match the 7386 product in BigCommerce.")Is there any way to get around this other than manually going into BigCommerce after the sync fails and changing it before resyncing?Thanks for any advice, even if it’s just that we have to manually do it and there is no way around it.Phil

There are only 2 choices to show available  for the web store.  My client would prefer that negative available is ignored and factored into the calculations. In the example below, they want to see 10.This is an example I set up and tested with the store setting for Availability Mode for Available and Available for Shipping.When set to Available the store shows a qty of 8 When set to Available for Shipping it shows 20  If I allocate the sales order for the 10 pieces it changes to either 8 or 10.  Generally, we do not set the sales orders to allocate because it ties up inventory you could use for orders with earlier ship dates.  Unfortunately, there is no way to allocate orders based on date.   

We are looking for a Customer Service Sales trainer for an E-commerce team. In case you have a referral,...

Hello,We are in the midst of implementing the Commerce Connector from Acumatica(build 21.208.0032) to an existing BigCommerce store. We are implementing in phases, with the first phase being stock and non-stock items, and inventory levels. We have a custom built integration that imports orders from BigCommerce. Most of our products need to be Matrix items with only 1 variant. I have followed the steps outlined here:With the exception of importing the items as we already have the items created in Acumatica. When trying to update a stock item to be tied to a template item, I get the following error:I have been able to use that attribute to create new matrix items following our part number format. I wou

AcuPOS  (April 2022) has just released new builds along with updated User Guides and Release Notes.  They can be found on the Acumatica AcuPOS Community PageRelease Versions:21R1 Build 104 R45 21R2 Build 207 R04 22R1 Build 100 R01Improvements:POS Orders forming PS sales orders with wrong taxEnhancements:Smart Scanning Receipts for Returns Receipt Format - Short & Regular Item Buttons Load from Stock Item Screen

Is there a way to make the customer pop-up note appear every time you go into the customers order and/or when a shipment is created?  It appears when you first create the sales order but never again.

I am trying to mass import Item Sales Categories for a commerce deployment. I was able to write an import utility to import the first tier but cannot import any child sub categories.I set the folder path using this syntax: Company/Level1/Level2/Level3 etc I then set the Category Description with using the final segmentIt seems that if the path category does not exist, then it will simply import the path string as the category name.What is the proper approach and syntax to get this to work? 

Has anyone configured the BigCommerce connector to work with an existing BigCommerce store? Our client has a well established store and wants to connect to their new Acumatica install. We started testing the syncs in a sandbox to see how it would work and have run into errors. With the stock item sync, we can only export from Acumatica to BC, but the items already exist in BC. When we try to sync anyways, the error says the item already exists. Is there a way to somehow map the two together to resolve the sync issue? Any other gotchas we need to look for in configuring the connector for an existing store? Thanks for your help!

Dimension Creation in AcuPOS:AcuPOS requires the DimensionCreation customization package to be published(only once for the instance) and then the AcuPOS build to be published to the Acumatica ERP  instance. The DimensionCreation customization package creates "WORKSTATION - POS Workstation" segmented key record in the Segmented Keys(CS202000). It is required to create a "WORKSTATION - POS Workstation" segmented key before the AcuPOS publishing. This operation can be done either manually or by the DimensionCreation customization package. In the case of creating a new tenant occurs a situation when in the new-created tenant the workstation segmented key is not created but the User Profile has a Workstation ID field to be selected. PROBLEM:For this reason if you try to create a new tenant while the

This is the Example ERROR: Export of the Stock Item record cannot be completed. The Stock Item with the same field or fields (<<item description>>) already exists.The first item has been exported to BigCommerce but others with the same description field didn’t. How can I export all items even if they have the same description field? 

HiI want to use my own Substitution Lists in my Commerce setup when exporting the Item entity.The formula function SubstitutionList and SubstitutionAll is available but during Process of data it fails with error SubstitutionList function unknown.Is this a bug?

Is there a way to see BigCommerce “Awaiting Fulfillment” orders IN Acumatica Sales Orders without another customization? We can’t be the only customer who has the BigCommerce Plugin integration into the eCommerce edition of Acumatica? Why we can’t see the Awaiting Fulfillment orders in Acumatica baffles me.

When using the Change ID action on an inventory item, the SKU# does not get updated on the BigCommerce side. Is this a bug or just a product feature that doesn’t exist yet?

Hi everyone. I need to know where in the BigCommerce I can configure the customer specific prices to provide to acumatica API.Thanks.

Hello,Is there a way to export a specific price attached to a price code to Shopify so that the price of an item updates when the price attached to the price code is updated?Alternatively, is there a way to make the “RETAIL” price code populate the “default price” field as this would also solve the issue?  

Hello! We’re attempting to troubleshoot a new store connection and seem to have everything in place on the Shopify side – when we try to sync the orders we get the following error:Inserting 'Sales Order' record raised at least one error. Please review the errors. CuryOpenTaxTotal: Tax is not up-to-date. CuryUnbilledTaxTotal: Tax is not up-to-date. ShipVia: 'Ship Via' cannot be empty.Shipping address and methods are present in the order JSON along with Tax lines which appear to all be accurate. Any input on where the misconfiguration could be would be greatly appreciated!

Our customers get uploaded automatically from our CMS. By error sometimes twice. Once in acumatica, how do I merge the customers, so I have only one customer in acumatica?

Is there a way to export record notes from an SO to BigCommerce?I’m currently working with a user who needs to make timestamped document notes on a Sales Order to update customers on their order statuses.Currently attempting to leverage Export Mapping on the Entities screen, however I am getting an error. Any thoughts/ideas? Thanks!