Commerce Edition QnA
- 370 Topics
- 1,540 Replies
If I set this inventory setting thusly under Shopify Stores in Acumatica: Acumatica will sync the Sales Category to Shopify as a product tag, which is great.However, if you add any additional tags in Shopify, the Acumatica connector will REPLACE them all with the Sales Category tag every time a sync occurs. Which is not so great.Anyone know if it is possible to make the Sales Category tag MERGE with any already existing tags in Shopify instead of replacing them all?
We have drop ship products on our Shopify site - if purchased, the order will sync to Acumatica, a drop ship PO will be created, and then a drop ship receipt once the vendor has confirmed the order has shipped.Is there a way natively to mark these orders as fulfilled in Shopify? This happens automatically for orders with product we stock and can ship from our own warehouse; a shipment is created and confirmed and the order is marked as fulfilled in Shopify. However, because the drop ship process uses a receipt instead of a shipment document, and there is no place to enter tracking # information in a receipt, we cannot see a way to mark the order as fulfilled in Shopify.We are currently on 21R1, in the process of upgrading to 23R1; perhaps this has changed in the latest release?
I would like to update the customer credit term assigned to orders based on their customer class with the credit term retrieved from the Shopify metafield.Currently, there are some orders where customer service can create an order for customers who, according to Acumatica, can only pay with a credit card (CC), but they are supposed to have NET 30 terms for this order. The NET 30 term is stored in the metafield, which is mapped to the Terms field. However, the issue is that the data does not automatically override the terms field in the order when it arrives from Shopify. The terms field is only updated manually by the CS team in Acumatica.Is there a way to manage this process automatically by using the metafield data from Shopify and passing it to Acumatica?
Yes you can export tracking number from Acumatica to BigCommerce/Shopify. To do so you nee to put tracking numbers in the line with box under Packages Tab.Keep in mind following rules: When shipments that include multiple boxes with separate tracking numbers are exported from Acumatica ERP to BigCommerce or Shopify, the system checks if the following conditions are met: • Each item in the shipment is linked with a particular box. If an item is not assigned to any box, the system displays an error. • Each box in the shipment contains at least one item. If a box is not assigned at least one item, the system displays an error. During the synchronization of shipments with Shopify or BigCommerce, for each box in the shipment, a separate shipment with a separate tracking number is created in the online store. Boxes that don't have any items assigned or are missing a tracking number are not exported to the online store.
https://www.acumatica.com/cloud-erp-software/acumatica-retail-edition/acumatica-for-shopify-connector/ Native Shopify integration Our Shopify integration is built into Acumatica Retail-Commerce Edition – no additional software or 3rd party applications to purchase. Enable users to pay via Shopify Payments from within Acumatica. Can anyone point me to instruction on how to enable Shopify Payments within Acumatica? From what I understand it is a new feature, one that we have been highly anticipating, but I cannot find any documentation on how to set it up in the community or Acumatica Open University. Any guidance is greatly appreciated. We have been putting off integrating with our Shopify Plus store because we were waiting for more B2B integrations that were expected with 2023 R1. Now it’s here and we excited to dive in.
How to prevent Acumatica ERP Sales Orders and Invoices from recalculating the taxes imported from external systems such as BigCommerce, Shopify, Amazon etc.,
In 2023R1, a new checkbox called “Disable Automatic Tax Calculation” is introduced in the Order Types(SO201000) form. When this checkbox is selected, the system will refrain from recalculating the taxes for the Sales Orders and Invoices. The Commerce connector will import the Taxes from external systems such as BigCommerce, Shopify, Amazon etc., if the “Tax Synchronization” checkbox is selected in the Stores form. If the “Tax Synchronization” checkbox is selected in the Stores form and if the selected Order Type in Order Type for Import selector has “Disable Automatic Tax Calculation” unchecked then a warning is shown to the user as “ The Disable Automatic Tax Calculation check box is cleared for the EO order type on the Order Types (SO201000) form. Taxes in sales orders imported from the BigCommerce store will be recalculated on invoice creation.” Once these taxes are imported, then it stays as the same even if the Sales Order or Invoice is modified. This “Disable Automatic Tax Ca
I can see under the 23R1 documentation that setting the Availability of a Non-Stock item to “Set as Unavailable” is supposed to disable it and make it “not available for purchasing in the online store”: However, I can’t see that anything changes in Shopify when the Non-Stock item is Set as Unavailable; I am still able to purchase the product online.Can anyone advise what the expected behavior is for this setting and Non-Stock items in Shopify?
We are integrating Acumatica and BigCommerce. There are >100k of Stock item records in Acumatica. With that amount, only a subset of products will be exported in BigCommerce based on criteria provided. We noticed that as a default, Export to External is set to true. Is there a straightforward way to achieve our goal where in only the identified items based on criteria shall be exported and the rest will not?Now, what we are doing is to create a GI and make everything Export to External as false, then running an Import Scenario to explicitly set the Export to External true based on criteria given.Hoping to hear your suggestions for a more direct and elegant way on fixing this. Thank you so much :)
Hi, we’re onboarding Acumatica now and would like to confirm this is possible. That is, can we use a Business Event or other functionality in Acumatica to automatically create a 6-digit Alternate ID upon creation of a Stock Item that would serve as a barcode? We would need to it to auto-increment so that it’s unique.
We’re using Shopify with AvaTax both in Acumatica and on Shopify.The sales orders come in fine with the correct tax and the correct state on the tax tab (i.e. if shipping to NJ, it will calculate NJ). However when it get’s to the invoice it recalculates the tax based on our warehouse (SC)
I’m looking for a fully mobile label printing solution. I’m looking at the zebra zq500 series. It says it is compatible with iOS apps, but would like to confirm that I would be able to print from Acumatica’s iPhone app to one of those printers. If not, could we use a Zebra mobile device to send the print jobs from there?
Hello,I wanted to share this setting since it took me a while to find it and searching the forums did not help.With Ecommerce some marketplaces like Home Depot and Lowes will use the same customer order number. Normally having the Sales Order not allow duplicates is the correct setting but if enabled you will get orders that will not import since the Customer Order Nbr is the same.Here is the screen name you need to navigate to change the setting.Order Types (SO201000) > Choose SO as Order Type > Order Settings.
Hello,We have just upgraded from 2019R2 to 2023R1. In 2019R2 I was previously able to change the template ID of an existing and assigned stock item if I had the “Edit Template ID” checkbox enabled in the item class. Today I went to do that and the Template ID is greyed out and unable to be edited. Is this a bug or new behavior? Is there anyway around this without making a customization to reenable this field?Thanks you in advance.
Since we integrated Shopify and Acumatica we have been having an issue with the vendor name not going up to Shopify for all products. It works with the stock items but does not send anything up for template items (just sends our company up for template items).We are upgrading to 23.1 and hoping that may fix the issue but in using the two for the past few months, I have come to realize that some of the vendor information in the ERP will never be accurate if passed to Shopify. Different company name on the books in the ERP than the brand name on the product.So it would be best if that would be something I can just manually enter into Shopify instead of letting Acumatica send it at all. Does anyone know if this is possible? I guess I am asking to unmap the vendor.
I can sync stock items to Shopify; however, it always creates a new item instead of updating an item that already exists. I have tried using the SKU and/or description/title but I cannot update a product origionally created in Shopify. The integration will only update products created from the sync. Any ideas?
Be default, commerce connector merges customers from external systems using the same email address. i.e. when you have two or more customers from one or more stores irrespective of the connectors(Shopify, BigCommerce etc.,) imported into Acumatica, the connector creates one customer record for all.But because of some business scenarios if this is required to not to be merged and create separate customer records, then this could be done using the attached customization. Once the customization is published, you see a new checkbox called “Merge Duplicate” in Entities(BC202000) form. If checked for the stores for the customer entity, then customer records from different stores would be merged and you would have one customer per email ID. If checked for few stores and not for all, then checked stores will create a separate customer records but unchecked stores will share a common customer record.
Hi everyone,I created a template item with two variants that will create two option sets in the BigCommerce. My goal is to make the “Choose Your Golf Cart” as the first option set before the “Choose Your seat color”. Is there a proper way I can make it in the process of creating the template item in Acumatica?
I am wondering if there is any update regarding the B2B features mentioned in this press release:https://www.acumatica.com/corporate-newsroom/press-releases/acumatica-broadens-strategic-relationship-with-shopify-to-enhance-experiences-for-b2b-buyers/It would be advantageous to maintain customer pricing in Acumatica and see that reflected for wholesales customers on Shopify. Any thoughts on best practices with the current connector?
We use an address validation tool in BigCommerce to validate addresses prior to them being imported through the BC Compactor into Acumatica. Recently we started receiving errors like the following: The AU country does not have a state with the name 'VI'. Make sure that you have specified the state according to the 3166-1 alpha-2 standard. We have set up the two-character codes for state, in this case “VI” for Victoria, Australia in the Countries/States screen in the entry for Australia. Yet we still get the error. We only recently implemented this address validation tool. Prior to that we did not validate and accepted three-character states for AU. Any thoughts on what we can do to get these orders through the connector? ThanksPatrick
We have a customer who uses Shopify and imports those orders to Acumatica, along with the customer’s payment at the time the order is placed.It is possible that an item becomes unavailable and the Sales Orders that have that item on them have to be partially refunded and that SO line canceled.What best practices have you seen to:Processes a partial refund on a prepaid sales order and sends that information back to Shopify. Cancels the SO line for the affected item.This would ideally be done in a bulk process. They could have several hundred sales orders with that item that need to be refunded.Thanks for any help provided!
We’re implementing Acumatica and I just learned that it’s not possible to fulfill orders in Shopify and have that information sync back with Acumatica which is very disappointing. Does anyone do that today? Maybe through a customization or how else could it be handled? Or, maybe am I forced to change our process so we do the fulfillment step in Acumatica? We do our own local delivery through a Shopify app which makes it easier for us to do in Shopify.
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.