Retail

Hello,While adding new products to Shopify(template items), we kept getting errors on some of the metafields syncing to Shopify.We getting getting errors like:Error on type : 'single_line_text_field' must be consistent with the definition's type: 'list.single_line_text_field'.;Error on type : 'single_line_text_field' must be consistent with the definition's type: 'multi_line_text_field'.;Error on type : 'single_line_text_field' must be consistent with the definition's type: 'metaobject_reference'.;Existing products are syncing just fine(and their metafields), in fact I can copy the values from the non-working product and push a sync on an existing product and it sync just fine.But if I do the opposite and take the values from a working product and copy them to the non-working, it gives the same errors.I also cloned one of the existing working template items(that i confirmed I could resync) and when I tried to sync th

I want to add a tag to Shopify orders with the dropship PO Number from the line details in Acumatica. I see the “mark for PO” field, but not the PO Number field. 

Hi Team,We are working with Build 23.112.0032 and working on a customization where we have to add an image url ( https://xyz.s3.amazonaws.com/kkltQWuXULPcHQ6TmoMsZkiJOK93x8.png) as File attachment to a Sales Order record through code. We tried to insert this image url under Name field in UploadFile table and later to map this record along with Sales Order NoteID under NoteDoc table but we are facing issue with approach. Can you please suggest the best possible way to achieve this. Thank you in advance! 

Is there a way to mark a stock item to not accept parts to be “Returned” to inventory and “Non-Refundable” if a customer (and salesperson) try to create an RC?We sell custom made parts that we don’t want to accept any parts to be returned to inventory for credit. 

We are trying to sync modifier options from BigCommerce to Acumatica. However, when the modifier type is ‘dropdown’ the value that syncs over to Acumatica does not match BigCommerce.  If we have the modifier type set to a text field, then the value syncs over just fine. but we need it to be a dropdown option, and would appreciate any insight into how to get the value to sync over correctly

Hi Guys,I need help to sync Line Item properties to Acumatica. Shopify apparently stores the variant options in and array format. Default connector only syncs the 1st option from line item properties but it could have up to 10+ options in that field.Is there a way we can create a loop to loop through the array and show all the options in Acumatica? Thanks for your help.

Hoping someone else has a solution to an issue we’re having with customer tax exemption records and new locations We recently noticed that when a customer is setup with a Tax Exemption Number and Entity Usage Type those values are saved to their default customer location - However, when new customer locations are created, the values from the default location are not copied over to the new locationWe are using Avalara for a our tax provider and we have a BigCommerce store connected to both Avalara and Acuamtica - BigCommerce maintains a single Customer Tax Code (analogous to Entity Usage Type) at the customer record and all customer orders, regardless of address or location, are processed using this tax code and exemption. Acuamtica keeps this record at the location level and calculates only off the customer location values Because of the above, when a customer changes any of their shipping information online, the s

Hello - we recently implemented the Ecommerce edition to our existing distribution edition  to connect with our Shopify store.  We do not have any 3rd party integrations for calculating tax in Acumatica as most of our business runs B2B, so we manually set up Tax ID’s and zones and apply them whenever necessary.One area that we do have to charge taxes in via web sales.  For most states, we are only dealing with a single flat rate per state.  However, there are a few states, like California, where you are charging State + County + Local in some cases.Shopify handles this as 3 distinct API calls, as opposed to a single calculation of tax and a pass to Acumatica.I’ve tried to do some mapping to change all the incoming tax rate names from Shopify to match up with my associated rates in Acumatica, but with this being 3 calls in the example above, it seems like Acumatica wants to add 3 rows with the same Tax ID name, which it obviously can’t do/will error.I know

Does anyone have any experience connecting one Shopify Store to multiple different tenants in one Acumatica instance? Just checking to see if anyone has experience, Acumatica told me it was possible but working with someone who is experiencing some issues. Thanks for any input.

Hello, We’ve noticed when processing offline Shopify orders with cash that the log in Shopify shows the amount of cash paid and then the change given to the customer. When this order syncs into Acumatica, the payment total is the amount of cash the customer gave and doesn’t account for the change, leaving a balance on the payment. Is this a known bug, and is there a fix or workaround for this?   

I just learned that shopify for some reason does not support multi select dropdown out of the box.I’m interested in using the commerce connector to map Text, Combo and Multi Select Combo product attributes to Shopify metafields.I was recommended https://apps.shopify.com/metafields-editor-2. The Metafield Guru supposedly supports multi-select metafields.Does anyone recommendations/experience for syncing single and multi select stock item attributes in acumatica with shopify using the commerce connector?

Does anybody know if the Availability Adjustment field works? Is there any additional setup other than changing this field? I’m still testing, but upon initial update it didn’t work. See screenshots.I set it to -5 expected that if I have 40 quantity available, the commerce site will display 35 because of the -5 adjustment I have as the availability adjustment. It’s still showing 40 qty.   

We just switched our main web site to Shopify last week and we’re running into some very annoying issues with the Acumatica Shopify connector.   Customer account details on the General tab are repeatedly being overwritten when the Bidirectional customer entity is bringing customer data back from Shopify.  We’re on 23R1 and while we plan to upgrade soon, we cannot upgrade right this moment.The primary issue we’re seeing is that customer information on the general tab is being overwritten by whatever the default address is in Shopify.  This seems to usually be the address of the most recent Sales Order’s address (I don’t know if it is the billing or shipping address).  Not only does this change the address but it completely rewrites the account name. I have salespeople telling me their biggest accounts are just “gone” from Acumatica because they use the Display Name to find their orders and customers. These customers are still there but unless the person memorized the ac

Hi All, I just want to ask regarding how to restrict the visibility of all sales order records and only show my sales order records? Please refer to the screenshot below. Regards,Nadia  

I’m just starting to use the Prepmt. Invoices to collect customer prepayments from the Sales Order. It all works perfectly until the moment I prepare the nomal Invoice and try to release it. The invoice status goes to “Open” but I get this error message:  "Sequence contains no elements".The prepmt invoices remain unapplied.Is it a bug or am I missing something in the setup.

Hello, Has anyone had issues with the Shopify Connector after Change_ID of a Stock Item in Acumatica?Even if the ERP_Id and the External_Id matches, the POS orders from Shopify generate an error that the item is not found in the ERP. 

Although it is recommended to use a new order type for Shopify POS, we have opted to use an existing order type. But we still want a way to identify POS order from web orders by mapping them into specific customer. Is that possible? 

We’re getting ready to switch our ecommerce site to Shopify and I am in the process of trying to export our open non-web orders to the site so customers can see their order status.  We’re on 23R1 for now (planning on upgrading after this migration).  We’ve setup a new order type for orders being imported from Shopify (WB).  I have also configured an existing order type (SB) that we want to export.  The sales order entity is configured for a bi-directional sync direction.  After running some tests on a handful of our open SB orders, they’re being exported as expected and at first glance everything is working great.  However, after these SB orders get created in Shopify, the connector sees that they have been modified externally and the next time I process one of them a bunch of fields get updated in the ERP that we do not wa

Our company brings in sales orders via our homemade website. Quiet often we have to change the order quantity on a sales order. When we do that and press save we get an error that says “Applied Amount Cannot Exceed the Unbilled Balance”. We have been able to plug numbers into the payments screen until we are able to save but I don’t think we are doing it the appropriate what. What is the correct steps for changing the quantity ordered for an SO?

Using the native Shopify Connector with Acumatica, we're looking to automate order fulfillment status updates. Specifically, when an order is finalized in Acumatica, we want it to automatically update the fulfillment status in the connected Shopify store. Is this functionality available within the native connector's configuration settings? If so, could you please guide me through the setup process?

We are applying Shipping Discount in Shopify, however, the shipping discount amount sync to Acumatica as an unpaid balance.  Does anyone know how to map the shipping discount to a field in Acumatica so that the shipping discount amount will be waived?  Thanks... 

Hello,Does anyone know the setup in the Commerce module to allow for the tracking number to be sent back to BC from Acumatica? I am unsure if this setup is the correct setup, but I know we not currently having tracking IDs sent back to BC.  

Our customer is using the Amazon IntegrationEach order creates a Payment on AcumaticaAmazon sends a deposit to the customers bank that consists of multiple payments less feesFor this customer this deposit can consist of more than 1000 paymentsWhat are best practices to enter these deposits?Does anyone have automation for this? 

When I try to make a connection to live Acumatica instance (2023R2), I get this error. We just purchased and activated the Shopify connector last week.Acumatica Error: You have insufficient rights to access the ShopifyStore (BC201010) form.Is there a feature that I miss enabling? Thank you! 

Our company uses ACU for walk in sales. We are just starting to incorporate hand held scanners to scan items that come up to the register. Is there a way trigger a new line on an SO after an item has been scanned so that the next item can be scanned without having to touch a keyboard key or mouse?