Retail

From time to time our shipper get the following message.“Transaction (Process ID 78) was deadlocked on lock recourses with another process and has been chosen as the deadlock victim. Rerun the transaction.”When we retry the step the process generally completes. Does anyone have any idea what causes this error,It appears that it may be related to the specific order being accessed by two users at the same time. But we are not sure and are looking for some insite.Thank you!

We have the Retail Commerce Edition.  Does the Retail Commerce Edition contain all of the features of the Distribution Edition?  If not, what general feature of the Distribution Edition are not contained in the Retail Commerce Edition? 

When syncing Customer Price Class (type) price lists that contain prices for matrix inventory and template items to BigCommerce, the price list in BigCommerce contains the list of items, but the prices are all $0.00.This is how it’s set up in Acumatica:and this is how it comes out in BigCommerce:I’m aware that Customer specific prices are not supported by the connector, but this is not a customer-specific price.Any ideas on how to overcome this issue?Thank you!

Is it possible to export a customer attribute from Acumatica as a tag to the customer record in Shopify? We have a customer attribute that is a combo type attribute that we would like to send as a tag to Shopify. I’d imagine that should be possible with something like the below: However, I’m having difficulty testing this; if the above is correct, is there something else we need to set up to make sure this syncs to Shopify when this attribute is updated?

I’m not sure how to get past this error when trying to sync a shipment back to shopify.

We just upgraded to 2022R2 - Build 22.207.0013.And we are having performance issues with our order syncs from BigCommerce.  The orders are Preparing and Processing as expected - and this is verified in the Sync History page.However - shortly after processing into the system, the order gets switched back to a status of “Prepared”.  The system is then trying to re-process the same order - even though it already exists now.This is causing system perf issues as the day goes on - and the number of orders grows.  The Prepare and Process jobs are scheduled to run every 60 seconds.Thoughts?

When you sync Template Items to BigCommerce, the Matrix Items in TemplateItem will be mapped to product variant in BC side. If you don’t want to use the default price mapping, and want to use the specified price in Matrix item attribute instead, the following customization project can help you.public class BCTemplateItemProcessor_Extension : PXGraphExtension<BCTemplateItemProcessor> { //The code is active only if BigCommerce connector feature is enabled. public static bool IsActive() => CommerceFeaturesHelper.BigCommerceConnector; //Specify the attribut ID to get the price. protected const string AttributeId = "RTLWEBPRC"; #region Event Handlers public delegate void MapBucketExportDelegate(BCProductWithVariantEntityBucket bucket, IMappedEntity existing); [PXOverride] public void MapBucketExport(BCProductWithVariantEntityBucket bucket, IMappedEntity existing, MapBucketExportDelegate baseMethod) { baseMethod(bucket, existing); TemplateItems impl = bucket.Product?.Lo

Hello, I have system admin user role in Acumatica, and I need to reset another users password. I have been able to do this in the past.Now, however, as soon as I click on the Reset Password button on the Users Screen… It changes over to my own user account in the system, so I would be changing my own password. Is there a way to workaround this issue? Thanks!

Hello, We have noticed after creating a sales order that a duplicate is now showing up. It has all the exact same information. Same Reference number, same shipment number, same payment information. I added a note to one of the orders and it showed up on both orders, so they are linked together somehow. Therefore, I don’t want to try and just delete one, since it will most likely delete both. However, when I look at the customer account, only one order shows up.  Does anyone have any ideas on how to address this duplicate order issue?  Thank you!

Is anyone else having an issue with Shopify returns/refunds not importing into Acumatica on 2022R2 build 22.210.0020?  No error messages in sync history.  Just nothing happening.

Synchronizing Payment from Shopify to Acumatica, I got this:“The payment could not be imported because the SO064037 sales order has been fully invoiced. Create the payment manually on the Payments and Applications (AR302000) form and apply it to the invoice.”Yes I agree, we receive this order 2 days ago, and we shipped it and invoiced. customer paid it today. Why Acumatica cannot create Payment? What setting I have to check? 

Hi all, Here’s the setup - both “business account ID” and “customer ID” have their own numbering sequences. When I extend business account into a customer, it adopts the numbering sequence of business account, instead of the next customer ID in sequence.  Is there a way to address this? Open to try all suggestions. Thanks

Hi, May I know what  is the function of sort order under customer price classes? What will it affect if I change/update the number. 

Why it cannot be shipped in full. Only 10 items that I want to ship and 13 available for shipping but still the error comes. 

     I am trying to figure out a way to update Fulfillment status and Confirm a shipment in one call instead of doing 2 separate calls, to get this approach working would it be difficult to extend the web service endpoints?Do y’all have any better option or the best way to go is make multiple calls?

We are new to the platform.  We are experiencing difficulties when trying to sync returns from Shopify.  We are getting the error message: The following tax identifiers from the external system could not be matched: PA STATE TAX. The ERP has failed to save the tax ID or the tax amount differs from the one that has been expected. Make sure that taxes are configured for the tax zone and tax categories. Also, make sure that taxes either have the same identifiers in the ERP and external system or are mapped on the Substitution Lists (SM206026) form. Has anyone experienced this issue and how do we correct the issue?  We are currently manually entering all returns into Acumatica at this point. We do not experience this problem with a normal order or with a POS return.

While working through an RC, is there a way to process it like the “Pick pack and ship” or “Receive and put away?” We have several coming back as a stock lift so one RC could have 10,000 pcs.  I’m sure something is available, but I cannot seem to find it through my VAR, or my limited research.

Price list syncs are taking a very long time, over 20 hours. Not to mention it usually errors out and needs to be manually restarted in this time period.I have tested this with a lot of price changes, and minimal price changes, and the time to sync did not change.Is there a better way to automate this process, and to only update the items which prices have changed (either + or - amount)?BigCommerce did recommend using Price List Importer/Exporter | BigCommerce. I have tested this on Sandbox, and this is a very fast way to update multiple price lists for multiple items at once (I did about 6,000 items in < 10 seconds). While this is an adequate solution, I don't see any way to automate this.

Using the BigCommerce/Bundle B2B connector, is there any way to handle the following business need? We would like to create a specific Sales Price Worksheet for approximately 600 of our customers. In Acumatica, this is feasible in the Sales Price Worksheet module by attributing the worksheet to a specific Customer Price Class and then assigning that Customer Price Class to the 600 customers. There doesn’t seem to be a way for BigCommerce and Bundle B2B to read that information in the hierarchy we are looking for. Any suggestions?

I have an export scenario set up to export using the Customer screen layout to an excel file.  I am trying to export the following records from the Customer screen and want to use a Source restriction to restrict the export to a couple particular customer classes.When I run it using the source filter (and not setting the customer id to ‘=every’, the address field data for the account and shipping addresses that are exported are all the same as the first customer, although other fields do export correctly.Any thoughts on what I can do to make this right so I can use source restrictions? My testing of using the =’every’ for customer ID and a source restriction results in no data being prepared all all.  The example below has the =every, but removing it is what gives me the same data in the address fields for all records.Any thoughts are greatly appreciated!    

Register Today: 

 Our client has received the following email from Shopify.. The customer is preparing to upgrade to 22R2 build 202 right now. Any impacts of these that we need to be aware of or execute.   Action Required - Migrate your custom app to the Fulfillment Orders API by March 31, 2023Your custom app is leveraging the deprecated Fulfillment API. Please note that the Fulfillment API will stop working as intended on March 31st, 2023 in favor of our new Fulfillment Order API. Read our migration guide and take action as soon as possible to avoid breaking changes.The following app(s) you are using currently use Fulfillments API and should be moved to Fulfillment Orders before March 31st, 2023: 

Is it possible to import historical orders via the Shopify connector?In my testing, archived orders are filtered (excluded) from the import by default.Customer would like to import historical orders for reporting and customer service reasons.Thx / Chad 

We would like to map the Acumatica Entity Usage Type field in a Customer Profile to the analogous field in BigCommerce’s Customer table, so that we can set whether a customer is tax-exempt or taxable from Acumatica. We use Taxjar as our tax solution, and to set a customer as taxable such that the Tax integration between BigCommerce and Taxjar will work properly to recognize the tax status of a customer, we need to either leave the field blank or fill it with “TAXABLE”. Any value other than Taxable in the BigCommerce field will send a customer tax-exempt value when Bigcommerce does an API call to Taxjar for that customer.If we sync the field as it stands now, the value for taxable in Acumatica in the Entity Usage Type is “Default”, which if entered in the BigCommerce field will make that customer exempt (opposite of what we want). Is there a way to either update the pick-list for entity usage types in Aculatica to add “TAXABLE”, or for us to use some sort of substitution in the connecto

Hello, We have been having an issue with our BigCommerce connection into Acumatica whenever a customer creates their first order on the website. When the customer creates an order from BigCommerce, it syncs into Acumatica and uses the Ship To Name and Address for the Customer profile instead of using the Bill To Name and Address. We have to manually override the Name and Address every time, on every tab to correct this. Also, if a new location is created in Acumatica for that customer, it defaults back to the original Attention and Ship To Addresses that were incorrect, even after they’ve been changed.  Any ideas for a fix to this issue? Thanks!